Google Sheets MCP Server

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
const mcpConfig = new MCPConfiguration({
  servers: {
    // Example 1: HTTP-based server (e.g., external web service or API gateway)
    server: {
      type: "http",
      url: "https://actions.zapier.com/mcp/YOUR_MCP_KEY/sse",
    },
  },
});

// Fetch all tools from all configured MCP servers into a flat array
const allTools = await mcpConfig.getTools();

const agent = new Agent({
  name: "MCP Agent",
  instructions: "An assistant that can use MCP tools configured at startup",
  llm: new VercelAIProvider(),
  model: openai("gpt-4o"),
  tools: allTools, // Add MCP tools during initialization
});

// Remember to disconnect later
// await mcpConfig.disconnect();