Superagento.
All tutorials
Actions · Lesson 16

Transform data

Rename fields for the next action

Live example
English narration · 29 sec

Before you run it

Examples use fictional data. Replace references with fields from your own run.

Read the related guide Open your canvasIncludes a recorded live example using demo data. Configuration close-ups and callouts explain the steps.
English narration generated with Kokoro Heart.

Try it step by step

  1. 1. Transform data

    Reshape API data into the exact columns your spreadsheet expects.

    THE USE CASETransform data

  2. 2. Name your output fields

    Create title, URL, and source fields to match the Research sheet.

    01 / DESTINATION COLUMNStitle · url · source

  3. 3. Map the response

    Map the company name and website from the fetch step. Add a source label so the row keeps its context.

    02 / VALUE REFERENCE{{steps.fetch.body.company.name}}

  4. 4. Check the mapped row

    The live run mapped three fields successfully. The final Google Sheets action wrote those values into the Research tab.

    03 / LIVE RESULTMapped 3 fields
Read the English transcript

Reshape API data into the exact columns your spreadsheet expects.

Create title, URL, and source fields to match the Research sheet.

Map the company name and website from the fetch step. Add a source label so the row keeps its context.

The live run mapped three fields successfully. The final Google Sheets action wrote those values into the Research tab.

Keep learningExpression