Google Spreadsheets Python API

https://github.com/burnash/gspread

opkg update
opkg install nano
opkg install python-openssl
opkg install python-expat
opkg install distribute
easy_install gspread

Go to Google Drive and create an empty spreadsheet you will use for testing.

and get spreadsheet id https://docs.google.com/spreadsheet/ccc?key=0Ao9lSur2AThldE1uQk1MVGtWS25vRTBuTXM4NWpGRFE&usp=drive_web#gid=0

nano /mnt/sda1/googledoc.py
#!/usr/bin/python
import gspread
# Login with your Google account
gc = gspread.login('[email protected]', 'googlepassword')
sh = gc.open_by_key('0Ao9lSur2AThldE1uQk1MVGtWS25vRTBuTXM4NWpGRFE')
wks= sh.get_worksheet(0)
wks.update_acell('B2', "it's down there somewhere, let me take another look.")
chmod 755  /mnt/sda1/googledoc.py
/mnt/sda1/googledoc.py

Confirm spreadsheet from Google drive is updated

Comments powered by CComment