Skip to content
ClickRuntime

Connect Airtable, Gmail and Google Drive

Airtable holds the records, Gmail is where requests and files arrive, and Google Drive is where the files belong. One automation can turn an email into an Airtable record, store its attachments in Drive and link the two.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Workflows

What Airtable, Gmail and Google Drive 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.

Email requests to Airtable with files in Drive

When an email arrives at requests@, create a record in my Airtable Requests table with the sender, subject and body, save any attachments to a Drive folder named after the record, and put the folder link on the record.

Send documents when a record is approved

When a record in my Airtable Orders table changes to Approved, find the files in its Drive folder and email them to the customer in the record.

Client files saved to the project folder

When a client emails files, match the sender to a project in my Airtable Projects table, save the attachments to that project's Drive folder and add a note to the record.

Weekly status email with folder links

Every Friday, email each client a summary of their open Airtable records with a link to their Drive folder.

Use cases

Why people use Airtable, Gmail and Google Drive together

  • Requests by email become records

    Operations teams get requests by email. The automation creates an Airtable record for each one and saves any attachments to Drive with a link on the record.

  • Files for each project in the right folder

    Agencies track projects in Airtable. When a client emails files, the automation saves them to that project's Drive folder and adds the link to the project record.

  • Updates emailed from Airtable

    When a record changes status, the automation emails the contact with the documents from the matching Drive folder.

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 Drive

Every 15 minutesAI

Screen CVs from a Drive folder into Airtable

Each CV dropped into your Drive folder is read, scored against the job, and saved as a candidate record in Airtable.

See how it works
Every 30 minutesAI

Write captions for Drive videos and track them in Airtable

Each video or photo you drop into a Drive folder gets a caption and hashtags and appears in your Airtable content table, ready to post.

See how it works
Every 15 minutesAI

Turn invoice PDFs in Drive into Airtable rows

Each invoice or receipt you save to a Drive folder becomes an Airtable record with vendor, number, date, total and line items.

See how it works

Gmail + Google Drive

Every 15 minutesAI

Save invoice PDFs from Gmail to Drive, named by supplier and amount

Invoice and receipt PDFs in your inbox are saved to Drive as date_supplier_amount files, and the email is labelled as filed.

See how it works
Every 15 minutesAI

Transcribe emailed audio and save summaries to Drive

Voice notes and recordings sent to your inbox become a transcript and summary in Drive, with the summary emailed to you.

See how it works
Every 10 minutes

Save client email attachments into Drive, one folder per company

Attachments from client emails are filed in Drive automatically, each in a folder named after the sender's company.

See how it works

Build your own

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

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

File storage

  1. At console.cloud.google.com, create a project and enable the Google Drive API.
  2. Set up the OAuth consent screen and add the scope https://www.googleapis.com/auth/drive.
  3. Create an OAuth client of type Web application with the redirect URI https://clickruntime.com/oauth/callback.
  4. In the ClickRuntime dashboard, open Connections, choose Google Drive and enter the client ID and secret, then connect.
  5. Prefer a service account? Under IAM & Admin → Service Accounts, create one and add a JSON key, share your folders or a Shared Drive with its email, and save the key as a secret on Connections & secrets.

FAQ

Questions about connecting Airtable, Gmail and Google Drive

How does it notice Airtable changes?
It checks the table on the schedule you choose, as often as every 5 minutes, and acts on records that changed since the last check.
Can it create Drive folders for new records?
Yes. It can create a folder per record, name it after a field and save the folder link back to the record.
Which Airtable access does it need?
A personal access token with access to the base you choose, added in the ClickRuntime dashboard.

Related pages

Keep exploring

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

Free plan. No credit card.

Add to ChatGPTAdd to Claude