> For the complete documentation index, see [llms.txt](https://docs.diaflow.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.diaflow.io/workflow-builder/nodes/apps/google-sheet.md).

# Google Sheet

<figure><img src="/files/nvLOmEIyEtrQW1FRdQzv" alt=""><figcaption></figcaption></figure>

## Description

**What it does**: This node allows you to connect and interact with Google Sheets, enabling you to read, write, update, and manage spreadsheet data dynamically within a workflow.

**When to use it? :** Use this node when you need to integrate Google Sheets as a data source or destination, such as logging workflow outputs, retrieving configuration data, or automating spreadsheet operations.

## Component settings

| Parameter Name | Description                                                                                                                                                                                                                                                                                 |
| -------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| Credentials    | Connect your Google account to authorize access to Google Sheets. Required to perform any actions.                                                                                                                                                                                          |
| Action         | <p>Select the operation you want to perform on the spreadsheet. Available actions include:<br><br>- Create a new Google sheet<br>- Create Sheet from JSON<br>- Lookup Spreadsheet Row<br>- Get Sheet Names<br>- Get Spreadsheet Info<br>- Batch Get<br>- Batch update<br>- Clear Values</p> |
| Another fields | <p>Based on the action, another field will display on the node:<br>- Spreadsheet ID<br>- Ranges<br>- Title<br>- Sheet Name<br>- Sheet JSON<br>- Query<br>- Value<br>- ...</p>                                                                                                               |

## Operations

### [Document-level Operations](/workflow-builder/nodes/apps/google-sheet/document-level-operations.md)

Operations related to the entire Google Sheet file:

* **Create a new Google Sheet**: Create a new Google Sheet document.
* **Get Spreadsheet Info**: Retrieve general information about the spreadsheet, including the list of sheets and metadata.

### [Sheet-level Operations](/workflow-builder/nodes/apps/google-sheet/sheet-level-operations.md)

Operations related to individual sheets within a spreadsheet:

* **Create Sheet from JSON**: Create a new sheet and populate it with data from a JSON string.
* **Get Sheet Names**: Retrieve the names of all sheets in the spreadsheet.
* **Clear Values**: Clear data within a sheet, either entirely or from a specified range.

### [Data-level Operations](/workflow-builder/nodes/apps/google-sheet/data-level-operations.md)

Operations related to rows, cells, or data content:

* **Lookup Spreadsheet Row**: Search for a row based on a specific column value.
* **Batch Get**: Retrieve data from multiple ranges or sheets at once.
* **Batch Update**: Update multiple cells or data ranges in bulk.