This integration will allow you to connect with Sendgrid and start collecting your data.

Setting up the Sendgrid Integration

How to connect

Login to your Blendo account and make sure that your data warehouse of choice is selected (at the navigation bar). Click on the “Add Pipeline” button to create a new Sendgrid pipeline. You will be presented a list of sources to choose from. This should also be what you see if you have no pipelines created yet. Select the Sendgrid option to start creating your pipeline.



Setting up the Sendgrid pipeline is really simple. You will be asked to fill in your account information on Sendgrid, specifically your API Key. In order to create the API Key needed, you should log into your Sendgrid account.

The API Key that you should use can be created at the “Settings” section of your Sendgrid account.



In order to create an API Key on your Sendgrid account that you can use on Blendo, you have to click on the bottom left corner of Settings and select “API Keys”. On the next page you should click on “Create API Key” on the top right corner.



To create an API Key you should type a name and select the Permissions. Blendo API Key must have the following permissions:

Read Access in:

  • Category Management
  • Email Activity
  • Sender Authentication
  • Stats
  • Suppressions

Full Access in:

  • Marketing Campaigns

No Access in:

  • Mail Send


Afterwards you should click on “Create & View” in order to generate a Key. After the Key is created, you should copy it and save it somewhere safe, as Sendgrid will not show it to you again for security reasons.

Going back to your Blendo account, you should fill in the API key that you have just created to authenticate your pipeline and click on “Next”.


In the second step you will be asked if you want to use a prefix to your tables names that will be created in your database. In case you leave it blank, the tables will use the default names.

Finally, select which Sendgrid resources you want to be synced. By default, all resources are selected. Click on each one you don’t need, to deselect it. When you are read click on the “Create” button. That’s it! Your pipeline is ready to receive data.

Configuration of the pipeline

Blendo collects the data as soon as they arrive and will sync them to your data warehouse according to your pipeline’s schedule. The default behaviour is to do this once per hour, but you can configure it to run as often as once per 15 minutes, by clicking on “Reschedule” button.


In this section you can also view the pipeline status, the details of the syncing status (the amount of records synced for each table or if an error has appeared), you can also stop the ongoing sync or start a new one before the following schedule sync.

Moreover, you can edit the resource selection for your pipeline by selecting or deselecting any of the resources.

Keep in mind that any changes that may be done to the pipeline will be valid starting from the following sync and on.

Expected Sendgrid Data Model & Schema Information

Blendo will now connect to your SendGrid data source. It will sync your historical data and all the future updates into your destination data warehouse. You will get analytics ready tables and syncs that make sure you will get recent and consistent data.

Let’s see:

  1. How Blendo syncs SendGrid data
  2. The tables with SendGrid data that we create in your destination data warehouse

How Blendo syncs SendGrid data

Historical Data

When Blendo first connects to SendGrid Data source, will pull all your historical data.

Sync Schedule

Blendo syncs SendGrid data based on the schedule and frequency you choose. The default setting is every 1 hour but is configurable from inside the app.

Replication Process

The first time Blendo syncs your SendGrid data performs a full replication. Then your SendGrid data is either replicated fully or updated, depending on each of the resources. More information can be found at the Expected SendGrid Data Model &Schema.Note that Blendo will only read your data.

I am message box. Click edit button to change this text.

After you finish the integration with SendGrid, you might see its status as Importing from sourceExporting to the destination, or Completed.

What SendGrid data do I have available?

Blendo creates analytics ready tables with recent and consistent data. Bellow is a diagram of the schema and you may also find a CSV with all the columns and fields in more detail.

Expected Sendgrid Data Model and Schema Information >>

Questions? Contact us!

in Connecting SaaS Data Sources