3 ms·
Google Sheets + Apps Script + UrlFetchApp[1] is a very powerful API runner enabling you to loop through a set of Google Sheet rows to make API calls. The unoff
by pbreit 9y ago
Google Sheets + Apps Script + UrlFetchApp[1] is a very powerful API runner enabling you to loop through a set of Google Sheet rows to make API calls.
The unofficial APIs exposed by single-page-apps are pretty easy to reverse engineer, too.
1: https://developers.google.com/apps-script/reference/url-fetch/url-fetch-app#fetch(String,Object) https://developers.google.com/apps-script/reference/url-fetc...
- sudshekhar 9y agoCan you give some examples where this combination was more effective than using a standard file and shell/python
- pbreit 9y agoWhen you have to massage, filter, sort, manipulate the data prior. Which for me is almost always the point.