Secure Google Sheets MCP Server
Secure Google Sheets is a remote MCP server that gives AI assistants controlled access to your Google Sheets. Connect it to Claude, ChatGPT, or any MCP client and let the AI read and summarize tabs, append rows, write values, create spreadsheets, and manage tabs, all routed through PortEden, the data firewall for AI. Your data. Your rules.
A raw "Google Sheets MCP" exposes every value in your spreadsheets to the model. Secure Google Sheets protects sensitive values, holds the AI to the permissions you grant, audits every write, and supports one-click revoke.
Why Secure Google Sheets
- Inspect and redact. Sensitive values are masked before any cell data reaches the AI.
- Scoped permissions. The AI only does what your token allows, per user, per AI, per project.
- One-click revoke. Cut access instantly, effective on the very next request.
- Full audit trail. Every write is logged.
- Nothing stored. No tokens, no cache, no database in the connector.
What you can do
- Read and summarize: "Read every tab in the budget sheet and summarize."
- Add rows: "Add these three rows to the sales tracker."
- Write values: "Update the Q2 totals in the forecast tab."
- Create spreadsheets: "Create a new sheet from this CSV."
- Manage tabs: "Add a 'Q3' tab to the planning sheet."
Tools (13): 5 read, 8 write
| Tool | Type | What it does |
|---|---|---|
google_sheets_search | Read | Search your spreadsheets |
google_sheets_get_metadata | Read | List tabs and properties |
google_sheets_read_all | Read | Read every tab |
google_sheets_read | Read | Read a specific range |
google_sheets_read_tab | Read | Read a single tab |
google_sheets_append | Create | Append rows |
google_sheets_create | Create | Create a new spreadsheet |
google_sheets_add_tab | Create | Add a tab |
google_sheets_copy | Create | Copy a spreadsheet |
google_sheets_write | Update | Write values to a range |
google_sheets_rename | Update | Rename a spreadsheet |
google_sheets_delete_tab | Delete | Delete a tab |
google_sheets_delete | Delete | Delete a spreadsheet |
Supported providers
Google Sheets (via Google Drive). Connect it inside PortEden.
Getting started
1 - Create a free PortEden account at https://porteden.com.
2 - Connect your Google account inside PortEden.
3 - Generate a PortEden access key (it starts with pe_mcp_) and paste it into the config above as your Bearer token.
Prefer OAuth 2.0? Add the URL https://mcp.porteden.com/google-sheets to your client with no token and sign in. For a client that needs a stdio bridge, use mcp-remote:
{
"mcpServers": {
"secure-google-sheets": {
"command": "npx",
"args": ["-y", "mcp-remote", "https://mcp.porteden.com/google-sheets"]
}
}
}
Works with
Claude (Desktop, web, and Code), ChatGPT, Microsoft Copilot, Google Gemini, Grok, and Cursor, plus any client that speaks MCP Streamable HTTP. Authentication is OAuth 2.0.
FAQ
Can the AI write to my spreadsheets? Yes, within the permissions you grant. You can keep it read-only or allow append, write, and delete.
Does the AI see sensitive numbers? Only what your permissions allow, after redaction of sensitive values.
Where is my data stored? Nowhere in the connector. It is stateless. PortEden enforces permissions, quotas, redaction, and audit logging.
Your data. Your rules. More info: https://porteden.com/
Server Config
{
"mcpServers": {
"secure-google-sheets": {
"url": "https://mcp.porteden.com/google-sheets",
"headers": {
"Authorization": "Bearer <YOUR_PORTEDEN_TOKEN>"
}
}
}
}