Skip to content
ClickRuntime

Connect Airtable, Gmail and Google Sheets

Teams often keep working data in Airtable, share numbers in Google Sheets and talk to customers through Gmail. One automation can keep the three in step: emails become Airtable records, records become sheet rows, and updates go out by email.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Workflows

What Airtable, Gmail and Google Sheets can do together

Each of these is one automation that uses all three apps. Copy a prompt into your assistant and change the details to fit.

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.

Daily Airtable export with a summary email

Every morning at 7, copy my Airtable Projects table to my Projects sheet and email me what changed since yesterday.

Follow up when a record reaches a stage

When a record in my Airtable Deals table moves to Proposal sent and has had no reply in 3 days, email the contact a follow-up and log it in my Follow-ups sheet.

Sheet updates pushed to Airtable

Every hour, update matching Airtable records from my Pricing sheet and email me a list of the records that changed.

Use cases

Why people use Airtable, Gmail and Google Sheets together

  • Leads from email to Airtable and a shared sheet

    Sales teams receive leads by email. The automation adds each one to Airtable and to the sheet the wider team reports from.

  • Reporting from Airtable in Sheets

    Managers want Airtable data in a sheet for charts and formulas. The automation copies the records on a schedule and emails a summary of what changed.

  • Follow-up emails from records

    When a record reaches a stage, the automation sends a follow-up email and logs it in the sheet.

Ready-made ideas

Start from two of the three apps

These automations use two of the apps. Ask your assistant to add the third as an extra step.

Airtable + Gmail

Every 10 minutesAI

Turn emails that ask for something into Airtable tasks

Emails that ask you to do something become tasks in Airtable, with a clear title, a due date and a priority.

See how it works
The moment it happens

Save form submissions to Airtable and send a confirmation email

Every form submission becomes an Airtable record, and the person gets a confirmation email from your own Gmail address.

See how it works
DailyAI

Get new AI grants you qualify for by email

Each day you get an email with any newly listed AI grants, a note on whether you look eligible, and every grant saved in Airtable.

See how it works

Airtable + Google Sheets

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

Gmail + Google Sheets

Daily

Copy a table from a web page into a sheet every morning

Each morning the listings on a page you choose are added to your Google Sheet, and you get the same rows by email as a CSV.

See how it works
Every 10 minutesAI

Log PDF invoices from Gmail in a spreadsheet

Every invoice that arrives by email is added as a row in your Invoices sheet with supplier, date, number and total.

See how it works
Daily or weeklyAI

Draft a LinkedIn post from your content sheet every weekday

Each weekday you get an email with a ready-to-edit LinkedIn post about the next idea in your Content sheet.

See how it works

Build your own

Build any Airtable, Gmail and Google Sheets automation you can describe

The workflows above are examples. Describe your own steps across Airtable, Gmail and Google Sheets, plus any other app 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.

Setup

Connect each app once

Every workflow on this page uses the same 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.

Gmail

Email

  1. At console.cloud.google.com, create a project and enable the Gmail API under APIs & Services → Library.
  2. Set up the OAuth consent screen. On Google Workspace choose Internal. On a personal Gmail account choose External, then under Audience click Publish app so it is In production, not Testing.
  3. Under Data Access, add the scopes you need, such as https://www.googleapis.com/auth/gmail.modify, or gmail.send if you only want to send.
  4. Under Clients, create an OAuth client of type Web application with the redirect URI https://clickruntime.com/oauth/callback.
  5. In the ClickRuntime dashboard, open Connections, choose Gmail and enter the client ID and secret. On a personal account Google shows an unverified-app screen: click Advanced, then go to your app.

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, Gmail and Google Sheets

Which is the source of truth?
You decide. Tell your assistant which app wins when values differ, and the automation only writes in that direction.
Will it create duplicate rows?
No. It matches records by a field you choose, such as email or record ID, and updates existing rows instead of adding new ones.
Can it send emails from my own address?
Yes. Emails go out through your Gmail connection, so they come from your address and appear in your Sent folder.

Related pages

Keep exploring

Tell your assistant what Airtable, Gmail and Google Sheets should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude