3 ms·

Good opportunity to highlight Google "Apps Script" which is one of the most powerful but unknown tools in the web: https://developers.google.com/apps-script/gui

by pbreit 4y ago

Good opportunity to highlight Google "Apps Script" which is one of the most powerful but unknown tools in the web: https://developers.google.com/apps-script/guides/sheets https://developers.google.com/apps-script/guides/sheets Includes easy fetching: https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app https://developers.google.com/apps-script/reference/url-fetc... I suppose python could be better for this use case but javascript seems to work fine. And it's all built righ in to Google Sheets.

jackamadeo 4y ago
(cofounder of Neptyne here) We see Apps Script is a strong signal that this kind of thing is useful. Apps Script adds so much power to Sheets but it could be so much easier to use. With Neptyne, since your spreadsheet engine runs in a Jupyter kernel, you get an interactive REPL and a very straightforward bidirectional API for reading/writing data.
deleted 4y ago
[deleted]
beenpola 4y ago
I feel like I should plug something I've been helping with for a while- it's not documented well yet, nor fully CRUD capable, but if you want to interface with Google Sheets a little better (and get things out in arrays of objects) this might be a good start: https://github.com/texas-mcallen-mission/sheetCore https://github.com/texas-mcallen-mission/sheetCore
deleted 4y ago
[deleted]