List spreadsheets
spreadsheet_listList the spreadsheets one of your Google Sheets, Excel or Smartsheet account connections can read (postgres_list_connections marks them spreadsheets: true), or one spreadsheet's tabs. Without spreadsheetId it returns the files: for a Google account, the spreadsheets its owner chose for OrionBI with "Add spreadsheets" on the Workbooks page (Google lets OrionBI open nothing else); for a Microsoft 365 account, the Excel workbooks it can open across OneDrive and SharePoint, filtered by query; for a Smartsheet account, the sheets it can open, filtered by query. With spreadsheetId (and, for Excel, driveId) it returns that file's tabs and their sizes; a Smartsheet sheet is one table, its columns named by their titles. For Excel, link instead takes a OneDrive or SharePoint sharing link the user pasted and returns that workbook and its worksheets. Excel connections read workbooks (.xlsx, .xlsm) in OneDrive for Business and SharePoint, not personal OneDrive. Every file and tab carries selection, the JSON object to pass as sql to dataset_create, which turns a tab into a Data Set with typed columns (numbers, dates, true/false) refreshed on a schedule. If a Google spreadsheet the user names is not listed, ask them to add it on the Workbooks page; it cannot be reached any other way.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"connection": "<connection>"
},
"name": "spreadsheet_list"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| link | No | Excel only: a OneDrive or SharePoint link to a workbook, as the user pasted it. Returns that workbook and its worksheets. | |
| query | No | Only files whose name matches this. For Excel it is a search across OneDrive and SharePoint; for Smartsheet, sheets whose name contains it. | |
| driveId | No | Excel only: the file's `driveId` from an earlier call. | |
| connection | Yes | Name of a Google Sheets, Excel or Smartsheet account connection you own. | |
| spreadsheetId | No | List this file's tabs instead of the files: a `fileId` from an earlier call. |