Skip to the operations

Reference data

Google Sheets in a decision flow.

5 Google Sheets operations a decision flow can call directly, with the credentials your own contract issued. The response is data the rest of the flow reads, branches on, and keeps in the trace.

Category
Reference data
Type
Integration
Authentication
Google service account
Test environment
Production host only

Who they are

Google's spreadsheet, and the API that reads one.

Google Sheets is the spreadsheet in Google Workspace, and its API lets a program read and write the cells of a document a person is editing at the same time. That combination is why it turns up in automation tools: it is the database non-developers already know how to maintain. Access to a private sheet needs a Google identity, not an API key.

What a flow can call

5 operations, each one a step you can place on the canvas.

  1. GET/v4/spreadsheets/$data.spreadsheet_id/values/$data.sheet_range

    Read a range

    Reads one A1 range, for example "Rates!A2:D200".

  2. GET/v4/spreadsheets/$data.spreadsheet_id/values:batchGet?ranges=$data.sheet_range&ranges=$data.sheet_range_2

    Read several ranges at once

    One call for several ranges, which is the right shape when a flow needs a rate card and a cut-off table from the same workbook.

  3. GET/v4/spreadsheets/$data.spreadsheet_id

    Read the workbook's structure

    Tab names, sizes and properties without any cell data.

  4. POST/v4/spreadsheets/$data.spreadsheet_id/values/$data.sheet_range:append?valueInputOption=RAW&insertDataOption=INSERT_ROWS

    Append a row

    Adds a row after the last one with data in the range.

  5. PUT/v4/spreadsheets/$data.spreadsheet_id/values/$data.sheet_range?valueInputOption=RAW

    Overwrite a range

    Replaces the cells in a range. Narrower than it looks and easy to get wrong: the range is overwritten whether or not the values array fills it, so a shorter array leaves the old cells behind rather than clearing them.

Where it sits in the decision

Reference data calls have a natural place in a flow.

Some of a policy is numbers rather than logic — a rate card, a regional cut-off, a list of blocked employers — and the person who owns those numbers is rarely the person who edits the flow. Reading them at decision time keeps the two jobs apart, at the cost of a network call on a path that would otherwise never leave the engine, so the response is worth caching.

Whatever Google Sheets returns is part of the run, so it is part of the record. When someone asks months later why an applicant was declined, the answer cites what came back at the time rather than re-fetching from a service whose answer has since changed.

  • 01Add Google Sheets as a connection authenticating with a Google service account.
  • 02Google Sheets has one host for both environments, so guard test runs with your own credentials and limits.
  • 03Place a Connection node and pick an operation — “Read a range” is usually the first one a flow needs.
  • 04Map the response into the fields your rules read, then test the whole path before it carries live traffic.

Common questions

Using Google Sheets in a flow.

How do I connect Google Sheets to a decision flow?

Add Google Sheets as a connection in your workspace authenticating with a Google service account, with the credentials your own contract issued — ArboRule calls the provider as you, and never holds a contract on your behalf. Once the connection exists, any flow in the workspace can place a Connection node and choose one of its operations. The credentials live on the connection, not in the flow, so a policy owner can use Google Sheets in a decision without ever seeing the secret.

Can I test Google Sheets without touching production?

Google Sheets exposes one host for both environments, so there is no separate sandbox to point at. Test runs still execute in Sandbox and are recorded separately in decision history, but the call goes to the same place as production — so guard it with your own test credentials, rate limits, or data.

What can a flow call on Google Sheets?

5 operations, including “Read a range”, “Read several ranges at once”, “Read the workbook's structure”. Each one is a step you place on the canvas and map into the fields your rules read, and most flows start with “Read a range”. The list comes from the same manifest the engine uses to make the call, so this page cannot describe an operation the product does not have.

Where in a decision should Google Sheets be called?

Some of a policy is numbers rather than logic — a rate card, a regional cut-off, a list of blocked employers — and the person who owns those numbers is rarely the person who edits the flow. Reading them at decision time keeps the two jobs apart, at the cost of a network call on a path that would otherwise never leave the engine, so the response is worth caching.

Ready when you are

Wire Google Sheets into a real decision.

Build the flow in Sandbox, connect your account, and watch the decision pull what it needs before it answers.

Read the docs