Skip to main content
Glama
Sign In

Google Sheets MCP by InsightfulPipe

by com.insightfulpipe
OverviewDiscussionsAdmin

Server Details

Hosted Google Sheets MCP server, with each action switched on or off per account.

Ownership verified
Status
Healthy
Uptime
100.0% over the last 24 hours
OAuth
Works in Glama
Last Tested
Transport
Streamable HTTP · MCP 2025-11-25
URL
Repository
Insightful-Pipe/google-sheets-mcp-server
GitHub Stars
0
ChatGPT
–
Claude
–

TDQS

B3.3/5.0

Scored across 4 tools

Disambiguation2/5

execute_action and query_data are nearly indistinguishable: both are described as Step 3 (FINAL) of the same workflow and list the same common Google Sheets actions, including reads and writes. query_contexts is a planning helper that overlaps with both as a prerequisite, while prompts_menu is the only clearly distinct tool.

Naming Consistency3/5

Three tools follow a verb_noun pattern (execute_action, query_contexts, query_data), but prompts_menu breaks it with a noun_noun form. The mixed convention is still readable, but it is not fully consistent.

Tool Count4/5

Four tools is a reasonable count for a Google Sheets wrapper that delegates most operations through a generic action schema. The count is slightly thin, and the duplication between execute_action and query_data makes the set feel less scoped than it could be.

Completeness3/5

The generic action pattern suggests broad Google Sheets coverage, and the visible surface includes read, write, preview, add rows, and create spreadsheet. However, common lifecycle operations such as deleting rows/sheets, formatting, and batch updates are not evident, leaving notable gaps.

Available Tools

4 tools
execute_actionGoogle Sheets Execute ActionA
Destructive
Inspect

Execute Google Sheets action (Step 3 (FINAL) of workflow).

REQUIRED: Complete these steps first using query_contexts:

  1. request='accounts' - Get workspace_id, brand_id, spreadsheet_id, sheet_id AND available_requests

  2. request='actions_details' with actions=['query_sheet_data'] - Get detailed body structure

Common actions: query_sheet_data (read/filter data), update_cells (write), get_sheet_peak (preview), add_rows, create_spreadsheet.

Rely on info from steps 1-2 to construct the action body. Follow the schema exactly.

Inputs: body (required). Returns: object

prompts_menuGoogle Sheets PromptsA
Read-only
Inspect

Access Google Sheets prompt catalog with 4 operations:

  1. List Public Prompts: • request='menu' - No additional params needed • Returns: All public/system prompts for Google Sheets

  2. List Custom Prompts: • request='menu', prompt_type='custom', workspace_id= • Returns: All custom prompts for the specified workspace

  3. Get Public Prompt Details: • request='prompt_details', prompt_id= • Returns: Full text/details of a public prompt

  4. Get Custom Prompt Details: • request='prompt_details', prompt_id=, is_custom=True, workspace_id= • Returns: Full text/details of a custom prompt

Inputs: request (required), is_custom, prompt_id, prompt_type, +1 more. Returns: object

query_contextsGoogle Sheets HelperA
Read-only
Inspect

Helper for planning InsightfulPipe Google Sheets data queries.

Step 1: request='accounts' – Retrieve workspace_id, brand_id, spreadsheet_id, sheet_id, other source metadata, AND available_requests (all tables you can query).

Step 2: request='actions_details' with actions=['table_a', 'table_b'] – REQUIRED before querying. Returns the exact request body, required identifiers, fields, and notes for each action.

Optional: request='available_actions' – Standalone call to list all available tables/actions (already included in accounts response).

Optional: request='brands' with brand_id + workspace_id to pull brand guidelines.

Inputs: request (required), actions, brand_id, platform, +1 more. Returns: object

query_dataGoogle Sheets Data QueryB
Read-only
Inspect

Query Google Sheets data (Step 3 (FINAL) of workflow).

REQUIRED: Complete these steps first using query_contexts:

  1. request='accounts' - Get workspace_id, brand_id, spreadsheet_id, sheet_id AND available_requests

  2. request='actions_details' with actions=['query_sheet_data'] - Get detailed body structure

Common actions: query_sheet_data (read/filter data), update_cells (write), get_sheet_peak (preview), add_rows, create_spreadsheet.

Rely on info from steps 1-2 to construct the query body. Follow the schema exactly.

Inputs: body (required). Returns: object

Tool Schema Changelog

Recent tool additions, removals, and schema changes observed during successful MCP inspections.

Loading tool schema changelog…

    Related MCP Connectors

    Related MCP Servers

    • sheets-mcp

      CaioAlexandreps02
      F
      license
      Not graded
      quality
      D
      maintenance
      MCP server for Google Sheets that exposes tools to read cell ranges, update values, and apply advanced batch updates (borders, colors, data validation, conditional formatting) via HTTP.
      6 npm
      -

    • gworkspace-mcp

      LeooNic
      A
      license
      B
      quality
      D
      maintenance
      An MCP server for automating Google Workspace applications including Sheets, Apps Script, Drive, Docs, and Gmail. It enables users to manipulate spreadsheets, edit scripts, manage files, and send emails directly from conversational AI interfaces.
      31
      MIT

    • gsheets-mcp

      henrysouchien
      A
      license
      Not graded
      quality
      C
      maintenance
      MCP server for Google Sheets operations, enabling spreadsheet management including reading, writing, appending, creating, and searching sheets via natural language.
      MIT
    Try in Browser
    One endpoint for every MCP toolRayrun runs every MCP server behind one URL and holds the credentials. Each call is decided per client, tool, and argument, then recorded.ray.runAd

    Glama MCP Gateway

    Add one secure layer between your agents and this server.

    Resources