Peter Sabapathy

I was wondering if anyone has done this before. I have an excel table of reference companies from a client. I am using an agent to quickly scan the list and identify 1-2 companies that align with the target. For smaller lists i am using columns in clay just set to text with the industry and references. But for bigger lists this becomes an issue and if i have more than one industry classification it wont format correctly in the text field. I am sure there is a more elegant way to do this? reference an external sheet or sheet within the clay table prefereably?

Hey All, looking for some inspiration and advice. I am working with a group of IT partners and building out clay tables for each of them based on their stack and workloads etc. I would like to create a custom agent for each that captures their expertise and products they specialize in along with some reference clients etc. Wondering what the best way would be to create custom agents for them to use in prompts for research and creating content for campaigns and outreach. I dont think a custom system prompt will work for all the clay prompts or agents but not 100% sure. If anyone has done something similar or if should be doing this in n8n and feeding n8n with clay, i can look at that too. I do have a lot of n8n stuff running for them too.

would anyone have an easy way to count all the unique entries in a column for an entire sheet. So if i have a table of linkedin posts, i am trying to count the posts from the 5 different companies I am tracking. I think a formula should be able to do it but not sure where to set the formula up so it runs for the entrie column and not just each row