- Support
- Integrations
- Sheets
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:
| Field | Type | Details | |
|---|---|---|---|
| Google Account (email) | string | ||
| Google OAuth Credential | credential | ${credentials.GOOGLE_DRIVE} |
Connect the Google account to your Flomation user once — the same grant covers every Google node, so you do not repeat it per flow. The optional Google OAuth Credential field never shows a token: it references a managed credential (e.g. ${credentials.GOOGLE_DRIVE}), not an environment secret. Leave both fields blank and the node just uses your connected account.
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) |
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 |
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 |
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 |
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 |
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 |
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 |
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) |
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.