How to sync an Airtable view to Google Sheets automatically (no Zapier)

You want an Airtable view to show up in a Google Sheet and stay current: for a dashboard, a pivot table, a client who lives in Sheets, or a formula that Airtable can't do. Airtable has no built-in sync to Google Sheets, so here are the real options and a setup that takes about five minutes.

The options

Download CSV and import it by hand. Open the view menu in Airtable, choose Download CSV, then in Sheets use File → Import. It's free and exact, but it's a snapshot: you repeat it every time the data changes.
Zapier, Make or a connector service (Coupler.io-style tools). These can push records into a sheet on a schedule or trigger. They work, but they are paid services, and most of them count every run, task or operation, which adds up when a whole view is copied often.
Airtable itself. Airtable has no native way to keep a Google Sheet in sync with a view.
A live CSV link and IMPORTDATA. Google Sheets can import a CSV straight from a URL with the IMPORTDATA function. If a URL always returns your view as CSV, the sheet updates itself. That's what ViewCourier's live CSV link is.

How IMPORTDATA keeps the sheet current

IMPORTDATA(url) imports a .csv or .tsv file from a URL into the sheet. Google's help article on spreadsheet calculation settings says import functions (IMPORTDATA, IMPORTHTML, IMPORTXML and IMPORTFEED) are recalculated every hour. So the sheet follows your Airtable view, about an hour behind at most, with nothing to run or maintain.

Step by step with ViewCourier

Create an Airtable personal access token. Go to airtable.com/create/tokens, add the scopes data.records:read and schema.bases:read (both read-only), add the base under Access, and copy the token.
Connect it. Sign in to ViewCourier and paste the token. It's encrypted at rest.
Pick the base, table and view. Create an export for the view you want in Sheets. The schedule and recipients are for the optional email; the link works either way.
Create the live CSV link. On the dashboard, open Live CSV link under the export and click Create live CSV link. You get a private URL and a ready-made formula.
Paste the formula in cell A1 of an empty sheet tab:
```
=IMPORTDATA("https://viewcourier.com/feed/…")
```
The view's header row lands in row 1 and the records below it.

Things to know

The imported range is read-only output. Edit records in Airtable, not in the sheet. If you type over a cell in the imported range, the formula can't fill it. Put your own formulas, charts and pivot tables on another tab that refers to the imported one.
The view decides what comes through. The view's filters, sort order and hidden fields define the rows and columns. Make a dedicated view such as "Sheets feed – do not edit" so teammates don't change it by accident.
Anyone with the link can read the data. Treat the URL like a password. If it leaks, click New link: the old URL stops working at once. Turn off disables it completely.
Freshness. Sheets refreshes about every hour, and ViewCourier may serve a cached copy for up to 10 minutes, so very recent edits can take a while to appear.
Row limits follow your plan, the same as scheduled exports. The link isn't part of the Free plan: if your trial ends without a paid plan it pauses, and works again as soon as you upgrade.

Want it in Excel instead?

The same link works in Excel through Power Query, with a refresh button and an optional refresh interval. See how to pull an Airtable view into Excel with Power Query. If you'd rather get a file in your inbox, see how to export an Airtable view to CSV automatically.

Get your live CSV link

Connect a read-only Airtable token, pick a view, and turn on its live CSV link. It's included in Starter, Pro and the free trial, alongside scheduled CSV or Excel emails. The free trial lasts 14 days and needs no credit card.

Start free trial