Search spreadsheets
search_spreadsheetsFind Google Sheets files the authorized user can open, filtering by name substring and sorting by recency. Returns file IDs, names, times, owners, and view links with pagination.
Instructions
Finds Google Sheets spreadsheets the authorized user can open (own files and shared drives; trashed files are excluded): id, name, createdTime, modifiedTime, owners and webViewLink per file, newest-modified first by default. name_contains filters by name substring; omit it to list everything. Paginate with page_token from nextPageToken. This is the one read that goes through the Drive API internally, so the OAuth token needs a Drive scope (drive, drive.readonly or drive.file for app-created files) — with only the spreadsheets scope it fails with 403 while every other tool still works.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| order_by | No | Drive sort key, e.g. "modifiedTime desc" (default), "name", "createdTime desc", "viewedByMeTime desc". | |
| page_size | No | Max files per page (1..1000; default 100). | |
| page_token | No | nextPageToken from the previous page. | |
| name_contains | No | Case-insensitive name substring to filter by (omit to list all spreadsheets). |