Connect Postmark and Google Sheets
Start a client’s workflow in Postmark and act in Google Sheets, or the other way round, on the client’s own accounts.
Each app by itself: Postmark integration and Google Sheets integration, with how to connect it, its scopes and its limits.
What the pair is used for
- Every Postmark bounce can add a row to a Google Sheets tab with the address, the bounce type, Postmark’s description of it, whether the address is now inactive, and the subject and sender of the email that failed.
- Clicks can be logged the same day they happen, one row per tracked click with the recipient, the original link, where in the email it was clicked, the platform, the city and the message tag, which shows which link in a send is working.
- A sheet that staff or a form fill in can email a fixed address through Postmark whenever a row is added or edited, quoting its first five columns.
Every way Postmark and Google Sheets 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 Postmark to Google Sheets
| When this happens in Postmark | This runs in Google Sheets | How fast | Starter |
|---|---|---|---|
| An email bounces | Add a row | Within seconds | Install the starter |
| An email bounces | Update a row | Within seconds | Two steps on the canvas |
| A link in an email is clicked | Add a row | Within seconds | Install the starter |
| A link in an email is clicked | Update a row | Within seconds | Two steps on the canvas |
From Google Sheets to Postmark
| When this happens in Google Sheets | This runs in Postmark | How fast | Starter |
|---|---|---|---|
| A row is added | Send an email | Within 15 minutes | Install the starter |
| A row is added | Send a template email | Within 15 minutes | Two steps on the canvas |
| A row is changed | Send an email | Within 15 minutes | Install the starter |
| A row is changed | Send a template email | Within 15 minutes | Two steps on the canvas |
Set up the starter
Send an email in Postmark when a row is added in Google Sheets
- 1Install the starter into the client from Templates → Library. It lands switched off.
- 2Connect the client’s Google Sheets, for “A row is added”
- 3Connect the client’s Postmark, for “Send an email”
- 4Fill in Google Sheets: Spreadsheet ID (For example from the URL: docs.google.com/spreadsheets/d/<this>
/edit) - 5Fill in Google Sheets: Sheet (tab) (For example Sheet1)
- 6Fill in Postmark: From (For example Northside Plumbing <hello@northside.example>)
- 7Fill in Who it goes to (Postmark) (The address that gets it: yours, or the client’s team)
- 8Switch it on. Within 15 minutes: Google Sheets is checked every 15 minutes.

What it produces
The Postmark 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 row is added
- Text
- A row is added in Google Sheets. Column A: example Column B: example Column C: example Column D: example Column E: example
- To
- emma.collins@example.com
Setup notes for this pair
- The bounce and click rows write six values left to right from column A, so give the tab headers in that order before switching on, or the values land under the wrong headings.
- The sheet-to-email starters quote columns A to E by letter. Rename those lines after your own headers, and add any column past E yourself. The changed-row starter identifies rows by column A, so every row needs its own value there.
- Both Postmark triggers hear only the message stream you name.
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.
Add a row for bounced emails
Add a row in Google Sheets when an email bounces in Postmark
| Google Sheets value | Filled from |
|---|---|
| Sheet | [Google Sheets: Sheet (tab)] |
| Spreadsheet ID | [Google Sheets: Spreadsheet ID] |
| Values | [the email’s email, from Postmark] [the email’s type, from Postmark] [the email’s description, from Postmark] [the email’s inactive, from Postmark] [the email’s subject, from Postmark] [the email’s from, from Postmark] |
Add a row for email clicks
Add a row in Google Sheets when a link in an email is clicked in Postmark
| Google Sheets value | Filled from |
|---|---|
| Sheet | [Google Sheets: Sheet (tab)] |
| Spreadsheet ID | [Google Sheets: Spreadsheet ID] |
| Values | [the email’s recipient, from Postmark] [the email’s original link, from Postmark] [the email’s click location, from Postmark] [the email’s platform, from Postmark] [the email’s city, from Postmark] [the email’s tag, from Postmark] |
Send an email for new rows
Send an email in Postmark when a row is added in Google Sheets
| Postmark value | Filled from |
|---|---|
| From | [Postmark: From] |
| Subject | A row is added |
| Text | A row is added in Google Sheets. Column A: [the 0, from Google Sheets] Column B: [the 1, from Google Sheets] Column C: [the 2, from Google Sheets] Column D: [the 3, from Google Sheets] Column E: [the 4, from Google Sheets] |
| To | [Who it goes to (Postmark)] |
Send an email for changed rows
Send an email in Postmark when a row is changed in Google Sheets
| Postmark value | Filled from |
|---|---|
| From | [Postmark: From] |
| Subject | A row is changed |
| Text | A row is changed in Google Sheets. Column A: [the 0, from Google Sheets] Column B: [the 1, from Google Sheets] Column C: [the 2, from Google Sheets] Column D: [the 3, from Google Sheets] Column E: [the 4, from Google Sheets] |
| To | [Who it goes to (Postmark)] |
Postmark and Google Sheets 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.