Skip to content
ClickRuntime

Automate Airtable

Keep your Airtable bases filled, checked and reported on. Form entries become records, new rows get scored, tagged or enriched, duplicates and stale records get flagged, and the totals land in your inbox. Describe what you want to your AI assistant, check what it will do, and it keeps running with your laptop closed.

Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Try asking

Create a ClickRuntime automation: give me a link I can point my website contact form at. Add each submission to my Airtable Leads table, and if the email is already there, update that record instead.

Paste it into your assistant. It tells you what it will send or change before it runs live.

Ideas

What you can automate in Airtable

Records that arrive on their own, fields filled in and cleaned up, alerts when a table goes quiet or piles up, and summaries and backups by email. These are ready-made starting points. Anything else you can describe works too.
The moment it happens

Save form submissions to Airtable

Every submission lands as a record in your table, and returning people update their existing record instead of creating a new one.

See how it works
The moment it happensAI

Screen new job applications in Airtable

Each applicant is scored against the job and sorted into shortlist, maybe or reject, and you get an email about the shortlisted ones.

See how it works
DailyAI

Get daily post drafts in Airtable to review

Each morning fresh drafts on your topics are waiting in Airtable, marked for your review.

See how it works
Hourly or daily

Keep Airtable prices up to date

The prices and values in your table update on their own every hour.

See how it works
On a scheduleAI

Collect Hacker News job posts in Airtable

Each 'Who is hiring' post is turned into a searchable record with company, role, location, remote and salary.

See how it works
Every 15 minutesAI

Fill in company details from their website

Each new URL in your table gets its page title, meta description, a summary and keywords filled in.

See how it works
Every 15 minutesAI

Tag and score new Airtable records automatically

Each new record gets its category, sentiment or score filled in from its text, without anyone reading it first.

See how it works
Hourly

Clean up and check Airtable fields

Image links become attachments and records with bad email addresses are flagged, every hour.

See how it works
WeeklyAI

Get a weekly spending summary from Airtable

Each Monday you get last week's totals by category, with a note on anything unusual.

See how it works
Daily

Send a daily team reminder and log it in Airtable

Your team gets the same reminder in Slack each day, and every one sent is logged in Airtable.

See how it works
The moment it happens

Delete a person's records on request

Send an email address and every record about that person is deleted, logged and confirmed to you.

See how it works
The moment it happens

Import a CSV file into Airtable

Send a link to a CSV and every row is added to your table, with an email telling you how many.

See how it works
On a schedule

Get a daily email of new Airtable records

Each evening you see everything added to your table that day in one email.

See how it works
On a schedule

Back up your Airtable base every week

Each week every table in your base is saved as a CSV and emailed to you.

See how it works
Every 5 minutes

Post new Airtable records to Slack

Your team sees each new record in Slack within minutes of it being added.

See how it works
Weekly

Find duplicate records in Airtable

Each week you get a list of records that share the same email, so you can merge them.

See how it works
Daily

Get one email with today's Airtable tasks

Each morning you see everything due today in a single email.

See how it works
Weekly

Get alerts about deals nobody has touched

Each week you see the records that haven't changed in two weeks, before they're forgotten.

See how it works
Daily

Get warned when your table stops getting records

If a form breaks and nothing new arrives for a day, you find out the same day.

See how it works
Hourly

Get alerts when too many records pile up

You hear once when a status goes over your limit, and again only after it has dropped and risen again.

See how it works Your own logic

Any other automation you can describe in words

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

See how to build your own

Build your own

Build any Airtable automation you can describe

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

Every hour, check new records in my Applicants table in Airtable, use AI to score each cover letter from 1 to 10 and write the score in the Score field.

When a record in my Airtable Orders table has Status set to Shipped, email the customer through Gmail with the tracking number from that record.

Every Friday, count the Airtable records created this week by Status, add a row with the totals to my Weekly Stats sheet in Google Sheets and post the summary in #ops on Slack.

Works with

Airtable with the apps you already use

Airtable runs the process. Connecting it to your chat, inbox, spreadsheets and phone means records come in from where work starts and updates go out to the people who need them.

Airtable works with hundreds of other apps

Name any of them when you ask your assistant, and your automation connects them. Over 248 apps are ready to go, and anything with an API works too.

  • Notion
  • Typeform
  • Jotform
  • Tally
  • Google Forms
  • HubSpot
  • Stripe
  • Shopify
  • Trello
  • Asana
  • Microsoft Teams
  • Discord
  • Outlook
  • Calendly
  • Webflow
  • Mailchimp
  • Google Calendar
  • monday.com

Beyond chat

Have Airtable work when you're not in the chat

Connecting Airtable to ChatGPT or Claude lets you ask about it while you chat. ClickRuntime handles the part that should happen on its own: checks on a schedule and actions on each new event, set up from the same chat and running after you close it.

Setup

Connect Airtable

You connect Airtable with a personal access token you create yourself. You choose its scopes and exactly which bases it can reach.

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.

Good to know

Airtable limits that affect automations

  • The token only reaches the bases you added to it and only does what its scopes allow. To use another base, edit the token in Airtable.
  • Airtable allows about 5 requests per second per base, and records are written in batches of 10, so large imports take a few minutes.
  • Updating a record by email or another key needs a field with unique values to match on.
  • Airtable's webhooks need refreshing every 7 days, so automations that watch a table check it on a schedule instead, usually every 5 to 15 minutes.
  • Backups and exports contain field values only. Attached files are not included.

FAQ

Questions about automating Airtable

What can ClickRuntime see in my Airtable?
Only the bases you added to your token, with the scopes you chose. With read and write scopes it can list, create, update and delete records. With `schema.bases:read` it can also see your tables and fields, which backups need.
Does this use up my Airtable automation runs?
No. ClickRuntime works through the Airtable API with your token, so reminders, alerts and reports don't count against the automation runs in your Airtable plan.
How quickly does it notice new records?
Anything sent to an automation's own link, like a form submission, is saved the moment it arrives. Automations that watch a table check it on a schedule, usually every 5 to 15 minutes.
Can it change or delete my records?
Only if your token has `data.records:write`. Most clean-up automations flag records rather than delete them. The one that removes a person's data on request deletes permanently, so keep its link private.
Do I need AI for Airtable automations?
No. Form capture, alerts, reminders, imports and backups run without it. Scoring, tagging, enrichment and drafting use the AI that comes with every ClickRuntime plan, so you don't need your own AI key.
Is this a Airtable connector for ChatGPT or Claude?
Not for chatting with Airtable data. A chat connector lets your assistant read and change Airtable while you're in the conversation. ClickRuntime is for the work that should happen without you: you set up an automation from the chat once, and it keeps running on a schedule or on each Airtable event.

Related pages

Keep exploring

Tell your assistant what Airtable should do

Free plan. No credit card.

Add to ChatGPTAdd to Claude