NOTE: You MUST follow these instructions in the Google Sheet for this work: 1. Open the destination spreadsheet. 2. Select "Tools > Script Editor" from the menu. 3. Replace all code in Code.gs with the following: function PARSEJSON(json) { const obj = JSON.parse(json) return [Object.keys(obj) .map(function(key) { return obj[key] })] } 4. Select "File > Save" from the menu. Now any new row added to your Airtable base will add a row to your Google Sheet!
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.
Discover more time saving integrations for Google Sheets and Airtable