Clay Icon

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?

  • Avatar of Channeled
    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".

  • Avatar of Mike F.
    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

  • Avatar of Bo (.
    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!

  • Avatar of Mike F.
    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?

  • Avatar of LuisArturo
    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.

  • Avatar of Channeled
    Channeled
    APP
    ·
    ·