How do I use mcp-google-sheets-server?

1. Click on "Install Server". 2. Wait a few minutes for the server to deploy. Once ready, it will show a "Started" state. 3. In the chat, type @ followed by the MCP server name and your instructions, e.g., "@mcp-google-sheets-server Create a chart from the sales data in range A1:F20" That's it! The server will respond to your query, and you can continue using it as needed. Here is a step-by-step guide with screenshots.

mcp-google-sheets-server

by Longtran2404

Overview Schema Related Servers Score Discussions

JavaScript

🚀 MCP Google Sheets Server v2.1.0

Complete MCP Server for Google Sheets - 40+ tools for professional sheet management, advanced charts, and enterprise features!

npm version npm downloads License: MIT TypeScript

✨ NEW in v2.1.0 - Complete Sheet Management & Enhanced Charts!

📋 Complete Sheet Management - Create, rename, hide/show, move, duplicate, delete sheets
📊 Advanced Chart Creation - Create charts with data, from tables, update chart data
🔍 Sheet Information - Get detailed sheet properties, list all sheets
🎨 Professional Formatting - Colors, fonts, borders, conditional formatting
🔒 Data Protection - Validation rules, range protection, access control
⚡ Performance Optimized - Batch operations, efficient API usage
🚀 Enterprise Ready - 40+ tools for professional Google Sheets management

Related MCP server: Google Docs, Drive & Sheets MCP Server

🚀 Quick Installation

Method 1: Install from npm (Recommended)

npm install -g mcp-google-sheets-server

Method 2: Local installation

npm install mcp-google-sheets-server

Method 3: Use npx (No installation needed)

npx mcp-google-sheets-server

🔐 Google Service Account Authentication

Detailed Guide

See GOOGLE_SERVICE_ACCOUNT_SETUP.md for step-by-step instructions on how to get Google Service Account Key.

Quick Configuration

{
  "mcpServers": {
    "mcp-google-sheets": {
      "command": "npx",
      "args": ["mcp-google-sheets-server"],
      "env": {
        "GOOGLE_SERVICE_ACCOUNT_KEY": "your-service-account-json"
      }
    }
  }
}

📋 Complete Tool Collection (40+ Tools!)

🔧 Basic Operations

Tool	Description	Parameters
`sheets_get_data`	Get data with formatting options	`spreadsheetId`, `range`, `valueRenderOption`, `dateTimeRenderOption`
`sheets_update_data`	Update data with input options	`spreadsheetId`, `range`, `values`, `valueInputOption`
`sheets_create`	Create spreadsheet with theme	`title`, `initialData`, `theme`

🎨 Advanced Formatting

Tool	Description	Parameters
`sheets_format_cells`	Apply professional formatting	`spreadsheetId`, `range`, `backgroundColor`, `textColor`, `fontSize`, `bold`, `italic`, `alignment`, `borders`
`sheets_conditional_formatting`	Set conditional rules	`spreadsheetId`, `range`, `ruleType`, `value`, `colors`
`sheets_merge_cells`	Merge cells with options	`spreadsheetId`, `range`, `mergeType`

📈 Enhanced Charts & Visualization

Tool	Description	Parameters
`sheets_create_chart`	Create basic charts	`spreadsheetId`, `chartType`, `dataRange`, `title`, `position`
`sheets_create_chart_with_data`	Create charts with data	`spreadsheetId`, `chartType`, `dataRange`, `title`, `position`, `chartOptions`
`sheets_create_chart_from_table`	Create charts from tables	`spreadsheetId`, `chartType`, `tableRange`, `title`, `useFirstRowAsLabels`
`sheets_update_chart`	Update existing charts	`spreadsheetId`, `chartId`, `title`, `dataRange`
`sheets_update_chart_data`	Update chart data	`spreadsheetId`, `chartId`, `newDataRange`, `updateTitle`
`sheets_delete_chart`	Delete charts	`spreadsheetId`, `chartId`
`sheets_list_charts`	List all charts	`spreadsheetId`

📋 Complete Sheet Management

Tool	Description	Parameters
`sheets_create_sheet`	Create new sheets	`spreadsheetId`, `title`, `index`
`sheets_duplicate_sheet`	Duplicate existing sheets	`spreadsheetId`, `sheetId`, `newTitle`
`sheets_delete_sheet`	Delete sheets	`spreadsheetId`, `sheetId`
`sheets_rename_sheet`	Rename sheets	`spreadsheetId`, `sheetId`, `newTitle`
`sheets_hide_sheet`	Hide sheets from view	`spreadsheetId`, `sheetId`
`sheets_show_sheet`	Show hidden sheets	`spreadsheetId`, `sheetId`
`sheets_move_sheet`	Move sheets to new position	`spreadsheetId`, `sheetId`, `newIndex`
`sheets_get_sheet_info`	Get all sheet information	`spreadsheetId`, `includeGridData`
`sheets_get_sheet_properties`	Get specific sheet properties	`spreadsheetId`, `sheetId`

