Combining Row Text for AI Summarization in Clay | Clay

Combining Row Text for AI Summarization in Clay

Is there a way to combine multiple rows of a column into one cell, or into an AI prompt? I have a column that contains text. I want to get AI to summarize all the text in all the columns. Can I do this within Clay or do I need to send all the cell out using HTTP API?

17 comments

Channeled
APP
·
·
We can help you combine multiple rows or summarize text using AI formulas in Clay. Here's how: 1. Add a new "formula" column to your table. 2. Prompt the AI to combine rows or summarize text as needed. 3. The AI will generate the appropriate code for your desired output. This method eliminates the need for manual work or complex formulas. AI formulas can handle tasks like concatenating company names, stringing together job titles, or summarizing content from multiple cells. If you need further assistance, please request human help by clicking on "Talk to a person".
Sources: AI Formulas + Conditional Runs [Clay 101] - Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University
Mike F.
·
·
the problem is all the cells are in different rows, within the same column. Here’s the table: https://app.clay.com/workspaces/283560/workbooks/wb_NgXFjHruwtpZ/tables/t_jbaDVpQUmFVC/views/gv_BN4fNtfE8UsC
Bo (.
·
·
Hey, The best way to handle this is by using a Clay Lookup. If the data is spread across multiple rows within the same column, you can use a lookup to gather all related values into one place. Then, reference that lookup in an AI prompt to summarize everything at once. Let me know if you’d like help setting that up!
Mike F.
·
·
Lookup requires a row value, I want any row that isn’t empty. Is there a way to do that? It should pull in 100+ rows, I’ll be able to put all that into the prompt of an AI enrichment?
LuisArturo
·
·
Hey there Michael thanks for reaching out, can you clarify which columns contain the data you are looking to combine here so that we can take a look at this.
Channeled
APP
·
·
Andrew S.
·
·
Was there an answer to this? I am running a sentiment analysis of reddit and I have a column of sentiment with each row representing a single post. I'd like to then summarize all the sentiment results into a single item. So take text data in a single column but across multiple rows and then run AI against it.
Clay
APP
·
·
Thanks! We've reopened this thread. You can continue to add more detail directly in this thread.
LuisArturo
·
·
Andrew- Do you mind sending the link (url) to the table so we can take a look?
(52 kB)
Andrew S.
·
·
https://app.clay.com/workspaces/288374/workbooks/wb_ERtArDFuSR77/tables/t_Wo3DNY9kKdr8/views/gv_yiMVVADzsbSP
LuisArturo
·
·
Thank you just clarify here, you want a single to take the value form the sentiment column and summarizes the values for each row or to have the column take the sentiment across the entire column
Andrew S.
·
·
LuisArturo The second, take the sentiment across the entire column
Clay
APP
·
·
Hey! Thanks for waiting patiently while I figured this out. Created a loom for you outlining my thought process and recommended solution. Do let me know if I have misunderstood or if there is anything else that I can help you with! :)
Andrew S.
·
·
Thank you, I'll check it out
Andrew S.
·
·
Yes, that looks like it will work for me, thank you
Clay
APP
·
·
Hey Michael! Glad it is working for you! Going to go ahead and close out this ticket now.
Channeled
APP
·
·