+2I’m curious – I know Zapier is useful for having AirTable talk to other platforms. But has anyone successfully used it to keep a table and a Google Sheet in perfect sync?
In other words, when I add a row to one place, it appears in another. When I EDIT a row in one place, it changes in the other.
I started to build it out but the further I got, the less faith i had that it would really work. So I thought I’d ask.
+18Hi @Peter_Steinberg - I don’t think this is possible. To do a full sync between Airtable and Google Sheets you’d need to trigger actions on create, update and delete of a row at either end. Looking at Airtable in Zapier you get the following triggers:
So, create is accommodated, but delete isn’t. Probably update isn’t either, although it is possible, depending upon your specific scenario that update could be accommodated by “new record in a view”, but that would only offer a very specific style of update, e.g. change of status from “in progress” to “done”.
JB
+2Thanks Jonathan. It’s good to see my initial impression was correct, even if it doesn’t solve my problem.
+3It is possible to:
or
You can do it by using Coupler.io Google Sheets add-on.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.