# Google Sheets

The **Google Sheets Node** allows you to interact with and modify a Google Sheet, or to set a trigger when a Sheet is updated with new data.

***

### Configure a Sheets Tool

Right click to add a node, select **Google Sheets**, then choose your tool, whether it's a trigger for your workflow (e.g. **On Sheet Update**), an information extractor (e.g. **Get Spreadsheet Details**), or an action for your Sheet (e.g. **Write to Sheet**).

<figure><img src="https://3697023207-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FFSlso1Kjob5CLDrh0dVn%2Fuploads%2F7A1TKAeIschXt99Hs6Yz%2Fcreate_gsheet.gif?alt=media&#x26;token=2b64bd85-9cb9-4f3b-b889-a4a353dff348" alt=""><figcaption></figcaption></figure>

Here is the list of tools that you can select.

<table><thead><tr><th width="138.375">Tool Name</th><th width="82.953125">Type</th><th>Description</th></tr></thead><tbody><tr><td><strong>On Sheet Update</strong></td><td>Trigger</td><td>Trigger a workflow when any changes occur on your Sheet.</td></tr><tr><td><strong>Create Column Headers</strong></td><td>Action</td><td>Write specific column headers in the first row of your Sheet.</td></tr><tr><td><strong>List Column Headers</strong></td><td>Extract</td><td>Get the column headers from the first row of your Sheet</td></tr><tr><td><strong>Create Sheet</strong></td><td>Action</td><td>Create a new worksheet (tab) in your existing Google Sheet</td></tr><tr><td><strong>Create Spreadsheet</strong></td><td>Action</td><td>Create a new Google Sheet with a specific title</td></tr><tr><td><strong>Get Spreadsheet Details</strong></td><td>Extract</td><td>Get information (e.g. dimension) and metadata about your Google Sheet</td></tr><tr><td><strong>Delete Row</strong></td><td>Action</td><td>Delete a specific row from the Sheet using its row number</td></tr><tr><td><strong>Get Row by Index</strong></td><td>Extract</td><td>Get a specific row from the Sheet using its row number</td></tr><tr><td><strong>List Worksheets</strong></td><td>Extract</td><td>Get a detailed list of all worksheets (tabs) in your Google Sheet </td></tr><tr><td><strong>Read from Sheet</strong></td><td>Action</td><td>Read data from your sheet by specific range</td></tr><tr><td><strong>Update Cell</strong></td><td>Action</td><td>Update a specific cell value in your Sheet by cell address (e.g. C1)</td></tr><tr><td><strong>Update Sheet</strong></td><td>Action</td><td>Update data in your Sheet by specific range or criteria</td></tr><tr><td><strong>Write to Sheet</strong></td><td>Action</td><td>Write data to your Sheet</td></tr></tbody></table>

***

### Create a Connection to Google Sheets

Click the node to open its settings, then select **Connect Google Sheets.**

On the dropdown menu under Select a Connection, click **New connection**, where you will be taken to a page to link your Google workspace to StackAI.

<figure><img src="https://3697023207-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FFSlso1Kjob5CLDrh0dVn%2Fuploads%2FBGk6uJ6SgE9HuUnE1GUl%2Fgsheets.gif?alt=media&#x26;token=9b36a22f-5af3-49e4-a434-2a42ac95481b" alt=""><figcaption></figcaption></figure>

Once you're connected to your Google workspace, you can select any Sheet you'd like to modify using the StackAI workflow.

### Featured Tools

***

#### **Write to Sheet**

**Description:**\
Appends data to a specified Google Sheet.

**Input Fields**

* **Data Format**
  * Select whether you're inputting data manually or using a CSV file URL link.
* **Data**
  * If you selected manual entry, select the data that you're writing to the Sheet (must be **JSON object** with column names as keys).
  * If your data comes from an AI Agent node, make sure the prompt for the AI agent asks it to format the output as a JSON object for writing to your Sheet, as seen below:

<figure><img src="https://3697023207-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FFSlso1Kjob5CLDrh0dVn%2Fuploads%2F6MUVqnWNhWB1t6lMQAMa%2FScreenshot%202025-12-04%20at%203.05.11%E2%80%AFPM.png?alt=media&#x26;token=8ac42afe-a636-4565-a80f-3951ccc2f752" alt=""><figcaption></figcaption></figure>

Here is a demo for selecting an AI Agent node's output as your data within the Google Sheets node.

<figure><img src="https://3697023207-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FFSlso1Kjob5CLDrh0dVn%2Fuploads%2FIRegLvyzArLgHYdSox6O%2Fsheets_input.gif?alt=media&#x26;token=935d1a58-6c52-4184-be97-6c4fd9738890" alt=""><figcaption></figcaption></figure>

* **CSV URL**
  * If you selected CSV file upload, add the file URL to parse.
* **Starting Cell**
  * Select the cell number in your Sheet that you'd like to write your first datapoint to (e.g. A1).

**Configurations Fields**

* **Spreadsheet (required)**
  * Select your Google Sheet.
* **Sheet (required)**
  * Select the tab of your Google Sheet to write to.

***

**Best Practices**

* Always use structured JSON for the data input for best results.
* Ensure you have the correct permissions to access and write to the selected Google Sheet.
* Use clear sheet and spreadsheet names to avoid confusion in multi-sheet documents.

***

**Automate your data workflows with the GSheets node in StackAI for seamless Google Sheets integration.**


---

# 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.stackai.com/workflow-builder/apps/google-sheets.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.