Skip to main content
Glama
lmdat

@lmdat/google-sheets-oauth-mcp

by lmdat

Tìm Google Sheet theo tên

drive_list_spreadsheets

Lists Google Sheets in your Drive with name, ID, URL, and last modified time. Filter by name to find spreadsheet IDs without copying URLs.

Instructions

List các Google Sheet trong Drive của chính user đang login (không cần share thủ công, vì OAuth đại diện chính user đó). Dùng để tìm spreadsheet_id theo tên thay vì copy URL. Trả về JSON array, mỗi item: {name, id, url, modifiedTime, owner}.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
max_resultsNo
name_containsNoLọc theo tên file chứa chuỗi này (vd "Ngân sách"). Bỏ trống để lấy gần đây nhất.
Behavior3/5

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

No annotations are provided, so the description carries the full burden. It discloses that the tool lists only the current user's Drive and returns a JSON array with specific fields. However, it does not mention limitations like pagination, error handling, or behavior when no results.

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

Conciseness4/5

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

The description is concise, consisting of three sentences that flow logically: scope, use case, and return format. No unnecessary words, but it could be better structured with explicit parameter details.

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

Completeness3/5

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

For a simple listing tool with two optional parameters and no output schema, the description covers scope, return fields, and use case. However, it omits details on max_results behavior, filtering semantics (e.g., case sensitivity), and ordering, which are needed for full completeness.

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

Parameters2/5

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

Schema description coverage is 50% (only name_contains has a schema description). The tool description adds overall purpose but does not explain the max_results parameter (e.g., default, max, or ordering). The description does not significantly enhance parameter understanding beyond the schema.

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

Purpose4/5

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

The description clearly states the tool lists Google Sheets in the user's own Drive and is used to find spreadsheet_id by name. It differentiates from copying URLs, but does not explicitly distinguish from sibling tools, though no other listing tool exists among siblings.

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

Usage Guidelines3/5

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

The description provides a specific use case (finding spreadsheet_id by name) but no explicit guidance on when not to use or alternatives. Sibling tools are different actions, so confusion is low, but the guidance is limited.

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/lmdat/google-sheet-oauth-mcp'

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