You can automatically update your Google Sheets spreadsheets when fields are updated in Airtable by using Make's Google Sheets integrations and Make's Airtable integrations.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable. 

I also give live demonstrations of how to use Make in many of my Airtable podcast appearances. For example, in this video, I show how to work with Airtable arrays in Make.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

You can use Byteline data sync to configure 1-way or 2-way synchronization between Airtable and Google Sheets. After the sync is live, it keeps running in the background; any changes in the Airtable records are automatically sent to Google Sheets. It handles creates, updates, and deletes.

Here are the steps:

1. Install the Byteline Google Sheets add-on in your spreadsheet. Now click on Extensions -> Byteline - Data Sync & Automation -> Open. Hit the "Add Columns" button on the right side panel to add Byteline columns.
2. Go to console.byteline.io/data-sync  and configure the sync.

Learn more.

Expensive but efficient

Hey. I made a low cost way which is super easy to set up:

https://www.csvgetter.com