Skip to content

Instantly share code, notes, and snippets.

@cuibonobo

cuibonobo/google-spreadsheet.py

Created January 30, 2014 04:18
Show Gist options
  • Save cuibonobo/8702565 to your computer and use it in GitHub Desktop.
Save cuibonobo/8702565 to your computer and use it in GitHub Desktop.
Download ZIP
Quick Google spreadsheet setup
Raw
google-spreadsheet.py
from google_spreadsheet.api import SpreadsheetOAuth
import os
ID_FIELD = '__rowid__'
client_secret = os.path.join('instance','client_secret.json')
api = SpreadsheetOAuth(client_secret,
'https://spreadsheets.google.com/feeds/',
'http://127.0.0.1:5000/oauth2callback',
'Floyd County Data')
print api.get_auth_uri()
api.get_auth_credentials('YOUR CODE HERE')
sheet = api.get_worksheet('t994R7qC0wVIkZOxDERPNCQ','oct')
rows = sheet.get_rows()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment