Clay AI: How to Output Search Results as a List for Table Writing

John T. · 2026-01-07T06:45:57.841Z

can clay output AI search results in a list? So i can write to another table 1 item per list

Clay AI: How to Output Search Results as a List for Table Writing | Clay

10 comments

· Sorted by Oldest

Clay Support
APP
·
·
Yes! Clay can break down lists into individual rows in another table using Write to Other Table. [1]
When you have AI search results in a list format, you can:
1.
Use Write to Other Table and select the column containing your list
2.
Choose "Send row for each item in a list" to map each item individually to rows in your destination table [2]
You can also use Send table data with the same "Send row for each item in a list" option. This flattens your list so each item becomes its own row in the target table.
Clay Support
APP
·
·
Is that what you were looking for?
Muhammad S.
·
·
yes --- at the end of prompt mention how you want the output i.e as json list and then use output schema(generate via prompt) and it will output the list
Clay Support
APP
·
·
Exactly! In your AI prompt, specify you want the output as a JSON list, then use the JSON schema output format in the Use AI enrichment. [1]
For example: "Return this as a JSON list" at the end of your prompt, then select JSON schema as the output format and configure the schema fields. [2]
Once you have the structured JSON output, you can use "Write each item to a new row in another table" to break the list into individual rows. [3]
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you need any more help with setting up your AI search results output or using the Write to Other Table feature, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific challenges you’re facing?
Taimoor A.
·
·
Yes.. when you write the prompt in the end just give the command that give json list so it will give you the response you can easily use as output
Clay Support
APP
·
·
Perfect! Just add "Return this as a JSON list" at the end of your AI prompt, then set the output format to JSON schema in your enrichment settings. [1]
Once you have that structured JSON output, you can use Write to Other Table with "Send row for each item in a list" to break each JSON item into separate rows in your destination table. [2] [3]
This gives you clean, structured data that's easy to work with across tables.
Clay Support
APP
·
·
Was this information useful?
Clay Support
APP
·
·
If you need any further assistance with setting up your AI prompts or using the Write to Other Table feature, I’m here to help. Would you like to share more about what you’re trying to accomplish or any specific issues you’re encountering?

Clay Support
APP
·
·
Yes! Clay can break down lists into individual rows in another table using Write to Other Table. [1]
When you have AI search results in a list format, you can:
1.
Use Write to Other Table and select the column containing your list
2.
Choose "Send row for each item in a list" to map each item individually to rows in your destination table [2]
You can also use Send table data with the same "Send row for each item in a list" option. This flattens your list so each item becomes its own row in the target table.
Clay Support
APP
·
·
Is that what you were looking for?
Muhammad S.
·
·
yes --- at the end of prompt mention how you want the output i.e as json list and then use output schema(generate via prompt) and it will output the list
Clay Support
APP
·
·
Exactly! In your AI prompt, specify you want the output as a JSON list, then use the JSON schema output format in the Use AI enrichment. [1]
For example: "Return this as a JSON list" at the end of your prompt, then select JSON schema as the output format and configure the schema fields. [2]
Once you have the structured JSON output, you can use "Write each item to a new row in another table" to break the list into individual rows. [3]
Clay Support
APP
·
·
Did that answer your question?
Clay Support
APP
·
·
If you need any more help with setting up your AI search results output or using the Write to Other Table feature, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific challenges you’re facing?
Taimoor A.
·
·
Yes.. when you write the prompt in the end just give the command that give json list so it will give you the response you can easily use as output
Clay Support
APP
·
·
Perfect! Just add "Return this as a JSON list" at the end of your AI prompt, then set the output format to JSON schema in your enrichment settings. [1]
Once you have that structured JSON output, you can use Write to Other Table with "Send row for each item in a list" to break each JSON item into separate rows in your destination table. [2] [3]
This gives you clean, structured data that's easy to work with across tables.
Clay Support
APP
·
·
Was this information useful?
Clay Support
APP
·
·
If you need any further assistance with setting up your AI prompts or using the Write to Other Table feature, I’m here to help. Would you like to share more about what you’re trying to accomplish or any specific issues you’re encountering?