Integrating Facebook Lead Ads with MailerLite and Google Sheets Using Pabbly Connect

Learn how to integrate Facebook Lead Ads with MailerLite and Google Sheets using Pabbly Connect in this step-by-step tutorial. Streamline your lead management process today!

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start integrating Facebook Lead Ads with MailerLite and Google Sheets, first access Pabbly Connect. Open your browser and navigate to the Pabbly Connect landing page by searching for Pabbly.com/connect.

Once on the landing page, you will see options to sign in or sign up. If you are new, click on ‘Sign up for free’ to get started. Existing users can click on ‘Sign in’. After signing in, you will see various Pabbly applications. Click on ‘Access Now’ under Pabbly Connect to enter your dashboard.

2. Creating a Workflow in Pabbly Connect

After accessing your Pabbly Connect dashboard, click on the ‘Create Workflow’ button. You will be prompted to name your workflow and select a folder to save it. Name your workflow something like ‘Create MailerLite Subscriber from Facebook Lead Ads and Add Details in Google Sheets’ and choose the ‘Automations’ folder. using Pabbly Connect

• Click on ‘Create’ to open the workflow window.
• In this workflow, you will set a trigger and an action.

This window is crucial as it allows you to define what happens when a specific event occurs. The trigger will be your command, and the actions will follow based on that command.

3. Setting Up the Trigger with Facebook Lead Ads

In the workflow window, select ‘Facebook Lead Ads’ as your trigger application. After selecting it, you will need to choose the trigger event, which should be set to ‘New Lead Instant’. Click on ‘Connect’ to proceed. using Pabbly Connect

If you have not connected your Facebook account before, select ‘Add New Connection’. Follow the prompts to authenticate your Facebook account. Once connected, select your Facebook page and the lead form you want to use.

• Choose the page named ‘Natural Glow Skincare’.
• Select the lead form you created for this automation.

After saving your selections, you will need to perform a test submission to capture the webhook response. This is crucial for ensuring that Pabbly Connect can receive the lead data.

4. Setting Up Actions with MailerLite and Google Sheets

Now that the trigger is set up, it’s time to add actions. First, search for ‘MailerLite’ as your action application. Select ‘Create or Update a Subscriber’ as the action event. Click on ‘Connect’ and either select an existing connection or create a new one by entering your MailerLite API token. using Pabbly Connect

Once connected, you will need to map the data fields from the trigger step to the MailerLite action. This includes mapping the subscriber’s email, first name, last name, and phone number. Ensure that you switch on the mapping button to dynamically insert the data from the lead.

Map the email field to the email captured from the lead. Map first and last names accordingly.

After mapping all necessary fields, click on ‘Save and Send Test Request’ to verify that the subscriber is created in MailerLite.

5. Finalizing the Integration with Google Sheets

To complete the integration, add another action step by selecting ‘Google Sheets’. Choose ‘Add New Row’ as the action event. Connect your Google Sheets account in the same manner as before, and select the spreadsheet and sheet where you want to add the lead details. using Pabbly Connect

Map the fields from the trigger data to the corresponding columns in Google Sheets. This includes the same information you mapped to MailerLite, such as first name, last name, email, phone number, skin type, and skin concerns.

Ensure all fields are correctly mapped to the right columns. Click on ‘Save and Send Test Request’ to finalize the setup.

Once the test is successful, you can check your Google Sheets to confirm that the lead details have been added correctly. This integration allows you to manage your leads effectively and nurture them into paying clients.

Conclusion

In this tutorial, you learned how to use Pabbly Connect to integrate Facebook Lead Ads with MailerLite and Google Sheets. This streamlined process improves lead management and enhances customer engagement, ultimately supporting increased sales.