🔒 Data Validation & Protection

Tool	Description	Parameters
`sheets_set_data_validation`	Set validation rules	`spreadsheetId`, `range`, `ruleType`, `values`, `message`
`sheets_protect_range`	Protect ranges from editing	`spreadsheetId`, `range`, `description`, `warningOnly`

📊 Advanced Data Operations

Tool	Description	Parameters
`sheets_insert_rows`	Insert rows at position	`spreadsheetId`, `sheetId`, `startIndex`, `endIndex`
`sheets_insert_columns`	Insert columns at position	`spreadsheetId`, `sheetId`, `startIndex`, `endIndex`
`sheets_delete_rows`	Delete rows from position	`spreadsheetId`, `sheetId`, `startIndex`, `endIndex`
`sheets_delete_columns`	Delete columns from position	`spreadsheetId`, `sheetId`, `startIndex`, `endIndex`

📐 Formula & Calculation

Tool	Description	Parameters
`sheets_set_formula`	Set formulas in cells	`spreadsheetId`, `range`, `formulas`
`sheets_calculate_formula`	Calculate formula results	`spreadsheetId`, `formula`

⚡ Batch Operations

Tool	Description	Parameters
`sheets_batch_update`	Multiple operations in one request	`spreadsheetId`, `requests`
`sheets_batch_get`	Get data from multiple ranges	`spreadsheetId`, `ranges`, `valueRenderOption`

Tool	Description	Parameters
`sheets_search`	Search spreadsheets	`query`, `maxResults`
`sheets_share`	Share with permissions	`spreadsheetId`, `email`, `role`, `message`
`sheets_get_metadata`	Get comprehensive metadata	`spreadsheetId`, `includeGridData`

🧹 Utility Operations

Tool	Description	Parameters
`sheets_clear_range`	Clear content and formatting	`spreadsheetId`, `range`
`sheets_copy_to`	Copy sheets between spreadsheets	`spreadsheetId`, `sheetId`, `destinationSpreadsheetId`

🛠️ Advanced Setup Examples

Create Professional Spreadsheet with Multiple Sheets

{
  "mcpServers": {
    "mcp-google-sheets": {
      "command": "npx",
      "args": ["mcp-google-sheets-server"],
      "env": {
        "GOOGLE_SERVICE_ACCOUNT_KEY": "your-service-account-json"
      }
    }
  }
}

📚 Advanced Usage Examples

Complete Sheet Management Workflow

// 1. Create spreadsheet
const spreadsheet = await mcp.callTool("sheets_create", {
  title: "Business Dashboard 2024",
  theme: "LIGHT",
});

// 2. Create multiple sheets
await mcp.callTool("sheets_create_sheet", {
  spreadsheetId: spreadsheet.spreadsheetId,
  title: "Sales Data",
  index: 1,
});

await mcp.callTool("sheets_create_sheet", {
  spreadsheetId: spreadsheet.spreadsheetId,
  title: "Charts",
  index: 2,
});

// 3. Add data to Sales Data sheet
await mcp.callTool("sheets_update_data", {
  spreadsheetId: spreadsheet.spreadsheetId,
  range: "Sales Data!A1:D6",
  values: [
    ["Month", "Revenue", "Expenses", "Profit"],
    ["January", 50000, 30000, 20000],
    ["February", 55000, 32000, 23000],
    ["March", 60000, 35000, 25000],
    ["April", 65000, 38000, 27000],
    ["May", 70000, 40000, 30000],
  ],
});

// 4. Create professional chart
await mcp.callTool("sheets_create_chart_from_table", {
  spreadsheetId: spreadsheet.spreadsheetId,
  chartType: "COLUMN",
  tableRange: "Sales Data!A1:D6",
  title: "Monthly Financial Performance",
  useFirstRowAsLabels: true,
});

// 5. Rename and organize sheets
await mcp.callTool("sheets_rename_sheet", {
  spreadsheetId: spreadsheet.spreadsheetId,
  sheetId: 0, // First sheet
  newTitle: "Summary",
});

// 6. Move Charts sheet to the end
await mcp.callTool("sheets_move_sheet", {
  spreadsheetId: spreadsheet.spreadsheetId,
  sheetId: 2, // Charts sheet
  newIndex: 3, // Move to end
});

