Streamlining Lookup Processes for Research Tools in Spreadsheets

·Oct 06, 2025 10:27 PM·

Would be cool to be able to loop through a cell and do lookups, with comma separated values... Right now, it seems I have to make individual columns for the tools that I'm researching. So that then I can bring in that data to a content AI column so that I can make messaging. To the clay team, is there a better way to do this?

4 comments

· Sorted by Oldest

Willy H.
·
·
https://app.clay.com/workspaces/155003/workbooks/wb_0t2r4za5CtKmCgTD3JB/tables/t_0t2r70mo8eQkB5tvCUT/views/gv_0t2r70nJwyzWp2h5ZS2
Willy H.
·
·
For context, I have two tables. One table does research on each individual tool, and the second table pulls up my prospective client list, which has intel on the type of cybersecurity tools they use. I then call and do a lookup in the first table to pull up relevant information to craft messaging for an outbound message.
Willy H.
·
·
Sometimes I have many tools that I need to craft into one message. So I would call this a "many-to-one" use case.
Willy H.
·
·
yeah Hari K. -- does this make sense?

Willy H.
·
·
https://app.clay.com/workspaces/155003/workbooks/wb_0t2r4za5CtKmCgTD3JB/tables/t_0t2r70mo8eQkB5tvCUT/views/gv_0t2r70nJwyzWp2h5ZS2
Willy H.
·
·
For context, I have two tables. One table does research on each individual tool, and the second table pulls up my prospective client list, which has intel on the type of cybersecurity tools they use. I then call and do a lookup in the first table to pull up relevant information to craft messaging for an outbound message.
Willy H.
·
·
Sometimes I have many tools that I need to craft into one message. So I would call this a "many-to-one" use case.
Willy H.
·
·
yeah Hari K. -- does this make sense?