general MCP Server
Advanced MCP server for Google Sheets — charts, pivot tables, formulas, formatting, and analytics
Discovered via smithery and last synced 3mo ago.
1. Install the package
npx -y mcp-google-sheets-advanced
2. Add to claude_desktop_config.json
{
"mcpServers": {
"-vic08-mcp-google-sheets-advanced": {
"command": "npx",
"args": [
"@vic08/mcp-google-sheets-advanced"
]
}
}
}Config file location: ~/Library/Application Support/Claude/claude_desktop_config.json (macOS) / %APPDATA%\Claude\claude_desktop_config.json (Windows)
Get spreadsheet metadata
Write values to a range
Create pivot tables
Apply/clear filters
Batch write to multiple ranges
Add conditional formatting
Get sheet properties
Add a new sheet
OAuth client ID from Google Cloud Console
List accessible spreadsheets
Remove charts
Description
List filter views
Path to store OAuth tokens
Analyze trends with linear regression
Description
Delete a sheet
Find duplicate values
Set data validation rules
Find and replace
Protect ranges
Get formulas from a range
Batch read multiple ranges
Clear values from a range
Compute summary statistics
OAuth client secret
Read cell values from a range
Append rows to a table
Format cells (fonts, colors, borders)
List charts
Modify existing charts
Sort data
List named ranges
Create charts (15 types)
Create named ranges
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.