Add Facebook Leads to Google Sheets for Marble and Granite Business Using Pabbly Connect

Learn how to integrate Facebook Leads with Google Sheets for your Marble and Granite business using Pabbly Connect. Step-by-step tutorial included. Implement the precise methodologies leading organizations use to automate repetitive tasks, illustrated with practical examples designed for immediate application.

Watch Step By Step Video Tutorial Below

Accessing Pabbly Connect for Facebook Leads

To add Facebook leads to Google Sheets for your marble and granite business, you first need to access Pabbly Connect. Start by opening a new browser tab and navigating to the Pabbly website.

Once on the site, you can either sign in or sign up for a free account. Signing up takes just a couple of minutes and provides you with 100 free tasks each month. After logging in, click on the ‘Access Now’ button under Pabbly Connect to enter the dashboard.

Creating a Workflow in Pabbly Connect

In the Pabbly Connect dashboard, you can create a workflow to automate the process of adding Facebook leads to Google Sheets. Click on the ‘Create Workflow’ button and name your workflow according to your objective, such as ‘Add Facebook Leads to Google Sheets for Marble and Granite Business’. using Pabbly Connect

Next, select the folder where you want to save this workflow. After naming your workflow, you will see two main boxes: Trigger and Action. The Trigger is set to Facebook Lead Ads, which will initiate the workflow whenever a new lead is generated.

Setting Up Trigger in Pabbly Connect

To set up the Trigger in Pabbly Connect, select Facebook Lead Ads as your application. Then, choose the trigger event as ‘New Lead Instant’. This event will fire whenever you receive a new lead from your Facebook ads.

Click on the ‘Connect’ button, then select ‘Add New Connection’. Log into your Facebook account to allow Pabbly Connect access. Once connected, choose the Facebook page for your marble and granite business, named ‘The Stone Source’, and select the lead generation form you are using.

• Select the Facebook page: The Stone Source
• Choose the lead generation form: New Form
• Click on ‘Save and Send Test Request’

After setting up the trigger, make sure to create a sample submission of your lead form to test the connection. This ensures that the workflow is working as intended.

Setting Up Action in Pabbly Connect

After successfully setting up the trigger, the next step is to configure the Action. In Pabbly Connect, select Google Sheets as your action application. Choose the action event as ‘Add New Row’ to insert the lead details into your spreadsheet.

Click ‘Connect’ and then ‘Add New Connection’ to link your Google Sheets account. Allow access to your Google account, and once connected, select the specific spreadsheet where you want to add the lead details. For this tutorial, use the spreadsheet named ‘Facebook Leads’ and the first sheet.

• Select the spreadsheet: Facebook Leads
• Choose the sheet: Sheet1
• Map the lead details: Full Name, Email, Phone Number

Use the mapping feature to link the data from the Facebook lead to the corresponding columns in your Google Sheet. This will ensure that each new lead’s information is correctly added to your records.

Testing the Integration in Pabbly Connect

Once you have set up both the trigger and action in Pabbly Connect, it is time to test the integration. Submit a new lead through your Facebook lead form to generate a test entry. After submission, return to Pabbly Connect and click on ‘Save and Send Test Request’.

You should receive a positive response indicating that the lead details were successfully captured. Check your Google Sheets to verify that the new lead entry appears. You will see the full name, email, and phone number listed as per the mapping.

This integration allows you to automatically manage your leads without manual entry, significantly streamlining your operations for the marble and granite business.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the process of adding Facebook leads to Google Sheets for your marble and granite business. By following the outlined steps, you can efficiently manage your leads and keep your records updated.

Utilizing Pabbly Connect not only saves time but also helps in maintaining accurate and organized lead data, empowering your business growth.