Google Sheets MCP by InsightfulPipe
Hosted Google Sheets MCP server, with each action switched on or off per account.
Installation
Ajoutez ceci à la configuration MCP de votre client (Claude Desktop : claude_desktop_config.json ; Cursor : .cursor/mcp.json ; VS Code et les autres utilisent la même forme « mcpServers »).
claude mcp add --transport http google-sheets-mcp-by-insightfulpipe 'https://google-sheets.insightfulmcp.com/'{
"mcpServers": {
"google-sheets-mcp-by-insightfulpipe": {
"type": "http",
"url": "https://google-sheets.insightfulmcp.com/"
}
}
}Documentation
Tirée du README du projet sur GitHub, actualisée chaque semaine. Les liens ouvrent GitHub.
Sommaire
Google Sheets MCP Server by Insightful Pipe
Connect Google Sheets to AI assistants: read, write and format spreadsheet data.
Part of the Insightful Pipe MCP Server Collection — use Google Sheets from Claude, ChatGPT, Cursor, and other AI assistants through the Model Context Protocol (MCP).
MCP Server URL
https://google-sheets.insightfulmcp.com/What is Google Sheets MCP?
Google Sheets MCP is a remote Model Context Protocol server hosted by InsightfulPipe. Preview tabs, headers, and targeted ranges from connected Google Sheets to pair manual data with AI workflows.
Installation
Claude
- Copy the MCP Server URL:
https://google-sheets.insightfulmcp.com/ - Open Claude Connectors Settings
- Scroll to the bottom and click Add custom connector
- Paste the URL and click Add
- Click Connect and sign in to InsightfulPipe if asked. Claude then lists the connector as connected.
ChatGPT
Custom MCP servers are added through ChatGPT's Developer mode. Availability depends on your ChatGPT plan, and workspace admins may need to allow it.
- Turn on Developer mode in ChatGPT settings
- Create a new app for a remote MCP server and paste the URL:
https://google-sheets.insightfulmcp.com/ - Sign in to InsightfulPipe if asked. The connection finishes as soon as you are signed in.
See OpenAI's guide: Developer mode and MCP apps in ChatGPT
Claude Code
claude mcp add --transport http google-sheets https://google-sheets.insightfulmcp.com/Cursor
Add the server to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (one project):
{
"mcpServers": {
"google-sheets": {
"url": "https://google-sheets.insightfulmcp.com/"
}
}
}When Cursor shows Needs authentication, click Connect and sign in to InsightfulPipe if asked.
Available Actions
26 actions: 3 read, 23 write.
Read Actions (3)
| Action | Description |
|---|---|
get_sheet_peak | Peek at sheet to see available columns and sample data |
list_sheets | List sheet/tab metadata inside a spreadsheet (sheet_id, title, index, optional gridProperties) |
query_sheet_data | Query sheet data with SQL-like operations (SELECT, WHERE) |
Write Actions (23)
| Action | Description |
|---|---|
add_banding | Apply alternating (banded) row colours to a range |
add_conditional_format | Add a conditional formatting rule (colour scale or boolean condition) to a range |
add_filter_view | Create a named saved filter view that can be activated later |
add_named_range | Create a named range that can be referenced in formulas across the spreadsheet |
add_protected_range | Lock a cell range so that only editors you choose can modify it |
add_rows | Insert blank rows into a sheet (default inserts at the end) |
add_slicer | Add an interactive slicer (filter control) anchored to a sheet |
auto_resize | Auto-fit column widths or row heights to content |
batch_update_cells | Update multiple ranges in a single call by providing a mapping of range => 2D array of values |
create_chart | Add an embedded chart (bar, line, pie, column, area, scatter) to a sheet |
create_sheet | Add a new tab to an existing spreadsheet with optional row/column counts and index |
delete_chart | Remove an embedded chart from the spreadsheet |
duplicate_sheet | Clone an existing sheet tab into a new tab within the same spreadsheet |
format_cells | Apply formatting (bold, colours, fonts, number formats, alignment) to a cell range |
merge_cells | Merge a range of cells into one |
set_basic_filter | Set the basic auto-filter on a sheet range (shows filter dropdowns in column headers) |
set_data_validation | Add a data validation rule (drop-down list, number constraint, etc.) to a range |
sort_range | Sort a range of cells by one or more columns |
unmerge_cells | Unmerge previously merged cells in a range |
update_borders | Set or clear borders on a cell range |
update_cells | Overwrite a contiguous range of cells with the provided 2D array of values |
update_sheet_properties | Rename a tab, change its tab colour, freeze rows/columns, or hide/show it |
update_slicer | Modify an existing slicer's column index or data range |
Control What Your AI Can Do
You decide what AI agents can do with each connected account:
- Turn individual actions on or off for every connected account, so agents only see the actions you allow.
- Connect as Read-only or Read & Write. A read-only connection can only enable read actions.
- Destructive actions stay off by default. Actions such as deletes are disabled until an admin enables them.
- Team access per account. Restricted team members only use the accounts they are granted, with the read actions enabled on them.
Usage Examples
"Summarize the tabs and headers in my "Q3 Budget" spreadsheet""Add a row to the Leads sheet with today's form submissions""Create a chart of monthly revenue"Pricing
The Google Sheets MCP server is included in every InsightfulPipe plan, together with all other MCP servers and the CLI. Plans start at $29.99/month, and you can try it for 7 days. See insightfulpipe.com/pricing for current plans.
Ready-Made Skills and Prompts
Explore More MCP Servers by Insightful Pipe
Visit insightfulpipe.com/mcp-servers to discover our full collection of MCP servers.
Resources
Support
- Documentation: insightfulpipe.com/docs
- All MCP Servers: insightfulpipe.com/mcp-servers
- Email: support@insightfulpipe.com
Insightful Pipe — AI-powered marketing analytics through MCP servers. Explore all integrations →
License
MIT License - see LICENSE for details.
Questions fréquentes
Qu'est-ce que Google Sheets MCP by InsightfulPipe ?
Hosted Google Sheets MCP server, with each action switched on or off per account.
Comment installer Google Sheets MCP by InsightfulPipe ?
Il fonctionne comme serveur distant. Dans Claude Code : claude mcp add --transport http google-sheets-mcp-by-insightfulpipe 'https://google-sheets.insightfulmcp.com/'. Pour les autres clients, collez la configuration JSON de cette page dans leurs réglages MCP.
Faut-il une clé API pour Google Sheets MCP by InsightfulPipe ?
Son entrée au registre n'indique aucune clé ni secret obligatoire. Certaines fonctions peuvent tout de même demander un compte auprès du service auquel il se connecte.
Google Sheets MCP by InsightfulPipe est-il open source ?
Oui. Son code est sur GitHub sous licence MIT.
Qui maintient Google Sheets MCP by InsightfulPipe ?
Il est publié par Insightful-Pipe. AI.tn le référence sans le maintenir ni le recommander.
Issu du registre MCP officiel. Être listé n'est pas une recommandation : vérifiez le code et les permissions d'un serveur avant de lui donner accès à vos données.