In this blog, I’ll walk you through the step by step process to add all the ActiveCampaign contacts in Google Sheets automatically instantly.

We are going to integrate ActiveCampaign with Google Sheets using Pabbly Connect to add ActicveCampaign subscribers to Google Sheets. This service allows integrating any two or more service as well as shares data within the connected services in real-time.

How to Automatically Add ActiveCampaign Subscribers to Google Sheets

We’ll set up a trigger on the ActiveCampaign subscribers and its respective action on Google Sheets to add the subscriber’s information on the spreadsheet.

Besides, Pabbly Connect also allows using instant triggers, routers, filters as well as multiple formatters for designing unlimited workflows. Moreover, it also allows you to use many other advanced options such as multi-step calls, integration with unlimited premium applications etc. And all these premium options without writing a single line of code or taking help from professionals.

Why Choose This Method Of Integration?

In contrast with other integration services-

  • Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer and more
  • Create “Unlimited Workflows” and smoothly define multiple tasks for each action
  • As compared to other services which offer 750 tasks at $24.99, Pabbly Connect proffers 50000 tasks in the starter plan of $29 itself
  • Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
  • Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE

Sign Up To Pabbly Connect  

In a few minutes interval, it allows you to add ActiveCampaign subscribers to Google Sheets on every new contact entry. So now, you can opt for even the free plan and save your time. As Pabbly Connect doesn’t restrict you on using any features in any plan.

Now, let’s move forwards with the step by step procedure to integrate ActiveCampaign and Google Sheets to automatically add ActiveCampaign contacts in sheets.

How to Automatically Add ActiveCampaign Subscribers to Google Sheets (step by step)

Step 1: Sign up to Pabbly Connect

Sign UpGo to the official website of Pabbly Connect and then click on the ‘Sign-Up Free‘ button. On the registration page, either signup using an existing Gmail account or manually fill out the form to get into the system.

Try Pabbly Connect for FREE

Step 2: Access Pabbly Connect

Select Connect

After signing up successfully, click the ‘Access Now’ button of the software ‘Connect’ Pabbly application.

Step 3: Workflow for ActiveCampaign with Google Sheets Integration

(a) Start with a New Workflow

Create New Workflow

Start with creating a workflow to integrate ActiveCampaign and Google Sheets for adding ActiveCampaign subscribers in Google Sheets and to do this hit the ‘Create New Workflow’ button.

(b) Name the Workflow

ActiveCampaign to Google Sheets Workflow

Now, name the workflow as per your need (for instance: ActiveCampaign to Google Sheets etc) and push the ‘Save’ button.

Step 4: Setting Trigger for ActiveCampaign – Google Sheet Integration

To automatically add ActiveCampaign subscribers to Google Sheets whenever a new contact is added, you need to set-up a trigger on ‘new contact’ event for your ActiveCampaign account. Then, its respective action to add a contact on Google Sheet. So, let’s get started with setting up the trigger first.

(a) Select Application you want to integrate

Integrate ActiveCamapign

When you hit the save button to create a workflow, a trigger window will open next.

You’ll need to select the ‘ActiveCampaign’ option from the ‘Choose App’ field drop-down options.

(b) Connect with ActiveCampaign

Connect with ActiveCampaign

Next, select the ‘Contact Added’ option from the ‘Choose Method’ field’s drop-down options.

Step 5: Connecting ActiveCampaign to Pabbly Connect

your ActiveCampaign account and access the API key.

(a) Go to Your ActiveCampaign Settings

ActiveCampaign Settings

On your ActiveCampaign account click the ‘Settings’ options available in the left vertical menu.

(b) Click on the Developer Option & Copy the API Key

Copy API Key & URL

Next, you will see another menu carrying more setting options. Click on the ‘Developer’ option from this menu.

Next copy the API key and URL.

(c) Paste the Copied API Key & URL in the Pabbly Connect Trigger

Paste URL & API Key

