Sendgrid
This page contains the setup guide and reference information for the Sendgrid source connector.
Prerequisites
Setup guide
Step 1: Set up Sendgrid
- Sendgrid Account
- Create Sendgrid API Key with the following permissions:
- Read-only access to all resources
- Full access to marketing resources
Step 2: Set up the Sendgrid connector in Airbyte
- Log into your Airbyte Cloud account or navigate to the Airbyte Open Source dashboard.
- In the left navigation bar, click Sources. In the top-right corner, click + New source.
- On the Set up the source page, enter the name for the Sendgrid connector and select Sendgrid from the Source type dropdown.
- Enter your
api_key. - Enter your
start_date. - Click Set up source.
Supported sync modes
The Sendgrid source connector supports the following sync modes:
Supported Streams
- Campaigns
- Lists
- Contacts
- Stats automations
- Segments
- Single Sends
- Templates
- Global suppression (Incremental)
- Suppression groups
- Suppression group members (Incremental)
- Blocks (Incremental)
- Bounces (Incremental)
- Invalid emails (Incremental)
- Spam reports
- Unsubscribe Groups
Create a read-only API key (Optional)
While you can set up the Sendgrid connector using any Salesforce user with read permission, we recommend creating a dedicated read-only user for Airbyte. This allows you to granularly control the which resources Airbyte can read.
The API key should be read-only on all resources except Marketing, where it needs Full Access.
Limitations & Troubleshooting
Expand to see details about Sendgrid connector limitations and troubleshooting.
Connector limitations
Rate limiting
The connector is restricted by normal Sendgrid requests limitation.
Troubleshooting
- Legacy marketing campaigns are not supported by this source connector. Sendgrid provides two different kinds of marketing campaigns, "legacy marketing campaigns" and "new marketing campaigns". If you are seeing a
403 FORBIDDEN error message for https://api.sendgrid.com/v3/marketing/campaigns, it might be because your SendGrid account uses legacy marketing campaigns. - Check out common troubleshooting issues for the Sendgrid source connector on our Airbyte Forum.
Reference
Config fields reference
Field
Type
Property name
string
start_date
string
api_key
Changelog
Expand to review
| Version | Date | Pull Request | Subject |
|---|---|---|---|
| 1.1.0 | 2024-09-11 | 45191 | Move Contacts stream to declarative async job |
| 1.0.18 | 2024-09-07 | 45239 | Update dependencies |
| 1.0.17 | 2024-08-31 | 44953 | Update dependencies |
| 1.0.16 | 2024-08-24 | 44753 | Update dependencies |
| 1.0.15 | 2024-08-17 | 44233 | Update dependencies |
| 1.0.14 | 2024-08-12 | 43751 | Update dependencies |
| 1.0.13 | 2024-08-10 | 43635 | Update dependencies |
| 1.0.12 | 2024-08-03 | 43269 | Update dependencies |
| 1.0.11 | 2024-07-27 | 42729 | Update dependencies |
| 1.0.10 | 2024-07-20 | 42310 | Update dependencies |
| 1.0.9 | 2024-07-13 | 41753 | Update dependencies |
| 1.0.8 | 2024-07-10 | 41531 | Update dependencies |
| 1.0.7 | 2024-07-09 | 41137 | Update dependencies |
| 1.0.6 | 2024-07-06 | 40898 | Update dependencies |
| 1.0.5 | 2024-06-25 | 40356 | Update dependencies |
| 1.0.4 | 2024-06-22 | 40155 | Update dependencies |
| 1.0.3 | 2024-06-06 | 39197 | [autopull] Upgrade base image to v1.2.2 |
| 1.0.2 | 2024-05-21 | 38478 | Update deprecated authenticator package |
| 1.0.1 | 2024-05-20 | 38264 | Replace AirbyteLogger with logging.Logger |
| 1.0.0 | 2024-04-15 | 35776 | Migration to low-code CDK. Breaking change that updates configuration keys, removes unsubscribe_groups stream, renames a stream to singlesend_stats, and adds the singlesends stream. |
| 0.5.0 | 2024-03-26 | 36455 | Unpin CDK version, add record counts to state messages |
| 0.4.3 | 2024-02-21 | 35181 | Handle uncompressed contacts downloads. |
| 0.4.2 | 2024-02-12 | 35181 | Manage dependencies with Poetry. |
| 0.4.1 | 2023-10-18 | 31543 | Base image migration: remove Dockerfile and use the python-connector-base image |
| 0.4.0 | 2023-05-19 | 23959 | Add unsubscribe_groupsstream |
| 0.3.1 | 2023-01-27 | 21939 | Fix contacts missing records; Remove Messages stream |
| 0.3.0 | 2023-01-25 | 21587 | Make sure spec works as expected in UI - make start_time parameter an ISO string instead of an integer interpreted as timestamp (breaking, update your existing connections and set the start_time parameter to ISO 8601 date time string in UTC) |
| 0.2.16 | 2022-11-02 | 18847 | Skip the stream on 400, 401 - authorization required with log message |
| 0.2.15 | 2022-10-19 | 18182 | Mark the sendgrid api key secret in the spec |
| 0.2.14 | 2022-09-07 | 16400 | Change Start Time config parameter to datetime string |
| 0.2.13 | 2022-08-29 | 16112 | Revert back to Python CDK |
| 0.2.12 | 2022-08-24 | 15911 | Bugfix to allowing reading schemas at runtime |
| 0.2.11 | 2022-08-19 | 15800 | Bugfix to allow reading sentry.yaml at runtime |
| 0.2.10 | 2022-08-17 | 15734 | Fix yaml based on the new schema validator |
| 0.2.9 | 2022-08-11 | 15257 | Migrate to config-based framework |
| 0.2.8 | 2022-06-07 | 13571 | Add Message stream |
| 0.2.7 | 2021-09-08 | 5910 | Add Single Sends Stats stream |
| 0.2.6 | 2021-07-19 | 4839 | Gracefully handle malformed responses from the API |