Skip to content
ClickRuntime

Connect Airtable to Google Sheets

Airtable is where many teams keep the structured version of their work: candidates, purchase requests, a CRM. Google Sheets is where the quick lists, budgets and exports live, and where people outside the base can see the numbers. Connect the two and records move between them without anyone copying and pasting rows.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Airtable and Google Sheets

Form entries, sales, lead imports, budget checks and candidate scoring, kept in step across your base and your sheet. These are ready-made starting points. Anything else you can describe works too.
The moment it happens

Save every form entry to Airtable and a sheet

Each form submission becomes an Airtable record and a sheet row, and you get an email confirming it arrived.

See how it works
Every hourAI

Research companies from a sheet into Airtable

Companies you add to a sheet are looked up and saved in Airtable with industry, size and a short summary.

See how it works
DailyAI

Score job listings against your CV into Airtable

New job listings in your sheet are scored against your CV each day, and the good matches land in Airtable with a tailored summary.

See how it works
The moment it happens

Log every sale to Airtable and a sheet

Each sale from your store is recorded in Airtable and a Google Sheet, and a note goes to Slack.

See how it works
Every 30 minutes

Import leads from a sheet into your Airtable CRM

New leads pasted into a sheet are added to Airtable as companies, without duplicates, and marked imported.

See how it works
Every 15 minutes

Check purchase requests against your budget sheet

New purchase requests in Airtable are checked against the department budget in your sheet and approved, flagged or rejected.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Airtable and Google Sheets, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Airtable and Google Sheets automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Airtable and Google Sheets in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Add sheet rows to Airtable only if the email column is valid and not already in the Contacts table, and mark skipped rows with a reason in a Notes column.

Every hour, update stock levels in Airtable from the sheet, and if any item drops below its reorder level, add it to a Reorder tab in the same sheet.

Use cases

Why people connect Airtable and Google Sheets

How the two apps work together

  • ClickRuntime checks the sheet every few minutes for new or changed rows and creates or updates Airtable records.
  • On a schedule it can read an Airtable view and write it to a sheet tab, replacing or appending rows.
  • A key column such as email or SKU is used for matching, so existing records are updated instead of duplicated.

  • Collect in Sheets, manage in Airtable

    Teams gather data from forms or partners in Google Sheets. New rows become Airtable records where linked tables and views make the work easier.

  • Share Airtable data with spreadsheet users

    Finance and leadership prefer Sheets. A scheduled export of an Airtable view gives them a sheet they can chart and pivot.

  • Bulk updates from a spreadsheet

    Ops staff paste price or stock changes into a sheet. Matching Airtable records are updated by SKU or ID without manual editing.

  • Backups of important tables

    Small businesses that run on Airtable want a copy outside it. A nightly sheet snapshot of key tables gives a simple record over time.

More apps

Airtable, Google Sheets and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Sheet rows to Airtable with Slack summary

When new rows appear in our Suppliers sheet, add them to Airtable and post a daily Slack summary of what was added.

Form answers into Airtable

Take each new response in the Google Forms response sheet and create an Airtable record in the Applications table with the answers mapped to fields.

Weekly Airtable export emailed

Every Monday, export the Open Orders view from Airtable to a new tab in our Google Sheet and email the team the link through Gmail.

Lead emails to Airtable and a reporting sheet

When an email arrives at leads@, extract the name, company and request, add a record to my Airtable Leads table and a row to my Pipeline sheet.

More with these apps

Setup

Connect Airtable and Google Sheets once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Airtable

Database / No-code

  1. In Airtable, go to airtable.com/create/tokens and create a new token with a name you'll recognise.
  2. Add the scopes the automation needs, such as data.records:read, data.records:write and schema.bases:read.
  3. Add the bases or workspaces the token may use.
  4. Copy the token. Airtable only shows it once.
  5. In the ClickRuntime dashboard, open Connections & secrets and save the token as a secret for Airtable.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

FAQ

Questions about connecting Airtable and Google Sheets

Do I have to move everything from Sheets into Airtable?
No. Most people keep both: the sheet stays the simple list or budget that others edit, and Airtable holds the records your team works through. The automation copies only the rows or fields you name.
How does it avoid creating the same record twice?
It either remembers which rows it has already handled, writes a status back to the sheet, or looks up a key field in Airtable, such as email or domain, before creating anything.
Can it react the moment a row is added to the sheet?
Sheets has no push events for new rows, so the automation checks on a schedule, every 15 minutes to every hour. Airtable records are checked the same way. Form and store events arrive instantly through a trigger link.
Which Airtable access does it need?
A connected Airtable account with access to the base you choose. It reads and writes records only in the tables you name in the prompt.
Do Airtable field names have to match my sheet headers?
No. The script maps each sheet column to an Airtable field by name, so 'Company name' in the sheet can go into 'Company' in Airtable. Tell your AI assistant which column goes where.
Can it write to Airtable linked record fields?
Yes, if the script can find the linked record, for example by its primary field value.
Does it handle large sheets?
Yes. The script reads rows in batches and works within Airtable's request limits, so big imports may take a few runs.
Can it run on a schedule instead of checking constantly?
Yes. You can run it every 5 minutes, hourly, daily or at set times.

Related pages

Keep exploring

Tell your assistant what Airtable and Google Sheets should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude