Products
- Pabbly Plus
  Pabbly Plus provides access to all Pabbly applications at a single price. You will have access to Pabbly Connect, Pabbly Subscription Billing, Pabbly Chatflow, Pabbly Email Marketing, Pabbly Form Builder and Pabbly Hook.
  
  Pabbly Connect
  Integrate different applications and start automating your work.
  
  Pabbly Subscription Billing
  Start accepting one-time and recurring subscription payments.
  
  Pabbly Chatflow
  Automate WhatsApp conversations effortlessly.
  
  Pabbly Email Marketing
  Send email newsletters to your subscribers and customers.
  
  Pabbly Form Builder
  Create professional forms for your business with no code builder.
  
  Pabbly Hook
  Webhook event handling for scalable applications.
Sign In

Automatically Capture Leads for Your Business

Watch Step By Step Video Tutorial Below

1. Accessing Pabbly Connect for Integration

To start automating your Facebook leads into Google Sheets, you first need to access Pabbly Connect. Open your browser and search for Pabbly Connect. Once on the homepage, you will see two options: Sign In and Sign Up Free.

If you are a new user, click on Sign Up Free to get 100 free tasks every month. Existing users can simply sign in. After signing in, you will have access to all the applications of Pabbly Connect.

2. Creating a Workflow in Pabbly Connect

After signing in, the next step is to create a workflow using Pabbly Connect. Click on the “Access Now” button to go to the dashboard. Here, you can create a new workflow by selecting “Create Using AI” or “Create from Scratch”. For this tutorial, we will choose “Create Using AI”.

Choose a single line prompt describing the workflow.
Enter the prompt as “When a new lead comes in from Facebook, add it to Google Sheets”.
Proceed with the suggested trigger and action.

After entering the prompt, click on “Continue” to analyze your request. Pabbly Connect will then ask you to select the app for the trigger, which in this case is Facebook Lead Ads.

3. Setting the Trigger in Pabbly Connect

In this step, you will set the trigger for your workflow using Pabbly Connect. Select “New Lead Instant” as the trigger event. You will then need to select your Facebook account and give access to Pabbly Connect to manage your leads.

Once connected, you will be prompted to choose the Facebook page and the lead form. Ensure you select the correct page and form from the dropdown menus. After confirming your selections, click on “Continue” to proceed with testing the trigger.

4. Testing the Trigger with Pabbly Connect

Testing the trigger is crucial to ensure that Pabbly Connect is correctly capturing leads from Facebook. To do this, you will need to generate a test lead using the Facebook Lead Ads testing tool. Navigate to your Meta Business Suite and select the lead testing tool.

Select your Facebook page and the lead form.
Create a new lead by entering dummy details.

After submitting the test lead, return to Pabbly Connect and check if the lead details are captured successfully. If successful, you will see the lead details displayed in the response section.

5. Adding Leads to Google Sheets with Pabbly Connect

The final step is to add the captured lead details into Google Sheets using Pabbly Connect. Click on the Google Sheets app and select “Add a New Row” as the action event. You will need to sign in with your Google account and provide access to Pabbly Connect.

Once connected, select the spreadsheet and sheet where you want to add the lead details. Map the fields from the Facebook lead to the corresponding columns in Google Sheets. After mapping, click on “Save & Send Test Request” to ensure everything is working correctly.

Conclusion

In this tutorial, we successfully demonstrated how to automate the process of capturing Facebook leads into Google Sheets using Pabbly Connect. By following these steps, you can streamline your lead management process and enhance your business operations.