How to Add Facebook Leads to Google Sheets Using Pabbly Connect

Learn how to integrate Facebook Leads with Google Sheets using Pabbly Connect for your sanitary ware business. Step-by-step tutorial included. Explore systematic approaches to creating efficient automation solutions that convert technical concepts into practical, implementable instructions.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To add Facebook leads to Google Sheets, first, access Pabbly Connect to set up the integration. Begin by signing into your existing account or sign up if you are a new user. Pabbly Connect allows you to automate tasks between applications seamlessly.

Once logged in, navigate to the applications page and select Pabbly Connect. Click on the ‘Access Now’ button to reach your dashboard where you can create a new workflow. This is essential for connecting Facebook leads to Google Sheets effectively.

2. Creating a New Workflow in Pabbly Connect

In your Pabbly Connect dashboard, create a new workflow to integrate Facebook Leads with Google Sheets. Click on the ‘Create Workflow’ button located at the top right corner. Name your workflow, for example, ‘Add Facebook Leads to Google Sheets,’ and choose a folder to save it in. using Pabbly Connect

• Click on the ‘Create’ button to initiate the workflow.
• Select Facebook as your trigger application.
• Set the trigger event to ‘New Lead Instant’.

This setup ensures that every time a new lead is generated through Facebook, it triggers the workflow to add details to Google Sheets automatically. The integration is set to run as soon as a new lead is captured.

3. Connecting Facebook Leads to Pabbly Connect

Now, establish the connection between Facebook and Pabbly Connect. Click on ‘Connect’ next to your trigger application. You’ll need to authorize Pabbly Connect to access your Facebook account where your lead ads are running.

After successfully connecting, select the Facebook page associated with your sanitary ware business. Choose the lead generation form you want to use. For instance, select ‘Contact Form Sam Plumbing and Sanitary Ware’ from the dropdown menu. This ensures that the correct lead information is captured.

4. Testing the Integration with a Test Lead

To verify that your integration works, you will perform a test submission. In Pabbly Connect, after setting up your trigger, it will prompt you to send a test request. To do this, go to the Meta for Developers page and access the Lead Ads Testing Tool.

• Select your Facebook page and the lead form.
• Fill in the required lead details like email, name, and phone number.
• Submit the form to create a test lead.

Once you submit the test lead, return to Pabbly Connect to check for the response. If the details appear correctly, your setup is functioning as intended.

5. Adding Facebook Leads to Google Sheets

After confirming that the test lead is captured in Pabbly Connect, the next step is to connect Google Sheets. Click on ‘Connect’ next to your action application. Choose to sign in with Google and allow necessary permissions for the integration.

Once connected, select the specific Google Sheet you created for leads. For example, choose the sheet named ‘Facebook Leads New’. Map the lead details received from Facebook, such as email, name, and phone number, to the corresponding columns in Google Sheets. This mapping ensures that every new lead is automatically added to a new row in your selected sheet.

Conclusion

Using Pabbly Connect, you can efficiently automate the process of adding Facebook leads to Google Sheets for your sanitary ware business. This integration saves time and ensures that you never miss capturing valuable lead information.