Append Only Table
I need to intercept a form on my website that goes to a third party. I want to capture all the data from that form prior to it going to a third party. I'd actually love it if I could write it to a Google Sheet or an Airtable, but all of those would require me putting the API keys in my code, which is fine, if they were append-only keys.
Is there some kind of low-code way of doing this? I'm looking to avoid building my own REST endpoint for this.
The first thing that comes to mind is making a Zapier webhook that your page submits to, and then setting that webhook up to send the form submission to Google Sheets, Airtable or whatever works best for you. That basically does exactly what you want, and I think might even work with Zapier's free tier.
Thanks so much. We use Zapier for other things, and didn't even think about the webhooks. This was super easy.
Try pipedream.com
It will give you the ability to do just that - create a webhook that you can call, that trigger a workflow to do anything you want, like writting the event to google sheets.
It is low code for developers
For a low/no code solution you can look into node-red.
There's a company that offers hosting service for it (around 15$ per month if I remember properly) what you're looking for is about 3-4 nodes ( processing units in node-red). Let me know if you need more info.
Will check back tomorrow and give you more details.