Skip to content

Instantly share code, notes, and snippets.

@DataSolveProblems

DataSolveProblems/import google sheets without using API.py

Created August 28, 2019 11:03
Show Gist options
  • Save DataSolveProblems/65ac120fb617c6458ca28a1438b4c643 to your computer and use it in GitHub Desktop.
Save DataSolveProblems/65ac120fb617c6458ca28a1438b4c643 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
import google sheets without using API.py
import pandas
googleSheetId = '<Google Sheets Id>'
worksheetName = '<Sheet Name>'
URL = 'https://docs.google.com/spreadsheets/d/{0}/gviz/tq?tqx=out:csv&sheet={1}'.format(
googleSheetId,
worksheetName
)
df = pandas.read_csv(URL)
print(df)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment