How to Add HubSpot Contact from MySQL Database Using Pabbly Connect

Learn how to automate adding HubSpot contacts from your MySQL database using Pabbly Connect in this step-by-step tutorial. 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 HubSpot Integration

To add HubSpot contacts from your MySQL database, you first need to set up Pabbly Connect. This platform allows you to automate the process seamlessly. Begin by signing up for a free account on the Pabbly Connect dashboard.

Once logged in, click on ‘Create Workflow’ and name it, for example, ‘MySQL to HubSpot’. This will initiate the integration process between your MySQL database and HubSpot CRM through Pabbly Connect.

2. Connecting MySQL Database in Pabbly Connect

In this section, you will connect your MySQL database to Pabbly Connect. In the trigger window, select ‘MySQL’ as the app. Then, choose ‘New Row in Table’ as the trigger event. Click on ‘Connect’ and then ‘Add New Connection’ to input your MySQL database credentials.

• Enter your MySQL username and password.
• Provide the host, database name, and port number.
• Click ‘Save’ to establish the connection.

After successfully connecting, select the table from which you want to retrieve new contact data. In this case, choose the ‘new contacts’ table and specify the unique column, typically the ‘ID’ column, which ensures that each contact entry is distinct.

3. Testing the MySQL Connection in Pabbly Connect

With your MySQL database connected, it’s time to test the integration through Pabbly Connect. Click on ‘Save and Send Test Request’. This action retrieves the most recent row added to your MySQL database, confirming that the connection is working correctly.

Upon successful testing, you should see the contact details displayed in Pabbly Connect. This step ensures that whenever a new row is added in your MySQL database, Pabbly Connect will automatically capture that data for further processing.

4. Adding a HubSpot Contact via Pabbly Connect

Now that you have verified the MySQL connection, the next step is to add the contact to HubSpot. In the action window of Pabbly Connect, search for ‘HubSpot’ and select it. Choose the action event ‘Create a Contact’.

• Click on ‘Connect’ and then ‘Add New Connection’ to link your HubSpot account.
• Authorize the connection by clicking the ‘Connect with HubSpot CRM’ button.
• Select the appropriate business account from the dropdown.

After connecting, map the fields from your MySQL data to the corresponding fields in HubSpot, such as first name, last name, email, and mobile number. This mapping ensures that the contact information is accurately transferred from MySQL to HubSpot.

5. Verifying the HubSpot Contact Addition

After completing the mapping, click on ‘Save and Send Test Request’ in Pabbly Connect. This action will add the contact to your HubSpot CRM. You should receive a positive response indicating that the contact was successfully created.

To verify, log into your HubSpot account and navigate to the contacts section. You should see the newly added contact with the details you provided from your MySQL database. This confirms that your automation workflow is functioning correctly.

Conclusion

In this tutorial, we demonstrated how to use Pabbly Connect to automate the addition of HubSpot contacts from a MySQL database. By following these steps, you can streamline your contact management process and ensure that your HubSpot CRM is always up-to-date with the latest user information.