fbpx

Learn: How to sync Facebook and Google Leads to a Google Sheet

Do you love managing your Facebook leads and google leads using Google Sheets? You can create real-time lead sync with Google Sheets using Leadzpipe.

The most important step before getting started is to add a welcome email template. Click here to get started.
Follow the below-given steps to set up real-time lead sync for Google Sheets using Leadzpipe-

Step 1:  #

Login / Sign up for Leadzpipe.

Step 2: #

In order to sync leads, you’ll need to create a pipe. Click ‘Create Pipe’ in the top right corner.

Step 3:  #

Click ‘ Facebook Lead Form’ or ‘Web Form’ and then choose ‘google sheets’ from the destination tab.

Step 4:  #

To Sync Website leads using google sheets follow the below steps: #

Step 1:
Enter Your Website Address using the whole website address including https.
Select the scan option and keep the fields you want to record the data and remove the rest.

Step 2:
Select or create a new tag and enter a new pipe name.
If your first field is Email than your first field in the middle section should be Email. If you don’t find a proper match for a field you can create an custom field from the dropdown on the middle section.

Step 3:
Select or Add your Google Account.
You have to manually create a google sheet from https://docs.google.com/spreadsheets/u/0/ and you have to name it with your pipe name. After creating a google sheet you have to name rows in the same pattern the form fields are in. See the image below to understand better.


Select the google sheet name below the select google account option.
Choose action ‘create lead’.
Then you have again map the fields. In the middle section your first field should match the first field in the google sheet section. Example: if you first field is Email than your first field in google sheet section should be Email.

To Sync Facebook leads using google sheets follow the below steps: #

Step 1: 
Select or Add Your Facebook Account.
Choose Your Facebook Page.
Select the Form for which you want to sync leads.

Step 2: 
Create or choose a tag and type a new pipe name.
Map you fields carefully here. for FirstName choose FirstName. 
And if a field does not exist you can choose the custom field option and then type the name of the field you want.

Step 3: 
Select or Add Your Google Account.
You have to manually create a google sheet from https://docs.google.com/spreadsheets/u/0/ and you have to name it with your pipe name. After creating a google sheet you have to name rows in the same pattern the form fields are in.


Select the Sheet inside that spreadsheet.
After that in ‘Choose Action’ choose create lead.
Then you have again map the fields. In the middle section your first field should match the first field in the google sheet section. Example: if you first field is Email than your first field in google sheet section should be Email.

Step 5:  #

Now, in order to check the integration, click ‘Test Connection’

Step 6:  #

Check the test lead data in the Google sheet which you have integrated

Step 7:  #

Go back to Leadzpipe and click ‘Next’

Step 8:   #

Select the lead recipients. Here, you can add multiple email ids to which the leads will be sent in real-time.

Lastly, before you click ‘Finish’ you’ll need to select a welcome e-mail.  #

If you have already created welcome email templates, you can select one from the drop-down menu. After that, all you need to do is click the ‘Finish’ button, and voila! You have created a pipe and all your leads will be synced in real-time and will receive instant welcome e-mails.


We hope that you understood the easy-peasy process of creating a pipe by integrating a Google sheet in Leadzpipe through the steps mentioned above. But still, if you are facing any difficulty in creating it๐Ÿ˜“ Please ping us on the Live Chat or Email us.
We are always happy to help you๐Ÿ˜Š

Powered by BetterDocs