# Google Sheets - Workflow node | Docs - nodulz

Source: https://nodulz.com/docs/nodes/google_sheets

Language: en

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](/docs/credentials/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](/docs/credentials) 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

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

See also : [Expressions and data](/docs/expressions), [Executions](/docs/executions), [Node catalog](/docs/nodes).

## Explore further

- [Features - nodulz](https://nodulz.com/product/overview)
- [Node catalog - nodulz](https://nodulz.com/product/catalog)
- [MCP server - nodulz](https://nodulz.com/product/mcp)
- [Pricing - nodulz](https://nodulz.com/pricing)
- [Use cases and workflow automation - nodulz](https://nodulz.com/use-cases)
- [Choose what your workflows can do. - nodulz](https://nodulz.com/compare)
- [Documentation - nodulz](https://nodulz.com/docs)