How to Include Results Alongside Steps in Your List Using Columns
The problem is the list is only the steps taken, results are not in the list. I can only create columns?
The problem is the list is only the steps taken, results are not in the list. I can only create columns?
Then you have to convert the results into list
To convert your results into a list format, you have a few options:
In the Cell Details panel:
For comma-separated data:
Use Extract Data From Values to process the data
Add a column using the Forward Slash (/) command
Apply this regex: [^,"]+"?[^,"]+ to split values into a list [3]
Write to Other Table:
You can also use the "Write to Other Table" integration to map list data from your current column into a new table, where each list item becomes its own row [4]
Which approach works best depends on your current data format - can you share what type of results you're seeing in the "Steps Taken" section?
Write to Other Table has been retired
You're right that "Write to Other Table" has been deprecated. Here are your current options for converting the "Steps Taken" results into a list:
Cell Details Panel:
Click into the cell with your "Steps Taken" data
Hover to the right of the data to see actions
Use "Turn items into rows" to move each item into its own row in another table [1]
Send Table Data (New Method):
Use the "Send table data" action from the Actions menu in your table
Select "Send row for each item in a list" to flatten your list data
This creates a new row for each item in your destination table [2]
The "Send table data" action is the new replacement for the deprecated "Write to Other Table" feature . Both methods will help you convert your nested results into a proper list format where each step becomes its own row.
Which approach would work better for your current setup?
That doesn't work. I have 5 columns returning Names 1 and Names 2 with different criteria. I wanted to send the all the data to two acolumns:
For your specific setup with 5 columns containing Names 1 and Names 2 data, here's how to consolidate everything into two columns:
Option 1: Merge Columns First
Click Add column → Merge columns [1]
Create one merged column for all Names 1 data using / to reference each column
Create another merged column for all Names 2 data
Option 2: Send Table Data Method
Option 3: Child Columns from Parent
If your "Steps Taken" is a parent column with nested data:
Click into the cell with your Steps Taken results
In the Cell details panel, hover over each name field
Click Add as column to create individual columns [4]
Then use the merge columns approach above to consolidate
Which method works best depends on your current data structure - are the Names 1 and Names 2 currently in separate columns or nested within the Steps Taken results?
That doesn't work. I have 5 columns returning Names 1 and Names 2 with different criteria. I wanted to send the all the data to two columns in the other table. If I create columns from evey AI response I have loads of columns will be different names. I'll then have to do loads of work changing columns into rows
You can use Send table data with custom mapping to consolidate your 5 columns into just 2 target columns: [1]
Go to Actions → Send table data
Select your destination table
Choose "Send row" method
In the mapping section, you can send nested data from your source columns directly without extracting them as separate columns first
Use the destination column dropdown to rename and map multiple source columns to your 2 target columns (Names 1 and Names 2)
The key is using the nested data sending feature - this lets you avoid creating individual columns for each AI response and instead map directly to your desired structure. You can rename fields in the destination table during the mapping process, so all your Names 1 data goes to one column and all Names 2 data goes to another.
Did that answer your question?
If you still need help with consolidating your data into two columns, I’m here to assist. Would you like to provide more details about your current setup or any specific challenges you’re facing?
I have name 1, name 2, job title 1, job title 2, URL 1, URL 2. How do I merge these and then get them to other table with only columns name, job title, URL?
You'll need to use Send table data with the "Send row for each item in a list" option to flatten your paired data: [1]
Go to Actions → Send table data [2]
Select your destination table
Choose "Send row for each item in a list" - this creates separate rows for each name/title/URL pair
In the mapping section, map your paired columns: • Name 1 + Name 2 → Name column • Job Title 1 + Job Title 2 → Job Title column • URL 1 + URL 2 → URL column
This flattens your data so each person gets their own row instead of being paired in the same row. You can also merge columns first using Add Column → Merge columns if you need to combine the data before sending. [3]
Was that helpful?
Will they maintain the right order?
The documentation doesn't specify how "Send row for each item in a list" handles ordering when flattening data. [1] Since you have paired data (Name 1 with Job Title 1 and URL 1, Name 2 with Job Title 2 and URL 2), maintaining the correct relationships is crucial for your workflow.
Have you tested this with a small sample to see if the pairing stays intact, or would you prefer exploring an alternative approach to ensure the data relationships are preserved?