Set up Airtable to Sheets

Install the add-on

Install Airtable to Sheets from the Google Workspace Marketplace onto the Google account that owns your spreadsheets.

• Open the Airtable to Sheets listing and click Install.
• Pick the Google account you use for the spreadsheets you want Airtable data in.
• Read the Google permissions and click Allow.

The add-on asks Google for four things: read and write access to the spreadsheets you open it in, permission to call Airtable's API, storage for your sync settings, and the triggers that scheduled and live syncs run on.

Open the sidebar

Open Airtable to Sheets from the side panel of the Google Sheet you want to sync into.

• Open the Google Sheet that should hold your Airtable data, or create a new one.
• Click the Airtable to Sheets icon in the side panel down the right edge of the window. If the panel is collapsed, open it with the small arrow in the bottom right corner.
• The welcome card loads in the sidebar.

The add-on lives in one spreadsheet at a time. Syncs you create here write to tabs in this file, and you can set up a second set of syncs in any other spreadsheet from the same account.

Connect your Airtable account

Authorize the add-on from Airtable's consent screen and pick which bases it may read.

• Read the terms, tick I accept the terms and conditions, then click Connect Airtable.
• Airtable's authorization page opens in a new browser tab. Sign in to the account that holds your bases.
• Tick the bases the add-on may read, then click the grant button.
• Close the tab and reopen the sidebar. Your account is connected.

Four Airtable permissions are requested, and the last two only do anything once you turn on the matching feature:

Your records travel directly between Airtable and Google Sheets. They never pass through our servers, and the OAuth token is held in Google's encrypted properties store.

Create your first sync

Pick a base, a table, and an optional view, choose how often it refreshes and in which direction, then start it.

• Click New sync.
• Pick a Base, then a Table.
• Leave View on all records, or pick a view to sync only the records that view shows. This is how you sync a filtered slice of a large table.

Under Pick what to sync, turn on Include read-only fields if you want computed values too: formulas, rollups, lookups, counts, and created or modified stamps. They arrive as values, since Airtable owns the calculation.

• Click Start sync. A sheet tab named after the table appears right away with its header in place.
• Records load in the background. Airtable returns them 100 at a time, so a large table fills in over a few passes and the sidebar shows the progress.

Read the synced sheet

The first two rows carry the sync's wiring, your records start on row 3, and anything you add alongside them survives every run.

The sheet owns its own column order. Drag a column somewhere else and the next run respects the move, and columns you add yourself are carried across every run with their values still lined up against the right record.

• Add your own columns next to the synced ones. Formulas, notes, and manual status columns all survive.
• Resize, hide, and reorder columns freely.
• Build pivot tables, charts, and QUERY or FILTER formulas on other tabs that point at this one.
• Leave row 1 alone. It is protected, and it is what maps each column back to its Airtable field.

Turn on scheduled, live, or two-way sync

Frequency and direction belong to each sync, so you can change them any time from the sync's card.

Open a sync from the sidebar and change When to sync or Direction the same way you set them up. Each sync keeps its own settings, so a live two-way sync and a manual read-only one can sit in the same spreadsheet.

• Live sync asks once for a Google Sheets authorization, because it writes to your sheet in the background while you are not there.
• Two-way sync adds a status column at the front of your data that tells you, per row, what is queued and when it will reach Airtable.
• Scheduled sync runs quietly on a 3 hour cadence. You can still press Sync whenever you want it sooner.