[pbreit]

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-fetc...

[sudshekhar]

Can you give some examples where this combination was more effective than using a standard file and shell/python

[pbreit]

When you have to massage, filter, sort, manipulate the data prior. Which for me is almost always the point.