How to Sync New Leads from Facebook Ads to Google Sheets Automatically with Pabbly Connect

Learn how to sync new leads from Facebook Ads to Google Sheets automatically using Pabbly Connect. Step-by-step guide with detailed instructions. Master proven automation processes with practical implementation examples and strategic recommendations you can apply immediately in your workflow.

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To sync new leads from Facebook Ads to Google Sheets automatically, you need to access Pabbly Connect. Start by visiting the Pabbly Connect website at pave.com/connect. This platform is essential for automating the integration process.

Once on the Pabbly Connect homepage, you can sign up for free or log in if you already have an account. After signing in, you will see the dashboard where you can create your workflow to connect Facebook Ads with Google Sheets.

2. Creating a Workflow in Pabbly Connect

In this section, you will create a workflow that connects your Facebook Ads with Google Sheets using Pabbly Connect. Click on the ‘Create Workflow’ button located at the top right corner of the dashboard.

• Enter a name for your workflow, such as ‘Sync New Leads from Facebook Ads to Google Sheets Automatically’.
• Select a folder where you want to save this workflow.

After naming your workflow, click on the ‘Create’ button to proceed. You will now see options for setting up triggers and actions within your automation.

3. Setting Up the Trigger for Facebook Ads

The next step involves setting up the trigger that will initiate the workflow in Pabbly Connect. Select ‘Facebook Lead Ads’ as your trigger application and choose the ‘New Lead’ event. This means that whenever a new lead is submitted, the workflow will start.

To connect your Facebook Lead Ads account, click on ‘Connect’ and then select ‘Add New Connection’. Authorize the connection by selecting your Facebook account. Once connected, choose your Facebook page and the specific lead generation form you want to use.

4. Testing the Lead Submission

After setting up the trigger, you need to test it to ensure everything is functioning correctly. Use the Facebook Lead Ads testing tool to submit a test lead. Fill out the form with dummy details such as first name, last name, email, and phone number.

• Type of property: Rental Property
• First Name: Test
• Last Name: User
• Email: [email protected]

Once you submit the test lead, return to Pabbly Connect to check if the lead details were captured successfully. You should see the response with all the lead information ready for the next step.

5. Adding Leads to Google Sheets Automatically

Now that the trigger is set up and tested, it’s time to add the lead details to Google Sheets. In Pabbly Connect, select ‘Google Sheets’ as your action application and choose ‘Add a New Row’ as the action event.

Connect your Google Sheets account by clicking on ‘Connect’ and selecting ‘Add New Connection’. Authorize the connection to allow Pabbly Connect to access your Google Sheets data. After connecting, choose the spreadsheet where you want to store the leads and map the fields from your trigger step to the corresponding columns in your Google Sheet.

Conclusion

In this tutorial, we explored how to sync new leads from Facebook Ads to Google Sheets automatically using Pabbly Connect. We detailed each step, from accessing Pabbly Connect to creating workflows, setting up triggers, testing lead submissions, and finally adding leads to Google Sheets. This integration simplifies lead management and enhances your business operations.