Google Sheets

Node catalog Actions

On this page

Share the document with the service account email. spreadsheetId is the identifier in its URL; sheetName identifies the tab. Ranges use A1 notation.

Usage and specifics

Share the document with the service account email. spreadsheetId is the identifier in its URL; sheetName identifies the tab. Ranges use A1 notation.

Technical type : google_sheets. Runtime : nodulz.

Credentials and prerequisites

Create and configure the credential : google-sheets

Create credentials in your nodulz instance’s Credentials area, then select them on the node. Availability depends on ownership and sharing. See the credentials guide for access and rotation.

Parameters

Names below are technical keys. Defaults are not a ready-to-run configuration: complete fields required by your operation. Paths containing [] describe list items; some fields depend on the selected mode.

Parameter	Type	Default	Values / limits
`credentialId`	`string`	`""`	-
`operation`	`enum`	`"append_row"`	`create_spreadsheet`, `delete_spreadsheet`, `append_or_update_row`, `append_row`, `clear_sheet`, `create_sheet`, `delete_sheet`, `delete_rows_or_columns`, `get_rows`, `update_row`
`spreadsheetId`	`string`	`""`	-
`spreadsheetTitle`	`string`	`""`	-
`sheetName`	`string`	`"Sheet1"`	-
`range`	`string`	`""`	-
`row`	`number`	`2`	-; ≥ 1
`matchColumn`	`string`	`""`	-
`values`	`string`	`"{}"`	-
`dimension`	`enum`	`"ROWS"`	`ROWS`, `COLUMNS`
`startIndex`	`number`	`1`	-; ≥ 1
`count`	`number`	`1`	-; ≥ 1

Configuration help

credentialId Google Sheets credential: Google service account. Share the spreadsheet with its email and enable Sheets and Drive APIs.
operation Action: Action to run in Google Sheets.
spreadsheetTitle Spreadsheet title: Name of the new document.
spreadsheetId Spreadsheet ID: ID in the Google spreadsheet URL.
sheetName Sheet: Exact tab name.
range A1 range: Leave empty for the whole sheet.
values JSON values: Object keyed by first row column names, or array of cells.
matchColumn Match column: Select a column added above. Its value identifies the row to update.
row Row number: Sheet row number starting at 1.
dimension Dimension: Delete rows or columns.
startIndex Start: First number, starting at 1.
count Count: Number of rows or columns to delete.

Initial configuration

Initial catalog configuration example, to adapt before running. Keep secrets in credentials.

json

{
  "credentialId": "",
  "operation": "append_row",
  "spreadsheetId": "",
  "spreadsheetTitle": "",
  "sheetName": "Sheet1",
  "range": "",
  "row": 2,
  "matchColumn": "",
  "values": "{}",
  "dimension": "ROWS",
  "startIndex": 1,
  "count": 1
}

Verification

Test with representative data. Check node output in the inspector and logs, then use editor mapping for downstream fields. A trigger test with a simulated payload does not validate external service delivery.