SendGrid

Loading data from your SendGrid account.

SendGrid is a cloud-based SMTP provider that allows you to send email without having to maintain email servers.

This source allows you to easily connect your existing SendGrid account to your DCN in order to ingest your customer IDs & their respective traits.

Creating a SendGrid Source

First you will need to setup your SendGrid account for our integration partner Fivetran. Follow Fivetran's setup guide for SendGrid to prepare the account and generate an API key.

You can create a new SendGrid source from your DCN by going to the Integrations > Sources section in your navigation menu or by using the CLI and running the following command:

optable-cli source create sendgrid <name>

In both cases you will be redirected to your browser in order to authenticate & link your SendGrid account to your DCN through Fivetran. To continue, you will have to input your API key and click "Save & Test". The connection will be completed and you will be redirected to your DCN while data ingestion starts.

Your SendGrid API key is never shared directly with Fivetran or Optable, it remains private throughout the process.

Add your API key and click Save & Test.

Finally, if you created the source using your DCN UI you will be redirected to the sources listing. If you used the CLI, you will be able to close you browser and continue at the command line.

Here is an example of the expected CLI output:

$ optable-cli source create sendgrid my-example-source
{ 
  "id": 1,
  "name": "my-example-source",
  "state": "SOURCE_STATE_ACTIVE",
  "kind": "SOURCE_KIND_SENDGRID",
  "created_at": "2022-06-08T15:45:00.502717Z",
  "updated_at": "2022-06-08T15:45:03.748793Z",
  "sendgrid": {},
  "version": {
    "minimum_timestamp": "2022-06-08T15:45:00.502716Z"
  }
}

What Will You Get?

Currently, email addresses, alternate email addresses and phone numbers stored in your SendGrid customer database will be periodically loaded as identifiers into your DCN along with the subscriber's country, city and state/province/region.

Identifiers	Traits
Email address (personal ID)	Country
Alternate email address (personal ID)	City
Phone number (personal ID)	State/Province/Region