Active campaign

Google Sheets + Active Campaign Integration

Query from Active Campaign into Google Sheets  or Post data from Google Sheets into Active Campaign

What is Sheet Director?

Sheet Director is a Google Workspace add-on that helps to manage and control bi-directional data flow between Google Sheets and several other applications like Google Calendar, Tasks, Contacts, Sheets, QuickBooks, FreshBooks, Zoho, PayPal, etc. 


It is available in the Google Workspace Marketplace. Please check the Installation instructions to install the add-on. 

What is ActiveCampaign?

ActiveCampaign is an email marketing, marketing automation, sales automation, and CRM software platform for small-to-mid-sized businesses 

ActiveCampaign to Google Sheets: Use Case(s)

> Pull data from ActiveCampaign objects and store it into a spreadsheet - Query

> Push data from spreadsheet to ActiveCampaign - Post

ActiveCampaign

Sheet Director

Google Sheets

Setting up ActiveCampaign in Sheet Director

Choose App and Service:


ActiveCampaign Configuration


How to get a key & url

ActiveCampaign to Google Sheet - Query


Destination Settings:

Scheduler Settings:

Notification Settings:

Google Sheet to ActiveCampaign - Post

Entity

Source Sheet

(the default value is A1, if you change the value you need to refresh the header by clicking on refresh icon on side)




Mapping

Sample Output

It will show the count of number of records posted successfully and failed to post.