Google Sheets is a spreadsheet service used to store tabular data, collaborate on workbooks, calculate values, and organize ranges, sheets, and shared spreadsheet files.
The Flowgear Google Sheets Node lets a Workflow discover accessible spreadsheets, read workbook metadata, read cell values, update ranges, and append rows by using a Google service account, which makes it useful for spreadsheet-driven integrations and lightweight operational data flows.
0.1.1.0 - Added detached request snapshots to update and append responses.
0.1.0.0 - Published after the completed V2 overhaul.
0.0.0.5 - Aligned the V2 connector contract and public help article.
0.0.0.1 - Initial release with spreadsheet discovery, workbook metadata, value reads, value updates, and row appends.
0.0.0.3 - Improved retry handling, simplified the public Connection surface, and improved pasted service-account private-key handling.
0.0.0.4 - Removed the legacy status, statusMessage, and errorMessage output fields and added normalized provider detail fields.
This Connection stores the Google service-account settings and optional spreadsheet defaults used by the Node.
| Property |
Type |
Description |
Client Email |
String |
Google service-account email used as the JWT issuer. |
Private Key |
Masked |
Google service-account private key used to sign JWT assertions. |
Scopes |
String |
Space-delimited scopes requested during token minting. |
Default Spreadsheet Id |
String |
Optional default spreadsheet ID used when preconfigured requests omit SpreadsheetId. |
Default Sheet Title |
String |
Optional default sheet title used when preconfigured ranges omit an A1 sheet prefix. |
Access Token |
Masked |
Cached access token minted from the Google service-account flow. |
- Create or obtain a Google service-account JSON key, then copy its
client_email and private_key values into the Connection.
- Paste
Private Key exactly as copied from the JSON key. JSON-style escaped newlines are accepted.
- Share target spreadsheets with the service-account email when you want the Node to discover them, expand templates from them, read them, or write to them.
- Set
Default Spreadsheet Id when you want omitted SpreadsheetId values to resolve to a known workbook.
- Set
Default Sheet Title when you want ranges without an A1 sheet prefix to resolve automatically to a known sheet.
- Connection test performs a lightweight spreadsheet discovery call.
The Node exposes methods for spreadsheet discovery, metadata reads, value reads, value updates, and row appends.
Lists spreadsheets visible to the configured service account.
| Parameter |
Type |
Description |
Connection |
Connection |
Google Sheets Connection including service-account credentials and defaults. |
NameContains |
String |
Optional case-sensitive name fragment used to narrow spreadsheet discovery. |
| Return |
Type |
Description |
Spreadsheets |
Array |
One row per discovered spreadsheet, including spreadsheetId, name, mimeType, webViewLink, trashed, and raw. |
Gets workbook metadata for one spreadsheet.
| Parameter |
Type |
Description |
Connection |
Connection |
Google Sheets Connection including service-account credentials and defaults. |
Request |
Object |
Metadata request containing SpreadsheetId and optional metadata controls such as Ranges and IncludeGridData. |
| Return |
Type |
Description |
Spreadsheet |
Object |
One workbook metadata row including spreadsheetId, title, sheetCount, sheets, and raw. |
Reads one or more spreadsheet ranges and emits one row per returned inner array.
| Parameter |
Type |
Description |
Connection |
Connection |
Google Sheets Connection including service-account credentials and defaults. |
Request |
Object |
Values request containing SpreadsheetId, Ranges, and optional render controls. Ranges must contain at least one range. MajorDimension defaults to ROWS. |
| Return |
Type |
Description |
Rows |
Array |
One row per returned inner array, including spreadsheetId, range, majorDimension, itemIndex, values, and raw. |
Updates spreadsheet values for one or more ranges.
| Parameter |
Type |
Description |
Connection |
Connection |
Google Sheets Connection including service-account credentials and defaults. |
Request |
Object |
Update request containing SpreadsheetId, ValueInputOption, optional response settings, and Data entries. Each Data item includes Range, optional MajorDimension, and Rows, where each row contains Values. ValueInputOption defaults to RAW. |
| Return |
Type |
Description |
Result |
Object |
One result row including update counters, provider payload fragments, and the Flowgear object with IsSuccess, Message, and a detached input snapshot under Request. |
Appends rows to a spreadsheet table range.
| Parameter |
Type |
Description |
Connection |
Connection |
Google Sheets Connection including service-account credentials and defaults. |
Request |
Object |
Append request containing SpreadsheetId, Range, Rows, and optional write controls. Each row contains Values. MajorDimension defaults to ROWS, ValueInputOption defaults to RAW, and InsertDataOption defaults to INSERT_ROWS. |
| Return |
Type |
Description |
Result |
Object |
One result row including append counters, nested updates, and the Flowgear object with IsSuccess, Message, and a detached input snapshot under Request. |
- Query and read rows do not include mutation-style default fields.
ListSpreadsheets, GetSpreadsheet, and GetValues return zero rows for valid empty data outcomes and do not convert first-call provider failures into success-shaped rows.- If the first provider call for
ListSpreadsheets, GetSpreadsheet, or GetValues fails, that Google API error surfaces to the Workflow.
UpdateValues and AppendValues return the Flowgear object with default success or failure metadata.- Mutation failure rows preserve
message, providerCode, providerStatus, providerReason, and httpStatusCode when that detail is available.
- Drive spreadsheet discovery handles pagination internally.
- Live template expansion depends on the service account already having access to the target spreadsheets.
- The Node is service-account-first and does not implement delegated end-user OAuth or domain-wide impersonation.
- Structural workbook operations such as
spreadsheets:batchUpdate, sheet creation, formatting, and protection management are not currently supported.