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

What each client fills in

SendGrid: From address

For example hello@northside.example

Who it goes to (SendGrid)

The address that gets it: yours, or the client’s team.

Google Sheets: Spreadsheet ID

For example from the URL: docs.google.com/spreadsheets/d/<this>/edit

Google Sheets: Sheet (tab)

For example Sheet1

The accounts it needs

Each is the client’s own, stored encrypted and never copied between clients. Until one is added the client’s checklist shows it, and nothing runs.

• Google Sheets

  In your own Google Cloud project: enable the Google Sheets API, then IAM & Admin → Service accounts → Create → Keys → Add key → JSON, and paste the file here. Then share each client sheet with the service account’s email (…@….iam.gserviceaccount.com) as an Editor. The account is yours; no Google review is needed.

• 

  SendGrid → Settings → API Keys → Create API Key with Mail Send access; for the triggers, also the Event Webhook settings permission (user.webhooks.event.settings.read and user.webhooks.event.settings.update), or Full Access. The From address must be a verified sender.

After you install it

It lands switched off. The client’s checklist holds exactly this:

1. Connect the client’s Google Sheets, for “A row is changed”
2. Connect the client’s SendGrid, for “Send an email”
3. Fill in Google Sheets: Spreadsheet ID (For example from the URL: docs.google.com/spreadsheets/d/<this>/edit)
4. Fill in Google Sheets: Sheet (tab) (For example Sheet1)
5. Fill in SendGrid: From address (For example hello@northside.example)
6. Fill in Who it goes to (SendGrid) (The address that gets it: yours, or the client’s team)