Row per order — Google Sheets

SETUP: add a “google-oauth2” credential in Admin → Credentials, then Test sends for real — the node is pre-wired with ${credential.…} references. Until then this demo saves and verifies but the send will report the missing credential. Appends each order as a row in the tracking spreadsheet.

What’s inside

3 nodes — every type links to its full reference page.

Step	Node	Type
Placed order	Inject	`input.inject`
Append order row	Google Sheets	`storage.google-sheets`
Tracked	Console	`utility.console`

Import it

Studio → Import — paste the JSON below (or the URL /docs/templates/row-per-order-google-sheets.json).

Or ask the AI Copilot with the JSON pasted after the phrase:

import this workflow json into a new workflow named "Row per order — Google Sheets"

Any credentials the nodes need are ${credential.…} references — add them once in Admin → Credentials and the template picks them up. Nothing secret ships in a template.

The workflow document (flowdrome.workflow.v1, 3 node types)

{
  "schemaVersion": "flowdrome.workflow.v1",
  "id": "",
  "name": "Row per order — Google Sheets",
  "version": "0",
  "status": "draft",
  "nodes": [
    {
      "id": "seed",
      "type": "input.inject",
      "label": "Placed order",
      "category": "trigger",
      "config": {
        "contentType": "application/json",
        "payload": {
          "orderId": "A-1002",
          "customer": "Globex",
          "total": 249
        }
      },
      "position": {
        "x": 0,
        "y": 0
      }
    },
    {
      "id": "row",
      "type": "storage.google-sheets",
      "label": "Append order row",
      "category": "io",
      "config": {
        "credentialId": "",
        "accessToken": "${credential.google.accessToken}",
        "operation": "append",
        "spreadsheetId": "YOUR_SHEET_ID",
        "range": "Orders!A1",
        "values": [],
        "valuesPath": "",
        "valueInputOption": "USER_ENTERED",
        "insertDataOption": "INSERT_ROWS",
        "baseUrl": "",
        "timeoutMs": 15000
      },
      "position": {
        "x": 530,
        "y": 0
      }
    },
    {
      "id": "out",
      "type": "utility.console",
      "label": "Tracked",
      "category": "utility",
      "config": {
        "message": "row appended for {{ $json.orderId }}"
      },
      "position": {
        "x": 1060,
        "y": 0
      }
    }
  ],
  "edges": [
    {
      "id": "e0",
      "sourceNodeId": "seed",
      "sourcePort": "output",
      "targetNodeId": "row",
      "targetPort": "input"
    },
    {
      "id": "e1",
      "sourceNodeId": "row",
      "sourcePort": "output",
      "targetNodeId": "out",
      "targetPort": "input"
    }
  ],
  "triggers": [
    {
      "id": "t0",
      "nodeId": "seed"
    }
  ],
  "meta": {
    "snippets": [],
    "source": "template-gallery",
    "description": "SETUP: add a “google-oauth2” credential in Admin → Credentials, then Test sends for real — the node is pre-wired with ${credential.…} references. Until then this demo saves and verifies but the send will report the missing credential. Appends each order as a row in the tracking spreadsheet."
  }
}

Generated from the verified demo corpus — this exact document seeds and runs on a fresh Flowdrome. Raw JSON: row-per-order-google-sheets.json.