How to Add Facebook Leads to Google Sheets Using Pabbly Connect for D2C Products

Learn how to seamlessly integrate Facebook Leads with Google Sheets using Pabbly Connect for your D2C products in this detailed tutorial. Explore efficient methods for automating routine tasks with clear, concise instructions suited for both newcomers and experienced professionals.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To add Facebook leads to Google Sheets, you first need to access Pabbly Connect. This platform enables seamless integration between your Facebook Lead Ads and Google Sheets for your D2C products.

Begin by visiting the Pabbly Connect website. If you are a new user, click on ‘Sign Up Free’ to create an account. Existing users should click on ‘Sign In’. Once you are logged in, you will be directed to the Pabbly Connect dashboard where you can create a new workflow.

2. Creating a New Workflow in Pabbly Connect

In this step, you will create a new workflow to manage the integration. Within the Pabbly Connect dashboard, click on the option to create a new folder and name it ‘Facebook Leads to Google Sheets’. This helps in organizing your workflows.

• Click on ‘Create Workflow’.
• Name your workflow as ‘Facebook Leads to Google Sheets for D2C Products’.
• Select the folder you created earlier.

After naming your workflow, you will see options for setting up a trigger and action. Choose Facebook Lead Ads as your trigger application to start the integration process.

3. Setting Up the Trigger in Pabbly Connect

The next step is to set up the trigger for your workflow. In Pabbly Connect, select Facebook Lead Ads as the trigger application. You will need to choose the trigger event, which is ‘New Lead Instant’. This event will activate the workflow whenever a new lead is submitted.

Click on ‘Connect Now’ to link your Facebook account with Pabbly Connect. If you don’t have an existing connection, select ‘Add New Connection’ and follow the prompts to authorize Pabbly Connect to access your Facebook account. Make sure to select the correct Facebook page and lead generation form.

4. Configuring Google Sheets as the Action Application

Now that your trigger is set up, the next step is to configure Google Sheets as the action application in Pabbly Connect. Click on the action application and select Google Sheets. The action event will be ‘Add a New Row’, which will enable you to add lead details to your Google Sheet.

• Select ‘Add New Row’ as the action event.
• Connect your Google Sheets account with Pabbly Connect.
• Choose the spreadsheet where you want to add the leads.

Once you have connected, map the fields from Facebook Lead Ads to your Google Sheets, ensuring that the data aligns correctly with the columns in your spreadsheet.

5. Testing the Integration and Finalizing

After mapping the fields, it’s time to test the integration. Click on ‘Save and Send Test Request’ in Pabbly Connect. This action will check if the data is being sent to Google Sheets correctly. If successful, you should see a new row added in your Google Sheets with the lead details.

To ensure everything is working, go back to your Facebook Lead Ads testing tool, delete any existing leads, and submit a new lead. Refresh your Google Sheets to confirm that the new lead appears. If the row is added successfully, your integration is complete!

Conclusion

In this tutorial, we explored how to use Pabbly Connect to automate the process of adding Facebook leads to Google Sheets for your D2C products. By following these steps, you can streamline your lead management efficiently.