Clay Icon
  • Avatar of Muhammad S.
    Muhammad S.
    Β·
    Β·

    you can use lookup multiple people enrichment in the same table, lookup by domain, then have chatgpt select the top 5 titles from the whole list of titles from each domain and push gpt response to new table.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·

    To accomplish this, you can use the "Lookup Multiple Rows in other Table" feature in Clay. Here's a step-by-step approach: 1. Use the "Lookup Multiple Rows" feature to search for people in your table based on company domains. 2. Set up a column to count the number of prospects from each company using the same "Lookup Multiple Rows" integration. 3. Use a formula to extract and list the top 5 titles for each domain. 4. Finally, use the "write to table" feature to push the results to a new table. For the ChatGPT part, you'd need to set up an integration with an external AI service, as Clay doesn't have built-in AI for title selection. Consider using Clay's API to export data, process it with an external AI service, and then import the results back into Clay.

  • Avatar of Channeled
    Channeled
    APP
    Β·
    Β·