lwc:google_api:python [wiki]

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
**Welcome to [[https://github.com/burnash/gspread|gspread]] adventures:

**setup:**
  * in some setup directory git clone https:%%//%%github.com/burnash/gspread.git
  * install: sudo python setup.py install
  * install oath2client:  sudo pip install --upgrade oauth2client
  * generate/get json credentials
  * add in .bashrc: export GOOGLE_APPLICATION_CREDENTIALS="/path/to.json"

You will get a "spreadsheet not found" error unless you share the sheet with the client email from your credentials. Just look at the json file and find the client email. Then share the sheet with that email.\\

Creating the credentials:
  * [[http://gspread.readthedocs.org/en/latest/oauth2.html|Google directions]]
  * I created an app engine, having no idea which engine to pick. There's a compute engine. No answers found quickly on Google regarding the difference.


One option for credentials with gspread:

from oauth2client.client import GoogleCredentials credentials = GoogleCredentials.get_application_default() credentials = credentials.create_scoped(['https:%%//%%spreadsheets.google.com/feeds'])\\
gs = gspread.authorize(credentials)\\
sheet = gs.open('file').worksheet('sheet')


Here's the way [[http://gspread.readthedocs.org/en/latest/oauth2.html|suggested by Google]] (untested with sharing client email):\\

import gspread from oauth2client.service_account\\
import ServiceAccountCredentials\\
scope = ['https:%%//%%spreadsheets.google.com/feeds']\\
credentials = ServiceAccountCredentials.from_json_keyfile_name('gspread-april-2cd … ba4.json', scope)\\
gc = gspread.authorize(credentials) wks = gc.open("Where is the money Lebowski?").sheet1

Using the latest Gspread (0.6.2) on 14.04

Update requests:

<code>
 apt-add-repository "deb http://us.archive.ubuntu.com/ubuntu/ yakkety main"
 apt-get update
 apt-get install python-requests # it installs 2.10.0
 apt-add-repository -r "deb http://us.archive.ubuntu.com/ubuntu/ yakkety main"
 apt-get update
</code>