Integrate LinkedIn Leads to MySQL with Pabbly Connect: A Step-by-Step Guide

Learn how to automate adding LinkedIn leads to MySQL using Pabbly Connect. Follow this detailed tutorial for seamless integration. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for LinkedIn Leads

To start the process of adding LinkedIn leads to MySQL, first, access Pabbly Connect. This platform is essential for automating the integration between LinkedIn Lead Gen Forms and your MySQL database. Begin by signing up on the Pabbly Connect website, where you can create a free account and get access to automation tasks every month.

Once you have signed in, navigate to the Pabbly Connect dashboard. Click on the ‘Create Workflow’ button. Here, you can name your workflow, such as ‘LinkedIn Leads to MySQL’. After naming it, click on the ‘Create’ button to proceed to the workflow page.

2. Configuring the Trigger in Pabbly Connect

In the workflow, the first step is to set up the trigger which will initiate the automation. Click on the trigger window and search for ‘LinkedIn Lead Generation Forms’. Select the trigger event as ‘New Lead Generation Form Response’. This event will start the workflow whenever a new lead is generated through your LinkedIn form. using Pabbly Connect

• Choose ‘LinkedIn Lead Generation Forms’ as the application.
• Select ‘New Lead Generation Form Response’ as the trigger event.
• Click on the Connect button and select ‘Add New Connection’.

After clicking connect, you will be prompted to log into your LinkedIn account. Enter your credentials and authorize Pabbly Connect to access your LinkedIn Lead Gen Forms. Once connected, select your LinkedIn account and the lead form from which you want to capture leads.

3. Generating and Testing LinkedIn Leads

Now that the trigger is set, it’s time to generate a test lead. Go to your LinkedIn Ads Manager and find the ad associated with your lead generation form. Click on the ad and select the option to manage your lead generation form. Fill out the form with sample information to simulate a new lead. using Pabbly Connect

• Enter a sample first name and last name.
• Provide a test email address and phone number.
• Click on the submit button to generate the lead.

After submitting the form, return to Pabbly Connect and click on the ‘Save and Send Test Request’ button. This will pull the lead data into Pabbly Connect, allowing you to verify that the information has been captured correctly.

4. Adding LinkedIn Leads to MySQL Database

With the lead data successfully captured, the next step is to send this information to your MySQL database. Click on the action window in Pabbly Connect and search for ‘MySQL’. Select the action event as ‘Insert Row’. This action will add a new row to your MySQL table with the lead details. using Pabbly Connect

Click on the connect button, and select ‘Add New Connection’. You will need to input your database username, password, host name, database name, and port number. These details can be obtained from your MySQL hosting provider. After entering the details, click on Save to establish the connection.

5. Mapping Lead Details to MySQL Table

Once connected to MySQL, you will be prompted to select the table where the lead information will be stored. Choose the appropriate table, such as ‘new_contacts’. After selecting the table, you will see the fields corresponding to the columns in your MySQL table. using Pabbly Connect

Map the first name field to the corresponding data from the LinkedIn response. Map the last name, email address, and mobile number similarly. After mapping all fields, click on ‘Save and Send Test Request’ to insert the data.

Upon successful insertion, you will receive a confirmation response. You can then check your MySQL table to confirm that the new lead has been added with all the correct details. This automation allows you to efficiently manage leads generated from LinkedIn without manual intervention.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the process of adding LinkedIn leads to a MySQL database. By following these steps, you can streamline your lead management process and ensure that your leads are captured efficiently for future communication.