Executable connectorDatabaseJul 22, 20260 calls

Google Sheets Connector

OAuth-connected Google Sheets metadata, range reads, appends, and updates.

Credential setup

oauth2

Request spreadsheets.readonly, adding spreadsheets only when writes are enabled.

Setup docs: https://console.cloud.google.com/apis/credentials

After adding this connector, attach the credential on the server page, then run astrail tools list.

Hosted MCP endpoint

/api/mcp/preset-google-sheets

Private servers require an Astrail API key in the Authorization header.

MCP client snippets

Connect

Claude Desktop config

{
  "mcpServers": {
    "google-sheets-connector": {
      "url": "/api/mcp/preset-google-sheets"
    }
  }
}

cURL initialize

curl -sS -X POST "/api/mcp/preset-google-sheets" \
  -H 'Content-Type: application/json' \
  --data '{"jsonrpc":"2.0","id":1,"method":"initialize","params":{}}'

cURL tools/list

curl -sS -X POST "/api/mcp/preset-google-sheets" \
  -H 'Content-Type: application/json' \
  --data '{"jsonrpc":"2.0","id":2,"method":"tools/list","params":{}}'

cURL tools/call

curl -sS -X POST "/api/mcp/preset-google-sheets" \
  -H 'Content-Type: application/json' \
  --data '{"jsonrpc":"2.0","id":3,"method":"tools/call","params":{"name":"sheets_get_spreadsheet","arguments":{"spreadsheet_id":1,"includeGridData":1}}}'

Runtime behavior

Runtime healthhealthy

Endpoint healthnot_checked

Execution modesafe_rest_execution

Deterministic executionSupported

Generated sourceExport only

Endpoint mapAvailable

Endpoint mappedYes

Auth-required endpointsPresent

Browser runtime endpointsNone detected

Last statusnot recorded

Last execution modenot recorded

Last toolnot recorded

Last latencynot recorded

Upstream statusnot recorded

Trace IDnot recorded

Error codenone

Observabilitystructured fallback

Rate limit modestandard

Missing authauth_required / oauth_required

Missing mappingmapping_required

Astrail does not evaluate generated TypeScript inside Next.js. Hosted calls are routed through stored tool metadata and endpoint maps.

Tools

sheets_get_spreadsheet

Retrieve Google Sheets spreadsheet metadata.

sheets_read_range

Read values from a Google Sheets range.

sheets_append_row

Append values to a Google Sheet after approval.

sheets_update_cells

Update a Google Sheets range after approval.

server.ts

import { McpServer } from "@modelcontextprotocol/sdk/server/mcp.js";
import { StdioServerTransport } from "@modelcontextprotocol/sdk/server/stdio.js";
import { z } from "zod";

const server = new McpServer({ name: "Google Sheets Connector", version: "1.0.0" });

// Curated Astrail connector for: sheets_get_spreadsheet, sheets_read_range, sheets_append_row, sheets_update_cells.
// The hosted endpoint executes its verified deterministic endpoint map. Attach a least-privilege provider credential before calling private tools.

server.tool("connector_status", "Confirm this curated connector template is installed.", z.object({}), async () => ({
  content: [{ type: "text", text: "Connector installed. Attach provider credentials to enable hosted API calls." }],
}));

const transport = new StdioServerTransport();
await server.connect(transport);