Answer BigQuery questions in Microsoft Teams with Claude 3.5 dual agents
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 27 nodes and runs on Microsoft Teams events (plus 1 other trigger). Along the way it connects Microsoft Teams, Google BigQuery and Anthropic.
How it runs
Trigger: On Microsoft Teams events (plus 1 other trigger).
- Validate Teams Message (Code): runs custom JavaScript code
- Format Error Message (Code): runs custom JavaScript code
- Configure Variables (Code): runs custom JavaScript code
- Send Error Notification to Teams (Microsoft Teams): send message
- Check Schema Cache Validity (Code): runs custom JavaScript code
- If: checks a condition and branches into true / false
- Ensure Schema Availability (Code): runs custom JavaScript code
- Create Schema Query Statement (Code): runs custom JavaScript code
- Build Main Agent Query Prompt (Code): runs custom JavaScript code
- Fetch Schema from BigQuery (Google BigQuery): uses Google BigQuery
…plus 15 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Rarely used nodes in this template: n8n-nodes-base.microsoftTeamsTrigger
Nodes used (7)
- Microsoft Teams Trigger
n8n-nodes-base.microsoftTeamsTrigger - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - Google BigQuery
n8n-nodes-base.googleBigQuery - Anthropic
@n8n/n8n-nodes-langchain.anthropic - Microsoft Teams
n8n-nodes-base.microsoftTeams - Error Trigger
n8n-nodes-base.errorTrigger
From the author
Quick overview Turn Microsoft Teams into a natural language BI tool. This dual-agent Claude workflow intelligently classifies user questions, generates safe BigQuery SQL, executes the query, and returns a plain-English summary alongside a data preview…