Skip to content

Instantly share code, notes, and snippets.

View chrsstrm's full-sized avatar

chrs strm chrsstrm

View GitHub Profile
@chrsstrm
chrsstrm / gas_sheet_as_json.js
Last active June 9, 2023 10:38
Treat a Google Sheet like a JSON API
/**
* create a Google Sheet then go to Tools > Script Editor
* Paste this code into the editor. Save.
* Publish > Deploy as Web App
* Set new version, publish as me, who has access - anyone, even anon.
* GET to the URL, add on end ?sheet=[sheet name]
* Sheet name is the sheet name, manage appropriately (no spaces or symbols to keep it simple)
* Request returns JSON representation of the sheet.
*/

Keybase proof

I hereby claim:

  • I am chrsstrm on github.
  • I am chrsstrm (https://keybase.io/chrsstrm) on keybase.
  • I have a public key ASDJeOhlnqMmJm6cJPkALuNhsW9P04fejWwGi8F-hOZGCgo

To claim this, I am signing this object: