How to Create ActiveCampaign Subscribers from Google Sheets Rows

Step 1: Sign up to Pabbly Connect

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

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

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

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

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 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

Sign-in your Google Account to create a spreadsheet.

(a) 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

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

And then hit the ‘Get Add-ons’.

(c) Search for Pabbly Connect Webhook

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

(d) Install the Addon

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

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

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

(b) Paste the Copied 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

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

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

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

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

(c) Go to Your ActiveCampaign Account 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

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 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

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

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

(h) Check the API Response

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

(i) Check the Contact Entry in the ActiveCampaign Contacts

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

Step 8: Save the Workflow

(a) Save the Action API’s Response

(b) Save the Workflow

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