SendGrid Integration and Expected Data

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.