Skip to content
ClickRuntime

Connect Google Sheets to SendGrid

Your sheet already holds the people you want to email: leads, applicants, subscribers. SendGrid is built to deliver those emails reliably and in volume. Connect them and the sheet becomes your send list, with each row marked once its email has gone.
Add to ChatGPTAdd to Claude
Works inChatGPTClaudeClaude CodeCursorCodexVS CodeGemini CLIZedopencodeAny MCP client

Ideas

What you can do with Google Sheets and SendGrid

Welcome emails, outreach, newsletters and weekly reports, sent through SendGrid to the people in your sheet. These are ready-made starting points. Anything else you can describe works too.
Every 30 minutesAI

Screen applicants in a sheet and email each one

Every new applicant in your sheet is scored against the job, the score is written back, and they get the right email.

See how it works
Daily

Send a personalised email sequence to leads in a sheet

Each lead in your sheet gets a short, personal sequence of emails through SendGrid, and the sheet shows who is at which step.

See how it works
Every 15 minutes

Send a welcome email to each new row in a sheet

Anyone added to your sheet gets your welcome email through SendGrid, with their name filled in, and the row is marked as sent.

See how it works
WeeklyAI

Send your newsletter to everyone in a subscriber sheet

AI drafts your newsletter, you approve it, and it goes to every subscriber in your sheet through SendGrid, with each send logged.

See how it works
Weekly

Email the team a weekly metrics report from a sheet

Every Monday your team gets an email with last week's numbers from your sheet, the change from the week before, and a short summary.

See how it works Your own logic

Any other automation you can describe in words

Your own rules, schedule and AI steps with Google Sheets and SendGrid, plus any other app. Describe it and your assistant builds it.

See how to build your own

Build your own

Build any Google Sheets and SendGrid automation you can describe

The ideas above are ready-made starting points, not a fixed list. Describe what should happen between Google Sheets and SendGrid in your own words, with your conditions, other apps or an AI step, and your assistant writes it, tests it and runs it on ClickRuntime.

  • Your own rules

    Conditions, thresholds, filters and exceptions, written the way you'd explain them to a colleague.

  • Any number of apps

    One automation can read from one app and update several others. Over 248 apps are ready, and anything with an API works too.

  • AI where it helps

    Summaries, classification, extraction and drafts use ClickRuntime's built-in AI, with no extra key.

  • On a schedule or on each event

    Runs as often as every 5 minutes, or the moment an app sends an event, and keeps track of what it already handled.

For example, ask your assistant

Only email rows where the "country" column is US or CA and the address has not bounced before, and send at most 200 per day.

Have AI write a two-sentence opening for each row based on the company and role columns, and hold any row where the company column is empty.

Use cases

Why people connect Google Sheets and SendGrid

How the two apps work together

  • A check every few minutes finds new or changed rows in Google Sheets, such as a status set to "send".
  • The script sends the email through SendGrid, using a dynamic template or AI-written text, and writes "sent" and the time back to the row.
  • Optionally, SendGrid's Event Webhook posts bounces, opens and unsubscribes to a trigger link, and the script updates the matching row.

  • Marketers sending to a list in a sheet

    A list of contacts with first name, company and segment lives in Google Sheets. Each row gets a personal email through SendGrid and a status column records the result.

  • Event organisers emailing attendees

    Registrations land in a sheet and each new attendee gets a confirmation with the date and joining details. Later, a reminder goes to everyone on the list.

  • Recruiters updating candidates

    A hiring sheet tracks the stage for each candidate. When the stage column changes, the candidate gets the matching email from SendGrid.

  • Teams tracking bounces and opens

    SendGrid events such as bounce, open or unsubscribe are written back to the sheet. The list stays clean and you can see who engaged.

More apps

Google Sheets, SendGrid and other apps in one automation

An automation isn't limited to two apps. Add the next step in another app and it runs as part of the same automation.

Typeform signups to a sheet with welcome email

When a Typeform response comes in, add it to my Google Sheet and send a welcome email through SendGrid with their name and their answer to the "goal" question.

Daily send report in Slack

Each evening, count rows marked sent, bounced and unsubscribed in my sheet and post the totals to #marketing.

Sync engaged contacts to HubSpot

When a contact in my sheet opens two SendGrid emails, create or update them in HubSpot with the source "sheet campaign".

Setup

Connect Google Sheets and SendGrid once

Every idea on this page uses the same two connections, so you set them up once. If one is missing, your assistant tells you and links to the right place.

Google Sheets

Spreadsheets

  1. In the ClickRuntime dashboard, open Connections and choose Google Sheets.
  2. Sign in with your Google account and allow access.
  3. Pick the spreadsheets the automation may use. It can't see any other file in your Drive.

SendGrid

Email (transactional / marketing)

  1. In SendGrid, go to Settings, API Keys and choose Create API Key.
  2. Pick Restricted Access and give only what your automations need, such as Mail Send: Full, plus Marketing, Stats or Suppressions access for the matching automations.
  3. Copy the key. SendGrid shows it only once.
  4. In the ClickRuntime dashboard, open Connections & secrets and save the key as a secret for SendGrid.

FAQ

Questions about connecting Google Sheets and SendGrid

Do I need a SendGrid account?
Yes, with a verified sender address or domain. You save a SendGrid API key with Mail Send access as a secret in your ClickRuntime dashboard.
How does it avoid emailing someone twice?
Each row gets a sent date or status written back after its email goes out, and rows that already have one are skipped.
Can I use my SendGrid templates?
Yes. Give the template id in the prompt and the row's columns are passed in as the template's fields, such as first name and company.
What about unsubscribes?
SendGrid's own suppression lists still apply, so anyone who unsubscribed or bounced is not emailed even if they are still in the sheet.
Can it use my verified sender in SendGrid?
Yes. Emails go out from a sender or domain you have verified in SendGrid, using your own API key saved in the ClickRuntime dashboard.
How many emails can it send in one run?
It can send a batch per run and continue on the next run, which keeps you within your SendGrid plan limits. You can set a daily cap.
Does the sheet need a status column?
It helps. A status or "sent at" column lets the script skip rows it has already emailed and makes progress easy to see.

Related pages

Keep exploring

Tell your assistant what Google Sheets and SendGrid should do together

Free plan. No credit card.

Add to ChatGPTAdd to Claude