Skip to main content

Google Sheets Tool

The Google Sheets tool lets your flow read and write spreadsheet data — append a row of captured lead info, read a range of values, update cells, or create a new spreadsheet. It's a simple, reliable way to log data or use a sheet as a lightweight database.

Use it inside an Agent node (the agent decides when to read or write) or as a standalone Tool node for a fixed operation.

Adding it to a flow​

In the Tool node's tool picker, choose Google Sheets, connect your Google account, then pick the operation type and actions.

Setup / credentials​

The tool connects to Google Sheets with Google OAuth.

  1. In the tool, use Connect Credential to add (or select) a Google Sheets OAuth connection.
  2. Approve the Google consent screen so Flowera can read and write your spreadsheets.
info

The connected Google account must have access to the spreadsheet you target. Share the sheet with that account if needed.

Inputs​

ParameterDescriptionRequired
Connect CredentialThe Google account (OAuth) to use.Yes
TypeWhether you're working with the Spreadsheet itself or its Values.Yes
Spreadsheet ActionsFor type Spreadsheet: Create, Get, or Update a spreadsheet.When type is Spreadsheet
Values ActionsFor type Values: Get, Update, Append, Clear, and their batch variants.When type is Values
Spreadsheet IDThe id of the spreadsheet to act on.For most actions
RangeThe cells to read/write, e.g. A1:B2 or Sheet1!A1:C10.For value reads/writes
ValuesJSON array of rows to write, e.g. [["A1","B1"],["A2","B2"]].When writing values
TitleTitle for a new or updated spreadsheet.When creating/updating
note

Additional options (value input/render options, major dimension, insert-data behavior) are available under advanced parameters and control exactly how values are read or written.

Outputs​

The tool returns the result of the action — the values you read, or a confirmation of the write. It's a single-output tool; the flow continues to the next node. Store what you read in flow state.

Example​

Log every new lead to a sheet

  1. Add a Tool node with Google Sheets, type Values, action Append Values.
  2. Set the Spreadsheet ID and a Range like Leads!A:C.
  3. Map Values to a row built from the collected name, email, and phone.

Each time the flow reaches this node, a new row is appended with the customer's details.

Tips​

  • Use Append to add rows without overwriting existing data; use Update to change a specific range.
  • Qualify the range with the sheet name (e.g. Leads!A:C) when the spreadsheet has multiple tabs.
  • Share the sheet with the connected Google account, or reads and writes will fail with a permission error.
  • Values are a 2-D array — each inner array is one row.