> 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/data-level-operations.md).

# Data-level Operations

## 1. **Lookup Spreadsheet Row**

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

### 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 action:<br><br>- Lookup Spreadsheet Row</p>                                                                                                                                                                                           |
| Spreadsheet ID | Input the "Spreadsheet ID" you want to get the info                                                                                                                                                                                                 |
| Query          | <p>Input the Query<br><br>Example:<br></p><ul><li>"An" → Find rows that contain the word "An".</li><li>"=23" → Find rows with a cell that contains the number 23.</li><li>"=B2='Nam'" → Find rows where cell B2 contains the value "Nam".</li></ul> |

## **2. Batch Get**

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

### Component settings

<table><thead><tr><th>Parameter Name</th><th>Description</th></tr></thead><tbody><tr><td>Credentials</td><td>Connect your Google account to authorize access to Google Sheets. Required to perform any actions.</td></tr><tr><td>Action</td><td>Select the action:<br><br>- Batch Get</td></tr><tr><td>Spreadsheet ID</td><td>Input the "Spreadsheet ID" you want to get the info</td></tr><tr><td>Ranges</td><td><p></p><p>Input the ranges you want to get info<br><br>Ex:<br></p><pre><code>[
  "Sheet1!A1:C5",
  "Sheet2!A1:B10
</code></pre></td></tr></tbody></table>

## **3. Batch Update**

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

### Component settings

<table><thead><tr><th>Parameter Name</th><th>Description</th></tr></thead><tbody><tr><td>Credentials</td><td>Connect your Google account to authorize access to Google Sheets. Required to perform any actions.</td></tr><tr><td>Action</td><td>Select the action:<br><br>- Batch Update</td></tr><tr><td>Spreadsheet ID</td><td>Input the "Spreadsheet ID" you want to update</td></tr><tr><td>Sheet Name</td><td>Input the "Sheet Name" you want to update</td></tr><tr><td>Values</td><td><p>Input the value you want to update<br><br>Example:<br></p><pre><code>[
  [
    "name",
    "age",
    "class"
  ],
  [
    "An",
    18,
    "12A1"
  ],
  [
    "Binh",
    17,
    "11B2"
  ]
]
</code></pre></td></tr></tbody></table>