Google Spreadsheets Scraper

[Tim McNamara]

Be great if we could be given a URL of a Google Spreadsheet with contacts information & insert that into Sahana.

Demo data

http://spreadsheets.google.com/ccc?key=0Ai4sPX0Iqn_vdFV3UWVEc18wejBUNm9tb1k0cDhZdlE&hl=en_GB

[pamela fox (pamela-fox)]

You can reference these Python scripts to build this:

Retrieves a JSON feed:
http://pamelafox-samplecode.googlecode.com/svn/trunk/learninggames/learninggames.py

Uses client library to retrieve a list feed + convert to a list of dict:
http://pamelafox-samplecode.googlecode.com/svn/trunk/spreadsheetscraper/spreadsheetscraper.py

Both of those assume a public sheet. You can publish a sheet by clicking "Share > Publish> Publish when changes are made".

You could build in authentication to second technique if desired.

[Fran Boon (flavour)]

Feature Request not a Bug

Work developing here:
http://eden.sahanafoundation.org/wiki/SpreadsheetImporter