How to Add OptinMonster Lead in MySQL Database Using Pabbly Connect

Learn how to automate the process of adding OptinMonster leads into a MySQL database using Pabbly Connect. Step-by-step guide included. Eliminate manual repetitive tasks from your workflow. Discover proven automation methods with intuitive steps designed for efficiency-minded professionals.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin the integration process, you need to access Pabbly Connect. This platform allows you to automate tasks between different applications without any coding skills. Start by visiting the Pabbly Connect homepage.

Once there, you will see options for signing in or signing up. If you are a new user, click on the ‘Sign up for free’ button to create an account. Existing users can simply click on ‘Sign in’ to access their dashboard. Remember, new users receive 100 free tasks every month to explore the features of Pabbly Connect.

2. Creating a Workflow in Pabbly Connect

After signing into Pabbly Connect, you will be directed to the dashboard. To create a new workflow, click on the ‘Create Workflow’ option. A dialog box will prompt you to name your workflow; for this tutorial, name it ‘Insert OptinMonster Lead in MySQL Database’.

• Select a folder to save your workflow.
• Click on ‘Create’ to finalize your workflow setup.

Now, you will see two windows: one for the trigger and another for the action. In this case, OptinMonster will be the trigger application, and MySQL will be the action application. This setup will ensure that whenever a new lead is generated, the details will automatically be recorded in your MySQL database through Pabbly Connect.

3. Setting Up the Trigger with OptinMonster

In the trigger window, select OptinMonster as your trigger application. Next, choose the trigger event as ‘New Lead’. This event signifies that the workflow will initiate when a new lead is generated from OptinMonster.

After selecting the trigger event, Pabbly Connect will generate a webhook URL that acts as a bridge for data transfer from OptinMonster. Copy this URL, as it will be needed to set up the connection in your OptinMonster account.

4. Configuring OptinMonster with Pabbly Connect

Log into your OptinMonster account and navigate to your campaign dashboard. Click on ‘Edit Campaign’ for the form you want to use for lead generation. In the integrations section, look for the option to add a new integration and select ‘Webhooks’ from the list.

• Click on ‘Add New Webhook’.
• Paste the webhook URL you copied from Pabbly Connect.
• Name the webhook, for example, ‘New Leads’.
• Click on ‘Connect to Webhook’ to finalize.

Once the webhook is set up, return to Pabbly Connect and click on ‘Recapture Webhook Response’. This action will help you capture the response of an actual lead when submitted through your OptinMonster form.

5. Setting Up MySQL Action in Pabbly Connect

Now that the trigger is set, move to the action window in Pabbly Connect. Select MySQL as your action application and choose the action event as ‘Insert Row’. This action will allow you to insert a new row in your MySQL database whenever a lead is generated.

Next, connect to your MySQL database by providing the required details such as database username, password, host name, and port. If you’ve already created a connection, simply select it. After successfully connecting, you will need to map the fields from the previous response to your MySQL table.

Select the table name, for example, ‘OptinMonster Leads’. Map the fields such as first name, last name, email, and phone number using the previous response data.

Once everything is mapped, click on ‘Save and Send Test Request’. If successful, you should see confirmation that the lead details have been added to your MySQL database. This confirms that the integration using Pabbly Connect is working correctly.

Conclusion

In this tutorial, we explored how to automate the process of adding OptinMonster leads into a MySQL database using Pabbly Connect. By following the steps outlined, you can efficiently manage lead data without any coding skills. This integration streamlines your workflow and enhances your lead management capabilities.