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.
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
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.
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.
Step 2: Access Pabbly 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
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
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
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
Next, select the ‘Contact Added’ option from the ‘Choose Method’ field’s drop-down options.
Step 5: Connecting ActiveCampaign to Pabbly Connect
Sign-in your ActiveCampaign account and access the API key.
(a) Go to Your 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
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 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
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
Assign a name here and click on ‘Save & Send Test Request’.
(f) Check the 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
To test the trigger, first, hit the ‘Capture Webhook Response’ button on the Pabbly Connect trigger window.
(b) Go to Your ActiveCampaign Subscription 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
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 a Google Sheet for the ActiveCampaign subscriber entries.
(b) Select Application You Want to Integrate
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
Next, check the method in here to be ‘Append Values’ and then click ‘Connect with Google Sheets’ button.
(c) Authorize your Google Sheets Account
In the next window that slides in from the right, click ‘Connect’ & authorize your Google account.
(d) Select the Spreadsheet
Select the spreadsheet and sheet.
(e) Map the Response to the Invoice
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
After mapping all the response values with the spreadsheet fields, click on ‘Save & Send Test Request’.
(f) Check the API Response
You can acknowledge the success of your set action on the ‘API Response’.
(g) Check the Google Sheet 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
(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.
Wind-Up
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.
