Import ActiveCampaign Data to Google Sheets – Step by Step Guide

Import ActiveCampaign Data to Google Sheets – Step by Step Guide

Last Updated On June 14, 2019
You are here:
< Back

ActiveCampaign is an email marketing and CRM platform for small businesses. In this guide, we’ll walk through how to pull data from the ActiveCampaign API directly into Google Sheets, using the free API Connector add-on. We’ll first get an API key from ActiveCampaign, and then set up a request to pull in email campaign data from ActiveCampaign to your spreadsheet.

PART 1: GET YOUR ACTIVECAMPAIGN API KEY

  1. Log in to ActiveCampaign and click “Settings” in the left side navigation menu.
    api-connector-activecampaign-img1

  2. The Account Settings menu will appear. Click “Developer”.
    api-connector-activecampaign-img2

  3. You should now see a page containing your API URL and Key. Congrats! You’re now ready to get started with the ActiveCampaign API.
    api-connector-activecampaign-img3

PART 2: CREATE YOUR API REQUEST

We’re going to follow the ActiveCampaign API documentation to view campaign details.

  • Base URL: https://<your-account>.api-us1.com/api/3/
    Base URL example: https://anakravitz1.api-us1.com/api/3
  • Endpoint: /campaigns

Putting it all together, we get the full API Request URL:
https://anakravitz1.api-us1.com/api/3/campaigns

Of course, you’ll need to substitute in your own account ID.

We can now enter all our values into API Connector and start importing ActiveCampaign data into Google Sheets.

  1. Open up Google Sheets and click Add-ons > API Connector > Create New API Request.
  2. In the Create Request interface, enter the Request URL we just created
    api-connector-activecampaign-img4

  3. Under Headers, enter a key-value pair like this:
    Api-Token{API Key}

    Replace {Api Key} with the value provided above in step 3.
    api-connector-activecampaign-img5


  4. Create a new tab. You can call it whatever you like, but here we’ll call it ‘AC Campaigns’. While still in that tab, click ‘Set’ to use that tab as your data destination.
  5. Name your request. Again we’ll call it ‘AC Campaigns’
  6. Click Run and a moment later you’ll see ActiveCampaign data populate the AC Campaigns tab in your Google Sheet:
    api-connector-activecampaign-img6

  7. Change the endpoints as described in the documentation to retrieve different data. For example, changing it from /campaigns to /contacts will produce a list of all your ActiveCampaign contacts.
  8. api-connector-activecampaign-img7

Comments:0

Leave a Reply

Your email address will not be published.