-
Notifications
You must be signed in to change notification settings - Fork 3
Spreadsheet installation
Martin Burch edited this page Jul 31, 2013
·
4 revisions
- Open Client.gs in an editor
- Change URL in
UrlFetchApp.fetch()
to point to your python script
- Open a Google Spreadsheet
- Open the Script Editor (Tools > Script editor...)
- Paste in the contents of Client.gs into Code.gs
The trigger cannot be attached to onEdit() for security reasons, because it calls UrlFetchApp
- From the Script Editor, open the triggers dialog (Resources > Current project's triggers...)
- Click the link to "Add a new trigger"
- Use these settings in the three dropdowns: cacheChanges | From spreadsheet | On change
- Don't forget to click "Save"