Create ActiveCampaign Contacts from New MySQL Rows Using Pabbly Connect

Learn how to create ActiveCampaign contacts automatically from new MySQL rows using Pabbly Connect. Follow our step-by-step tutorial for seamless integration. Navigate the automation landscape confidently with clear, structured guidance suitable for professionals regardless of prior technical experience.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for MySQL to ActiveCampaign Integration

To create ActiveCampaign contacts from new MySQL rows, you need to set up Pabbly Connect. Start by signing up for a free account on the Pabbly Connect dashboard. Once logged in, click on ‘Create Workflow’ to initiate the integration process.

Give your workflow a name, such as ‘MySQL to ActiveCampaign’. This naming will help you identify the workflow later. After naming your workflow, click on the ‘Create’ button to proceed.

2. Configuring MySQL Trigger in Pabbly Connect

The next step involves configuring the MySQL trigger in Pabbly Connect. In the trigger window, search for ‘MySQL’ and select it. From the dropdown, choose the event ‘New Row in Table’ as the trigger event.

• Select ‘Add New Connection’ to connect your MySQL database.
• Enter your MySQL database username, password, host, database name, and port.
• Click ‘Save’ to establish the connection.

After connecting, select the table from which you want to fetch new row data. Choose the unique column that will help identify each record, usually an ID column. Once you have this set up, click on ‘Test Request’ to ensure that Pabbly Connect is receiving data from your MySQL database.

3. Setting Up ActiveCampaign Action in Pabbly Connect

Now that your MySQL trigger is configured, it’s time to set up the ActiveCampaign action. In the action window, search for ‘ActiveCampaign’ and select it. Choose the action event ‘Create or Update Contact’ from the dropdown.

Click on ‘Add New Connection’ to link your ActiveCampaign account with Pabbly Connect. You will need to enter your ActiveCampaign API key and URL. To find these, navigate to your ActiveCampaign account settings and go to the ‘Developers’ section. Copy the API key and URL, ensuring to remove the ‘https://’ part from the URL before entering it into Pabbly Connect.

• Map the email field with the email response received from MySQL.
• Map the first name, last name, and mobile number similarly.
• You can ignore the tag ID list and account ID fields as they are not mandatory.

Once all necessary fields are mapped, click on ‘Save and Send Test Request’ to verify that the connection is working correctly. If successful, you will receive a positive response confirming the new contact creation.

4. Testing the MySQL to ActiveCampaign Integration

With everything set up, it’s time to test the integration. Insert a new row into your MySQL database with the details of a new user, such as a name, email address, and mobile number. After adding this data, wait for up to one hour, as Pabbly Connect checks for new entries in your MySQL database every hour.

Once the hour has passed, check your ActiveCampaign account to see if the new contact has been created. You should find that the new user’s details match what you entered in MySQL, confirming that the automation is functioning as intended.

Conclusion

In this tutorial, we demonstrated how to create ActiveCampaign contacts from new MySQL rows using Pabbly Connect. By following the steps outlined, you can automate the process of adding new contacts, ensuring efficient data management and streamlined communication. This integration allows you to focus on growing your business while Pabbly Connect handles the technical details.