How to Seamlessly Add Facebook Leads to Google Sheets Using Pabbly Connect

Learn how to integrate Facebook Leads with Google Sheets for your furniture business using Pabbly Connect. Follow our step-by-step tutorial for easy automation. Build sophisticated automated workflows in less time than you think. This guide translates complex integrations into straightforward steps for immediate implementation.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Facebook Leads Integration

To add Facebook leads to Google Sheets, you first need to access Pabbly Connect. This platform serves as the central integration tool that connects your Facebook lead ads with Google Sheets for your furniture business.

As an existing user, you can simply sign in. If you are new to Pabbly Connect, click on the ‘Sign up for free’ button to create an account, which allows you to use 100 tasks for free each month. Once you are signed in, navigate to the ‘All Applications’ page and click on ‘Pabbly Connect’ to access your dashboard.

2. Creating a Workflow in Pabbly Connect

Next, you need to create a new workflow in Pabbly Connect. On the right-hand side of your dashboard, click on the ‘Create Workflow’ button. In the dialog box that appears, name your workflow, for example, ‘Add Facebook Leads to Google Sheets.’ You can save it in a folder named ‘Facebook Lead Ads.’

• Click the ‘Create’ button to proceed.
• You will see a window with trigger and action options.

In this window, set Facebook Lead Ads as your trigger application and choose ‘New Lead Instant’ as the trigger event. This setup ensures that every time you receive a new lead, the workflow will automatically run.

3. Connecting Facebook Lead Ads to Pabbly Connect

To connect Facebook Lead Ads with Pabbly Connect, click on the ‘Connect’ button in the trigger window. Since you are already logged into your Facebook account, simply authorize the connection. Once successful, select the Facebook page you created for your furniture business, such as ‘ARA Furniture Store.’

After selecting your page, choose the associated lead generation form, like ‘ARA Furniture Contact Form New.’ Click on ‘Save & Test Request’ to finalize this connection. At this point, Pabbly Connect is ready to capture leads from your Facebook ads.

4. Testing the Integration with Pabbly Connect

Now it’s time to test the integration you set up in Pabbly Connect. You will need to create a test lead to confirm the integration works correctly. Go to the Meta for Developers site and navigate to the Lead Ads Testing Tool.

• Select your page ‘ARA Furniture Store’ from the dropdown.
• Choose the form ‘ARA Furniture Contact New Form’ and fill in the required details.
• Click on ‘Submit’ to send the test lead.

After submitting the test lead, return to Pabbly Connect to check if the lead details have been captured successfully. You should see the full name, phone number, email, and other details of the lead, confirming that the integration is working.

5. Adding Lead Details to Google Sheets via Pabbly Connect

The final step is to add the captured lead details to Google Sheets using Pabbly Connect. In the action window, select Google Sheets as your action application and choose ‘Add New Row’ as the action event.

Next, connect your Google account to Pabbly Connect by clicking ‘Connect’ and authorizing access. Once connected, select the Google Sheet you created for this purpose, named ‘Facebook Leads New.’ Ensure that the sheet has columns for email, name, and phone number.

Map the lead email, name, and phone number from the captured data. Click ‘Save & Send Test Request’ to send the data to Google Sheets.

Check your Google Sheet to confirm that the test lead details have been added successfully in a new row. This indicates that your integration is complete, and now every new lead from Facebook will automatically populate in your Google Sheets.

Conclusion

By following this tutorial, you learned how to integrate Facebook leads into Google Sheets using Pabbly Connect. This automation streamlines your workflow, ensuring that every lead generated from your furniture business is captured efficiently in your Google Sheets.