How to Add Facebook Leads to Google Sheets for Dry Fruits Business Using Pabbly Connect

Learn how to integrate Facebook Leads with Google Sheets for your Dry Fruits business using Pabbly Connect. Follow this step-by-step tutorial. Discover hidden automation capabilities within your existing tools. This guide shows you how to connect your essential applications and permanently eliminate redundant manual processes.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To add Facebook leads to Google Sheets for your dry fruits business, you will first need to access Pabbly Connect. Begin by opening a new tab in your browser and searching for Pabbly Connect. If you don’t have an account, you can sign up for free, which takes only a couple of minutes.

Once you have logged in, you will be directed to the Pabbly Connect dashboard. Here, you can view all your workflows. Click on the ‘Access Now’ button under Pabbly Connect to start creating your integration workflow.

2. Creating a New Workflow in Pabbly Connect

In this step, you will create a new workflow to integrate Facebook leads with Google Sheets using Pabbly Connect. Click on the ‘Create Workflow’ button. A pop-up window will appear where you can name your workflow. Name it something descriptive, like ‘Add Facebook Leads to Google Sheets for Dry Fruits Business’.

• Select the folder to save your workflow.
• Click on ‘Create’ to proceed.
• You will now see the trigger and action setup boxes.

In this section, you will set up the trigger application, which is Facebook Lead Ads. Select this application and choose the trigger event as ‘New Lead Instant’. This will initiate the workflow whenever a new lead is generated.

3. Connecting Facebook Lead Ads to Pabbly Connect

Next, you will connect your Facebook Lead Ads account to Pabbly Connect. Click on ‘Connect’ and then ‘Add New Connection’. After successful connection, you will need to grant access to your Facebook account.

Once connected, you will see two tabs: one for the page and one for the lead generation form. Select the page associated with your dry fruits business, which is ‘Tara Dry Fruit Company’. Then, select the lead generation form named ‘Lead Form for Dry Fruit Business’. This form contains the details you want to capture.

• Ensure your lead generation form is live.
• Click on ‘Save and Send Test Request’ to fetch lead details.

After clicking the save button, you need to create a sample lead submission to test the connection. Use the Meta for Developers tool to fill out the form with sample data.

4. Adding Lead Details to Google Sheets

Now that you have set up Facebook Lead Ads in Pabbly Connect, it’s time to configure the action application, which is Google Sheets. Select Google Sheets as your action application and choose ‘Add New Row’ as the action event.

Click on ‘Connect’ and then ‘Add New Connection’ to link your Google Sheets account. Allow access to your account, and then select the spreadsheet named ‘Facebook Leads’. You will see the columns in your sheet, which should match the lead details you want to add.

Map the lead details such as full name, email, and phone number. Use the mapping feature to ensure data is retrieved correctly.

After mapping all the necessary details, click on ‘Save and Send’ to test if the lead details are successfully added to your Google Sheet. You should see the new entry appear in your spreadsheet.

5. Testing and Verifying the Integration

To ensure everything is working perfectly, you need to perform a test submission. Go back to the Meta for Developers tool and delete the previous sample lead. Fill the form with new details and submit it. This will create a new lead.

After submitting the form, return to Pabbly Connect and check if the new lead details have been captured. You should see the updated information in your Google Sheets. This confirms that your integration is working as intended.

Repeat this process to verify that your leads are consistently added to Google Sheets in real-time. This setup allows you to manage your leads efficiently for your dry fruits business.

Conclusion

In this tutorial, we have successfully demonstrated how to use Pabbly Connect to integrate Facebook leads with Google Sheets for your dry fruits business. By following these steps, you can automate the process of adding lead details to your Google Sheets, saving time and improving your business operations.