Avoiding Duplicate Companies with Google Maps API in CRM

I am using the google maps api to search for companies and then add them to a table. I already have a lot of companies in this region and have their domains and other data points. These companies are already in my CRM. How can i avoid pulling duplicated or existing companies that i already have? I have been running into issues with de-dupe and other methods.

7 comments

Channeled
APP
·
·
To avoid pulling duplicate or existing companies that are already in your CRM when using the Google Maps API, you can use Clay's "write to table" feature to import your existing CRM contacts first. Here's a simplified approach: 1. Import your CRM contacts into Clay. 2. Use the "write to table" feature to create a table with your existing company data. 3. When searching for new companies using the Google Maps API, cross-reference the results with your imported data. 4. Only add companies to your table that don't match the existing entries. This method allows you to maintain a clean, deduplicated list of companies by leveraging your existing CRM data as a reference point. Can you provide more details about the specific de-duplication methods you've tried so far?
Source: Claybooks: Find lookalike companies from CRM contacts | Clay.com
Max
·
·
I have tried putting the domains of all the contacts in my CRM into the domain column, that way when the new domains get added it will detect as a duplicate and not add the one from google
Channeled
APP
·
·
To effectively avoid pulling duplicate companies, you can use our "write to table" feature and implement a more comprehensive de-duplication process: 1. Import your CRM contacts into Clay. 2. Use the "write to table" feature to create a table with your existing company data. 3. When searching with the Google Maps API, cross-reference results using multiple fields: • Domain • Company name • Address • Phone number 4. Use an AI formula to compare email domains of existing contacts with the domains of companies you're enriching. This multi-field approach will help catch duplicates that might slip through when only using the domain column.
Sources: Claybooks: Find lookalike companies from CRM contacts | Clay.com Push Data To Your CRM [Clay 101] - Clay University
Max
·
·
So to be clear, if i follow the above method, When i do a google search using the api map tool. It will not include any exisiting companies i already wrote to a table
Channeled
APP
·
·
The Google Maps API search itself won't automatically exclude existing companies you've written to a table. However, you can use our "write to table" feature to create a process that effectively filters out duplicates: 1. Import your existing companies into a Clay table. 2. When using the Google Maps API to search for businesses, you'll get results as usual. 3. After getting the results, you can cross-reference them against your existing table. 4. Only add new, non-duplicate companies to your final list. This approach allows you to maintain a clean, deduplicated list by leveraging your existing data as a reference point.
Sources: Turn Google Maps listings into a target account list with contacts and emails | Clay Find Businesses using Google Maps with Google
Channeled
APP
·
·
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.