Do you want to automatically list your Facebook leads on a Google Sheet & are here looking for a way?
Then you have landed on the right post, in this article, I’m going to walk you through the step by step procedure on, how to add Facebook leads to Google Sheets and automate the tasks within minutes. You must be aware that there is no native integration between these services. So, we’ll be using Pabbly Connect to establish a connection in between for automation.
Pabbly Connect is an integration tool that enables integrating multiple applications to automate manual & repetitive tasks in real-time.
Moreover, this workflow is a one-time setup & after that, the created workflow will take care of the automation. Also, you don’t have to learn programming to use this tool, even a non-technical person can use Pabbly Connect efficiently.
Why Choose This Method Of Integration?
In contrast with other integration services-
- Pabbly Connect does not charge you for its in-built apps like filters, Iterator, Router, Data transformer and more
- Create “Unlimited Workflows” and smoothly define multiple tasks for each action
- As compared to other services which offer 750 tasks at $24.99, Pabbly Connect offers 50000 tasks in the starter plan of $29 itself
- Unlike Zapier, there’s no restriction on features. Get access to advanced features even in the basic plan
- Try before you buy! Before spending your money, you can actually signup & try out the working of Pabbly Connect for FREE
But, before heading straight to the procedure first, let’s get to know a wee bit about the services involved. Facebook Lead ads enable advertisers to gather information from prospects directly from mobile ads. Whereas, Google Sheets is a web-based spreadsheet program.
After setting up this workflow the leads will get listed onto a spreadsheet automatically i.e, Google Sheets whenever there is a new lead entry on Facebook.
Additionally, check out the video tutorial below for this particular integration.
Also, we have added the template for this integration to help you get started immediately. You can simply click on the image given below to start. Moreover, you can visit Marketplace to look for numerous other integrations & apps.
So, buckle up as we’re going to discover the Facebook and Google Sheets integration.
Step 1: Sign up to Pabbly Connect
Begin the procedure of adding Facebook leads by visiting the Pabbly Connect website. There, hit the ‘Sign-Up Free‘ button available. Enter your existing Gmail credentials or simply fill up the registration form to signup.
Step 2: Access Pabbly Connect
After that, click on the ‘Access Now’ button of the software ‘Connect’ (as shown in the above image) amongst the Pabbly applications.
Step 3: Workflow for Facebook and Google Sheets Integration
(a) Start with a New Workflow
Further, start with creating a workflow to add leads on sheet for every new Facebook lead & to do this click the ‘Create Workflow’ button first.
(b) Name the Workflow
Now, name the workflow as per the integration or use-case (for instance: Facebook to Google Sheets etc). Finally, click on the ‘Create’ button available.
Step 4: Setting Trigger for Facebook to Google Sheets Integration
To automatically add leads to your spreadsheet program, you’ll need to set-up a trigger on the new Facebook Lead entry and its respective action to add the lead data on Google Sheets using Pabbly Connect.
(a) Select Application you want to integrate
After naming your workflow, a page will open up carrying the trigger window settings.
Pick the ‘Facebook Lead Ads’ app from the ‘Choose App’ drop-down choices.
(b) Select Event & Connect with Facebook
Select the event as ‘New Lead’ & then click on the ‘Connect with Facebook Lead Ads button.
Step 5: Connecting Facebook Lead Ads to Pabbly Connect
(a) Authorize Facebook Account
In the window that slides in from the right, click on the ‘Connect with Facebook Lead Ads’ button. Then, authorize the Facebook and Pabbly Connect integration by allowing for the requested permissions.
(b) Select Page & Form
Next, select the Facebook page and the Lead Form from which you want to gather the lead data from.
Step 6: Test the Response in Pabbly Connect Dashboard
As we can see, we are done setting up the trigger for Facebook and Google Sheets integration. So, let’s test the Facebook Leads Ads trigger by adding test lead details.
(a) Create Lead
To test the set trigger first, go to your selected lead form on the Facebook Lead Ads group. And add a test lead through the form.
(b) Click on Send Test Request
Now, go back to your Pabbly Connect trigger window and click on the ‘Save & Send Test Request’ button.
When we click on ‘Save & Send Request’, it will start showing data of the recently created lead.
(c) Check & Save the Trigger API Response
Check the lead data in the trigger response window and remember to save this data.
Step 7: Setting Action for Facebook to Google Sheets Integration
Now, as we have gathered all the data to store on Google Sheet from the Facebook lead form. We can proceed to use this data to perform our action. After that, every lead from Facebook will be added automatically to your spreadsheet.
(a) Select Application you want to Integrate
Hit the plus button next to your Facebook Lead Ads trigger.
Select the app to integrate here as ‘Google Sheets’.
(b) Select Event & Connect with Google Sheets
Next, select the event as ‘Add New Row’.
Lastly, click the ‘Connect with Google Sheets’ button.
Step 8: Connecting Google Sheets to Pabbly Connect
Ou next step is to connect Google Sheets with Pabbly Connect. For this first, create a dedicated Google Sheet to add the Facebook Lead Ads data. Then, authorize your Google account to connect.
(a) Authorize Google Sheets Account
An authorization window will open up next. Allow your Google account to connect with Pabbly Connect by giving the required permissions.
(b) Select Spreadsheet, Sheet & Map Fields
Further, select the spreadsheet as well as a sheet in it & map the response values with the sheet heads.
To map a value, click on the menu button (three horizontal lines) next to a field.
After that, find and select the response value from the trigger response.
Similarly, map all the required fields.
(c) Send Test Request
Further, click on the ‘Save & Send Test Request’ button to send a request for a lead entry on Google Sheets.
(d) Check & Save Response
Certainly, you can check the APIs response in the action window. And, if there is some error while sending the data then the window will start showing you the error.
Finally, hit ‘Save’ to save the action API’s response.
Step 9: Check Response in Google Sheets
Also, you can check the lead’s entry on your connected Google Sheet.
To sum up, this was all about ‘How to Add Facebook Leads to Google Sheets’. Consequently, after completing the step by step procedure, you will end up adding Facebook Leads to Google Sheets on every new lead entry automatically.
Meanwhile, automate your tasks on Pabbly Connect for FREE with all its premium features.
Also, comment below your queries and suggestions about this procedure.
You May Also Like to Read:
- How to Send SMS Alert on New Form Submissions
- Zapier Alternatives
- How to Add Google Calendar Event for New Todoist Task
- How to Create Sendlane Subscriber from New Shopify Customer