comparison

Gmail to Airtable: 4 Ways to Connect Gmail and Airtable

Leandro Zubrezki··11 min read
Gmail to Airtable: 4 Ways to Connect Gmail and Airtable

I built Quicktion partly because I kept seeing people use Airtable as a smarter inbox (grid for triage, kanban for pipeline, calendar for follow-ups) and then giving up because there was no good way to actually get emails in there. A spreadsheet would have been easier, but a spreadsheet doesn't have Linked Records, doesn't have a Multiple Attachments field, and doesn't fire Airtable Automations when a row changes.

The reason Airtable is worth the trouble is exactly that: typed fields, multiple views, shared interfaces, and a mobile app that's actually usable. The reason it's a pain is that Gmail and Airtable don't talk to each other. Airtable has no Gmail integration. Gmail has no "send to Airtable" action. So you're left choosing between four methods, and they're not equally good.

  1. Gmail add-on (manual, one-click saves from the Gmail sidebar)
  2. Email forwarding (automatic, rule-based saves via a forwarding address)
  3. Zapier (general automation platform)
  4. Make (visual scenarios, more flexibility, more setup)

I'll walk through each one honestly, including where Quicktion doesn't do the thing you might be hoping for.

Method 1: Gmail Add-on (Quicktion)

The Gmail add-on lives in the right sidebar of Gmail. You open an email, click the Quicktion icon, pick your Airtable destination, and the record shows up in your base. No tab switching, no copy-paste.

How to set it up

Install Quicktion from the Google Workspace Marketplace, grant the Gmail permissions, then sign in inside the sidebar. Connect Airtable via OAuth (you grant access to specific bases, not your whole workspace).

In the Quicktion dashboard, create a destination linked to one Airtable base and one table. Map email fields to Airtable fields. Quicktion auto-suggests sensible mappings; you adjust as needed.

Open any email, click the Quicktion icon, and hit Save to Airtable. The record appears within a couple of seconds.

Preview and edit before the row exists

Before I save, the add-on shows me what the row will look like. I can edit any field: change a default Single Select status, tweak the subject, override the sender. This is the feature I personally use most. I read a customer email, decide it's "needs follow-up" not "general feedback," and set that field there before the row gets created.

What gets saved (and to which Airtable field types)

Quicktion writes to the following Airtable field types out of the box:

Email contentAirtable field typeNotes
SubjectSingle Line Text or Long TextEither works
Sender nameSingle Line Text
Sender emailEmail field or Single Line TextBoth supported
Date receivedDate, or Date with TimeSaved in ISO 8601
Email bodyLong TextSaved as markdown (links preserved, signatures cleaned up)
AttachmentsMultiple AttachmentsPDFs, images, docs, uploaded directly into the field
Gmail thread linkURL or Single Line TextOptional, lets you jump back to the original email

For default values (set per destination, applied to every saved email), I also support: Single Select, Multiple Select, Checkbox, Number, Currency, Percent, Rating, Duration, Linked Record (you pick a specific record to link to), and User fields.

What Quicktion does NOT do for Airtable

Being honest about this matters more than the marketing copy:

  • No auto-resolving Linked Records from email content. If the sender is lisa@acme.com, Quicktion won't search your Contacts table for a matching record and link to it. You can set a static default linked record per destination, or build an Airtable Automation on top of the table.
  • No writing to Formula, Lookup, Rollup, or Count fields. Those are Airtable-computed and read-only via the API. Same for Created Time, Last Modified Time, Autonumber.
  • No Barcode, Button, or Sync field writes. Same reason.
  • Attachments don't populate Lookup fields in linked tables. They go into the Multiple Attachments field on the row Quicktion creates.

When to use it

The add-on is for selective saves. You're reading an email, you decide this one belongs in Airtable, you save it with the right field values on the spot. Good for vendor communications you want in a CRM base, support escalations going into a triage table, partner emails you log against a deals table.

For a full walkthrough see the save emails to Airtable guide or the marketing overview.

