I would like to do the following...
As a user, as soon as someone responds to my google form, I want to read the response and send some data to another API.
When the API responds, I want to take the response, create a google document, and forward that document to my own email.
Am I better creating an add-on for workspaces, or a stand-alone app that uses the forms API etc?
Which solution should I select, and how do I start? Thanks!
Sounds like this might be a case for Apps Script: https://developers.google.com/apps-script
There's a pretty active Google Group of Apps Script developers at https://groups.google.com/g/google-apps-script-community if you need any assistance as you get started.
Hope that helps,
Ian
Thanks for the help, I will keep this thread open, but I think you are right.