from google.colab import auth auth.authenticate_user() import gspread from oauth2client.client import GoogleCredentials gc = gspread.authorize(GoogleCredentials.get_application_default()) worksheet = gc.open('My cool spreadsheet').sheet1 # get_all_values gives a list of rows. rows = worksheet.get_all_values() print(rows) import pandas as pd pd.DataFrame.from_records(rows)