Skip to content
Airtable

Connect Airtable and SendGrid

Start a client’s workflow in Airtable and act in SendGrid, or the other way round, on the client’s own accounts.

Step by step, with the other ways to do it: How to send a SendGrid email when an Airtable record is created

Each app by itself: Airtable integration and SendGrid integration, with how to connect it, its scopes and its limits.

What Airtable and SendGrid do together

An Airtable base often holds a client’s bookings, orders or enquiries, and SendGrid sends email from an address the client has verified. Joined in a workflow, a new row in a table such as Leads becomes an email sent through the client’s own SendGrid account.

The pairing also runs back into the base. When an email SendGrid sent bounces, or someone clicks a tracked link in it, a starter adds an Airtable row with the address, the reason or the link. Airtable’s second trigger, “A record is changed”, sends the same kind of email when an existing row is edited, such as a quote marked ready.

What the pair is used for

  • A client who sends booking or order email through SendGrid can keep a bounce list in Airtable, one row per address with SendGrid’s reason and classification, and correct each one before the next send.
  • Click tracking feeds the same base with who clicked which link and from what browser, so the client sees which customers acted on an offer.
  • For email in the client’s own design, “Send a template email” fills one of their SendGrid dynamic templates from the row, and the template sets the subject and content.

Every way Airtable and SendGrid join

A workflow starts from a trigger in one app and runs a step in the other, on the client’s accounts. Where the library has a starter for it, it installs that pairing into a client switched off; any other pairing is two steps on the canvas.

From Airtable to SendGrid

Triggers in Airtable with steps in SendGrid
When this happens in AirtableThis runs in SendGridHow fastStarter
A record is addedSend an emailWithin 15 minutesInstall the starter
A record is addedSend a template emailWithin 15 minutesTwo steps on the canvas
A record is changedSend an emailWithin 15 minutesInstall the starter
A record is changedSend a template emailWithin 15 minutesTwo steps on the canvas

From SendGrid to Airtable

Triggers in SendGrid with steps in Airtable
When this happens in SendGridThis runs in AirtableHow fastStarter
An email bouncesCreate a recordWithin secondsInstall the starter
An email bouncesFind recordsWithin secondsTwo steps on the canvas
An email bouncesUpdate a recordWithin secondsTwo steps on the canvas
A link in an email is clickedCreate a recordWithin secondsInstall the starter
A link in an email is clickedFind recordsWithin secondsTwo steps on the canvas
A link in an email is clickedUpdate a recordWithin secondsTwo steps on the canvas

Set up the starter

Send an email in SendGrid when a record is added in Airtable

The starter “Send an email in SendGrid when a record is added in Airtable” checks the table every 15 minutes. Each new row becomes one plain-text email with the subject “A record is added” and a body saying a record was added in Airtable, followed by the time Airtable records as its creation. The From address is the one you type in, and it has to be a verified sender in SendGrid. The recipient is the address in “Who it goes to”.

Rows already in the table when you switch it on send nothing. After installing, bring the record’s own columns into the subject and the body (the trigger gives each one as fields followed by the column name), so every email names the booking or order it is about.

  1. 1Install the starter into the client from Templates → Library. It lands switched off.
  2. 2Connect the client’s Airtable, for “A record is added”
  3. 3Connect the client’s SendGrid, for “Send an email”
  4. 4Fill in Airtable: Base ID (For example appXXXXXXXXXXXXXX)
  5. 5Fill in Airtable: Table (For example Leads)
  6. 6Fill in SendGrid: From address (For example hello@northside.example)
  7. 7Fill in Who it goes to (SendGrid) (The address that gets it: yours, or the client’s team)
  8. 8Switch it on. Within 15 minutes: Airtable is checked every 15 minutes.
The install dialog for an example client, with the Airtable and SendGrid details filled in.
The installed workflow on the canvas: Airtable’s “A record is added” trigger leading to SendGrid’s “Send an email” step.

What it produces

The SendGrid step as it runs for an example client, Lakeview Consulting, when Emma Collins asks for a consultation: each value the starter fills in.

From
hello@lakeview.example
Subject
A record is added
Text
A record is added in Airtable. Added at: 2026-10-21T09:05:00Z
To
emma.collins@example.com

Setup notes for this pair

  • The bounce and click starters need an API key with Event Webhook access (Mail Send alone cannot make one), and each uses up one of the event webhooks the SendGrid plan allows.
  • “A record is changed” asks for a “Last modified time” field in the table. Limit that field to the columns whose edits should send an email.

Field mapping, starter by starter

Each value a starter’s step is given, and where it comes from. Words in brackets are filled in when it runs; change any of it after installing.

Send an email for new records

Send an email in SendGrid when a record is added in Airtable

The values Send an email in SendGrid when a record is added in Airtable sends
SendGrid valueFilled from
From[SendGrid: From address]
SubjectA record is added
TextA record is added in Airtable. Added at: [the created time, from Airtable]
To[Who it goes to (SendGrid)]

Send an email for changed records

Send an email in SendGrid when a record is changed in Airtable

The values Send an email in SendGrid when a record is changed in Airtable sends
SendGrid valueFilled from
From[SendGrid: From address]
SubjectA record is changed
TextA record is changed in Airtable. Added at: [the created time, from Airtable]
To[Who it goes to (SendGrid)]

Create a record for bounced emails

Create a record in Airtable when an email bounces in SendGrid

The values Create a record in Airtable when an email bounces in SendGrid sends
Airtable valueFilled from
Base ID[Airtable: Base ID]
Fields{"Address that bounced":"[the email’s email, from SendGrid]","Their servers answer":"[the email’s reason, from SendGrid]","Why":"[the email’s bounce classification, from SendGrid]","bounce hard or blocked soft":"[the email’s type, from SendGrid]"}
Table[Airtable: Table]

Create a record for email clicks

Create a record in Airtable when a link in an email is clicked in SendGrid

The values Create a record in Airtable when a link in an email is clicked in SendGrid sends
Airtable valueFilled from
Base ID[Airtable: Base ID]
Fields{"Browser":"[the email’s useragent, from SendGrid]","Category":"[the email’s category, from SendGrid]","Link":"[the email’s url, from SendGrid]","Who clicked":"[the email’s email, from SendGrid]"}
Table[Airtable: Table]

Airtable and SendGrid and their logos are trademarks of their owners, used here only to say what Thrum works with; no endorsement is implied.

Thrum is cooking.

Get early access and you’ll be among the first in. Early members get a launch perk.