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

Sheets signs in with a Google account you connect to Flomation — there is no API key or secret to paste. Connect the account once and every Sheets node picks it up automatically. Two optional fields let you steer it:

02Append

Append to Sheet

google/sheets/append · Action

Append rows to a Google Sheet

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

Returns: tool_result, cleared_range, success, error

04Create

Create Spreadsheet

google/sheets/create · Action

Create a new Google Sheets spreadsheet

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

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

Returns: tool_result, success, error

06Get

Get Sheet Metadata

google/sheets/get_metadata · Action

Get metadata for a Google Sheets spreadsheet

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

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

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

09Notes & Limitations

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

• Append to Sheet locates the first empty row beneath the existing block of data in the range you point it at and adds rows there, so it never overwrites existing content, whereas Write to Sheet overwrites whatever currently sits at the range you name.
• Value Input Option set to User Entered (the default) makes Google parse each value as though it were typed into the cell, so a leading = becomes a live formula and date-like text or long all-digit reference numbers can be converted. Flomation automatically protects phone- and ID-shaped values (a digit run with a leading zero, or a leading +) so they land as text; choose Raw to store every value exactly as supplied.
• Read Sheet returns only the populated region of the requested range, trimming trailing empty rows and cells, so rows can come back with different lengths (or fewer rows than requested) and downstream steps should not assume a fixed column count.
• Clear Sheet Range removes cell values only; formatting, conditional rules, data validation and the rows themselves remain in place, so it is not a substitute for deleting rows.
• Delete Sheet Tab requires the tab's numeric Sheet ID rather than its name, which you can get from Get Sheet Metadata. Deletion is permanent and the node makes no checks of its own — it forwards the request to Google, so if Google refuses (for example because it is the only tab left in the spreadsheet) the node fails and reports Google's error.
• Append to Sheet takes a whole 2D array of rows, so collect your rows and append them in one call rather than looping one Append per row — fewer calls means less chance of tripping Google's rate limits, which matters because a rate-limited call is not retried: the node simply fails with Google's error.