Loading tools…

Spreadsheet Values Update: price, inputs and example | Scrollport

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-update",
  "input": {
    "body": {
      "values": [
        [
          "Workflow",
          "Owner",
          "Status"
        ],
        [
          "Google verification",
          "Scrollport",
          "Ready"
        ]
      ]
    },
    "path": {
      "range": "Plan!A1:C2",
      "spreadsheetId": "YOUR-GOOGLE-SHEETS-SPREADSHEET-ID"
    },
    "query": {
      "valueInputOption": "USER_ENTERED"
    }
  }
}

Output

{
  "updatedRows": 1,
  "updatedCells": 3,
  "updatedRange": "Plan!A2:C2",
  "spreadsheetId": "spreadsheet-output-id",
  "updatedColumns": 3
}

Spreadsheet Values Update

What this API does

Input

Output

Use Spreadsheet Values Update with Scrollport

Request

Output