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

# Sheet-level Operations

## 1. **Create Sheet from JSON**

<figure><img src="/files/5ZhhRpPTGkjCIQm41oX1" 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>- Create Sheet From JSON</td></tr><tr><td>Title</td><td>Input the Title of the "Google sheet" you want to create</td></tr><tr><td>Sheet Name</td><td>Input the "Sheet Name" you want to create</td></tr><tr><td>Sheet JSON</td><td><p>Input the JSON data<br><br>Example:<br></p><pre><code>[
  {
    "name": "Huy",
    "age": 18,
    "class": "12A1"
  },
  {
    "name": "Tai",
    "age": 17,
    "class": "11B2"
  },
  {
    "name": "Thuy",
    "age": 16,
    "class": "10C3"
  }
]
</code></pre></td></tr></tbody></table>

## **2. Get Sheet Names**

<figure><img src="/files/jdoV4dliwBuXjVf8cCJy" 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>- Get Sheet Names</p>                                                 |
| Spreadsheet ID | Input the "Spreadsheet ID" you want to get the info                                                |

## **3. Clear values**

<figure><img src="/files/CKTGX3Iulm8p6EOV0USe" 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>- Clear Values</td></tr><tr><td>Spreadsheet ID</td><td>Input the "Spreadsheet ID" you want to clear the values</td></tr><tr><td>Ranges</td><td><p>Input the ranges you want to clear<br><br>Ex:<br></p><pre><code>[
  "Sheet1!A1:C5",
  "Sheet2!A1:B10"
]
</code></pre></td></tr></tbody></table>