Cross Referencing Companies with Product Catalog CSV for Insights

Andi D. · 2025-10-29 18:56:20.406819+00

Hey team I have a big product catalog CSV file with product records, what’s the best way to cross reference a list of companies against my file and output competing products?

Cross Referencing Companies with Product Catalog CSV for Insights | Clay

8 comments

· Sorted by Oldest

Clay Support
APP
·
·
Import your product catalog CSV into Clay first. [1] Then create a companies table and use Lookup Rows to cross-reference companies against your product data by matching fields like company name or domain. [2]
For competing products output, use write to table to map matching results to a new table where each row shows company-product relationships. [3]
The workflow: CSV import → company lookup → write to table for organized output.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you need any more help with cross-referencing your product catalog or setting up the output, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific challenges you’re facing?
Andi D.
·
·
No. Won’t be able to do name look up. It has to be AI based matching. When given a list of companies, I want Claygent or somehow analyze the company and cross reference the catalog and find the top competing products
Clay Support
APP
·
·
I understand this is important to you, so I’m routing you to one of our human agents who can assist with AI-based matching and competing product analysis.
Intercom
APP
·
·
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Loading attachments
Mitch H.
·
·
Hey Andi, in this case what I recommend is creating a claygent column that searches the web for similar/competing products and returns them to your table. This is really what Claygent is for, let me know if you have any specific questions.
Clay Support
APP
·
·
We haven't heard back from you here, so we're going to go ahead and close this thread out.
Still need help here? Reply back and someone will jump back in.
Have a question thats not related to this thread? We recommend kicking off a new ticket in the support channel!

Clay Support
APP
·
·
Import your product catalog CSV into Clay first. [1] Then create a companies table and use Lookup Rows to cross-reference companies against your product data by matching fields like company name or domain. [2]
For competing products output, use write to table to map matching results to a new table where each row shows company-product relationships. [3]
The workflow: CSV import → company lookup → write to table for organized output.
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you need any more help with cross-referencing your product catalog or setting up the output, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific challenges you’re facing?
Andi D.
·
·
No. Won’t be able to do name look up. It has to be AI based matching. When given a list of companies, I want Claygent or somehow analyze the company and cross reference the catalog and find the top competing products
Clay Support
APP
·
·
I understand this is important to you, so I’m routing you to one of our human agents who can assist with AI-based matching and competing product analysis.
Intercom
APP
·
·
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Loading attachments
Mitch H.
·
·
Hey Andi, in this case what I recommend is creating a claygent column that searches the web for similar/competing products and returns them to your table. This is really what Claygent is for, let me know if you have any specific questions.
Clay Support
APP
·
·
We haven't heard back from you here, so we're going to go ahead and close this thread out.
Still need help here? Reply back and someone will jump back in.
Have a question thats not related to this thread? We recommend kicking off a new ticket in the support channel!