Hi team, quick question I was using AI to source ICP contacts from a list of companies and I got some details in a cell marked "Response". Each response has 5 -6 stakeholders and I would like to add this data in different columns. How can I do that?
To split stakeholder details from the "Response" cell into separate columns: 1. Click the cell containing the stakeholder list to open Cell details. 2. Hover over each stakeholder (or endpoint) and select Add as column to create a new column for each stakeholder. 3. Alternatively, use the Manage cell data menu to take actions like turning list items into rows or extracting specific values. 4. For more control, add a new column using AI and set up the output fields to map each stakeholder to its own column. If you need further help, you can request human assistance by clicking on "Talk to a person" in this chat.
"Hover over each stakeholder (or endpoint) and select Add as column to create a new column for each stakeholder" - How can I add the five stakeholders Clay sourced as rows? I cannot add them as columns individually as this will take a lot of time.
Alternatively, use the Manage cell data menu to take actions like turning list items into rows or extracting specific values. - I dont see this option
For more control, add a new column using AI and set up the output fields to map each stakeholder to its own column. - How?
To quickly add each stakeholder from the "Response" cell as separate rows, open the Cell details for that cell. Hover to the right of the list and select Turn items into rows—this will move each stakeholder into its own row in another table, which is ideal for handling multiple contacts efficiently. If you want to add them as columns, you can use Add Column using AI: click Add Column > Add Column using AI, describe the information you want to extract (e.g., "extract each stakeholder as its own column"), and follow the prompts to set up the output fields. If you need further help, you can request human assistance by clicking "Talk to a person" in this chat.
Also, I tried using AI using this prompt but it didn't work. Only one stakeholder info is getting populated and the rest are not getting added as individual rows. Generated Prompt: #CONTEXT# You are tasked with extracting structured stakeholder information from a table column that may contain multiple people per cell. #OBJECTIVE# Extract the first name, last name, and LinkedIn URL for each stakeholder listed in the /f_0syo7t6G3ovPwv52mvH column. If multiple stakeholders are present in a single cell, create a separate row for each, retaining the same Company name. #INSTRUCTIONS# 1. For each cell in the /f_0syo7t6G3ovPwv52mvH column, parse and extract the following for every stakeholder mentioned: - First name - Last name - LinkedIn URL (if present) 2. If a cell contains multiple stakeholders, split them and create a new row for each stakeholder, copying the value from the Company name column for each new row. 3. Only use information present in the /f_0syo7t6G3ovPwv52mvH column. Do not infer or fabricate data. 4. Output the results as structured data with columns: Company name, First name, Last name, LinkedIn URL. #EXAMPLES# Example input (/f_0syo7t6G3ovPwv52mvH): "Jane Doe (https://www.linkedin.com/in/janedoe), John Smith (https://www.linkedin.com/in/johnsmith)" Company name: Acme Corp Expected output: | Company name | First name | Last name | LinkedIn URL | |--------------|-----------|-----------|------------------------------------------| | Acme Corp | Jane | Doe | https://www.linkedin.com/in/janedoe | | Acme Corp | John | Smith | https://www.linkedin.com/in/johnsmith |
Hey — looks like you figured it out correctly! Using Write to Other Table is the right approach here to split out multiple stakeholders into individual rows. And yes, when using AI for this, make sure the output is structured as a list of objects in JSON — that’s what allows Clay to split each stakeholder properly into separate rows. Nice work getting it set up! Let me know if you want help refining the schema or any other part.