Skip to content

Instantly share code, notes, and snippets.

@sudar

sudar/gsheet.py

Created August 31, 2014 07:18
Download ZIP

Revisions

  1. sudar created this gist Aug 31, 2014.
    7 changes: 7 additions & 0 deletions gsheet.py
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,7 @@
    import gspread
    import pandas

    gc = gspread.login('my@email.com', 'supersecretepassword')
    book = gc.open('Spreadsheet name')
    sheet = book.sheet1 #choose the first sheet
    dataframe = pandas.DataFrame(sheet.get_all_records())