Inputs and outputs

Input

bodyobject · required

Bounded request body sent to the connected application.

pathobject · required

Identifier path for the authorised connected-app record.

Output

indexnumber

Returned index value.

sheetIdnumber

Returned sheet id value.

sheetTypestring

Returned sheet type value.

titlestring

Returned title 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-sheet-copy",
  "input": {
    "body": {
      "destinationSpreadsheetId": "YOUR-GOOGLE-SHEETS-SPREADSHEET-ID"
    },
    "path": {
      "sheetId": "YOUR-GOOGLE-SHEETS-SHEET-ID",
      "spreadsheetId": "YOUR-GOOGLE-SHEETS-SPREADSHEET-ID"
    }
  }
}

Output

{
  "index": 1,
  "title": "Copy of Launch plan",
  "sheetId": 987654321,
  "sheetType": "GRID"
}

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.

Spreadsheet Sheet Copy

What this API does

Input

Output

Request

Output

Use Spreadsheet Sheet Copy with Scrollport

Spreadsheet Sheet Copy

What this API does

Input

Output

Request

Output

Use Spreadsheet Sheet Copy with Scrollport