How do I use a webhook to send contact information to a Google Sheet?

Sending contact information to a google sheet allows you to store data in one place, making it easy to review information at a glance. You may want to do this in order to keep your own reporting on unsubscribes, or date and time contacts opened your communications.

In order to perform this function, you’ll need a google sheet, a Zapier account, and an ActiveCampaign account. This task also requires that you create a webhook in ActiveCampaign.

We’ll walk you through each step below. For purposes of context, we want to update a google spreadsheet each time a contact in any list clicks on the unsubscribe link in an email.

  1. In your ActiveCampaign account, click your avatar and click “My Settings.”

    Account_my_settings.png

  2. Select “Developer” from the left side menu:

    Select_developer.png

  3. Click “Manage Webhooks.”

    Click_manage_webhooks.png
  4. Click “Add.”

    Webhook_click_add.png

  5. Open a separate tab or window and log into your Zapier account.
  6. Click “Make a Zap”
  7. Select “Webhooks” as your trigger and click “Catch Hook.” Click “Save + Continue.”

    click_catch_hook.png

  8. Click “Continue” again.
  9. Copy the webhook URL to your clipboard.

    test_webhook_in_zapier.png

  10. Go back to the Webhook page in your ActiveCampaign account.
  11. Select which list will be associated with this webhook. In this example, we’re going to choose “All Lists.”
  12. Give your webhook a name and paste the webhook URL generated by Zapier into the URL bar.

    create_webhook_in_ac.png

  13. Select which item will trigger your webhook to run. In this example, we’ll choose “Contact Unsubscription” by clicking that option.

    webhook_type.png
  14. Select where this webhook will run from. In this example, we’re going to choose “by a contact” by clicking it. This webhook will run every time a contact clicks “Unsubscribe.”
  15. Click “Add.”

    Webhook_click_add.png
  16. Go back to your Zapier account to finish creating your Zap.
  17. Click “Ok I did this” in order to test your trigger.

    Test_webhook_ok_i_did_this.png

  18. Click “Continue” to proceed with setting up your action.

    zapier_test_webhook_successful.png

  19. Select Google Sheets from the list of available apps by clicking it:

    Google_sheets_app.png

  20. Select “Create Spreadsheet row” by clicking it. Then click “Save + Continue.”

    create_spreadsheet_row.png

  21. Next you’ll need to connect your Google account with Zapier by clicking “Connect an Account.” Once connected, click “Save + Continue.”

    google_sheet_save_and_continue.png

  22. Select the spreadsheet and worksheet you wish to update by selecting them from the appropriate dropdowns.
  23. Next, map the fields in your Google Sheet with the fields in your ActiveCampaign account. Click “Continue.”
    map_google_sheet_and_click_continue.png

  24. Click “Create and Continue” in order to test your Google Sheets connection.

    create_test_and_continue.png

  25. Click “Finish.”

    finish_test.png

  26. Give your Zap a name and click the toggle to turn it on.

    name_zap_google_sheet.png

For information on how to setup your Google Sheet to work with Zapier, click here.

Have more questions? Submit a request