Google Sheets (OAuth) Connector for AI agents.
7 live capabilities
Automate spreadsheet data entry and reporting with your AI agent.
Waiting for input…
Why people use Google Sheets (OAuth)
Google Sheets (OAuth) Spreadsheet Data Automation
With this Connector, you just tell your agent what to do. You can ask it to grab data from a specific range, add a new entry to a log, or create a brand-new sheet for a new project. It handles the clicking and navigation for you, so you can stay focused on the actual work instead of the data entry.
What Vinkius changes
You get a direct line between your AI agent and your Google Sheets data without any manual data entry.
Use it from Claude, ChatGPT, Cursor or another AI client you already have.
One account · 5,900+ Connectors
- Real-world use case 01
Updating a sales log
A salesperson asks the agent to add a new row to the Q3 Sales sheet with the latest figures.
- Real-world use case 02
Summarizing inventory
A warehouse manager asks the agent to pull stock levels from three different sheets into a summary table.
- Real-world use case 03
Creating project trackers
A PM asks the agent to make a new sheet for Project X and add the first five tasks to the first tab.
Complete set · 7capabilities
The complete Google Sheets (OAuth) capability set.
These are the exact actions your AI can choose when you ask it to work with Google Sheets (OAuth).
01—04
4 capabilities in this set.
Part of 7 available through Google Sheets (OAuth).
- 01 Capability
Sheets.info
Get the title, timezone, and list of all tabs for a specific spreadsheet. It helps your agent understand the workbook structure.
- 02 Capability
Sheets.read
Pull cell values from a specific range using A1 notation like Sheet1!A1:B10. It returns the data in a clean format.
- 03 Capability
Sheets.batch read
Grab data from several different areas of a sheet in one go. This is much faster than calling read multiple times.
- 04 Capability
Sheets.write
Overwrite specific cells with new data or formulas. It uses user entered input so formulas will evaluate correctly.
05—07
3 capabilities in this set.
Part of 7 available through Google Sheets (OAuth).
- 05 Capability
Sheets.append
Add new rows to the bottom of your existing tables. This keeps your old data safe while adding new entries.
- 06 Capability
Sheets.clear
Remove all text and numbers from a range. It preserves your colors and borders so you don't lose your formatting.
- 07 Capability
Sheets.create
Generate a brand-new blank spreadsheet with a title you choose. It returns the ID and a direct edit link.
Set up in minutes
One URL. Then ask Google Sheets (OAuth) to work.
Claude and ChatGPT only need the Connector URL. Copy it once, add it in settings, and use Google Sheets (OAuth) from the conversation.
Choose your client
Live previewAdvanced clients IDE · CLI
Claude · Web + desktop
Connector URL · ready to paste
Streamable HTTPhttps://edge.vinkius.com/vk_preview_WRZzfv7tD5Iq0uGPYkA47NxkBfDiDeHJTMYzqLBk/mcp - Step 01
Open Connectors
In Claude Web or Claude Desktop, open Settings and choose Connectors.
- Step 02
Add the URL
Choose Add custom connector, name it Google Sheets (OAuth), and paste the URL above.
- Step 03
Turn it on in chat
Select +, open Connectors, and enable Google Sheets (OAuth) for the conversation.
ChatGPT · Web + desktop
Connector URL · ready to paste
Streamable HTTPhttps://edge.vinkius.com/vk_preview_WRZzfv7tD5Iq0uGPYkA47NxkBfDiDeHJTMYzqLBk/mcp - Step 01
Open MCP settings
On desktop, open Settings and MCP servers. On web, open your workspace app or connector settings.
- Step 02
Add the URL
Choose Add server with Streamable HTTP, or create a custom MCP app, then paste the Google Sheets (OAuth) URL.
- Step 03
Save and start
Save the connection and enable Google Sheets (OAuth) in your conversation. Desktop may ask you to restart once.
Cursor · IDE configuration
Advanced setup
{
"mcpServers": {
"google-sheets-oauth": {
"url": "https://edge.vinkius.com/vk_preview_WRZzfv7tD5Iq0uGPYkA47NxkBfDiDeHJTMYzqLBk/mcp"
}
}
} - Step 01
Open MCP Settings
Press Cmd+Shift+P (macOS) or Ctrl+Shift+P (Windows/Linux) → search "MCP Settings"
- Step 02
Add the server config
Paste the JSON configuration above into the mcp.json file that opens
- Step 03
Save the file
Cursor will automatically detect the new Connector
- Step 04
Start using Google Sheets (OAuth)
Open Agent mode in chat and ask: "Using Google Sheets (OAuth), help me...". 7 tools available
VS Code Copilot · IDE configuration
Advanced setup
{
"mcpServers": {
"google-sheets-oauth": {
"url": "https://edge.vinkius.com/vk_preview_WRZzfv7tD5Iq0uGPYkA47NxkBfDiDeHJTMYzqLBk/mcp"
}
}
} - Step 01
Create MCP config
Create a .vscode/mcp.json file in your project root
- Step 02
Add the server config
Paste the JSON configuration above
- Step 03
Enable Agent mode
Open GitHub Copilot Chat and switch to Agent mode using the dropdown
- Step 04
Start using Google Sheets (OAuth)
Ask Copilot: "Using Google Sheets (OAuth), help me...". 7 tools available
Windsurf · IDE configuration
Advanced setup
{
"mcpServers": {
"google-sheets-oauth": {
"url": "https://edge.vinkius.com/vk_preview_WRZzfv7tD5Iq0uGPYkA47NxkBfDiDeHJTMYzqLBk/mcp"
}
}
} - Step 01
Open MCP Settings
Go to Settings → MCP Configuration or press Cmd+Shift+P and search "MCP"
- Step 02
Add the server
Paste the JSON configuration above into mcp_config.json
- Step 03
Save and reload
Windsurf will detect the new server automatically
- Step 04
Start using Google Sheets (OAuth)
Open Cascade and ask: "Using Google Sheets (OAuth), help me...". 7 tools available
Cline · IDE configuration
Advanced setup
{
"mcpServers": {
"google-sheets-oauth": {
"url": "https://edge.vinkius.com/vk_preview_WRZzfv7tD5Iq0uGPYkA47NxkBfDiDeHJTMYzqLBk/mcp"
}
}
} - Step 01
Open Cline MCP Settings
Click the Connectors icon in the Cline sidebar panel
- Step 02
Add remote server
Click "Add Connector" and paste the configuration above
- Step 03
Enable the server
Toggle the server switch to ON
- Step 04
Start using Google Sheets (OAuth)
Ask Cline: "Using Google Sheets (OAuth), help me...". 7 tools available
Claude Code · Terminal command
Advanced setup
claude mcp add google-sheets-oauth --transport http "https://edge.vinkius.com/vk_preview_WRZzfv7tD5Iq0uGPYkA47NxkBfDiDeHJTMYzqLBk/mcp" - Step 01
Install Claude Code
Run npm install -g @anthropic-ai/claude-code if not already installed
- Step 02
Add the Connector
Run the command above in your terminal
- Step 03
Verify the connection
Run claude mcp to list connected servers, or type /mcp inside a session
- Step 04
Start using Google Sheets (OAuth)
Ask Claude: "Using Google Sheets (OAuth), show me...". 7 tools are ready
Where the request belongs
Work Google Sheets can move forward.
This is for anyone whose workday is buried in rows and columns. If you're tired of jumping between tabs to update trackers or move data into reports, this is for you.
Data Analyst
Pulls data from multiple sheets to create summaries without manual exports.
Operations Manager
Updates project trackers and logs in real-time via voice or text.
Finance Clerk
Populates monthly expense logs and audits sheet metadata for consistency.
Build the capability set
Add more capabilities.
Each Connector adds new actions and data without changing how you work.
Browse ConnectorsGoogle Sheets
Interact with Google Sheets to read, write, and manipulate data via AI.
Zoho Sheet
Connect your AI agents to Zoho Sheet for spreadsheet management: workbooks, worksheets, cell data, rows, and sharing.
Smartsheet
Manage sheets, reports, and rows on Smartsheet with AI agents.
Rows
Automate spreadsheets via Rows.com. manage tables, data values, and folders with AI agents.
Retable
Organize data in smart spreadsheets with relational views, team collaboration, and workflow automation that goes beyond basic tables.
Coda
Combine docs, spreadsheets, and apps into powerful all-in-one documents that grow with your team and automate routine work.
Bring your own AI
Change the model, client or framework. Keep Google Sheets connected.
-
Claude -
ChatGPT -
Gemini -
Cursor -
VS Code -
Windsurf -
ZCode -
Cline -
Zed -
Continue -
Kiro -
Roo Code -
Zencoder -
Goose -
Void -
Augment Code -
Amp -
Qodo -
Tabnine -
Pieces -
Sourcegraph Cody -
JetBrains -
Warp -
Amazon Q -
Antigravity -
BoltAI -
Raycast -
Jan -
LM Studio -
AnythingLLM -
Open WebUI -
Msty -
Cherry Studio -
LibreChat -
TypingMind -
Chorus -
5ire -
n8n -
LangChain -
LlamaIndex -
CrewAI -
Vercel AI SDK
Before you connect
Questions about Google Sheets.
The practical details behind the request, access and result.
Can Google Sheets (OAuth) help me update my trackers automatically?
Yes. You can tell your agent to add new rows or update specific cells in your trackers without ever opening the spreadsheet yourself.
Does Google Sheets (OAuth) preserve my cell colors and borders?
Yes, the clear capability removes the content of the cells but keeps your formatting, like colors and borders, exactly as they were.
Can I use Google Sheets (OAuth) to create new files?
You can. Your agent can create a brand-new blank spreadsheet with any title you give it and provide you with the link immediately.
Is it possible to read multiple ranges at once with Google Sheets (OAuth)?
Yes, your agent can pull data from several different areas of a sheet or different sheets in one step to save time.
How do I give the AI permission to access my sheets?
You'll need to provide a Google OAuth2 token. This gives your agent the specific permission it needs to read and write to your files.
Can the AI agent find my sheet IDs automatically?
It can pull metadata like the title and tab names, which helps your agent understand the structure of your workbook before it starts working.
How do I get a Google OAuth2 access token for this server?
You can use the Google OAuth Playground (select Sheets API v4 and authorize) or run 'gcloud auth print-access-token' in your terminal. Note that these tokens are typically valid for 1 hour.
Can my agent create a new spreadsheet and add data to it in one go?
Yes. The agent can orchestrate multiple operations. First, use 'create_spreadsheet' to get the new ID, and then use 'write_data' or 'append_data' to populate it with your JSON arrays natively.
What is the benefit of batch reading through the agent?
Batch reading allowing your agent to retrieve data from multiple non-contiguous ranges (e.g., 'Sheet1!A1:B10' and 'Sheet2!C5:D15') in a single request, improving context efficiency and reasoning accuracy flawlessly.
One connection away
Give your agent a direct line to Google Sheets.
Connect Google Sheets once. Keep it beside 5,900+ managed Connectors when the next task needs more.
Explore every Connector No credit card required · Free tier available