This guide walks you through how to connect Acadio to Zapier, and then pass that data along to Mailchimp, using a method that leverages Zapier Tables as an intermediate step. While there are other ways to integrate these platforms, this approach offers the added benefit of storing and organizing the data in tables—giving you a flexible, reusable dataset that can support additional automations, reporting, or auditing tasks beyond just Mailchimp integration.

Setting up a Zapier Table

  1. Create a new table in Zapier Tables.

  2. Add the fields you wish to populate using the webhook data.

Creating a Zap to Populate the Table

  1. Create a new Zap.

  2. For the Trigger, select Webhooks by Zapier.

  3. For the Event, choose Catch Hook, then click Continue to proceed to the Test tab.

  4. Copy the webhook URL provided and enter it in Acadio, along with the appropriate topic subscription. Please reference the Webhooks documentation for more information on setting up webhooks and topic subscriptions in Acadio.

    It is recommended to complete the above step before testing the trigger, as you'll need Acadio to send data to successfully map the fields.

  5. For the Action (Step 2 of your zap), select Zapier Tables.

  6. For the Event, choose Create Record and click Continue to proceed to the Configure tab.

  7. Select the newly created table from the Table ID dropdown. Then, click into each field to map the test data to the fields in the selected table. Click Continue to move to the Test tab.

  8. Click Test Step to ensure your Zap is working correctly.

Creating a Zap to Send Data to Mailchimp

  1. Create a new Zap.

  2. For the Trigger, select Zapier Tables.

  3. For the Event, choose New or Updated Record. Click Continue to proceed to the Configure tab.

  4. Select the appropriate table from the Table ID dropdown. Click Continue to proceed to the Test tab.

  5. For the Action (Step 2 of your zap), select Filter by Zapier. Click Continue to go to the Configure & Test tab.

  6. Define your filter by selecting a Field and Condition from the dropdowns, and enter the desired value (e.g., a course ID, credit name, email domain, etc.) to determine which records continue through the Zap.

  7. Add a new step and select Mailchimp.

  8. For the Event, choose Add/Update Subscriber.

  9. Connect your Mailchimp account by clicking the Account field and entering your credentials. Click Continue to move to the Configure tab.

  10. Map the required fields by clicking each one and selecting the corresponding Zapier Table data. The fields labeled New and Old can contain the same values, as this step can update existing contacts.

  11. Add a new step and select Delay by Zapier.

  12. For the Event, choose Delay For and set a value.

  13. Add another step and select Mailchimp again.

  14. For the Event, choose Add Subscriber to Tag. Click Continue to proceed to the Configure tab.

  15. Select the Audience, Tag, and Email Address using the dropdowns. The selected email address can also be the one labeled New. Click Continue to proceed to the Test tab.

  16. Click Test Step to confirm your Zap is functioning as expected.