Can you give some examples of what you've created with Google Apps Script?
I've used it a little, but it's one of those things I always spend an hour building up courage to attempt (because of the slow feedback loop, browser-based testing, confusion about different deployment types, permission models and extension types). In such ways it's the opposite of writing Emacs extensions, though I can see how it promises to give something similar in the end.
In a previous job I rigged up the submission of a Google Form to send out an FYI email to relevant stakeholders and to create a GitHub issue (glossing over the details of why this was useful)
Apps Script also has an API that essentially allows me to expose my spreadsheet data as a web service that returns the data as JSON
For a while I was doing daily journals in Google Docs. I used Apps Script to auto-populate the heading for each day, e.g. an H1 with the text "21 May 2024". I've done lots of little auto-population things like this
I've used it a little, but it's one of those things I always spend an hour building up courage to attempt (because of the slow feedback loop, browser-based testing, confusion about different deployment types, permission models and extension types). In such ways it's the opposite of writing Emacs extensions, though I can see how it promises to give something similar in the end.