Syncing 10,000 leads/mo? Get a demo
Google Sheets logo
+
Google Customer Match logo

How to connect Google Sheets with Google Customer Match

Connect Google Sheets to Google Customer Match with LeadsBridge

Google Sheets » Google Customer Match

In this article, you'll learn how to set up the bridge and connect Google Sheets to My CRM Example using LeadsBridge.

How to set up your bridge step-by-step tutorial

Before you start

  1. Head over to the left sidebar and click on the Create new Bridge green button
  2. You'll be taken to the first step of the bridge creation

Step 1: Choose the apps you want to connect

  1. Choose Google Sheets as the source for your bridge
  2. Choose Google Customer Match as the destination for your bridge
  3. Click on the Continue button
  4. At this point you can choose a name for your bridge (this will only be visible inside LeadsBridge and you can also edit it later)

Step 2: Configure your Google Sheets with Google Customer Match

Step 2.A: Setup your Google Sheets integration

  1. Click on Connect Google Sheets
  2. Click on Create new integration to connect your Google Sheets (or select an existing one from the dropdown if you already connected it)
  3. A popup wil be opened where you can authorize the Google Sheets integration
  4. Click on Authorize and you will be prompted to the Google Sheets authorization experience
  5. Here you will need to provide the info required and grant access to LeadsBridge
  6. Once done, you will be get back to LeadsBridge application
  7. You can choose a name for this Google Sheets and LeadsBridge integration (you can also edit it later)
  8. Once done, click on Continue button and you will get back to the bridge experience where you could choose additional integration settings
  9. Now that your Google Sheets is connected, you can continue with the set-up of your bridge

Step 2.B: Configuration details for Google Sheets

How to get Domain, Sheet Id, Collect only last N rows

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

How to get Allow Duplicates

Using the Allow Duplicates option, you may choose if you want to send duplicate leads in your Google Sheets when using it as a Destination integration.

If you want to avoid duplicates when sending leads to Google Sheets, you can disable the Allow Duplicates toggle from the Google Sheets integration settings.

Please note that this option works only if there's an Email column inside your Google sheet.

If the Allow Duplicates toggle is enabled, LeadsBridge will search for the exact same email address that already exists in your Google Sheets and then it will update it. If there's no match, a new row will be created.

Step 2.C: Setup your Google Customer Match integration

  1. Click on Create new integration to connect your Ad account (or select an existing one from the dropdown if you already connected it)
  2. You will be prompted to the Ad platform authorization experience. Here you will need to grant LeadsBridge access on click on the Authorize button
  3. Once done, you can choose a name for this Google Customer Match and LeadsBridge integration (you can also edit it later)
  4. Once the authorization pop up is closed, you are ready to select from the dropdown the Ad Account and all the required parameters, including the sync frequencies.
  5. Use Simulation functionality in order to test the source data and receive a report to verify the information processed
  6. Now that your Google Customer Match integration is fully set up too, you can click on the Continue button

Notes for the simulation mode: A published bridge with simulation ON is not sending any data, the simulation has to be switched off to have the audience being created, up and running on the Advertising platform. You can edit it later from inside the bridge if you want to go live and send the data.

Step 3: Fields Mapping

Here you'll be able to map your Google Sheets information with your Google Customer Match fields.

  1. You will have Google Customer Match fields on the left. Match the information you wish to pass align from Google Sheets
  2. Based on Google Customer Match functionality, some fields might be required; if this is the case, you can identify those fields with a * (star), so be sure to map all them
  3. You can also use the functions to customize information like reformatting dates and times or modifying text, phone numbers and so on.
  4. You may leave blank the box of a field's information you don't want to send through. Clicking on the Show unmapped fields button you will have visibility on all the available fields still not mapped

Step 3.A: Leads Filter (Optional)

If you'd like you could add a filter for incoming leads. This filter will sync only leads that meet the configured conditions

  1. Click on the link Add Filter for Incoming Leads on the top left
  2. A popup wil be opened where you can configure the filter
  3. You can define a series of condition to filter the leads. The lead will be synced only when all the conditions will be met
  4. Once finished, click the Save Changes button to switch back to the Fields Mapping to continue with the bridge configuration

Step 4: Save and Publish

  • Click on the Save and publish button

Congratulations! Now your bridge is up and running

 

Common questions for Google Customer Match

What is Customer Match in Google Ads?

Google Customer Match is a powerful feature that allows advertisers to target and retarget customers using online and offline data across various Google properties. By utilizing this feature, you can create user groups that are more likely to convert. 

 

Customer Match allows you to match customers' information with users on Google's platform to determine who can see your ads. These ads can be displayed on Google Search, YouTube, Gmail, and the Google Display Network. 

 

