# 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.


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.diaflow.io/workflow-builder/nodes/apps/google-sheet.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.