Paste the copied API key and URL in the Pabbly Connect trigger settings.

Lastly, hit the ‘Save’ button to establish a connection.

(d) Select the List

Select List

Once both the services (i.e, ActiveCampaign to Pabbly Connect) are connected, all the lists automatically get populated. Pick the list that you wanna connect here.

(e) Save & Send Test Request

Save & Send Test Request for Trigger

Assign a name here and click on ‘Save & Send Test Request’.

(f) Check the Trigger API Response

Trigger API Response

Check the trigger’s API response.

Step 6: Test the Trigger Response in Pabbly Connect Dashboard

As we can see we are done setting up the trigger to send order data when a new subscriber is added to the ActiveCampaign account. So, let’s just test the trigger by making a test order on ActiveCampaign.

(a) Capture Webhook Response

Capture Webhook Response

To test the trigger, first, hit the ‘Capture Webhook Response’ button on the Pabbly Connect trigger window.

(b) Go to Your ActiveCampaign Subscription Form

Fill ActiveCampaign Subscriber form

Now, go to your ActiveCampaign subscriber form that enables adding contact directly to your selected list. Fill in all the required details and hit the ‘Submit’ button.

Remember to create a dedicated list as well as a connected form that adds data automatically to that particular list to follow this step first.

(c) Check the Trigger Response

Test API Response

You can see the response of your created trigger below the Webhook response in the Pabbly Connect trigger.

The response will start showing the details of a recent contact added to the selected list.

Step 7: Setting Action for ActiveCampaign – Google Sheet Integration

As we can see the response that we got of the set trigger is as expected and now we can move forward towards taking an action on the received data from ActiveCampaign.

(a) Create a Google Sheet

Create Google Sheet

Create a Google Sheet for the ActiveCampaign subscriber entries.

(b) Select Application You Want to Integrate

Integrate Google Sheets

To start sending subscribers from ActiveCampaign to Google Sheets, click the plus button next to your recently created trigger window.

Then select the ‘Google Sheets’ app to integrate from the ‘Choose App’ field’s drop-down menu.

(b) Connect with Google Sheets

Connect with Google Sheets

Next, check the method in here to be ‘Append Values’ and then click ‘Connect with Google Sheets’ button.

(c) Authorize your Google Sheets Account

Authorize Google Account

In the next window that slides in from the right, click ‘Connect’ & authorize your Google account.

(d) Select the Spreadsheet

Choose Spreadsheet

Select the spreadsheet and sheet.

(e) Map the Response to the Invoice

Map Values

This is a significant step & you can map the values that you got from the ActiveCampaign response to the Google Sheet action details. The mapped values will be responsible for the automatic action afterwards.

To map a value, place your cursor to the position on which you wanna map the value.

Click the menu button (or three vertical lines) next to that particular field.

Lastly, click select the value that you want to map.

(e) Save & Send Test Request

Save & Send Test Request

After mapping all the response values with the spreadsheet fields, click on ‘Save & Send Test Request’.

(f) Check the API Response

Action API Response

You can acknowledge the success of your set action on the ‘API Response’.

(g) Check the Google Sheet Entries

Spreadsheet Entries

Also, you can check the Google Sheet entry in the test customer’s email inbox.

Step 8: Save the Workflow

(a) Save the Action API’s Response

Save API Response

(b) Save the Workflow

Save Webhook

As we can see the Webhook is working perfectly. So, simply save the webhook by clicking the save button in the trigger window.


Well, this is all about ‘How to automatically add ActiveCampaign subscribers to Google Sheets’. Consequently, after completing the step by step procedure, you will end up automating the process of adding ActiveCampaign contacts to Google Sheets in real-time. Most importantly, the procedure is very easy to implement and you don’t need any coding knowledge to follow the steps.

You can always try Pabbly Connect for FREE.

For any further questions, do comment below. We’ll get back to you ASAP.

You May Also Like to Read: