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 Store Facebook & Instagram Leads in Google Sheets

Watch Step By Step Video Tutorial Below

1. Setting Up Pabbly Connect for Lead Retrieval

To automatically store Facebook and Instagram leads in Google Sheets, you must first access Pabbly Connect. Start by opening a new tab in your browser and navigating to pabbly.com/connect. Once on the homepage, click on the “Sign Up Free” button in the upper right corner to create your account.

After signing up, log into your Pabbly Connect account and open the workflow builder. Here, you will set up the integration that allows you to capture leads from Facebook Lead Ads or Instagram Lead Ads directly into Google Sheets.

2. Choosing the Trigger Application in Pabbly Connect

In this step, you will select the trigger application for your automation. Click on “Add Trigger” and choose either Facebook Lead Ads or Instagram Lead Ads, depending on where you want to capture leads. The event will be the same for both platforms.

Select Facebook Lead Ads or Instagram Lead Ads as your trigger application.
Click on “Connect” to establish a connection with your selected platform.
Ensure you are logged into your Facebook account to proceed.

Once you are logged in, click “Continue” to link your Facebook Lead Ads or Instagram Lead Ads to Pabbly Connect. After connecting, you will need to select the specific page and form you want to use for lead retrieval.

3. Testing the Webhook in Pabbly Connect

After setting up the trigger, you must test the webhook to ensure it captures leads correctly. In the Pabbly Connect workflow, select the option to send a test lead. This will require you to use the Meta for Developers tool to create a test lead.

Open a new tab and go to Meta for Developers.
Navigate to the “Resources” section and select “Lead Ads Testing Tool”.
Choose the same page and form you selected in Pabbly Connect.

Fill out the test lead form with sample data, then click “Submit”. Pabbly Connect will capture this lead and confirm that the connection is successful, showing you the data received.

4. Adding Data to Google Sheets via Pabbly Connect

Once you have confirmed that leads are being captured correctly, the next step is to add this data to Google Sheets. Click on “Add Action” in your Pabbly Connect workflow and select Google Sheets as the action application.

Choose the event “Add New Row” and click on “Connect”. You will need to log into your Google account to allow Pabbly Connect to access your Google Sheets. After logging in, grant the necessary permissions.

5. Mapping Lead Details to Google Sheets

Now that you have connected Google Sheets, it’s time to map the lead details from Facebook or Instagram to the columns in your spreadsheet. In the mapping section, you will see fields for name, email, phone number, and other details.

Map each lead detail to its corresponding column in Google Sheets. This mapping allows Pabbly Connect to dynamically insert the lead data into the correct fields each time a new lead is captured.

After mapping, save your workflow and test it by sending another test lead. Check your Google Sheets to see if the data appears correctly. This process ensures that every new lead from Facebook or Instagram is automatically stored in Google Sheets without manual entry.

Conclusion

By using Pabbly Connect, you can seamlessly integrate Facebook and Instagram leads into Google Sheets. This automation saves time and reduces errors, allowing for efficient lead management.