// 7. Hide a temporary sheet if needed
await mcp.callTool("sheets_hide_sheet", {
  spreadsheetId: spreadsheet.spreadsheetId,
  sheetId: 1, // Hide Sales Data sheet
});

Advanced Chart Management

// Create chart with custom options
await mcp.callTool("sheets_create_chart_with_data", {
  spreadsheetId: "your-spreadsheet-id",
  chartType: "LINE",
  dataRange: "A1:C10",
  title: "Trend Analysis",
  chartOptions: {
    colors: ["#4285F4", "#34A853"],
    legendPosition: "RIGHT_LEGEND",
  },
});

// Update chart data when source data changes
await mcp.callTool("sheets_update_chart_data", {
  spreadsheetId: "your-spreadsheet-id",
  chartId: 12345,
  newDataRange: "A1:C15", // Extended range
  updateTitle: "Updated Trend Analysis",
});

// List all charts in spreadsheet
const charts = await mcp.callTool("sheets_list_charts", {
  spreadsheetId: "your-spreadsheet-id",
});

// Delete unwanted charts
await mcp.callTool("sheets_delete_chart", {
  spreadsheetId: "your-spreadsheet-id",
  chartId: 12345,
});

Sheet Information and Properties

// Get information about all sheets
const sheetInfo = await mcp.callTool("sheets_get_sheet_info", {
  spreadsheetId: "your-spreadsheet-id",
  includeGridData: false,
});

// Get properties of specific sheet
const sheetProps = await mcp.callTool("sheets_get_sheet_properties", {
  spreadsheetId: "your-spreadsheet-id",
  sheetId: 0,
});

// Check if sheet is hidden
if (sheetProps.properties.hidden) {
  // Show the sheet
  await mcp.callTool("sheets_show_sheet", {
    spreadsheetId: "your-spreadsheet-id",
    sheetId: 0,
  });
}

🔧 Troubleshooting

Common errors:

Error	Solution
"GOOGLE_SERVICE_ACCOUNT_KEY not found"	• Check environment variable in mcp.json• Ensure JSON is properly escaped
"Permission denied"	• Check service account access permissions• Ensure Google Sheets are shared with service account
"Invalid credentials"	• Check service account JSON file• Ensure Google Sheets API is enabled

🚀 Advantages Over Other Solutions

✅ 40+ Advanced Tools - Most comprehensive Google Sheets MCP server
✅ Complete Sheet Management - Full control over sheets (create, rename, hide, move, delete)
✅ Enhanced Chart Creation - Create charts with data, from tables, update dynamically
✅ Professional Formatting - Colors, fonts, borders, conditional formatting
✅ Data Validation - Set rules and protect sensitive data
✅ Batch Operations - High-performance multiple operations
✅ Sheet Information - Get detailed properties and status of all sheets
✅ Performance Optimized - Efficient API usage and batch processing

📄 License

MIT License - See LICENSE file for details.

🤝 Contributing

All contributions are welcome! Please:

🍴 Fork the project
🌿 Create a feature branch (git checkout -b feature/AmazingFeature)
💾 Commit your changes (git commit -m 'Add some AmazingFeature')
🚀 Push to the branch (git push origin feature/AmazingFeature)
🔄 Open a Pull Request

📞 Support

If you encounter issues:

🔍 Check Issues first
🆕 Create a new issue if none exists
📝 Describe the problem in detail and how to reproduce it

⭐ Star the Project

If this project is helpful, please give it a star! ⭐

Made with ❤️ by Longtran2404

🚀 Now with 40+ Tools for Complete Google Sheets Management! 🚀

This server cannot be installed

license - permissive license

quality - not tested

maintenance

How are these scores calculated?

Maintenance

–Maintainers

–Response time

0dRelease cycle

2Releases (12mo)

Commit activity

Resources

Need Help?

Related Servers

Unclaimed servers have limited discoverability.

Looking for Admin?

If you are the server author, to access and configure the admin panel.

Latest Blog Posts

Who's Calling? MCP Hosts Are an Identity Blind Spot (And the Spec Knows It)
By Om-Shree-0709 on July 25, 2026.
mcp
Agent Identity
OAuth 2.1
Your AI Chatbot Just Exposed Your CEO's Salary to an Intern
By Om-Shree-0709 on July 2, 2026.
Agent Identity
MCP Security
OAuth Delegation
Why MCP Servers Need Execution Sandboxing (And Why Your Current Stack Isn't Enough)
By Om-Shree-0709 on June 30, 2026.
Agentic Ai
Prompt Injection
WebAssembly

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/Longtran2404/mcp-google-sheets'

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