Cookbook

This is community generated cookbook. Please, feel free to share your recipes.

gspread with pandas

Had to share... this was just too easy.

import gspread
import pandas
gc = gspread.login('my@email.com', 'supersecretekey')
book = gc.open('My Spreadsheet')
sheet = book.sheet1 #in this case
dataframe = pandas.DataFrame(sheet.get_all_records())

And to add data to a spreadsheet from a dataframe...

for row in dataframe.iterrows():
    sheet.append_row(row[1].tolist())

Nice!