Spreadsheet Values Append: price, inputs and example | Scrollport

Spreadsheet Values Append: price, inputs and example | Scrollport

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"
}