In this blog, we’ll go through the step by step procedure to create ActiveCampaign contacts from spreadsheet rows. This way whenever new subscriber details are added to a Google Sheet row, it automatically gets added on the ActiveCampaign contacts lists.

We are going to integrate Google Sheets and ActiveCampaign using Pabbly Connect to create new ActiveCampaign contact from the spreadsheet’s rows instantly. It allows connecting two or more service together to share data as well as set trigger and actions in real-time.

How to Create ActiveCampaign Subscribers from Google Sheets Rows

Our objective would be to set up a trigger on the Google Sheet new row entries and its respective action will be carried on the ActiveCampaign subscriber addition.

Furthermore, Pabbly Connect supports using instant triggers, routers, filters & formatters for designing unlimited workflows. Also, it enables you to use multiple advanced benefits such as multi-step calls, integration with unlimited premium apps etc. And all this without writing a single line of code or help from a professional.

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 new subscribers from Google Sheet rows. Also, now you can use all Pabbly Connect features without any restriction even in its free plan.

Let’s move forwards with the step by step procedure to integrate Google Sheets with ActiveCampaign and automatically add ActiveCampaign subscriber using Google Sheets rows.

How to Create ActiveCampaign Subscribers from Google Sheets Rows (step by step)

Step 1: Sign up to Pabbly Connect

Sign Up

Go 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’ in Pabbly application.

Step 3: Workflow for Google Sheets to ActiveCampaign Integration

(a) Start with a New Workflow

Create New Workflow

Start with creating a workflow to create ActiveCampaign subscribers using Google Sheets rows and to do this strike the ‘Create New Workflow’ button.

(b) Name the Workflow

Google Sheets to ActiveCampaign Workflow

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

Step 4: Setting Trigger for Google Sheets – ActiveCampaign Integration

To create ActiveCampaign subscribers from Google Sheet rows automatically whenever a new row is added in the spreadsheet, you need to set-up a trigger on the Google Sheet entry and its respective action to add the contact on ActiveCampaign. So, let’s get started with setting up the trigger first.

(a) Select Application you want to integrate

Integrate Google Sheets

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

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

(b) Check Method & Copy Webhook URL

Check Method & Copy the Webhook URL

Check the method to be ‘New Spreadsheet Row’.

And then, copy the Webhook URL by clicking the ‘Copy’ button next to the URL.

Step 5: Connecting Google Sheets to Pabbly Connect

your Google Account to create a spreadsheet.

(a) Create Google Sheet

Create Google Sheet

First, log in to your Google account and create a new spreadsheet.

Mention, the heads as well as the data or subscriber details that you want to send to ActiveCampaign.

(b) Get Pabbly Connect Addon for Your Sheet

Get Addon

Click on the ‘Add-ons’ option from the top horizontal menu.

And then hit the ‘Get Add-ons’.

(c) Search for Pabbly Connect Webhook

Search Pabbly Connect Webhook Addon

Next, search for the ‘Pabbly Connect Webhook’ Addon and then click on it.

(d) Install the Addon

Install Pabbly Connect Webhook Add-on

Now, click the ‘Install’ button and complete the process of installing this add-on on your Google Sheet.

(e) Go to Pabbly Connect Plugin & Initiate Set-up

Sheet Addon Initiate Setup

Once the Pabbly Connect Webhook add-on is successfully installed, you can move forward to sending the data from the sheet.

For this, sequentially click on ‘Addons’ button first, then Pabbly Connect Webhook and then ‘Initiate Setup’ option.

Step 6: Test the Trigger Response in Pabbly Connect Dashboard

We are almost done setting up the trigger for our workflow. Only two things needed to complete the trigger setting part, pasting the Webhook URL and testing it.

(a) Capture Webhook Response

Capture Webhook Response

First, click on the ‘Capture Webhook Response’ button on the Pabbly Connect trigger.

(b) Paste the Copied Webhook URL

Paste Webhook URL

Now, paste the copied Webhook URL from Pabbly Connect trigger in the ‘Webhook URL’ field.

Also, mention the values for the ‘Trigger Column’ field.

Lastly, click the ‘Send Test’ button to send a test request to the connect trigger on Pabbly Connect.

(c) Check the Trigger Response

Check the Trigger Response

You can check the response of the test request from Google Sheet on the Pabbly Connect trigger response.

The response will start showing all the data sent from the Google Sheet.

(d) Click Submit

Click Submit

Lastly, click the ‘Submit’ button to save the connection settings.

Step 7: Setting Action for Google Sheet – ActiveCampaign Integration

Up to this point, all the trigger settings are done and we can start working on the action part to create ActiveCampaign subscribers from Google Sheets rows.

(a) Select Application You Want to Integrate

Integrate ActiveCampaign App

To start adding subscribers to ActiveCampaign from Google Sheet rows, click the plus button next to your recently created trigger window.

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

(b) Connect with ActiveCampaign

Connect with ACtiveCampaign

Next, check the method in here to be ‘Create Contact’ and then click ‘Connect with ActiveCampaign’ button.

(c) Go to Your ActiveCampaign Account Settings

ActiveCampaign Settings

To connect your ActiveCampaign account first, login to your ActiveCampaign account and access the settings by clicking the ‘Settings’ option from the left verticle menu.

(d) Copy the API Key & URL

Copy the API Key & URL

Next, click on the ‘Developer’ option from the settings menu.

Lastly, copy the API key & URL one by one.

(e) Paste the ActiveCampaign API Key & URL on Pabbly Connect

Paste API Key & URL

Paste the API key as well as URL on Pabbly Connect action settings one by one.

(f) Map the Values from Trigger Response to the Action Settings

Map Values

In this step, you can map the Google Sheet trigger response values with the ActiveCampaign contact entries.

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

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

Lastly, select the value that you want to map.

(g) Save & Send Test Request

Save & Send a Test Request

After mapping all the required values, click on the ‘Save & Send Test Request’ button.

(h) Check the API Response

Trigger API Response

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

(i) Check the Contact Entry in the ActiveCampaign Contacts

Contact Entry

Also, you can check the contact entry in the ActiveCampaign contacts.

Step 8: Save the Workflow

(a) Save the Action API’s Response

Save API Response

(b) Save the Workflow

Save Workflow

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 create ActiveCampaign subscribers from Google Sheets rows’. Consequently, after completing the step by step procedure, you will end up automating the ActiveCampaign subscriber creation through new entries of the spreadsheet rows. Most importantly, the procedure is very easy to implement and you don’t need any coding knowledge to follow the steps.

Try Pabbly Connect for FREE

For your queries or suggestions, do comment below.

You May Also Like to Read: