Sending SendGrid Emails From New Google Sheets Rows

If you want to automatically send emails through your SendGrid account when you update your Google Sheets spreadsheets, you can do that using Zapier.

You will need:

Steps

  1. Getting your accounts ready
  2. Connecting your accounts

Getting your accounts ready

To connect your Google Sheets to Zapier, make sure you have created a new sheet for this purpose. You can learn more about getting started with Google Sheets on Zapier, here.

To link your Google Sheets to SendGrid, you must have an active SendGrid account. To learn more about getting started with SendGrid basics, start here. For more information about getting started with SendGrid on Zapier, go here.

Connecting your accounts

Click here to Send SendGrid emails from new Google Sheets rows.

  1. Choose your Google Sheets account from the list of accounts, or connect a new account.
  2. Choose the Spreadsheet and the Worksheet you wish to use.

Google Sheets pages

  1. Choose your SendGrid account from the list of accounts, or connect a new account.
  2. To connect your SendGrid account to Zapier for the first time, you will enter the credentials of an API/mail account. If you have not created this account, you can do so here.

Credential entry

  1. Using fields from Google Sheets, create, and customize the To, From, and Subject email message that the Zap will send.

Email content

  1. Click Save + Finish.

Now test the Zap to make sure it works. Once you’re satisfied with the results, newly updated rows in Google Sheets will send corresponding emails through your SendGrid account.

If you ever want to change this Google Sheets and SendGrid integration, just go to your Zapier dashboard and tweak anything you'd like.

You can also check out all that’s possible with Google Sheets on Zapier, and other ways to connect Google Sheets and SendGrid.

Rate this page:

Need some help?

We all do sometimes. Get help now from the Twilio SendGrid Support Team.

Running into a coding hurdle? Lean on the wisdom of the crowd by browsing the SendGrid tag on Stack Overflow or visiting Twilio's Stack Overflow Collective.

Thank you for your feedback!

Please select the reason(s) for your feedback. The additional information you provide helps us improve our documentation:

Sending your feedback...
🎉 Thank you for your feedback!
Something went wrong. Please try again.

Thanks for your feedback!

thanks-feedback-gif