Save emails in seconds

Forward any email to your Quicktion address and it lands in Notion, Google Sheets, Airtable, Linear, or Trello automatically.

Method 2: Email Forwarding (Quicktion)

Forwarding is the version of this you set up once and stop thinking about. Quicktion gives you a unique address like abc123@in.quicktion.io. Anything you send (or auto-forward) there becomes a new record in your Airtable table.

How it works

In the dashboard, create an Airtable destination. Configure your field mappings and any default values (a default Single Select status, a default Linked Record pointing at an "Inbound" project, whatever your workflow needs). Quicktion generates the forwarding address.

Forward manually, or set up a Gmail filter so anything matching a search query auto-forwards. Every email lands as a new row within seconds.

Setting up auto-forwarding in Gmail

  1. In Gmail's search bar dropdown, define your filter (sender, subject contains, has attachment, label, etc.)
  2. Click Create filter
  3. Check Forward it to and pick your Quicktion forwarding address
  4. Optionally check Also apply filter to matching conversations to backfill

Once that's set, the pipeline runs without you. For the full setup walkthrough see the forward emails to Airtable guide.

Two workflow examples

Concrete is more useful than generic, so here are two patterns I see most often.

Lead intake CRM. A team uses a contact form that emails leads@company.com. Gmail filter auto-forwards anything matching to:leads@company.com to a Quicktion address. The Airtable base has a Leads table with fields for Company (Single Line Text), Email (Email field), Source (Single Select, default "Web form"), Status (Single Select, default "New"), Body (Long Text), and Attachments (Multiple Attachments). Grid view is the inbox for new leads. A kanban view grouped by Status becomes the pipeline. With Pro's AI Email Intelligence on, the destination has a prompt like "Extract the company name from the email signature or the sender's domain" filling the Company field. Sales triages from the kanban; nobody touches Gmail.

Customer support ticket triage. support@ forwards into Quicktion. Airtable base has a Tickets table with Subject (Single Line Text), Customer Email (Email field), Priority (Single Select), Category (Single Select), Body (Long Text), Screenshots (Multiple Attachments), and Status (Single Select, default "Open"). AI prompt: "Set Priority to Urgent if the email mentions outage, billing, or data loss. Set Category based on the subject." Kanban view grouped by Status drives the support standup. Screenshots from the customer land in Multiple Attachments, so the engineer sees the bug image without leaving Airtable.

What you get

  • Fully automatic once configured
  • Works with any email client (Outlook, iCloud, fastmail, whatever; forwarding is client-agnostic)
  • Rule-based: only matching emails save
  • Body saved as clean markdown in a Long Text field
  • Attachments uploaded straight into Multiple Attachments
  • Plays nicely with Airtable Automations downstream (route a row to Slack on save, change Status when a field hits a value, etc.)

