To resolve the issue of duplicate results in Google Search queries, you can use our Normalize and Deduplicate a List integration. Here's how:
1. After running your Google Search, add the "Normalize and Deduplicate a List" integration.
2. Select the column with your search results as input.
3. This will remove duplicates and standardize the data format.
For more complex deduplication across tables, use the Lookup integration:
** "Lookup Single Row in Other Table" for individual checks
** "Lookup Multiple Rows in Other Table" for bulk verification
These tools will help ensure unique results in your searches.
If you need further assistance, please request human support by clicking on "Talk to a person" in this chat.
Hey Brandon,
To avoid duplicates during the run, try this instead: at the bottom of your table, click “Add”, then type “Google” and select the Google Search option as a source — not as an enrichment. This will pull in results without duplication and is free to use.
I set up an example in your workbook so you can see how it works:
View Example
Let me know if you want help tweaking it!
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.
.png){kind=logo}
