Orchestrate enterprise MCP AI tool access with Claude and Google Sheets
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: AI Agent v1 (old agent modes). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 18 nodes and runs when an HTTP POST request hits its webhook URL. Along the way it connects Google Sheets and Anthropic Chat Model.
How it runs
Trigger: When an HTTP POST request hits its webhook URL.
- Enterprise Auth, JWT and RBAC Validation (Code): runs custom JavaScript code
- Fetch RBAC Policies for Role and Tools (Google Sheets): uses Google Sheets
- Fetch Active Session and Prior Context (Google Sheets): uses Google Sheets
- Build Enterprise Context Package (Code): runs custom JavaScript code
- Claude AI Contextual Orchestration and Tool Planning (AI Agent): runs an AI agent, with model: Claude AI Model
- Parse Orchestration Plan and Enforce Policies (Code): runs custom JavaScript code
- Dispatch — CRM System (HTTP Request): calls an HTTP API (POST)
- Dispatch — ERP System (HTTP Request): calls an HTTP API (POST)
- Dispatch — Analytics and Data Warehouse (HTTP Request): calls an HTTP API (POST)
- Merge: merges the data from its input branches
…plus 6 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Claude AI Contextual Orchestration and Tool Planning (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Claude AI Contextual Orchestration and Tool Planning (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Webhook
n8n-nodes-base.webhook - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - AI Agent
@n8n/n8n-nodes-langchain.agent - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Send Email
n8n-nodes-base.emailSend - Respond to Webhook
n8n-nodes-base.respondToWebhook
From the author
A secure, scalable enterprise AI orchestration layer built on the Model Context Protocol (MCP). This workflow standardizes tool access across all business systems, enforces permission-based data handling, applies contextual reasoning via Claude AI, and…