Connecting Mandrill to Stitch is a three-step process:
- Add Mandrill as a Stitch data source
- Generate a Webhook URL
- Set up webhooks in Mandrill
Adding Mandrill as a Stitch Data Source
- On the Stitch Dashboard page, click the Add an Integration button.
- Click the Mandrill icon. If you need to use Mandrill's Zapier integration to complete the setup, click the Zapier icon instead.
- Enter a name for the integration. This is the name that will display on the Stitch Dashboard for the integration; it’ll also be used to create the schema in your data warehouse.
For example, the name “Stitch Mandrill" would create a schema called
stitch_mandrill in the data warehouse. This schema is where all the tables for this integration will be stored.
- Click Save Integration.
Generating a Mandrill Webhook URL
Once Stitch has successfully saved and created the integration, you’ll be redirected to a page that displays your webhook URL and token (which is blurred in the image below):
Click the Copy button to copy it.
Note that this particular URL won’t display in Stitch again once you click Continue. Think of this URL like you would your login or API credentials - keep it secret, keep it safe. You can, however, generate another URL should you need it.
Once you’ve copied your webhook URL, click Continue to wrap things up in Stitch.
Setting Up Webhooks in Mandrill
The last step is to setup webhooks in your Mandrill account.
- Sign into your MailChimp account.
- Click the user menu (your icon) > Account.
- Click the Transactional tab.
- Click Launch Mandrill.
- Once you're in your Mandrill account, click the Settings icon in the left nav tab.
- Click the Webhooks tab.
- Click Add a Webhook.
- Check the events that you want to track. Every time one of these events occurs, the webhook will be triggered and data will post to your webhook URL.
- In the Post to URL field, paste the Stitch-generated webhook URL.
- Enter a brief Description:
- When you're finished, click Create Webhook.
Mandrill Data & Replication
After the setup for Mandrill is complete, your webhook data will be continuously replicated through Stitch. To learn more about how Stitch replicates Mandrill webhook data and our recommended strategy for querying, check out the Expected Mandrill Data article.