general MCP Server
MCP server for Google Sheets - Read, write and manipulate spreadsheets through Claude Desktop
Discovered via unknown and last synced 3mo ago.
Install instructions not detected yet
Check the source repository for the latest setup steps.
Clear all values in a range (preserves formatting)
Remove a sheet tab by its numeric sheet ID
Insert a date/datetime value formatted correctly into a cell
Modify an existing chart's spec or position
Write values to multiple ranges in one request
Apply different formats to multiple ranges in one request
Read data validation rules (checkboxes, dropdowns, custom formulas) from a sheet or range. Returns compact run-length-encoded list of unique rules grouped by cell ranges
Insert a hyperlink formula into a cell
Create a bar, line, pie, column or other chart on a sheet
Merge a range of cells
Lightweight structural metadata only — no per-cell data. Returns dimensions, frozen rows/cols, tab colour, column widths, row heights, hidden columns/rows, and all merges in A1 notation. Single fast API call
Create a new Google Sheets file
Get spreadsheet metadata: title, locale, sheets list with IDs, row/column counts
Rename a sheet, change tab colour, toggle grid lines, etc.
Description
Apply background colour, font style, alignment and number format to a range
Delete one or more columns using a full-column A1 range
Add a conditional formatting rule (gradient or boolean) to a range
Read cell values from a single range
Add a new sheet tab to an existing spreadsheet
Set or remove borders on a range (style, width, colour per side)
Return all merged cell ranges for a sheet, with A1 notation and raw GridRange coordinates
Copy a sheet within the same spreadsheet
Delete multiple sheet tabs in one request
Read cell formatting for a range and return it as compact A1Range→format pairs (run-length encoded). Identical adjacent cells are collapsed into rectangular ranges — reduces output by 90 %+ compared to per-cell data
Read raw cell formatting (background colour, font, borders, alignment, number format) for a range without returning cell values
Read all conditional formatting rules and banded (alternating-colour) ranges defined on a sheet
Verify that the service account can access a spreadsheet
Delete one or more rows using a full-row A1 range
Read cell values from multiple ranges in one request
Insert blank or pre-filled rows at a specific position
Append rows after the last row of an existing table. **Default `insertDataOption` is `OVERWRITE`** — set `INSERT_ROWS` to push existing rows down
Write values to a single range (overwrites existing content)
Copy a sheet to a different spreadsheet
Unmerge previously merged cells in a range
Return column widths, row heights, frozen column/row counts, and hidden flags for every column and row
Remove a chart from a spreadsheet
Master one-shot tool — returns all structural and formatting metadata (merges, dimensions, conditional formatting, and optionally cell formatting) in a single API call. Supports `fields` filter and `compactMode` to limit response size
Read the Basic Filter (AutoFilter) configuration for a sheet, including filtered range, sort specs, and per-column filter criteria (hidden values, conditions, colour filters)
Implementing and auditing GCP VPC firewall rules to enforce network segmentation, restrict ingress and egress traffic, apply hierarchical firewall policies across the organization, and monitor firewall rule effectiveness using VPC Flow Logs.
Auditing Google Cloud Platform IAM permissions to identify overly permissive bindings, primitive role usage, service account key proliferation, and cross-project access risks using gcloud CLI, Policy Analyzer, and IAM Recommender.
Configuring Google Cloud Identity-Aware Proxy (IAP) to enforce per-request identity verification for Compute Engine, App Engine, Cloud Run, and GKE services using access levels, context-aware policies, and programmatic access with service accounts.
Implement GCP Binary Authorization to enforce deploy-time security controls that ensure only trusted, attested container images are deployed to Google Kubernetes Engine and Cloud Run.
Sample code and notebooks for Generative AI on Google Cloud, with Gemini Enterprise Agent Platform
The secure gateway connecting AI agents to enterprise systems.
DecisionBox connects to your data warehouse, runs autonomous AI agents that write and execute SQL, and surfaces validated insights and actionable recommendations — without you asking a single question.
Learn how to use the cloud-gcp Claude skill. Complete guide with installation instructions and examples.
Learn how to use the implementing-gcp-vpc-firewall-rules Claude skill. Complete guide with installation instructions and examples.
Learn how to use the auditing-gcp-iam-permissions Claude skill. Complete guide with installation instructions and examples.