Follow our setup guide to connect SendGrid to Fivetran.
Prerequisiteslink
To connect SendGrid to Fivetran, you need a SendGrid account.
IMPORTANT: Only use an HTTPS URL with TLS version 1.2 or above.
Setup instructionslink
Create an API Keylink
-
Log in to your SendGrid account.
-
Go to Settings -> API Keys.
-
Click Create API Key.
-
Give a descriptive name to the Fivetran API key and select Restricted Access.
-
In the Access Details section, select the following permissions for the Fivetran API key. Fivetran requires these permissions to access your data.
NOTE: collapsing categories, for example, ‘Mail Settings’ will reset the category settings. Do not collapse categories.
IMPORTANT: To retrieve data from legacy marketing campaigns, select the Marketing Campaigns permission. If you are using a legacy account and want to retrieve data from both old and new marketing campaigns, select both the Marketing Campaigns and Marketing permissions.
-
Click Create & View.
-
Make a note of the API key because you will not be able to see it again. You will need it to fill in your connector setup form.
Activate Trackinglink
-
Go to Settings -> Tracking.
-
Enable Click Tracking, Open Tracking, and Subscription Tracking to receive Events.
Disable Webhook Settingslink
-
Go to Settings -> Mail Settings.
-
Click Event Notification.
-
In the HTTP Post URL field, enter
https://webhooks.fivetran.com
. At the bottom of the page, set the toggle to Disabled to disable the webhook settings. Fivetran will enable webhooks during the initial sync and replace the specified HTTP Post URL with the correct URL.
Finish Fivetran configurationlink
-
In the connector setup form, enter your chosen destination schema name.
-
Enter the API key you created in Step 1.
-
Click Save & Test. Fivetran will take it from here and sync your SendGrid data.
Related Contentlink
description Connector Overview
account_tree Schema Information
settings API Connector Configuration