- There's a lot todo.
- First is probably the documentation. :(
- You can find out more at: Hackaday.io.
- Also see my revised Google app script.
- First, you'll need to setup your Google app script. You can see the github gist link above for a working script, which includes instructions. Make sure to read through the code and insert the required information before deploying (there are three separate places. Terrible design, I know.). Also, note that for the app script to work, you have to push a new version with every change to the code.
- Change the file extension of the file called
google_script_stuff.#h
to.h
. - Open your newly saved file, and replace the fields marked for replacement:
spreadSheetID
is String which identifies your specific spreeadsheet. You can get it by going to your spreadsheet and copying the uri string between docs.google.com/spreadsheets/d/ and /edit.key
is a String, which will be your API key provided by google. The key string should be formatted askey=*your_API_key*
.SHEET_SCRIPT_URI
is a constant String (which I probably should make aconst char*
instead of a#define
), which is a link to your published app script. You can get the link from the google app script online editor when deploying. The string should be of the form /macros/s/ YOUR_PUBLISHED_SCRIPT_ID /exec? (without spaces, and don't forget the '?' at the end!).