With Google Customer Match, you can reach a wider audience and acquire new customers for your business. Additionally, it ensures that your messages and ads are delivered directly to your audience without being directed to spam folders, providing a better chance of engagement and conversions.

How to use Customer Match in Google Ads?

Google Customer Match in Google Ads allows you to leverage email addresses, physical addresses, and phone numbers of your prospects to create a Customer Match Audience. By uploading these identifiers, you can target your prospects across various Google platforms like Search, Shopping, Gmail, and YouTube. Here are some ways to make the most out of Google Customer Match:

 

  1. Move prospects down the sales funnel: Segment your prospects based on their buying cycle and create tailored advertisements to nurture their interest and guide them toward becoming paying customers.
  2. Convert mid and low-funnel prospects: Use Google Customer Match to help prospects who exhibit high intent but struggle to finalize a purchase. Overcome their decision fatigue and encourage them to convert through targeted ads.
  3. Improve upsell and cross-sell efforts: Extend the use of Customer Match beyond acquiring new customers. Increase conversions and average revenue per customer by encouraging existing customers to make additional purchases or cross-sell complementary products.
  4. Enhance account-based marketing: Take advantage of Customer Match's ability to target prospects based on their email addresses. This makes account-based marketing more efficient and straightforward, allowing you to focus on specific individuals within a particular company or geographic region.

Target users across devices: Unlike remarketing, Google Customer Match enables you to target customers on all devices, including mobile, tablet, and laptop computers. This ensures you don't miss out on users who switch between devices, maximizing your reach and engagement.

How to upload Customer Match lists on Google Ads?

To upload a customer match list in Google Ads, follow these steps:

 

  1. Log in to your Google Ads account.
  2. Click on the "Tools and setting" icon at the top of your screen and select "Shared Library".
  3. Under the Shared Library section, choose "Audience manager".
  4. Select "Segments" from the left menu.
  5. Click on the blue "+" button and choose "Customer list".
  6. On the Customer list screen, give a name to your list and upload your customer data, including emails, phone numbers, and mailing addresses.
  7. Specify the type of customer data you are uploading.
  8. Upload the CSV file and confirm that the data was collected and shared with Google in compliance with their policies.
  9. Choose the membership duration for the list and add any additional details about your segment.
  10. Once you've completed the setup, click on "Upload and create".

 

Please note that it may take up to 48 hours for the list to be uploaded to your audience lists. Once the audience is ready, you can further refine it using the insights tool.

 

Alternatively, you can automate the process by connecting your CRM or autoresponder with Google Customer Match through LeadsBridge.

What is LeadsBridge’s Google Customer Match integration?

The Google Customer Match integration with LeadsBridge is a powerful automation tool that simplifies the process of syncing your CRM or autoresponder with Google Customer Match. It saves you time by eliminating the need for manual email list uploads and ensures higher accuracy in data processing. 

 

With LeadsBridge's Google Customer Match integration, you can effortlessly upload and update your email data in Google Customer Match. This includes adding new subscribers, deleting unsubscribed leads, and removing unsegmented users. This integration allows you to efficiently follow up and nurture your leads as they come in. 

 

LeadsBridge, as a Google Premier Marketing Partner, helps streamline advertising processes by automating Google Marketing tools with your marketing stack. By utilizing these integrations, you can automatically track lead data, optimize campaigns in real-time, and achieve a higher return on investment without any manual effort.

How to create a new Google Ads account through LeadsBridge and get a $500 Google ad credit

To get a $500 Google ad credit by creating your Google Ads account through LeadsBridge, follow these steps:

 

  1. Log in to your LeadsBridge account or create one for free, if you don't have one yet.
  2. Click on "Google Suite" in the left-side panel. Select "Google Ads Accounts" from the drop-down menu.
  3. Find and click on "Create new ads account".
  4. Complete the Google Ads account creation process:

Create: Fill in your information, Google account (email), timezone, and currency, then click "Continue".

Activate: Fill in your billing information, including name, personal and billing address, and payment method. Once verified, proceed to the next step.

Connect: Set your Customer Match Audience and start your Lead Gen Campaigns using the "Try now" buttons.

 

Check out how the credit works:

 

This offer is only available to new Google advertisers. You must spend at least $500 on Google Ads campaigns within the first 60 days to activate the offer. Once you reach $500 in ad spend, you will receive a $500 Google Ads credit to use on your campaigns (USD or equivalent currency). 

 

The credit is valid until the end of the year and becomes spendable 31 days after being issued. The promotion will be automatically applied to your Google Ads account (Tools → Billing → Promotions).

Do you need help?

Here some additional resources:

RELATED ARTICLES FROM OUR BLOG

Create your new Google Ads account via LeadsBridge and access a very special offer

Google Customer Match: a complete guide (with case studies)

The ultimate guide to the best Google Ads – CRM integrations