Google Sheets

Works with Google Sheets (API v4): append rows, read a range (as objects via the header row), update or clear a range, create a spreadsheet, or add a sheet. Uses a Google OAuth2 credential's access token.

Finding it in the library

Search the builder's node library for Google Sheets (it lives under Storage). A single click opens the in-editor docs panel shown here — description, ports, and every property, without leaving the canvas. Double-click (or drag) to add it to the workflow.

Library capture pending — regenerate with npm run shots:nodes.

Wired up in the builder

Google Sheets in a real, runnable flow — captured live from the Studio editor, exactly as it looks on your canvas. This is the same workflow used for the example input & output below.

Canvas capture pending — regenerate with npm run shots:nodes.

How it’s configured

The node’s Configure panel as it opens in the builder when you select the step — every setting laid out with real values. Click any field to edit it.

Config capture pending — regenerate with npm run shots:nodes. See the full property reference below.

Ports

Ports are the node’s contract with its neighbours. In the editor a port label renders bold when wired and italic when optional; ◈ ports accept attachment carriers rather than data wires.

How data flows through it

Google Sheets consumes the content of the incoming envelope — when it is fed directly by a trigger, the trigger’s wrapper is unwrapped at the node boundary so the node sees the actual data, not the metadata shell. Its output becomes the payload for the next node, while the envelope (trace ids, correlation, binary refs) rides along untouched. In the Runs view you always see the whole envelope for both sides of this node.

Expressions in the config

String-typed properties accept {{ }} expressions evaluated against the incoming item at run time — e.g. {{ $json.customer.email }}. On this node that’s accessToken, spreadsheetId, range, title, sheetTitle, baseUrl. JSON- and code-typed fields never interpolate — they are passed through literally.

Build it with AI

Every node in this reference is reachable through Flowdrome’s AI Copilot and the MCP tools — say what you want, and the graph surgery happens server-side. Node types resolve fuzzily, so the catalog label (Google Sheets) works as well as the exact type id (storage.google-sheets).

In the Copilot panel (or any connected AI):

add a google sheets node after the trigger

As a step in a create_chain_workflow call:

{"type":"Google Sheets","config":{}}

curl -s -X POST http://localhost:48170/mcp -H "content-type: application/json" -d '{ "jsonrpc": "2.0", "id": "1", "method": "tools/call", "params": { "name": "add_node", "arguments": { "workflowId": "<id>", "type": "Google Sheets" } } }'

Example input & output

Captured from a real test run of the workflow above — this is what you see in the run data panel after pressing Test workflow.

{
  "kind": "json",
  "contentType": "application/json",
  "payload": {},
  "body": {}
}

{
  "spreadsheetId": "S1",
  "updatedRange": "Sheet1!A1:B1",
  "updatedRows": 1,
  "updatedColumns": 0,
  "updatedCells": 0
}

Property reference

Every setting, with its type and default — the same fields shown configured in the panel above.

Using it

Append order rows (the shipped demo)

Set Operation to append, paste the Spreadsheet id, and point Range at the target tab (Orders!A:D). Then choose where the rows come from: set Values path to a field on the input (e.g. orders) and each object in that list appends as one row — keys map to columns in order. With input like

{ "orders": [ { "id": 1, "customer": "Smith, John", "total": 149.95 } ] }

one row lands per order object. (No values path? Type rows directly into the Values JSON field — a list of lists, one inner list per row.)

For auth, pick your Google credential in the node’s credential picker — the token field then carries ${credential.google-oauth2.accessToken}, a vault reference that is resolved at run start and refreshed automatically when near expiry.

Read a range into items

read with a bounded range (Orders!A1:D50) emits the cell grid; clear empties a range.

Tips

• OAuth client setup is the hard part — redirect URI, enabled APIs, test users and the 7-day testing caveat are walked through in the Google Sheets guide and the credentials guide.
• USER_ENTERED lets Sheets parse "149.95" and "2026-06-12" the way typing would; RAW stores exactly the strings you send.
• The spreadsheet id is the long path segment of the sheet’s URL (docs.google.com/spreadsheets/d/<THIS>/edit).
• Token refresh is automatic: the vault refreshes the access token whenever a run resolves a near-expiry credential — deployed apps included.

Related nodes

The rest of the Storage group — the same folder you’d scan in the editor’s library.

• Global Key / Value Reads, writes, deletes, and atomically increments shared JSON-compatible runtime values.
• Memory Read/write durable cross-run memory (append/recall/get/set/clear) via the state engine.
• Write File Writes workflow data to a file — pretty JSON, raw text, or decoded base64 bytes — with optional append and par
• SQL Query Runs a SQL query against PostgreSQL or MySQL with real server-side positional parameters ($1…$n / ?) — no stri
• S3 Storage Reads and writes objects in S3-compatible storage (AWS S3, MinIO, R2) with Signature V4: put, get, delete, lis
• Redis Talks to a Redis server over the dependency-free RESP2 wire client: get/set/del/incr/expire, list push/pop, ha
• FTP Lists, downloads, uploads, deletes, or creates directories on an FTP server (optional explicit FTPS via AUTH T
• MongoDB Runs one MongoDB operation over the dependency-free OP_MSG wire client: find, insert many, update many, delete

This page is generated from the node registry by gen-node-docs.mjs on every site build — ports, properties, defaults and visibility rules cannot drift from the code. The screenshots and example data are captured from a live Flowdrome by npm run shots:nodes and npm run gen:examples. The hand-authored notes above are merged in.