How to Add Facebook Leads to Google Sheets Using Pabbly Connect

Learn how to automate adding Facebook leads to Google Sheets for your Dance Academy using Pabbly Connect. Step-by-step guide with specific integration instructions. 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 Automation

To start automating the addition of Facebook leads to Google Sheets, you need to access Pabbly Connect. Begin by navigating to the Pabbly Connect homepage, which you can reach by typing ‘Pabbly.com/connect’ in your browser.

Once there, you will see options to sign in or sign up for free. If you are an existing user, click on the ‘Sign In’ button. New users can create an account by clicking ‘Sign Up for Free’, which grants you 100 free tasks monthly to explore Pabbly Connect’s features.

2. Creating a Workflow in Pabbly Connect

After signing in, you will land on the Pabbly Connect dashboard. Here, you can see existing workflows or create a new one. To create a new workflow, click on the ‘Create Workflow’ button located in the top right corner of the dashboard.

• Name your workflow, for example, ‘Add Facebook Leads to Google Sheets for Dance Academy.’
• Select a folder to save the workflow, such as ‘Test Integrations.’
• Click ‘Create’ to proceed.

This action will open two windows for setting up the trigger and action. The trigger is where you select Facebook Lead Ads, and the action is where you choose Google Sheets, establishing the integration through Pabbly Connect.

3. Setting Up Facebook Lead Ads as Trigger

In this step, select Facebook Lead Ads as your trigger application in Pabbly Connect. The trigger event you need is ‘New Lead Instant.’ This event will activate the workflow whenever a new lead is generated from your Facebook page.

Click on ‘Connect’ and choose ‘Add New Connection’ to build a connection with your Facebook account. After successful authorization, select your Facebook page, which should be named NRA Dance Academy, and the lead gen form associated with it. Click ‘Save and Send Test Request’ to initiate the testing process.

4. Testing the Integration with Facebook Lead Ads

Once you have set up the trigger, you need to test the integration. To do this, go to the Meta for Developers site and access the Lead Ads Testing Tool. Select your Facebook page and the appropriate lead gen form, then preview the form to fill it out.

• Enter test details such as first name, last name, email, and phone number.
• Submit the form to generate a new lead.

After submitting, return to Pabbly Connect to verify that the lead details have been captured successfully. This confirms that your workflow is set up correctly and ready to process real leads.

5. Adding Facebook Leads to Google Sheets

After confirming that leads are captured, it’s time to set up Google Sheets as the action application in Pabbly Connect. Select ‘Google Sheets’ and choose the action event ‘Add New Row.’ This will allow you to add the details of each new lead into your spreadsheet.

Connect your Google Sheets account by selecting ‘Sign In with Google’ and granting the necessary permissions. Once connected, choose the spreadsheet named NRA Dance Academy Leads and ensure you select the correct sheet where the data will be added.

Map the fields from the Facebook lead to your Google Sheets columns, ensuring first name, last name, email, and contact number are included. Click ‘Save and Send Test Request’ to check if the data is added correctly.

After testing, check your Google Sheets to confirm that the new lead details have been added as a new row, indicating that your integration is successful.

Conclusion

In this tutorial, we’ve demonstrated how to use Pabbly Connect to automate the process of adding Facebook leads to Google Sheets for your Dance Academy. By following these steps, you can efficiently manage leads and streamline your workflow.