How to Connect Airtable to Google Sheets

Airtable has no first-party Google Sheets sync. You can export a view to CSV in about two minutes, and that is genuinely the right answer for a one-off. Anything that needs to stay current means going through the REST API, either yourself with Apps Script or through a connector. This guide covers every route, and the three details that break most first attempts: pagination that stops at 100 records, personal access tokens replacing the old API keys, and attachment URLs that expire.

The two-minute option: CSV export

In your base, open the view you want, click the view menu and choose Download CSV. Import the file into Sheets via File → Import. Worth knowing: the export follows the view, not the table, so any filters, hidden fields and sort order in that view are applied to the file. That is useful when you want a subset, and surprising when you expected the whole table and got a filtered slice.

Honest take: if you need this once, or once a quarter, stop here. Everything below exists to avoid repeating this by hand.

Airtable to Google Sheets for free (Apps Script + REST API)

First, authentication. If you find an older tutorial telling you to grab an API key from your account page, it is out of date: Airtable retired user API keys and they stopped working in early 2024. Create a personal access token from your account's Builder Hub, give it the data.records:read scope (add data.records:write if you plan to push changes back), and grant it access to the specific base you want. Tokens are scoped per base, so one token does not automatically read all of them.

You also need the base ID and table name. Open Help → API documentation from inside the base; the base ID is the identifier beginning app shown throughout those docs, and it also appears in the URL when the base is open.

The detail that catches nearly everyone: the API returns a maximum of 100 records per request. When more exist, the response carries an offset value, and you request the next page by passing it back. Code that reads a single response works perfectly on a test table and silently truncates the real one:

1function importAirtableTable() {2  const TOKEN = "YOUR_PERSONAL_ACCESS_TOKEN";3  const BASE_ID = "appXXXXXXXXXXXXXX";4  const TABLE = "Projects";        // table name or table ID5  const VIEW = "Grid view";        // optional: respects the view's filters6 7  const headers = { Authorization: "Bearer " + TOKEN };8  const base =9    "https://api.airtable.com/v0/" + BASE_ID + "/" + encodeURIComponent(TABLE);10 11  // Page through every record. 100 per response is the maximum, so any12  // table larger than that needs this loop, not a single fetch.13  const records = [];14  let offset = null;15 16  do {17    let url = base + "?pageSize=100&view=" + encodeURIComponent(VIEW);18    if (offset) url += "&offset=" + offset;19 20    const page = JSON.parse(21      UrlFetchApp.fetch(url, { headers }).getContentText()22    );23    records.push(...page.records);24    offset = page.offset;          // absent once the last page is reached25    if (offset) Utilities.sleep(250); // stay under 5 requests/second26  } while (offset);27 28  if (!records.length) return;29 30  // Airtable omits empty fields entirely, so collect every key that appears31  // across all records rather than trusting the first one to be complete.32  const columns = [];33  records.forEach((r) =>34    Object.keys(r.fields).forEach((k) => {35      if (columns.indexOf(k) === -1) columns.push(k);36    })37  );38 39  const rows = records.map((r) =>40    columns.map((c) => {41      const v = r.fields[c];42      if (v === undefined || v === null) return "";43      // Multi-selects, linked records and collaborators arrive as arrays.44      if (Array.isArray(v)) {45        return v.map((x) => (x && x.url) ? x.url : (x && x.name) ? x.name : x).join(", ");46      }47      if (typeof v === "object") return v.name || JSON.stringify(v);48      return v;49    })50  );51 52  const ss = SpreadsheetApp.getActiveSpreadsheet();53  const sheet = ss.getSheetByName(TABLE) || ss.insertSheet(TABLE);54  sheet.clearContents();55  sheet.getRange(1, 1, 1, columns.length).setValues([columns]);56  sheet.getRange(2, 1, rows.length, columns.length).setValues(rows);57}

Run it once to authorise, then add a time-driven trigger under Triggers → Add Trigger → Time-driven. Two behaviours worth calling out in that code. Airtable omits empty fields from a record entirely rather than returning null, so building headers from the first record alone loses any column that happened to be blank in row one. And several field types arrive as arrays or objects rather than strings: multi-selects, linked records, collaborators and attachments all need flattening before they can go into a cell.

Limits: the API allows about 5 requests per second per base, and Apps Script caps execution at six minutes, so very large bases need the import split across runs. There is no write-back here unless you build it, and the script needs updating whenever the schema changes.

Automation tools and dedicated sync products

Zapier, Make and n8n all have Airtable triggers that fire when a record is created or updated, plus Google Sheets actions to append or update a row. They suit event-driven work: a new record should also become a sheet row, a Slack message and a CRM task.

They are a poor fit for reporting. Rebuilding a 5,000-row table through per-record automations is slow and expensive, and Zapier's free tier of 100 tasks a month disappears immediately at that scale. If what you want is a continuously mirrored copy rather than a report, dedicated two-way products such as Whalesync are built for exactly that and start around $29 a month.

The Brooked method

Brooked handles the pagination, the missing-field problem and the array flattening described above, so a table lands as a clean rectangle whatever its field types. Several tables from the same base can import into one spreadsheet on a single schedule, and write-back is supported for editable fields.

Step 1: Install Brooked

Install Brooked from the Google Workspace Marketplace. Free tier includes 100 imports per month, no credit card required.

Step 2: Connect Airtable

Open Brooked in your sheet, choose Airtable, and paste a personal access token scoped to the bases you want. Brooked lists the bases and tables that token can reach; pick a table, optionally pick a view to inherit its filters, and import.

Step 3: Schedule the refresh

Set the import to re-run hourly, daily or weekly. Because it re-reads the table rather than listening for individual record events, a scheduled refresh also catches changes made while an event-based automation was failing, which is a quiet failure mode of webhook-driven setups.

Brooked AI, Airtable

Live

Ask anything about your Airtable data…

Method comparison

Common use cases

• Project reporting: pull a projects table into Sheets for status roll-ups leadership already reads there
• Budget tracking: combine Airtable project records with finance data that lives in the spreadsheet
• Content calendars: report on an editorial base without giving every stakeholder a base seat
• Inventory and ops: schedule a daily snapshot so you have history Airtable itself does not retain
• Cross-base reporting: bring several bases into one sheet to report across them

Troubleshooting common issues

Related Articles

• PostgreSQL to Google Sheets: Connect & Auto-Sync in 10 Minutes (2026)
• How to Connect MySQL to Google Sheets
• How to Connect Supabase to Google Sheets

Frequently asked questions