Documentation
  1. Integrate Google Sheets with LeadsBridge

Integrate Google Sheets with LeadsBridge

Google Sheets is the largest spreadsheets online editor that can also read Excel and CSV files and

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

  1. Head over to the left sidebar and click on Integrations
  2. Click on the Add New button
  3. Enter a recognizable name for your integration
  4. Click on the Browse button
  5. Select "Google Sheets" from the providers list
  6. Click on the Next button
  7. Enter the Sheet Id to connect Google Sheets with LeadsBridge
  8. (Optional) Enter the ID of the Sheet if you would use a specific sheet.
  9. Click on the Authorize button
  10. A Google Sheets's wizard will popup
  11. Enter your credentials and grant the access to LeadsBridge
  12. Head back to LeadsBridge and click on the Finish button

Which entity concepts we support for Google Sheets

  1. 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.

  1. 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 the "Sheet Id" is useful?

Currently, the Google Sheet integration expects to collect a maximum of 500 Sheets per Account, so if your Account contains more than 500 Sheets it is possible that your Sheet is not displayed in the selection list in the Bridge configuration.
In this case, thanks to this field, you will be able to indicate the exact ID of the Sheet to be used.

Related Articles

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!