Skip to content
Airtable

Connect Airtable and Postmark

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

Step by step, with the other ways to do it: How to log Postmark bounces in Airtable

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

What Airtable and Postmark do together

Postmark sends a client’s receipts, confirmations and account emails, and an Airtable base can sit beside it as the place where the people and orders behind those emails are kept. Connecting the two lets the base start emails and lets Postmark report back into the base.

From Airtable, a record that is added or changed sends a plain-text email through the client’s Postmark server, and a “Send a template email” step fills one of the client’s Postmark templates instead. From Postmark, two triggers arrive within seconds, an email that bounces and a tracked link that is clicked, and each has a starter that writes an Airtable row.

What the pair is used for

  • Clicks on tracked links are logged as rows too, with who clicked, the link, the device and whether it was in the HTML or text part, so the client sees who acts on a receipt or confirmation.
  • A row can send one of the client’s Postmark templates, such as a booking confirmation, with “Send a template email” filling its variables from the record.

Every way Airtable and Postmark 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 Postmark

Triggers in Airtable with steps in Postmark
When this happens in AirtableThis runs in PostmarkHow 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 Postmark to Airtable

Triggers in Postmark with steps in Airtable
When this happens in PostmarkThis 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

Create a record in Airtable when an email bounces in Postmark

The starter picked here is Postmark’s “An email bounces” to Airtable’s “Create a record”, which turns each Postmark bounce into a row the client’s team can act on. You fill in the message stream the emails go out on (“outbound” unless the server has others), the base ID and the table.

Each row gets four values. “Address that bounced” holds the email address, “Bounce type HardBounce” holds Postmark’s type for the bounce, “What happened” holds Postmark’s description of it, and “Address now deactivated” says whether Postmark has stopped sending to that address. Match those names to the client’s own columns, or create the columns, before you switch it on.

  1. 1Install the starter into the client from Templates → Library. It lands switched off.
  2. 2Connect the client’s Postmark, for “An email bounces”
  3. 3Connect the client’s Airtable, for “Create a record”
  4. 4Fill in Postmark: Message stream (The stream the emails go out on: “outbound” unless the server has others)
  5. 5Fill in Airtable: Base ID (From the base’s URL: airtable.com/appXXXX/…)
  6. 6Fill in Airtable: Table (For example Leads)
  7. 7Match Airtable’s fields to the client’s own: Address that bounced, Bounce type HardBounce, What happened, Address now deactivated
  8. 8Switch it on. Within seconds: Postmark tells us as it happens.
The install dialog for an example client, with the Postmark and Airtable details filled in.
The installed workflow on the canvas: Postmark’s “An email bounces” trigger leading to Airtable’s “Create a record” step.

What it produces

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

Base ID
appXXXXXXXXXXXXXX
Fields
{"Address now deactivated":"{{ trigger.payload.Inactive }}","Address that bounced":"{{ trigger.payload.Email }}","Bounce type HardBounce":"{{ trigger.payload.Type }}","What happened":"{{ trigger.payload.Description }}"}
Table
Leads

Setup notes for this pair

  • “Send a template email” uses templates on the server whose token is connected. A template on another Postmark server is out of reach.

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 Postmark when a record is added in Airtable

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

Send an email for changed records

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

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

Create a record for bounced emails

Create a record in Airtable when an email bounces in Postmark

The values Create a record in Airtable when an email bounces in Postmark sends
Airtable valueFilled from
Base ID[Airtable: Base ID]
Fields{"Address now deactivated":"[the email’s inactive, from Postmark]","Address that bounced":"[the email’s email, from Postmark]","Bounce type HardBounce":"[the email’s type, from Postmark]","What happened":"[the email’s description, from Postmark]"}
Table[Airtable: Table]

Create a record for email clicks

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

The values Create a record in Airtable when a link in an email is clicked in Postmark sends
Airtable valueFilled from
Base ID[Airtable: Base ID]
Fields{"Device":"[the email’s platform, from Postmark]","Link":"[the email’s original link, from Postmark]","Where the link was HTML or text":"[the email’s click location, from Postmark]","Who clicked":"[the email’s recipient, from Postmark]"}
Table[Airtable: Table]

Airtable and Postmark 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.