What you don't get

  • No preview before the row is created (it's automated by definition)
  • One Gmail filter setup step
  • Manual forwards take one extra click vs. the add-on

When to use it

Forwarding wins whenever the rule is "every email of type X should go to Airtable." Vendor invoices, form submissions, order confirmations, anything where you can describe it as a Gmail search query. Combine forwarding (for the predictable stuff) with the add-on (for the one-offs) and you've covered the whole surface.

Method 3: Zapier

Zapier's a general automation platform. You build a Zap with a Gmail trigger and an Airtable "Create record" action.

How it works

You authorize Zapier on Gmail and Airtable, configure the trigger filter, manually map every email field to every Airtable field, activate the Zap.

Where Zapier falls short for Airtable specifically

  • 5-15 minute polling. Email at 10:00 might not show up in Airtable until 10:15. Not instant.
  • Body comes through as plain text or raw HTML. No conversion to markdown. The body field is either stripped of formatting or full of <div> tags.
  • The Multiple Attachments field is the hard part. Zapier gives you attachment URLs from Gmail, but doesn't download the file and re-upload it into Airtable's attachment field. You need extra Zap steps (sometimes a third app like Dropbox) to make it work, and each step costs a task.
  • Task-based billing. Each saved email is a task. Each formatting or attachment step is another task. Free plan is 100 tasks/month total.
  • Field mapping breaks when you rename Airtable fields. Quicktion maps by stable field ID; Zapier prompts you to remap.

Pros

  • Good if the workflow fans out to multiple apps (save to Airtable AND post in Slack AND create an Asana task)
  • Familiar interface for teams already on Zapier

Cons

  • Polling delays
  • Body formatting is bad in Airtable's Long Text field
  • Attachments require workarounds
  • $19.99+/month for regular use

For the head-to-head see the Zapier vs Quicktion for Airtable post.

Method 4: Make (Integromat)

Make is Zapier's more powerful, less polished cousin. Visual modules instead of linear triggers.

How it works

A Scenario with a Gmail watch module and an Airtable create-record module, scheduled to run on an interval (15 min on the free plan).

What's different from Zapier

Make's data transformation between modules is genuinely more flexible. You can parse strings, format dates, and extract content with built-in functions before the value hits Airtable. It's also cheaper at equivalent volume. The trade is a steeper learning curve and the same fundamental problems: polling, no native attachment upload, no clean body markdown without writing the parsing yourself.

Pros / Cons

Same shape as Zapier. Cheaper, more flexible, more complex. Worth it if you're already on Make for something else. Overkill if Airtable is the only destination.

Method comparison

FeatureGmail Add-onEmail ForwardingZapierMake
Setup time~2 min~5 min15-20 min20-30 min
AutomaticNo (manual)YesYesYes
Edit before saveYesNoNoNo
Real-timeYesYesNo (5-15 min)No (15 min)
Body in Long TextClean markdownClean markdownPlain text / raw HTMLPlain text
Multiple Attachments fieldNative uploadNative uploadURLs only (extra steps)Custom modules
Linked Record defaultsYes (per destination)Yes (per destination)Manual per ZapManual per scenario
AI field extractionYes (Pro)Yes (Pro)NoNo
Works with non-GmailNoYesGmail trigger onlyGmail trigger only
Free tier25 emails/mo25 emails/mo100 tasks/mo1,000 ops/mo
Paid$12/mo (Pro)$12/mo (Pro)$19.99+/mo$9+/mo

Which one should you actually pick

If you want one-click saves from inside Gmail with a preview before the record gets created, use the Quicktion add-on. The preview matters more than people expect. Being able to set a Status or override the Company field before save is the difference between "Airtable becomes my source of truth" and "Airtable becomes a graveyard of half-correct rows."

If you have predictable email patterns (form submissions, receipts, support tickets, lead inquiries), use forwarding. Set the Gmail filter once, define defaults on the destination so every row lands tagged correctly, and stop thinking about it.

Use both together for full coverage. That's what I do.

Pick Zapier or Make only if the email needs to fan out to multiple non-Airtable destinations in the same workflow. If Airtable is the endpoint, they cost more and produce worse rows than Quicktion does.

Getting started

Install Quicktion from the Google Workspace Marketplace, authorize Airtable, and build your first destination. Free plan is 25 emails/month and one destination, enough to see whether your Long Text body looks right and whether attachments land in the field you expect.

For step-by-step setup see the save emails to Airtable guide and the forward emails to Airtable guide. If you're considering rolling your own with Airtable's built-in tools, the Airtable Automations vs Quicktion breakdown covers the tradeoffs. And if you're comparing destinations, the Gmail to Google Sheets integration guide covers why people pick Sheets over Airtable (and when they shouldn't).

Ready to put your emails where they belong?

Quicktion lets you forward emails or use the Gmail add-on to save messages to Notion, Google Sheets, Airtable, Linear, or Trello. No code required.

LZ

Leandro Zubrezki

Founder of Quicktion

Building tools to bridge the gap between email and the tools you already use. Leandro created Quicktion to help teams save time by automating email workflows across Notion, Google Sheets, Airtable, Linear, and Trello.

Related Posts