SendGrid webhook setup

Ihor Tomilenko edited this page Aug 3, 2017 · 9 revisions

HOME » SNOWPLOW SETUP GUIDE » Step 2b: setup a Webhook » SendGrid webhook setup

Contents

1. Overview

This webhook integration lets you track a variety of events logged by SendGrid.

Available events are:

  • Processed
  • Dropped
  • Delivered
  • Deferred
  • Bounce
  • Open
  • Click
  • Spam Report
  • Unsubscribe
  • Group Unsubscribe
  • Group Resubscribe

For the technical implementation, see SendGrid webhook adapter.

1.1 Compatibility

2. Setup

Integrating SendGrid's webhooks into Snowplow is a two-stage process:

  1. Configure SendGrid to send events to Snowplow
  2. (Optional) Create the SendGrid events tables for Amazon Redshift

2.1 SendGrid

First login to SendGrid. Select Settings from the menu panel along the left-hand side of the screen. You should then navigate in the expanded list to the Mail Settings page.

Select Event Notification from the list by clicking the row. Ensure it's switched ON in order to send events to Snowplow.

Click edit on the top right-hand side of the Event Notification dropdown.

For the HTTP POST URL field you will need to provide the URI to your Snowplow Collector. We use a special path to tell Snowplow that these events are generated by SendGrid:

http://<collector host>/com.sendgrid/v3

Our Webhooks setup page should look like this after we have added our HTTP POST URL:

If you want, you can also manually override the event's platform parameter by appending a query string to the end of the URL so:

http://<collector host>/com.sendgrid/v3?p=<platform code>

Supported platform codes can again be found in the Snowplow Tracker Protocol; if not set, then the value for platform will default to srv for a server-side application.

The other values you can set up manually in the similar fashion are nuid, aid, cv, eid, ttm, and url.

Before we save our SendGrid webhook we can configure what types of events SendGrid will send to our webhook and what channels will trigger these events. Simply select the boxes that are applicable to you and SendGrid will send these events to our webhook.

2.2 Redshift

If you are running the Snowplow batch flow with Amazon Redshift, then you should deploy the relevant event tables into your Amazon Redshift.

You can find the table definitions here:

Make sure to deploy this table into the same schema as your events table.

That's it - with these tables deployed, your SendGrid events should automatically flow through into Redshift.

Clone this wiki locally
You can’t perform that action at this time.
You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session.
Press h to open a hovercard with more details.