Skip to main content
Glama

Search spreadsheets

search_spreadsheets
Read-onlyIdempotent

Find 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

TableJSON Schema
NameRequiredDescriptionDefault
order_byNoDrive sort key, e.g. "modifiedTime desc" (default), "name", "createdTime desc", "viewedByMeTime desc".
page_sizeNoMax files per page (1..1000; default 100).
page_tokenNonextPageToken from the previous page.
name_containsNoCase-insensitive name substring to filter by (omit to list all spreadsheets).
Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

Beyond the readOnly/idempotent annotations, the description discloses meaningful behavior: results are limited to openable files, trashed files are excluded, ordering is newest-modified first, and the tool uniquely goes through the Drive API. The 403 failure mode without a Drive scope is especially valuable and goes far beyond annotation defaults.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is dense but each sentence earns its place: scope, returned fields, filtering, pagination, and the critical auth caveat. It front-loads the core purpose before the scope requirement, making it efficient for an agent to parse.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

With no output schema, the description compensates by listing the returned fields and default ordering. It covers pagination, filtering, exclusions, and authentication failure modes. For a 4-parameter read-only listing tool, nothing essential is missing.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters4/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema coverage is 100%, so the baseline is 3. The description adds semantic context on top: name_contains is a substring filter with 'omit to list everything', page_token is tied to nextPageToken, and order_by has a documented default. This enriches the schema rather than repeating it.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description uses a specific verb ('Finds') and names the exact resource ('Google Sheets spreadsheets the authorized user can open'), including exclusions like trashed files and shared drives. It lists returned fields and default sorting, clearly distinguishing this search/list operation from sibling tools like get_spreadsheet or read_values.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

It gives clear operational guidance: omit name_contains to list everything, use page_token for pagination, and handle the Drive-scope requirement. It does not explicitly contrast with get_spreadsheet or other alternatives, but the search/list context is unmistakable and practical.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/A1-x-Tech/mcp-google-sheets'

If you have feedback or need assistance with the MCP directory API, please join our Discord server