How to Add Facebook Leads to Google Sheets for FMCG Products Using Pabbly Connect

Learn how to integrate Facebook Leads with Google Sheets for FMCG products using Pabbly Connect. Step-by-step tutorial for seamless automation. Follow this definitive guide to creating powerful automated workflows with straightforward, efficiency-focused solutions that save valuable time.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Facebook Leads Integration

To begin adding Facebook leads to Google Sheets for FMCG products, first, access Pabbly Connect. Open a new tab and enter the URL Pabbly.com/connect. This platform is essential for integrating Facebook lead ads with Google Sheets.

Once on the Pabbly Connect page, you will see options to sign in or sign up for free. New users can sign up to receive 100 tasks free every month, while existing users can simply log in. After logging in, navigate to the dashboard where you will find various applications offered by Pabbly.

2. Creating a Workflow in Pabbly Connect

In the Pabbly Connect dashboard, click on the button labeled ‘Create Workflow’ to initiate the automation process. You will be prompted to select a folder to save your workflow and name it. For this integration, name your workflow ‘Add Facebook Leads to Google Sheets for FMCG Sector’. using Pabbly Connect

• Select a folder for your workflow.
• Name your workflow appropriately.

After naming your workflow, click on ‘Create’ to proceed. This opens the workflow window where you will set up the trigger and action. The trigger will be Facebook lead ads, and the action will be to add data to Google Sheets.

3. Setting Up Trigger with Facebook Lead Ads

In the workflow window, select ‘Facebook Lead Ads’ as your trigger application. Next, choose the trigger event as ‘New Lead Instant’. This option allows Pabbly Connect to capture leads as soon as they are submitted. using Pabbly Connect

Click on ‘Connect’ to link your Facebook account with Pabbly Connect. You can either select an existing connection or create a new one. If creating a new connection, choose your Facebook account and click on ‘Continue’. Once connected, select the Facebook page and lead form from which you want to capture leads.

• Select your Facebook page (e.g., Black and Spicy).
• Choose the lead form you want to use.

After selecting the appropriate options, click on ‘Save and Send Test Request’. Pabbly Connect will then wait for a webhook response, indicating it is ready to capture data from Facebook.

4. Testing the Trigger in Pabbly Connect

To test the trigger, you need to generate a dummy lead response. Open a new tab and search for Meta for Developers. Navigate to the Lead Ads Testing Tool, where you can simulate a lead submission. using Pabbly Connect

In the testing tool, select the same Facebook page and lead form you used in Pabbly Connect. Fill in dummy details such as a name, email, and phone number, then submit the form. Once the test lead is submitted, Pabbly Connect will capture this response, confirming that the trigger is functioning correctly.

Fill in dummy lead details (e.g., Demo User, [email protected]). Submit the lead to test the trigger.

After submitting, return to your Pabbly workflow to verify that the dummy lead details have been captured successfully. This indicates that your trigger is set up correctly.

5. Setting Up Action with Google Sheets

Now that the trigger is set up, it’s time to configure the action. Select ‘Google Sheets’ as your action application and choose the action event as ‘Add a New Row’. Click on ‘Connect’ to link your Google Sheets account. using Pabbly Connect

Similar to the previous steps, you can either select an existing connection or create a new one by signing in with your Google account. Once connected, specify the spreadsheet name (e.g., Facebook Leads) and the sheet name (e.g., FMCG) where you want the leads to be added.

Select the spreadsheet name correctly. Choose the correct sheet name for data insertion.

Next, map the lead details (name, email, phone number) from the trigger step to the corresponding fields in Google Sheets. After mapping the data, click on ‘Save and Send Test Request’ to check if the data is added to Google Sheets successfully. Verify by opening your Google Sheets to see if the test lead appears.

Conclusion

Using Pabbly Connect, you can seamlessly integrate Facebook leads into Google Sheets for FMCG products. This automation saves time and ensures you never miss a lead, enhancing your business efficiency.