Automating Row Creation from Incoming Data in Zapier/Make Workflow | Clay

Automating Row Creation from Incoming Data in Zapier/Make Workflow

is there a way to automatically create multiple rows based on a list of data that comes into a record? Here is the workflow I'm trying to create. Team member emails a Zapier/Make flow with a request to research, create, and report back with leads. AI agent collects the information and parses the multiple leads into a list. For each item on the list, it is a field that is converted to a record on another table. Each record is then enriched, and the workflow continues from there. Thank you!

9 comments

Channeled
APP
·
·
Yes, you can use our "Write to Table" feature to create multiple rows from a list of data. Here's how it works: 1. First, select your destination table (ideally within your current workbook). 2. Choose the column that contains your list data (for example, a cell containing multiple email addresses). 3. Map the list properties to the columns in your new table.The "Write to Other Table" action supports writing lists, single values, or objects, giving you flexibility in how you transfer data between tables.You can also enable auto-update to automatically process new rows as they're added to your table. Sources: Write to Other Table with Clay Labs Write to Table - Clay University
Stephen S.
·
·
And can you have a claygent output a list with unlimited records?
Channeled
APP
·
·
No, there are specific limits to the number of records that can be output in a search. You can search up to 50,000 records per query. This 50,000 record limit is available on our Enterprise Plan. Sources: Find People overview | Clay University Clay Plan Feature Overviews
Stephen S.
·
·
Could you feed a claygent with an email that contains a list of, say, 200 companies, and have it output the name of each company in a separate field?
Channeled
APP
·
·
Yes, you can process a list of companies in Clay by importing them into a Clay table. Here's how: 1. Take your list of company names and import them into Clay using the CSV import feature. 2. Once imported, each company name will be in its own cell/field in the Clay table, allowing you to work with them individually.From there, you can enrich the data further by finding company domains and running additional searches as needed.
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Stephen S.
·
·
I would like to know if I can provide input to claygent, in one row, unstructured list data which it would then out put each item on the list into a separate field for each item?
Arturo O.
·
·
Hey Stephen, appreciate your patience! Happy to help. To achieve this type of behaviour, you can prompt Claygent to format its response as a JSON array/list output, and then combined with the Write to table integration mentioned above, you can export each item as an individual record to another table to further enrich. Here's a video that may help provide some context on variations of this. Let me know if you have additional questions! https://www.loom.com/share/4b8f10bd04f64c67b6c9011c1babadc0?sid=cc2a954a-dabe-463b-b251-9897a090b4ec
1
Channeled
APP
·
·
Hi Stephen S.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: