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

Learn how to automate adding Facebook leads to Google Sheets for your dry fruits business using Pabbly Connect. Follow this step-by-step guide for seamless integration.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To begin, accessing Pabbly Connect is essential for integrating Facebook leads into Google Sheets. Open a new tab and search for Pabbly Connect. You will see options to either sign in or sign up for free. If you don’t have an account, signing up is straightforward and takes just a couple of minutes.

Once logged in, you will be directed to the dashboard of Pabbly Connect. Here, you can see all your workflows. To create a new workflow, click on the ‘Create Workflow’ button. This action will prompt you to name your workflow, which should reflect your objective, such as ‘Add Facebook Leads to Google Sheets for Dry Fruits Business’.

2. Setting Up the Trigger in Pabbly Connect

The next step involves setting up the trigger in Pabbly Connect. In the workflow interface, you will see two boxes labeled Trigger and Action. For the trigger application, select Facebook Lead Ads. The trigger event you need to choose is ‘New Lead Instant’.

• Select Facebook Lead Ads as the trigger application.
• Choose ‘New Lead Instant’ as the trigger event.
• Connect your Facebook account to Pabbly Connect.

After selecting the trigger event, click on ‘Connect’ and then ‘Add New Connection’. Follow the prompts to authorize Pabbly Connect to access your Facebook account. Once connected, you will need to select your Facebook page and the lead generation form that you are using.

3. Mapping Lead Details from Facebook to Pabbly Connect

After successfully connecting your Facebook account, the next step is to map the lead details. In Pabbly Connect, you will see fields to select your Facebook page and lead generation form. Ensure that you select the correct page, which in this case is ‘Tara Dry Fruit Company’.

Once the page is selected, you will also need to choose the lead generation form. This form contains fields like full name, email, and phone number. Make sure these fields are correctly mapped in Pabbly Connect to capture the lead details accurately.

• Select ‘Tara Dry Fruit Company’ as the page.
• Choose the lead form for your dry fruit business.
• Map the fields for full name, email, and phone number.

Once you have mapped these details, you will need to test the connection by submitting a sample lead. Ensure that your lead generation form is live before proceeding with this step.

4. Adding Leads to Google Sheets with Pabbly Connect

With the lead details mapped, the next step is to set up the action in Pabbly Connect to add these leads to Google Sheets. For this, you will select Google Sheets as your action application. The action event you need to choose is ‘Add New Row’.

Click on ‘Connect’ to link your Google Sheets account to Pabbly Connect. You will need to sign in and grant access to your Google account. After connecting, select the specific spreadsheet where you want to store your leads.

Choose Google Sheets as the action application. Select ‘Add New Row’ as the action event. Map the lead details to the respective columns in your Google Sheet.

After mapping the details, click on ‘Save and Send Test Request’ to confirm that the integration works. Check your Google Sheet to see if the new lead has been added successfully.

5. Finalizing the Integration and Testing

With everything set up, the final step is to test the entire integration. Go back to your lead generation form and create a new lead. Fill in the required details and submit the form. This action should trigger the workflow in Pabbly Connect and automatically add the lead details to your Google Sheet.

After submitting the lead, check your Google Sheet to confirm that the new entry has appeared. If everything is set up correctly, you will see the lead’s full name, email, and phone number in the respective columns.

Create a new lead in your Facebook lead form. Submit the form to trigger the integration. Verify the lead details in your Google Sheet.

By following these steps, you have successfully created an integration between Facebook Lead Ads and Google Sheets using Pabbly Connect. This automation will save you time and help you efficiently manage your leads for your dry fruits business.

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automatically add Facebook leads to Google Sheets for a dry fruits business. This integration streamlines lead management and enhances productivity.