SendGrid is a cloud-based SMTP provider that allows users to send email without having to maintain email servers. SendGrid manages all of the technical details, from scaling the infrastructure to ISP outreach and reputation monitoring to whitelist services and real time analytics.
With the addition of Webhook data source, Sprinkle now enables users to push data from SendGrid to Sprinkle using Webhook.
To add SendGrid as a data source, users can click on the ‘+’ sign on the data sources page and select SendGrid.
Upon selection and naming the SendGrid data source, a connection URL is generated.
An example of the URL could be:
The user needs to copy this URL and save it for editing later. Post copying, the user can click on ‘Create’.
Post clicking on create, the user will be redirected to the data set page, wherein the user needs to name the Webhook table and click on ‘Create’. Users can then schedule the jobs and the ingestion frequency. It is recommended to set the Autorun frequency of ingestion to real time or every 1 hour.
Post clicking on create, the user will be redirected to the data set page, wherein he needs to name the Webhook table and click on ‘Create’.
This will create a table in the warehouse. But, this table will not have any data. Users can push data into this table using the Webhook URL created earlier.
In the URL, the user needs to fill the API details. In order to generate API keys,the user can go to Admin -> Permissions -> Api Keys.
Note: Please note, users with Analyst or Developer roles may not have access to the Admin tab. Please check with Admin for API key and secret.
Once on the Permissions page,the user can click on ‘API keys’ and then ‘New’ to generate new API keys and secret keys.
Once the API key and secret key is generated, users can edit the Webhook URL and add the API key and secret key to the Webhook URL.
Now, the user can log into their SendGrid account from https://app.sendgrid.com/login. Next users can update the Webhook in Settings -> Mail Settings -> Event Settings.
Authorization method needs to be selected as none (OAuth is not yet supported in Sprinkle). Next, the user needs to post the Webhook URL in the space provided for Post URL. The user then needs to select the events for which report needs to be pushed to Sprinkle.
Finally users need to enable the Event Webhook status and click on Save. Once the settings are saved, data will start flowing into Sprinkle within the next 5 minutes.