Aug 02, 2021 05:31 PM
So I made a zap that will add to my Airtable when a row in Google Sheets is created. That was easy.
However, I am a bit hung up on updating the Airtable record though. How do I get Zapier to update Airtable from Google Sheets? Zapier wants a specific record, but I don’t know which record will need to be updated? How do I get Zapier to watch the entire table and update the field that was changed?
Aug 02, 2021 05:43 PM
Nevermind, this will need a paid plan. Off to find a different solution.
Aug 02, 2021 06:07 PM
You are right; you may need a multi-step zap, and doing an Airtable search for the record you are looking for, and then updating Airtable with the record found on the “search step.”
I hope that it helps.
Aug 04, 2021 04:57 AM
Hi there @Deko , Michaela from Integromat here :wave:
To achieve this, you’re gonna need to watch the Google Sheet rows for new ones, search your Airtable records and finally update the specific record. That means multiple steps indeed.
You could very easily do this with Integromat. It’s a no-code tool that lets you connect pretty much any online services and automate all kinds of processes.
With Integromat, you can build automations with multiple steps and pathways on every subscription plan. Depending on how much data you’re looking to process, the free plan might cover your needs:
Anyway, circling back to your question - the scenario would look like this:
You can check out the currently available features of the Airtable integration on Integromat (i.e. triggers, actions, and pre-made templates) to see what the further options are :slightly_smiling_face: