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

Learn how to automate the process of adding Facebook leads to Google Sheets for your marble and granite business using Pabbly Connect. Follow our step-by-step guide!

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start integrating Facebook leads into Google Sheets, you first need to access Pabbly Connect. Open your browser and visit the Pabbly website. If you don’t have an account, you can sign up for free, which takes just a couple of minutes.

Once logged in, you will see options for various Pabbly applications. Click on the ‘Access Now’ button under Pabbly Connect to enter the dashboard. This is where you will create your workflow for adding Facebook leads to Google Sheets.

2. Creating a New Workflow in Pabbly Connect

In the Pabbly Connect dashboard, you need to create a new workflow. Click on the ‘Create Workflow’ button. A pop-up window will prompt you to name your workflow. Name it something descriptive, like ‘Add Facebook Leads to Google Sheets for Marble and Granite Business’.

• Select the folder where you want to save your workflow.
• After naming and selecting the folder, click ‘Create’.

Now, you will see two boxes labeled ‘Trigger’ and ‘Action’. The trigger indicates when the workflow will start, and the action defines what happens next. In this case, your trigger will be Facebook Lead Ads.

3. Setting Up the Trigger with Facebook Lead Ads

To set up your trigger in Pabbly Connect, select ‘Facebook Lead Ads’ as your trigger application. You will then need to choose a trigger event, which is ‘New Lead Instant’. This event activates the workflow whenever a new lead is captured.

Next, you need to connect your Facebook account to Pabbly Connect. Click on ‘Connect’, then ‘Add New Connection’. This will prompt you to log into your Facebook account, where you must grant access to Pabbly Connect to retrieve lead information.

• Select the Facebook page associated with your leads.
• Choose the lead generation form you wish to use.

After setting up the trigger, save your settings and send a test request to ensure everything is connected properly. You should see a successful response indicating that your trigger is working.

4. Configuring the Action to Add Leads to Google Sheets

Now that your trigger is set up, it’s time to configure the action in Pabbly Connect. Select ‘Google Sheets’ as your action application. The action event you need to choose is ‘Add New Row’. This action will automatically add new leads from Facebook to your Google Sheets.

Connect your Google account to Pabbly Connect by clicking on ‘Connect’, then ‘Add New Connection’. Allow access to your Google account to proceed. Once connected, you will need to select the specific spreadsheet where the leads will be stored.

Choose the spreadsheet named ‘Facebook Leads’. Select the correct sheet within that spreadsheet.

After selecting the spreadsheet and sheet, map the fields from the Facebook lead to the corresponding columns in Google Sheets. Ensure that you have mapped the full name, email, and phone number correctly.

5. Testing the Integration and Finalizing Setup

With everything configured in Pabbly Connect, it’s time to test the integration. Go back to your Facebook lead form and create a test lead. Fill out the form with dummy information and submit it. This step is crucial to ensure that your integration works as expected.

Return to Pabbly Connect and check if the lead details are captured successfully. If you receive a positive response, it means that your lead has been added to Google Sheets. You should now see the new lead details in your specified spreadsheet.

Verify that the data in Google Sheets matches the information submitted in the form. Repeat the process to ensure everything is functioning correctly.

Once you confirm that the integration works flawlessly, you have successfully automated the process of adding Facebook leads to Google Sheets for your marble and granite business using Pabbly Connect.

Conclusion

Using Pabbly Connect, you can easily automate the process of adding Facebook leads to Google Sheets for your marble and granite business. This integration saves time and helps manage leads efficiently, allowing for better business growth.