How to Create ActiveCampaign Contact from New Google Sheets Tables Row Using Pabbly Connect

Learn how to use Pabbly Connect to automatically create ActiveCampaign contacts from new rows in Google Sheets. Step-by-step guide included. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start creating ActiveCampaign contacts from new Google Sheets rows, first, you need to access Pabbly Connect. Open your browser and search for Pabbly Connect to reach its landing page. Here, you will find options to sign in or sign up for free if you are a new user.

For existing users, click on the ‘Sign In’ button. Once logged in, you will see various applications offered by Pabbly. Click on the ‘Access Now’ button under Pabbly Connect to get to your dashboard and begin setting up the automation.

2. Creating a Workflow in Pabbly Connect

After accessing Pabbly Connect, the next step is to create a workflow. Click on the ‘Create Workflow’ button. You will be prompted to name your workflow and select a folder to save it. For this tutorial, name it ‘How to Create ActiveCampaign Contact from New Google Sheets Table Row’ and save it in the ‘Automations’ folder.

• Click on ‘Create’ to open the workflow window.
• Select Google Sheets as the trigger application.
• Choose ‘New or Updated Spreadsheet Row’ as the trigger event.

This setup allows the workflow to trigger whenever a new row is added to your Google Sheets table.

3. Connecting Google Sheets to Pabbly Connect

To connect Google Sheets to Pabbly Connect, you will receive a webhook URL. Copy this URL and log into your Google Sheets account. Open the specific spreadsheet you want to work with and go to Extensions > Add-ons > Get Add-ons.

Search for the Pabbly Connect Webhook add-on, install it, and refresh your Google Sheets page. After refreshing, go to Extensions > Pabbly Connect Webhooks and select ‘Initial Setup’. Paste the copied webhook URL and specify the trigger column, which is usually the final data column, like ‘D’. Click ‘Submit’ to complete the setup.

4. Testing the Integration with ActiveCampaign

With the connection established, it’s time to test the integration. In your Google Sheets, navigate to Extensions > Pabbly Connect Webhooks and enable the ‘Send on Event’ option. This ensures that any new details added will automatically send data to your Pabbly Connect workflow.

• Enter test lead details like first name, last name, email, and phone number.
• Select the status for the lead, which is crucial for the trigger column.

Once you have entered the details, check your Pabbly Connect workflow to see if the data has been received correctly. This confirms that your Google Sheets data is being sent properly.

5. Creating ActiveCampaign Contact from Google Sheets

Now that the test submission is successful, the next step is to create a contact in ActiveCampaign using Pabbly Connect. Select ActiveCampaign as the action application and choose ‘Create a Contact’ as the action event. Click on ‘Connect’ to link your ActiveCampaign account.

Enter the API key and URL from your ActiveCampaign account settings. Ensure to remove ‘https://’ from the URL as specified in the help text. Once connected, map the email, first name, last name, and other details from the Google Sheets trigger response. This mapping allows Pabbly Connect to dynamically insert data for each new lead.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automatically create ActiveCampaign contacts from new rows in Google Sheets. This integration streamlines lead management and enhances your marketing efforts. By following these steps, you can efficiently convert leads into customers.