How to Use the Google Sheets MCP in Mastra AI

Q: Can I require manual approval before Mastra AI modifies Google Sheets?

Yes, you can set requireToolApproval on tools like deletesheet or clearsheetvalues to ensure a human approves the change before Mastra AI runs it.

Build reliable, self-healing Google Sheets workflows with Mastra AI agents.

See Vinkius in Action

Works with every AI agent you already use

…and any MCP-compatible client

MCP Servers - Free for Subscribers

Connect Google Sheets MCP to Mastra AI

Create your Vinkius account to connect Google Sheets to Mastra AI and route execution through our secure gateway. The platform manages server hosting, runtime updates, and security layers. Configuration requires no manual server provisioning.

GDPR Free for Subscribers

Setup Google Sheets with Mastra AI

Ask AI about this MCP

ChatGPT

Claude

Perplexity

Log Mastra AI step results directly to Google Sheets

Mastra AI excels at running multi-step pipelines with this Google Sheets MCP Server. By equipping your agents with `append_sheet_values`, they can write execution logs, transaction records, or system states straight into a Google Sheets row as they happen. If a write fails due to network issues, Mastra AI handles it. The framework's built-in retry mechanics ensure that calls to `update_sheet_values` are retried automatically, keeping your sheet in sync with your system state.

Let Mastra AI manage spreadsheet layouts

Your agents can dynamically adapt their storage. When a workflow starts a new project, Mastra AI can run `create_spreadsheet` and `add_sheet` to set up dedicated workspaces for different teams. For complex setups, the agent can use `batch_update_spreadsheet` to organize tabs, set up validation rules, or format cells. It turns Google Sheets into a structured, agent-managed database.

Run high-volume Mastra AI tasks with this MCP Server

Processing data row-by-row is slow and triggers rate limits. Mastra AI can use `batch_get_values` to read large chunks of your spreadsheet in one go, processing everything in memory before writing back. Once the agent finishes its calculations, it can clear old data with `clear_sheet_values` and write the fresh results back. It keeps your workflows fast and your Google API quotas safe.

Setup guide

Set up Google Sheets MCP in Mastra AI

Prerequisites

Node.js 18+ and a TypeScript project
@mastra/mcp + @mastra/core packages
Active Vinkius subscription with a valid endpoint token

1

Install dependencies
Run npm install @mastra/mcp @mastra/core plus your preferred model provider (e.g. @ai-sdk/openai).
2

Configure the MCPClient
Create an MCPClient with your Vinkius endpoint as a URL object. Replace [YOUR_TOKEN_HERE] with your token from cloud.vinkius.com.
3

Discover and inject tools
Call mcpClient.listTools() and spread the result into your agent's tools object. All Google Sheets tools become native Mastra tools.
4

Run with any model
Swap openai("gpt-4o") for any AI SDK-compatible provider. Call agent.generate() and the agent routes tool calls through MCP automatically.

agent.ts

import { MCPClient } from "@mastra/mcp";
import { Agent } from "@mastra/core/agent";
import { openai } from "@ai-sdk/openai";

const mcpClient = new MCPClient({
  id: "google-sheets-mcp-client",
  servers: {
    "google-sheets-mcp": {
      url: new URL(
        "https://edge.vinkius.com/[YOUR_TOKEN_HERE]/mcp"
      ),
    },
  },
});

const agent = new Agent({
  name: "Google Sheets Agent",
  model: openai("gpt-4o"),
  instructions: "You have access to Google Sheets tools.",
  tools: {
    ...(await mcpClient.listTools()),
  },
});

const result = await agent.generate(
  "List recent Google Sheets transactions"
);
console.log(result.text);

Get your connection token →

Independent Platform Disclaimer: Vinkius is an independent platform and is not affiliated with, endorsed by, sponsored by, verified by, or otherwise authorized by Google Sheets. All third-party trademarks, logos, and brand names are the property of their respective owners. Their use on this website is strictly for informational purposes to identify service compatibility and interoperability.

Why Choose Vinkius

Vinkius connects your tools to AI with real-time monitoring and automatic cost savings — all from one dashboard.

Connect Google Sheets now

Real-time monitoring

Live

visibility into every interaction

Connect your favorite tools to your AI and see exactly what's happening — every request, every response, in real time.

Built-in savings

60%

lower AI costs

Vinkius compresses data between your apps and your AI automatically. Lower bills every month — no configuration required.

Single dashboard

One

place for every integration

Every tool your AI connects to, managed from a single screen. One account, complete control.

Common questions about Google Sheets MCP in Mastra AI

Mastra AI uses its built-in workflow engine to retry failed tool calls. If `append_sheet_values` fails, the agent retries with exponential backoff before raising an error.

Yes, you can set `requireToolApproval` on tools like `delete_sheet` or `clear_sheet_values` to ensure a human approves the change before Mastra AI runs it.

You initialize the client using the Vinkius URL and add it to your Mastra AI agent config. The agent automatically discovers tools like `get_sheet_values`.

Yes, the client connects over HTTP or SSE, making it lightweight enough to run inside any serverless function where you deploy Mastra AI.

Vinkius manages the MCP connection securely, passing your credentials directly to the Google Sheets API without storing them on disk. Your sheet cells remain private.

Use it with your favorite AI tools

Connect this server to Cursor, Claude, VS Code, and more.

OpenAI Agents SDK sdk-python

Google ADK sdk-python

Pydantic AI sdk-python

Vercel AI SDK sdk-typescript