pandas_read_google_sheets.py

from io import BytesIO
import requests
from pandas import read_csv

def pandas_read_gsheets(GSHEET_ID):
    ''' Returns a pandas DataFrame from a spreadsheet in google sheets. Make sure the spreadsheet has a "view" link and only contains one tab of data.'''
    r = requests.get('https://docs.google.com/spreadsheets/d/%s/export?format=csv' % GSHEET_ID)
    data = r.content
    df = read_csv(BytesIO(data))
    return df