Connect Airtable and Google Sheets

Teams often end up with some data in Airtable and the rest in Google Sheets, usually because different people prefer different tools. FlowMattic keeps the two in line from your WordPress site: new records become rows, new rows become records, and edits in the sheet update the matching record. Nobody has to export or paste between them.

Try FlowMattic free See example workflows

7 triggers 26 actions 6 example workflows 9 ready-made templates Unlimited runs

Try a pairing

When this happens in Airtable1 trigger

Do this in Google Sheets19 actions

1. TriggerNew Record

2. ActionAdd New Row

When Airtable fires New Record, FlowMattic runs Add New Row in Google Sheets with the data from that event.

You build this in the FlowMattic workflow builder on your own site. See the setup steps

Airtable and Google Sheets workflows you can build

Each one uses only triggers and actions the two integrations ship today, plus FlowMattic's own tools. Where the library has a ready-made template, import it instead of building from scratch.

Ready-made template

Copy each new Airtable record into a sheet

Teammates and clients who only use Google Sheets get a row for every new record, without being added to the Airtable base.

New RecordAdd New Row

View the template

Create an Airtable record from each new row and save its ID

Rows added in the sheet become records, and the new record ID is written back into the row so later edits can find the right record.

New Spreadsheet RowCreate RecordUpdate Cell Data

Send sheet edits to the matching Airtable record

When a row with a stored record ID changes, the same fields are updated in Airtable, so the base reflects what people typed in the sheet.

New Or Updated Spreadsheet RowUpdate Record

Fill in record details from a lookup sheet

A new record has only a product code. The workflow finds that code in a price sheet and writes the name and price into the record.

New RecordLookup Row DataUpdate Record

Archive a sheet's rows into Airtable each month

A monthly Schedule reads a busy log sheet and creates a record for each row in an archive base, where linked fields and views make history easier to search.

ScheduleGet Row DataIteratorCreate Record

Ready-made template

Standardise country names with AI before filing records

Free-text countries and regions from a sheet are normalised by an AI Agent step, so the Airtable record uses one spelling for each place.

New Spreadsheet RowAI AgentCreate Record

View the template

Set up: new records copied to a sheet

When finished, each record created in your Airtable table is copied to a Google Sheet as a new row.

Mirror the fields as headers
Give the sheet one column per Airtable field you want, plus a Record ID column.
Connect both apps
In FlowMattic, add an Airtable connection and a Google Sheets connection under Connects.
Watch the table
Create a workflow with Airtable New Record, choose the base and table, and add a test record.
Add the row
Add Add New Row, map each field and the record ID to its column, test the step and switch the workflow on.

Import the ready-made template Beginner, about 5 min to set up

From Airtable	To Google Sheets
Record ID	Record ID
Name	Name
Status	Status
Owner	Owner
Created time	Created

Triggers and actions in this pair

A trigger starts a workflow. An action is something FlowMattic does in the app as a step.

Good to know

Airtable's only trigger is New Record. Changes made in Airtable do not start a workflow, so treat the sheet as the place for edits when you sync both ways.
Update Record needs the Airtable record ID. Store it in the sheet when the record is created and map it in every update.
Fields that hold several values, such as multi-select or linked records, may need a Text Formatter step to fit in one cell. Check the captured test record first.
If one workflow writes rows and another watches the same tab, a new row can loop back as a new record. Use separate tabs for each direction.

Airtable

Integration page

Triggers (1)

New RecordTriggers when a new record is created

Actions (7)

Create RecordCreates a new record
Update RecordUpdates an existing record
Get RecordGet the detail of an existing record
Get All RecordsGet all records from a table
Search RecordSearch for records using a filter formula
Search Record by ViewSearch for records filtered by a specific view
Delete RecordDelete an existing record

Google Sheets

Integration page

Triggers (6)

New Spreadsheet RowTrigger when a new row is added to the spreadsheet
New Or Updated Spreadsheet RowTrigger when a row is updated in the spreadsheet
Deleted Spreadsheet RowTrigger when a row is deleted from the spreadsheet
Update Cell DataTrigger when any cell is updated in the spreadsheet
Update Specific Cell DataTrigger when a specific cell is updated in the spreadsheet
Update Specific Column ValueTrigger when a specific column value is updated in the spreadsheet

Actions (19)

Add New RowAdd a new row with mapped data
Update RowUpdate existing row in specific spreadsheet with mapped data
Delete RowDelete row by ID in specific spreadsheet
Clear Row DataClear data or row by ID in specific spreadsheet
Lookup Row DataSearch for data in specific spreadsheet
Get Cell DataGet data for particular cell in specific spreadsheet
Update Cell DataUpdate data for particular cell in specific spreadsheet
Get Row CountGet total number of rows in specific spreadsheet
Get Row DataGet rows data from the sheet based on specified range
Create Spreadsheet ColumnCreate a new column in specific spreadsheet
Create New SheetCreate a new sheet in specific spreadsheet
Import CSV or JSON to Existing SheetImport CSV or JSON data to existing sheet in specific spreadsheet
Copy SheetCopy a sheet to another or within the same spreadsheet
Get RowsRetrieve rows in JSON format for use with Iterator
Export sheet to CSVExport the selected sheet to CSV format and save to WordPress Media Library
Export Sheet to ExcelExport the spreadsheet to Excel (.xlsx) format and save to WordPress Media Library
Export Sheet to PDFExport the spreadsheet to PDF format and save to WordPress Media Library
Export Sheet to OpenDocumentExport the spreadsheet to OpenDocument (.ods) format and save to WordPress Media Library
Export Sheet to TSVExport the selected sheet to TSV format and save to WordPress Media Library

Why run this pair with FlowMattic

Airtable and Google Sheets connect through FlowMattic on your own site, with no separate automation account in the middle and no charge per run.

Each team keeps its own tool

Airtable users keep their views and links, sheet users keep their formulas, and FlowMattic moves the data between them.

Data travels through your site

Records and rows pass through your WordPress server rather than a third service.

Big bases, same price

Runs are unlimited, so archiving or syncing thousands of rows does not need a bigger plan.

Common questions

Is this a true two-way sync?

Partly. New Airtable records and new or edited sheet rows can each start a workflow, but edits made inside Airtable cannot, because Airtable's only trigger is New Record.

Can I copy existing records into the sheet?

The New Record trigger handles records from now on. For older records, export a view from Airtable once and paste it, then let the workflow keep the sheet current.

Can I remove records when they are no longer needed?

Yes. Delete Record removes a record by its ID. For example, a Status column set to Remove can start a workflow that reads the stored Record ID and deletes that record in Airtable.

Can one sheet feed several Airtable tables?

Yes. Add a Router after the sheet trigger and send each row to a Create Record step for the right table based on a column value.

Can I check a record before copying it?

Yes. Add a Filter after New Record, or read the full record with Get Record, and continue only when a field such as Status or Region matches what the sheet should hold.

Did not find your answer? You can browse the help center or ask us directly.

Start automating Airtable and Google Sheets

Install FlowMattic, connect both accounts and import a template. Every run stays on your own server.

Try FlowMattic free See pricing

30-day money-back guarantee Unlimited workflows and runs Self-hosted

Reviewed 23 Oct 2026. The example workflows are written with AI from the real triggers and actions of both integrations and checked against them. Airtable integration 1.1.0, Google Sheets integration 2.2.4.