[pbreit]

Google App Script using the Fetch function to make API calls is incredibly powerful and almost unknown.

https://developers.google.com/apps-script/reference/url-fetc...

[samanator]

I know of it. The main issue is it has a 30 second execution script time limit for custom functions [1]. So if you want to build anything that could take longer than that to execute you need to make sure to write to the spreadsheet before 30 seconds elapse and have a recurring scheduled function that completes any unfinished jobs. Gets tedious and failure prone quickly IME.

[1] https://developers.google.com/apps-script/guides/services/qu...

[pbreit]

Oh, wow, that's terrible. I guess I haven't run into it. That would be a bit of a show-stopper for many of the projects I am contemplating.