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.
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
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.
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’ 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.
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.
For your queries or suggestions, do comment below.