Connect SendGrid and Google Sheets
Start a client’s workflow in SendGrid and act in Google Sheets, or the other way round, on the client’s own accounts.
Each app by itself: SendGrid integration and Google Sheets integration, with how to connect it, its scopes and its limits.
What the pair is used for
- SendGrid bounces can feed a spreadsheet the client cleans their lists from, each row giving the address, bounce or blocked, SendGrid’s classification, the receiving server’s reason, the SMTP status and the category the email was sent under.
- For campaigns that rely on tracked links, each click writes the reader’s address, the URL, their browser’s user agent, the category, a Unix timestamp and SendGrid’s message ID, which ties the click to the exact email sent.
- Rows a team adds or edits in Google Sheets can go out as plain-text email from the client’s verified SendGrid sender to one address.
Every way SendGrid 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 SendGrid to Google Sheets
| When this happens in SendGrid | 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 SendGrid
| When this happens in Google Sheets | This runs in SendGrid | 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 SendGrid 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 SendGrid, 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 SendGrid: From address (For example hello@northside.example)
- 7Fill in Who it goes to (SendGrid) (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 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 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 two SendGrid triggers each take one of the plan’s event webhooks, so logging both bounces and clicks uses two.
- The timestamp in the click row is Unix time (seconds), so format the column or convert it in the step if people read the sheet.
- The emails list columns A to E by letter and leave the subject fixed as “A row is added” or “A row is changed”. Put a name or reference column into the subject after installing; the changed-row starter matches rows on column A.
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 SendGrid
| Google Sheets value | Filled from |
|---|---|
| Sheet | [Google Sheets: Sheet (tab)] |
| Spreadsheet ID | [Google Sheets: Spreadsheet ID] |
| Values | [the email’s email, from SendGrid] [the email’s type, from SendGrid] [the email’s bounce classification, from SendGrid] [the email’s reason, from SendGrid] [the email’s status, from SendGrid] [the email’s category, from SendGrid] |
Add a row for email clicks
Add a row in Google Sheets when a link in an email is clicked in SendGrid
| Google Sheets value | Filled from |
|---|---|
| Sheet | [Google Sheets: Sheet (tab)] |
| Spreadsheet ID | [Google Sheets: Spreadsheet ID] |
| Values | [the email’s email, from SendGrid] [the email’s url, from SendGrid] [the email’s useragent, from SendGrid] [the email’s category, from SendGrid] [the email’s timestamp, from SendGrid] [the email’s sg message id, from SendGrid] |
Send an email for new rows
Send an email in SendGrid when a row is added in Google Sheets
| SendGrid value | Filled from |
|---|---|
| From | [SendGrid: From address] |
| 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 (SendGrid)] |
Send an email for changed rows
Send an email in SendGrid when a row is changed in Google Sheets
| SendGrid value | Filled from |
|---|---|
| From | [SendGrid: From address] |
| 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 (SendGrid)] |
SendGrid 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.