How to Add Facebook Leads to Google Sheets for Your Sanitary Ware Business Using Pabbly Connect

Learn how to seamlessly integrate Facebook Leads into Google Sheets for your sanitary ware business using Pabbly Connect. Step-by-step tutorial included. Revolutionize your productivity approach with just a few strategic clicks. Uncover professional methods for connecting applications and creating workflows that reclaim hours of your week.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin with, you need to access Pabbly Connect to set up the integration between Facebook Leads and Google Sheets. Start by signing into your account. If you are a new user, click on the sign-up option to create a free account that offers 100 tasks each month.

Once logged in, navigate to the Pabbly Connect dashboard. Click on the ‘Create Workflow’ button located in the top right corner. Here, you will name your workflow, such as ‘Add Facebook Leads to Google Sheets,’ and select the appropriate folder for organization.

2. Setting Up Facebook as the Trigger Application

In this step, you will configure Facebook as your trigger application within Pabbly Connect. The trigger event is set to ‘New Lead Instant,’ which means that every time a new lead is generated through Facebook Lead Ads, it will initiate the workflow.

After selecting Facebook as the trigger application, you need to establish a connection. Click on the ‘Connect’ button and authorize the connection with your Facebook account. Once connected, select the specific Facebook page you are using for your sanitary ware business.

• Select your Facebook page from the dropdown.
• Choose the lead generation form associated with your page.

After these selections, click on ‘Save and Send Test Request’ to ensure that the integration is working correctly. This will prepare you for the next steps in the workflow.

3. Testing the Facebook Leads Integration

Now that you have set up Facebook as the trigger application, it’s time to test the integration using Pabbly Connect. You will need to create a test lead to confirm that the data is captured correctly. Go to the Meta for Developers section and access the lead ads testing tool.

Select your Facebook page and the lead form you previously set up. Fill in the required details such as email, full name, and phone number, then submit the test lead. This action will send the lead data to Pabbly Connect.

• Choose your page from the dropdown.
• Select the form and preview it.
• Fill in the lead details and submit.

After submitting, check Pabbly Connect to see if the test lead information has been successfully captured. This confirms that the Facebook integration is functioning correctly.

4. Setting Up Google Sheets as the Action Application

With the Facebook leads integration confirmed, you can now set up Google Sheets as the action application in Pabbly Connect. The action event will be to ‘Add New Row’ in your Google Sheets whenever a new lead is received. Click on the ‘Connect’ button to establish a connection with Google Sheets.

Authorize the connection by signing in with your Google account. Once connected, select the Google Sheet where you want to store the lead information. Make sure your sheet has the appropriate columns for lead email, lead name, and phone number.

Select the spreadsheet titled ‘Facebook Leads New’. Ensure the columns are correctly set up to receive data.

Map the fields from the Facebook lead response to the corresponding columns in Google Sheets. This step is crucial for ensuring that the correct data is placed in the right columns.

5. Finalizing the Integration and Testing

After mapping the fields, it’s time to finalize the integration in Pabbly Connect. Click on ‘Save and Send Test Request’ to see if the lead details are accurately added to Google Sheets. If successful, you should see the test lead information appear in a new row of your specified Google Sheet.

This integration allows for seamless automation, ensuring that every new lead generated through Facebook Lead Ads is automatically captured in Google Sheets. This saves time and reduces manual entry errors, making your workflow more efficient.

Check your Google Sheet for the new lead entry. Confirm that all data fields are populated correctly.

With this setup, you can focus on your business while Pabbly Connect automates the data entry process for your Facebook leads.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to integrate Facebook Leads into Google Sheets for your sanitary ware business. This automation streamlines lead management, ensuring that all lead details are captured efficiently.