Skip to content
Google Sheets

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

Triggers in SendGrid with steps in Google Sheets
When this happens in SendGridThis runs in Google SheetsHow fastStarter
An email bouncesAdd a rowWithin secondsInstall the starter
An email bouncesUpdate a rowWithin secondsTwo steps on the canvas
A link in an email is clickedAdd a rowWithin secondsInstall the starter
A link in an email is clickedUpdate a rowWithin secondsTwo steps on the canvas

From Google Sheets to SendGrid

Triggers in Google Sheets with steps in SendGrid
When this happens in Google SheetsThis runs in SendGridHow fastStarter
A row is addedSend an emailWithin 15 minutesInstall the starter
A row is addedSend a template emailWithin 15 minutesTwo steps on the canvas
A row is changedSend an emailWithin 15 minutesInstall the starter
A row is changedSend a template emailWithin 15 minutesTwo steps on the canvas

Set up the starter

Send an email in SendGrid when a row is added in Google Sheets

  1. 1Install the starter into the client from Templates → Library. It lands switched off.
  2. 2Connect the client’s Google Sheets, for “A row is added”
  3. 3Connect the client’s SendGrid, for “Send an email”
  4. 4Fill in Google Sheets: Spreadsheet ID (For example from the URL: docs.google.com/spreadsheets/d/<this>/edit)
  5. 5Fill in Google Sheets: Sheet (tab) (For example Sheet1)
  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: Google Sheets is checked every 15 minutes.
The installed workflow on the canvas: Google Sheets’s “A row 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 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

The values Add a row in Google Sheets when an email bounces in SendGrid sends
Google Sheets valueFilled 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

The values Add a row in Google Sheets when a link in an email is clicked in SendGrid sends
Google Sheets valueFilled 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

The values Send an email in SendGrid when a row is added in Google Sheets sends
SendGrid valueFilled from
From[SendGrid: From address]
SubjectA row is added
TextA 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

The values Send an email in SendGrid when a row is changed in Google Sheets sends
SendGrid valueFilled from
From[SendGrid: From address]
SubjectA row is changed
TextA 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.