Importing google sheet

importing_g_sheet.py

auth.authenticate_user()
# https://colab.research.google.com/notebooks/snippets/sheets.ipynb
import gspread
from oauth2client.client import GoogleCredentials
gc = gspread.authorize(GoogleCredentials.get_application_default())
#worksheet = gc.open('Your spreadsheet name').sheet1
wb = gc.open_by_url('https://docs.google.com/spreadsheets/d/1cH8SE6ba4LqYA0kIS8n9LFt2zJQvh7EZaldcJ_MzgyA/edit#gid=48937339')
# get_all_values gives a list of rows.
wb = wb.worksheet('Form Responses 1')
rows = wb.get_all_values()
# Convert to a DataFrame and render.
df = pd.DataFrame.from_records(rows)