This Applet will help you keep things in sync: When you add a new record to Airtable, the ID, Name, URL, Json, and a timestamp will be added to a Drive spreadsheet.
If
New record created
This Trigger fires every time a new record is created in a table. You can optionally configure it to only fire when a record appears in a specific view.
Then
Add row to spreadsheet
This action will add a single row to the bottom of the first worksheet of a spreadsheet you specify. Note: a new spreadsheet is created after 2000 rows.
Explore more great ways to automate Airtable and Google Sheets