Google Spreadsheets Scraper

Bug #509358 reported by Tim McNamara
This bug affects 1 person
Affects Status Importance Assigned to Milestone

Bug Description

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

Demo data

Revision history for this message
pamela fox (pamela-fox) wrote :

You can reference these Python scripts to build this:

Retrieves a JSON feed:

Uses client library to retrieve a list feed + convert to a list of dict:

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.

Revision history for this message
Fran Boon (flavour) wrote :

Feature Request not a Bug

Work developing here:

Changed in sahana-eden:
status: New → Invalid
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers