Integrate Google Sheets with LeadsBridge

Google Sheets is the largest spreadsheets online editor that can also read Excel and CSV files and makes your data pop with colorful charts and graphs. Built-in formulas, pivot tables, and conditional formatting options save time and simplify common spreadsheet tasks. All for free. It's commonly used by agencies and startups to share data across the team.

In this article, you'll learn how to connect your LeadsBridge account with Google Sheets.

Connect Google Sheets integration

Head over to the left sidebar and click on Integrations
Click on the Add New button
Enter a recognizable name for your integration
Click on the Browse button
Select "Google Sheets" from the providers list
Click on the Next button
Enter the Domain, Sheet Id and Collect only last N rows to connect Google Sheets with LeadsBridge
(Optional) Enter the Sheet Id of your spreadsheet if you need to use a specific one
(Optional) Enabling More Settings? it is possible to insert the value for the field Collect only last N rows which allow collecting only the last N rows of the Sheet. This option is useful with very large Sheets because due to some API limits, the integration can't retrieve all the data.
Click on the Authorize button
A Google Sheets's wizard will popup
Enter your credentials and grant the access to LeadsBridge
Head back to LeadsBridge and click on the Finish button

Which entity concepts we support for Google Sheets

Lead
A lead is a potential client that has shown interest in your listings.

Which segmentation concepts we support for Google Sheets

With LeadsBridge you may use these segmentation concept for Google Sheets.

Sheet
A sheet is a Web-based application that allows users to create, update and modify spreadsheets and share the data live online. The sheet can also be saved as HTML.

Common questions for Google Sheets

How does LeadsBridge recognize emails on a sheet?

LeadsBridge automatically finds the email column that is used to check for duplicates or to retrieve emails that can be used as the source in the Custom Audience feature.

Why do I see "#ERROR" under the phone number column inside my sheet?

You are seeing this error on your Google Sheet because the phone number is passed with a "+" before the value and Google recognize it as the SUM operation. Typically this "+" character is used to identify the international format prefix and is automatically added by your lead generation tool to any phone number.

You may fix it very quickly by editing the phone column on your sheet, please follow these steps:

Head to your Google Sheet
Select the whole column (1-click on the column letter)
Click on "Format" » "Number" on the top menu
Select "Text" instead of "Number"

What is the "Allow Duplicates?" toogle?

With this toggle you may choose if you want to allow duplicates or not inside your sheet.
When "No" is checked, LeadsBridge will search if the email address already exists in one of your rows and then will try to update it. If no row is found, a new one will be created.
If "Yes" is checked, the lead will be added each time as a different row, without checking if the email already exists on the spreadsheet.

Google Sheet Tips

Do not change the order of the columns in your spreadsheet, especially when the bridge has already recognized the fields. This can cause errors with how you'll receive the leads' information on your Google Spreadsheet.

When should I use the Sheet Id field?

Currently, Google Sheets Integration expects to collect a maximum of 500 spreadsheets per Google account, so if your account contains more than 500 spreadsheets it’s possible that your spreadsheet is not displayed in the selection list from the Bridge configuration.
If this is your case, thanks to the Sheet Id field, you will be able to indicate the exact ID of the spreadsheet you want to use.

If you have any further questions regarding this matter, or if you need help to set up the connection between Google Sheets with LeadsBridge, do not hesitate to get in touch!

How to connect Google Sheets with LeadsBridge