How To Connect SendGrid To Google Sheets

Connect SendGrid to Google Sheets
Reading Time: 5 minutes

Imagine you were an ambassador to a distant country. You were sent there to establish a diplomatic relationship and foster trade which would benefit both your and that country. You went there full of hope, expecting a grand reception. But on landing, you were received coldly, and consigned to a  junkyard before and finally dismissed.

This is the fate of most emails. And your next batch of ambassadorial emails would meet a similar fate. But there are a few things we can do to ensure that the emails we send out are received, if not with open hearts, with open hands. One of these few things is to use tools like SendGrid. And we can optimise this by connecting SendGrid to Google Sheets.

We can easily connect SendGrid to Google Sheets using Amigo and automatically pull data from SendGrid to Google Sheets. You can then microscopically analyse all the small but important details and gather the information necessary to run a successful email campaign. And you can share the data with your team; you and your team will then have access to the up-to-date data simultaneously. More eyes usually result in more insights. And with more insights better strategies can be devised.

Amigo is an easy-to-use web tool and Google Sheets extension that lets us retrieve data from various sources without coding. And not just import data to Google Sheets stop there; it automates the data import serving you fresh data as and when you need them.

Let’s learn how to use the Amigo extension in Google Sheets to connect SendGrid to Google Sheets and import SendGrid data to Google Sheets.

How to connect SendGrid to Google Sheets

We’ll learn step by step how to connect SendGrid to Google Sheets and import SendGrid data to Google Sheets.

Step 1: Generate SendGrid API key

We’ll need to first get an API key with which we’ll connect SendGrid to Google Sheets and retrieve data from SendGrid.

Log in to your SendGrid account.

On the left panel, expand the settings tab and click API keys.

SendGrid account page

Click the Create API key button.

Creating an API key to connect SendGrid to Google Sheets

Name the API key, select the access level and click the Create and View button. (If you want access to only specific scopes, select the Restricted Access option and grant access–read, write or none–to the specific scopes.

Choose the access level and scopes of the API

Copy the key and make sure to store it somewhere safe. Sendgrid will not show the key again.

SendGrid API key

Step 2: Install the Amigo add-on in Google Sheets

Install the Amigo extension to connect SendGrid to Google Sheets and import SendGrid data to Google Sheets. You can get the extension from the Google Workspace Marketplace by clicking the link provided below.

Install Amigo to connect SendGrid to Google Sheets

Click here to install.

Alternatively, you can get it from Google Sheets.

  • Open a new sheet
  • Go to Extensions→Add-ons→Get add-ons
  • Search for Amigo and install

Step 3: Create SendGrid Google Sheets connection

Launch Amigo from any spreadsheet tab.

Launch Amigo in Google Sheets

A sidebar will appear on the right. Select SendGrid from the list of sources.

Select SendGrid from the sources list to connect to Google Sheets

Enter the API key generated earlier, name the connection and click Connect.

Creating a connection between SendGrid and Google Sheets

A SendGrid Google Sheets integration will be created. And we’ll be able to pull data from SendGrid to Google Sheets with a couple of clicks. The SendGrid Google Sheets connection will appear in the connections list.

Step 4: Import SendGrid data to Google Sheets

Click the connection you’ve created from the connection list.

The created SendGrid connection

From the dashboard, specify the date range for the SendGrid report to import to Google Sheets and select the aggregation–day, week, or month.

Date range and aggregation to import

Click the PREVIEW button to, well, see the preview of the data. Then name the report and click IMPORT.

Preview of the SendGrid data to import to Google Sheets

The SendGrid’s data will be imported to Google Sheets in a moment. The imported data have all the important email campaign metrics such as open rate, clicks, spam reports, delivery status, and so on.

Snippet of the imported data

And that’s it! Actually, that’s not it; in fact, that’s just a portion of it. After successfully integrating SendGrid with Google Sheets and importing data from SendGrid to Google Sheets, you may want the data to be updated automatically at regular intervals so that you’re never behind the report and the data are not behind you.

If that’s what you want, then simply set a refresh schedule and Amigo will retrieve the data automatically at the time and frequency you set it to.

Setting a refresh schedule for automatic update

You can also set the refresh schedule later.

  1. Click View Reports
  2. Select the report you want to be updated automatically
  3. Click Edit, set the interval and time
  4. Switch the refresh schedule toggle and save the changes

SendGrid is just one of the many sources of data that you connect to Google Sheets with Amigo and import data to Google Sheets with little manual input. If you’re someone who is loth to manual and mundane tasks and who likes efficiency and accuracy, then Amigo is to your speed.

Some related articles you may find useful:

Import SurveyMonkey Data To Google Sheets

Export Google Ads Data To Google Sheets

Export Facebook Ads Data to Google Sheets

X
Hire expert data analysts on-demand. Get 30 Days Free Trial