Skip to main content
Use Data Transform when you need to reshape existing workflow output before another step reads it. Data Transform does not call an external service. It is useful after Extract from File, before Google Sheets, Airtable, Custom API, and follow-up Iteration steps.

​
Configuration

Add this step from the Utilities group in Search steps….

​
Modes

​
Build Rows

Use Build Rows to zip arrays by index into an array of objects. Each field has a Key and a Source Value. The key becomes an object property. The source can be a whole variable reference such as {{tool_names}} or {{step_3.output}}, or a static value. Array source values are read by index. Static scalar values repeat for every row. Example:
Build Rows fields:
Output:
Use Mismatch Policy when array lengths differ:

​
Concat Arrays

Use Concat Arrays to append multiple arrays into one longer array. Each source must resolve to an array. If a source resolves to a string, object, number, or boolean, the step fails. Example sources:
If those values are ["a", "b"] and ["c"], the output is:

​
Flatten Array

Use Flatten Array to flatten one array by one level. Nested array elements expand. Non-array elements stay in place. Example source:
Output:

​
Objects to Grid

Use Objects to Grid when a previous step returns an array of objects and you want to write that dataset into Google Sheets. Set Source Value to the records array, such as {{step_2.output}}. If the previous step wraps rows in a field (for example AI Keyword Data Search), use that field instead, such as {{step_2.output.items}}. Leave Headers blank to use every object key in first-seen order. You can also pass a placeholder that resolves to an array of column names, or a comma-separated list such as keyword, volume, difficulty. Example source:
Output:
Pass those values into a Google Sheets Upsert Rows step:
Missing keys become empty cells. Nested objects or arrays inside a record are passed through as-is; Google Sheets cells work best with simple values such as text and numbers.

​
Output

Data Transform stores its result at:
For Build Rows, the output is an array of objects. This shape works well with integration steps that expect records or rows. For Concat Arrays and Flatten Array, the output is an array that later steps can iterate over. For Objects to Grid, the output is an object with headers and rows. Use it with Google Sheets Upsert Rows.

​
Notes

  • Source values should be whole placeholders such as {{step_2.output}}, or static scalar values.
  • Mixed template strings such as Research for {{tool_names}} are not supported in Data Transform V1.
  • Data Transform preserves arrays and objects as structured JSON for downstream steps.
  • Data Transform is a free utility step.
See also: Google Sheets, Airtable, Custom API, and Testing and Iteration