Skip to content
ClickRuntime

Connect Airtable to Google Drive

Google Drive is where the files arrive: CVs, invoices, receipts, videos, shared documents. Airtable is where the team keeps track of what each file is and what happens next. Connecting them means each file gets a record with its link and the details pulled out of it, and documents made from Airtable records are filed in Drive.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Airtable and Google Drive

CV screening, invoice parsing, file logs, captions and generated documents, linked between your Drive folders and your base. These are ready-made starting points. Anything else you can describe works too.
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
Every hourAI

Draft articles from approved Airtable topics into Drive

Topics you approve in Airtable are written up as draft articles, saved as Google Docs in Drive, and linked back on the record.

See how it works
Every 10 minutes

Keep an Airtable list of new files in a Drive folder

Every file added to a Drive folder is listed in Airtable with its name, type, owner and link.

See how it works
Every 15 minutes

Create PDF invoices from Airtable orders into Drive

When an order in Airtable is marked for invoicing, a PDF invoice is created, saved to Drive and linked on the record.

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 Drive, 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 Drive automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Airtable and Google Drive 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

Only add Drive files to Airtable if AI identifies them as invoices, and match the vendor to an existing Vendors record instead of creating a new one.

Every week, find Airtable client records with no new files in their Drive folder for 30 days and tick a Needs follow-up field on each.

Use cases

Why people connect Airtable and Google Drive

How the two apps work together

  • ClickRuntime checks a Drive folder every few minutes for new files and creates or updates Airtable records with the file name and link.
  • New Airtable records are checked on a schedule and can trigger folder creation or file uploads in Drive.
  • Text from the files can be read and parsed by AI before it is written to Airtable fields.

  • Keep file links next to records

    Teams that track clients or assets in Airtable store the files in Google Drive. New files in a client's folder are added as links on the matching Airtable record.

  • Pull details out of documents

    Ops and finance teams drop invoices or forms into Drive. AI reads each file and fills Airtable fields such as vendor, amount and date.

  • Folders created per record

    Agencies and recruiters want a Drive folder for every new client or candidate. When an Airtable record is created, a folder is made and its link written back.

  • Archive attachments to Drive

    Airtable attachment storage fills up over time. Attachments can be copied to Drive folders and replaced with links, keeping a full copy in Drive.

More apps

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

Invoice files to Airtable with Slack alert

When an invoice PDF lands in our Drive Invoices folder, add the vendor, amount and due date to Airtable and post it in #finance on Slack.

Generate documents from Airtable records

When an Airtable record is marked Ready, create a Google Doc from our proposal template with its fields filled in and save it to the client's Drive folder.

Email files when records change

When an Airtable order is marked Shipped, find the packing slip in Drive and email it to the customer through Gmail.

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.

More with these apps

Setup

Connect Airtable and Google Drive 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 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 and Google Drive

Does the automation need access to my whole Drive?
It needs a connected Google account that can see the folder you name. The script only lists and reads files inside that folder, using its folder id.
How quickly are new files picked up?
Drive folders are checked on a schedule, usually every 10 to 30 minutes. The automation remembers the newest file it has handled, so each file is processed once.
Are the files copied into Airtable?
No. Airtable stores the Drive link alongside the details, so the file itself stays in Drive with its existing sharing settings.
Which file types can it read?
PDFs and plain text files can be read for their content. Images and videos are logged by name, type and link, and their captions are written from the file name and description.
Can it write files back to Drive?
Yes. Some automations create documents or PDFs from Airtable records and save them to a Drive folder, then put the link back on the record.
Can it match a file to the right record?
Yes, by folder name, file name or details read from the file, depending on how you describe it.
Does it work with shared drives?
Yes, if the Google account you connect has access to the shared drive.
What happens to files already in the folder?
You choose whether to import existing files once or only handle files added after setup.

Related pages

Keep exploring

Tell your assistant what Airtable and Google Drive should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude