SendGrid
SendGrid is a customer communication platform for transactional and marketing emails.
Features
| Feature Name | Supported | Notes |
|---|---|---|
| Capture deletes | check | |
| History mode | ||
| Custom data | check | EVENT and RECIPIENT tables |
| Data blocking | check | |
| Column hashing | check | |
| Re-sync | check | |
| API configurable | check | API configuration |
| Priority-first sync | ||
| Fivetran data models | ||
| Private networking | ||
| Authorization via API | check |
Setup guide
Follow our step-by-step SendGrid setup guide to connect SendGrid with your destination using Fivetran connectors.
Sync overview
Fivetran uses a combination of SendGrid REST APIs and Webhooks to sync your data. At every update frequency, we retrieve all Campaigns, Senders, Lists, Recipients, Unsubscribe groups and their related entities. And for the Events, we retrieve only the new events that happened after the previous sync cycle.
We support SendGrid accounts based on both legacy marketing campaigns and new marketing campaigns. We classify the connector based on the SendGrid account type you are using, and use custom sync strategies for each connector type:
Legacy: If you are using a legacy SendGrid account and have configured your connector with a legacy API key, we classify the connector as Legacy. We upsert the legacy tables in to the destination. See the schema information for details on the legacy tables. This schema applies to all legacy SendGrid connectors created before July 20, 2020.
Upgraded: If you were using a legacy SendGrid account and had configured your connector with a legacy API key, but have migrated your account to a new marketing campaign account, and configured the existing connector with the new API key, we classify the connector as Upgraded. We upsert data from both new marketing tables and mapped legacy tables into the destination to support your existing queries on the legacy tables.
New: If you have a new SendGrid account, and have created a new connector using a new API key, we classify the connector as New. We upsert the new marketing tables into the destination. See the schema information for details on the new marketing tables. This schema applies to all new SendGrid connectors created after July 20, 2020.
See New Marketing Campaigns and our detailed changelog for more information.
Schema information
New Marketing Campaigns
This schema is applicable for SendGrid connectors based on new marketing campaign accounts and applies to all connectors created after July 20, 2020.
To zoom, open the ERD in a new window.Legacy Marketing Campaigns
This schema is applicable for SendGrid connectors based on legacy marketing campaign accounts and applies to all connectors created before July 20, 2020.
To zoom, open the ERD in a new window.Events
SendGrid generates different kind of Events for your email Campaign. The different types of Events are listed in SendGrid's Retrieve Event Webhook settings documentation.
The following image shows where events can be generated while email is being processed:
NOTE:
The
Spam Reportevent is not sent because SendGrid does not receive feedback from GMail.SendGrid does not support more than one Webhook URL, so we cannot get
EVENTdata for a SendGrid account with two different Fivetran connectors. Due to this Webhooks limitation, you can only connect a SendGrid account to a single destination.
New Marketing Campaigns
SendGrid released a new set of API endpoints under new marketing campaigns on July 10, 2019. These new endpoints have been built on an entirely new platform, so they guarantee better performance and new features.
Notes:
A new schema for new marketing campaigns is available.
SendGrid’s existing set of API endpoints are now part of the legacy marketing campaign APIs.
You can't access legacy marketing campaigns using a new marketing campaign account. You can only access the new API endpoints.
If you are using a SendGrid account based on legacy marketing campaigns, you will need to migrate your data into new marketing campaigns at some point in the future. The migration isn't automatic - you can either do the migration manually using SendGrid endpoints or you can contact the SendGrid’s support team for assistance. See SendGrid's migrating from legacy marketing campaigns documentation for more details.
We will continue to support legacy SendGrid accounts along with the new ones. Existing customers can keep using their old accounts until SendGrid deprecates the legacy accounts. We have no information about SendGrid's deprecation date for the legacy accounts.