Superagento.
All tutorials
Workflows · Lesson 01

From leads to next actions

Read three leads from Google Sheets, process each row, and write a useful next action back to the workbook.

Live example
English narration · 87 sec

Before you run it

Recorded live with three fictional leads. Append creates new rows on every run. Check existing results before repeating a test.

Read the related guide Open your canvas Download example workflow Download sample workbook

Import the workbook into Google Sheets. Import the workflow JSON, then choose your own connections and spreadsheet. Review every action before a live test.

Includes 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. A next action for every lead

    A lead list is useful when every row has a next action. Let's turn these three sample leads into an outreach worklist, using a real Google Sheets workflow in Superagento.

    THE USE CASE3 leads → 3 next actions

  2. 2. Read the right rows

    Connect your Google account and choose the Leads tab. Read A one through F four, with a maximum of three rows. Keep the first row as headers, so each lead has named fields like company and email.

    01 / READ SPREADSHEETLeads · A1:F4 · maximum 3 rows

  3. 3. One row, one iteration

    Pass the read step's rows into a Loop. The loop runs the following steps once for each lead. Inside the loop, input refers to the current row, so each company keeps its own contact details.

    02 / LOOP{{steps.read.rows}}

  4. 4. Map a useful next action

    Use Transform to keep the lead ID, company, and email. Build a next action from the lead's interest and contact name. The same mapping now produces a different, useful instruction for every row.

    03 / TRANSFORMPrepare a {{input.interest}} demo

  5. 5. Write it back. Run it live.

    Map those four fields into the Outreach tab, in column order, and choose Append. Run a live test. Here, the execution log confirms three loop iterations and three successful writes. Check these receipts before repeating a run.

    04 / GOOGLE SHEETSRead → Loop → Transform → Append

  6. 6. Three leads. Three next actions.

    Open the destination sheet. All three rows are there, each with its own next action. This pattern works for lead intake, customer onboarding, and internal task lists. Start with a small batch, then extend the workflow.

    THE VERIFIED RESULT9 successful steps · 3.05 seconds
Read the English transcript

A lead list is useful when every row has a next action. Let's turn these three sample leads into an outreach worklist, using a real Google Sheets workflow in Superagento.

Connect your Google account and choose the Leads tab. Read A one through F four, with a maximum of three rows. Keep the first row as headers, so each lead has named fields like company and email.

Pass the read step's rows into a Loop. The loop runs the following steps once for each lead. Inside the loop, input refers to the current row, so each company keeps its own contact details.

Use Transform to keep the lead ID, company, and email. Build a next action from the lead's interest and contact name. The same mapping now produces a different, useful instruction for every row.

Map those four fields into the Outreach tab, in column order, and choose Append. Run a live test. Here, the execution log confirms three loop iterations and three successful writes. Check these receipts before repeating a run.

Open the destination sheet. All three rows are there, each with its own next action. This pattern works for lead intake, customer onboarding, and internal task lists. Start with a small batch, then extend the workflow.

Keep learningAPI research to Google Sheets