# Spreadsheet Values Append

Google Drive

Append values after a detected Google Sheets data table.

## Use this tool with your AI agent

1. Copy the prompt
2. Paste it into your agent
3. Tell it what you need

Read https://scrollport.com/start. Use my existing Scrollport connection, or help me connect if needed. Help me use Spreadsheet Values Append (tool ID: google-drive.spreadsheet-values-append). Ask me for the details you need, then show me the result. Help me connect the required app account if needed.

**Already connected:** Your agent can use that connection.

**New user:** Your agent will guide you through setup, sign-in and authorisation.

This tool also needs you to connect your app account.

Connect your first agent to receive $1 trial credit.

**Job:** [Read and update Google Sheets](https://scrollport.com/tools/google-sheets-mcp)

**Current price:** $0.0025/request

**Availability:** Requires connected account

## Tool details

**About this tool**

Appends one bounded value matrix using explicit input and insert options. Always one upstream request at $0.0025.

**Inputs and outputs**

### Input

`body` object · required

Bounded request body sent to the connected application.

`path` object · required

Identifier path for the authorised connected-app record.

`query` object · required

Search terms used to find relevant records.

### Output

`spreadsheetId` string

Returned spreadsheet id value.

`tableRange` string

Returned table range value.

`updates` object

Returned updates value.

**Example request and output**

Inspect returns this reviewed example, its estimated cost and the current input schema. Run calculates the estimate for your actual input.

### Request

```
{
  "tool_id": "google-drive.spreadsheet-values-append",
  "input": {
    "body": {
      "values": [
        [
          10,
          20,
          30
        ]
      ]
    },
    "path": {
      "range": "Plan!A:C",
      "spreadsheetId": "YOUR-GOOGLE-SHEETS-SPREADSHEET-ID"
    },
    "query": {
      "insertDataOption": "INSERT_ROWS",
      "valueInputOption": "USER_ENTERED"
    }
  }
}
```

### Output

```
{
  "updates": {
    "updatedRows": 1,
    "updatedCells": 3,
    "updatedRange": "Plan!A3:C3"
  },
  "tableRange": "Plan!A1:C2",
  "spreadsheetId": "spreadsheet-output-id"
}
```

**Errors and limitations**

- `connection_required`: This capability acts on the connected Google Workspace, which is not available yet.Open connect_url, approve Google Drive access, then retry this run unchanged.

---

Canonical page: https://scrollport.com/tools/providers/google-drive/spreadsheet-values-append