Spreadsheet Values Append

Google Drive

Append values after a detected Google Sheets data table.

Capability: Spreadsheet management
Current price: $0.0025/request
Availability: Requires connected account

What this API does

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

Agents select this operation with tool ID google-drive.spreadsheet-values-append, then check its current inputs and price before a run.

Inputs and outputs

Input

bodyobject · required

Bounded request body sent to the connected application.

pathobject · required

Identifier path for the authorised connected-app record.

queryobject · required

Search terms used to find relevant records.

Output

spreadsheetIdstring

Returned spreadsheet id value.

tableRangestring

Returned table range value.

updatesobject

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.

Use Spreadsheet Values Append with Scrollport

Get started

Connect your app account to let your agent use its tools. Your credentials stay private, and you pay only for successful runs.

Connect your first agent to receive $1 trial credit.