Hi @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
Thanks Jonathan. It’s good to see my initial impression was correct, even if it doesn’t solve my problem.
Hi @Peter_Steinberg
It is possible to:
- Add a new row to an Airtable view
- Schedule automatic data refresh for 1 hour
- Choose “replace” mode
- View how all your data is updated in Google Sheets
or
- Add a new row to an Airtable view
- Schedule automatic data refresh for 1 hour
- Choose “append” mode
- View how your new row appears in Google Sheets (in the end of the document)
You can do it by using Coupler.io Google Sheets add-on.