Sheets

Google integration · 8 node(s).

00Overview

Google Sheets spreadsheet operations

Every field below is exactly what you see in the Flomation editor. Fields marked ● live picker let you choose from a list pulled live from your account — no IDs to look up.

01Connecting Sheets

Add your credentials as a Flomation environment secret, then pick them in each node. The connection fields are:

Pick an Environment on your flow (Flow Settings → Environment) so the secret resolves. Secret fields never show the value — they reference ${secrets.your_secret}.

02Append

Append to Sheet

google/sheets/append · Action

Append rows to a Google Sheet

Field	Type		Details
Spreadsheet ID	`string`	Required
Sheet/Range	`string`	Required	Sheet1
Rows to append	`rows`	Required	[["Alice",30],["Bob",25]]
Value Input Option	`string`		choices: User Entered (auto-format), Raw (as-is)
Google Account (email)	`string`
Google OAuth Credential	`credential`		${credentials.GOOGLE_DRIVE}

Returns: tool_result, updated_range, updated_rows, success, error

03Clear

Clear Sheet Range

google/sheets/clear · Action

Clear a range of cells in a Google Sheet

Field	Type		Details
Spreadsheet ID	`string`	Required
Range	`string`	Required	Sheet1!A1:D10
Google Account (email)	`string`
Google OAuth Credential	`credential`		${credentials.GOOGLE_DRIVE}

Returns: tool_result, cleared_range, success, error

04Create

Create Spreadsheet

google/sheets/create · Action

Create a new Google Sheets spreadsheet

Field	Type		Details
Title	`string`	Required	My Spreadsheet
Sheet Names (comma-separated)	`string`		Data, Summary
Google Account (email)	`string`
Google OAuth Credential	`credential`		${credentials.GOOGLE_DRIVE}

Returns: tool_result, spreadsheet_id, spreadsheet_url, success, error

Add Sheet Tab

google/sheets/create_sheet · Action

Add a new sheet tab to a Google Sheets spreadsheet

Field	Type		Details
Spreadsheet ID	`string`	Required
Sheet Name	`string`	Required	Data
Google Account (email)	`string`
Google OAuth Credential	`credential`		${credentials.GOOGLE_DRIVE}

Returns: tool_result, sheet_id, success, error

05Delete

Delete Sheet Tab

google/sheets/delete_sheet · Action

Delete a sheet tab from a Google Sheets spreadsheet

Field	Type		Details
Spreadsheet ID	`string`	Required
Sheet ID	`integer`	Required
Google Account (email)	`string`
Google OAuth Credential	`credential`		${credentials.GOOGLE_DRIVE}

Returns: tool_result, success, error

06Get

Get Sheet Metadata

google/sheets/get_metadata · Action

Get metadata for a Google Sheets spreadsheet

Field	Type		Details
Spreadsheet ID	`string`	Required
Google Account (email)	`string`
Google OAuth Credential	`credential`		${credentials.GOOGLE_DRIVE}

Returns: tool_result, title, sheets, sheet_count, spreadsheet, success, error

07Read

Read Sheet

google/sheets/read · Action

Read a range of cells from a Google Sheet

Field	Type		Details
Spreadsheet ID	`string`	Required
Range	`string`	Required	Sheet1!A1:D10
Value Render Option	`string`		choices: Formatted, Unformatted, Formula
Google Account (email)	`string`
Google OAuth Credential	`credential`		${credentials.GOOGLE_DRIVE}

Returns: tool_result, data, rows, columns, success, error

08Write

Write to Sheet

google/sheets/write · Action

Write data to a range in a Google Sheet

Field	Type		Details
Spreadsheet ID	`string`	Required
Range	`string`	Required	Sheet1!A1
Data (JSON 2D array)	`text`	Required	[["Name","Age"],["Alice",30]]
Value Input Option	`string`		choices: User Entered (auto-format), Raw (as-is)
Google Account (email)	`string`
Google OAuth Credential	`credential`		${credentials.GOOGLE_DRIVE}

Returns: tool_result, updated_cells, updated_rows, updated_range, success, error

09Notes & Limitations

Behaviours and constraints worth knowing before you build with these nodes.

Reading a range omits trailing empty cells and rows, so returned rows can vary in length and a sparsely-filled sheet returns fewer rows than the range spans.
Appending rows locates the last row of the nearest existing table and writes after it, so a blank row or gap above your data can cause new rows to land in an unexpected position.
Clearing a range removes only cell values and leaves formatting, data validation, and conditional formatting in place.
Deleting a sheet tab is permanent and cannot remove the last remaining sheet in a spreadsheet.
Referencing a range without a tab name (for example A1:C10) targets the first sheet, which may not be the tab you intend to act on.