Watch Step By Step Video Tutorial Below





1. Accessing Pabbly Connect for Automation

To get started, you need to access Pabbly Connect. Open a new tab in your browser and search for pabblab.com/connect. This platform is essential for automating your workflows.

Once on the site, you will see options for signing in or signing up. If you’re new, click on the “Sign Up Free” option to get 100 free tasks every month. Existing users should click “Sign In”. After signing in, navigate to the Pabbly Connect dashboard by clicking on the “Access Now” button.

2. Creating a New Workflow in Pabbly Connect

In the Pabbly Connect dashboard, click on “Create Workflow”. You will be prompted to create from scratch or use AI. Select “Create from Scratch” for this tutorial.

  • Choose “New Beta” as your workflow builder.
  • Name your workflow something like “Capture Facebook Leads”.
  • Select the folder as “Publicly Connect” and click “Create”.

Now, you need to set a trigger. Search for “Facebook Lead Ads” and select it as your trigger application. Choose the event “New Lead Instant” to ensure automation runs every time a new lead is generated.

3. Connecting Facebook Lead Ads to Pabbly Connect

After selecting the trigger, click on the “Connect” button. You will have options to add a new connection or select an existing one. For this tutorial, we will create a new connection.

Click on “Add New Connection” and connect with your Facebook account. Once connected, select your Facebook page and lead form. Make sure to choose the lead form you are using to collect details.

  • Choose the response format as “Simple”.
  • Click on “Save and Send Test Request” to test the connection.

Once the test is successful, you’ll see that the connection between your Facebook account and Pabbly Connect is working perfectly.

4. Storing Leads in Google Sheets via Pabbly Connect

Next, you will set up the action to store leads in Google Sheets. Click on the plus icon and search for “Google Sheets”. Select the event as “Add New Row”.

Click on the “Connect” button and create a new connection by signing in with your Google account. After connecting, select the spreadsheet where you want to store the leads.

  • Choose the spreadsheet named “Facebook Leads”.
  • Select “Sheet 1” for the data storage.

In the mapping section, map the fields such as first name, last name, phone number, and email address from the Facebook lead data to the corresponding columns in your Google Sheet. This dynamic mapping will ensure that each lead’s data is captured correctly.

5. Completing and Activating the Automation

After mapping the fields, click on the “Save and Send Test Request” button. You should see a positive response indicating that a new row has been successfully added to your Google Sheet.

To finalize your workflow, ensure to enable the toggle switch at the top right of the screen. This step is crucial; if not enabled, your automation will not work.

  • Test the workflow to confirm everything is functioning correctly.
  • If you encounter any issues, refer to the support options available.

With this setup, your Facebook leads will automatically be captured and stored in Google Sheets, streamlining your lead management process using Pabbly Connect.

Conclusion

In this tutorial, we explored how to automate Facebook Lead Ads with Google Sheets using Pabbly Connect. This integration allows you to capture leads instantly, ensuring no opportunities are lost. Start automating your workflows today!