Build an AI-powered tech radar advisor with SQL DB, RAG, and routing agents
Needs changesNeeds changes. This template uses 2 thing(s) that n8n 3.0 removes: Cron, AI Agent v1 (old agent modes). 2 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 37 nodes and runs on a schedule (legacy Cron node) (plus 3 other triggers). Along the way it connects Google Drive, MySQL, Google Sheets and Google Docs and 6 more.
How it runs
Trigger: On a schedule (legacy Cron node) (plus 3 other triggers).
- MySQL: delete table
- Download Doc File From Google Drive (Google Drive): download
- LLM - Determine - Agent Input Router (Basic LLM Chain): sends a prompt to an LLM, with model: AI Chatmodel - Deepseek 32B
- AI Agent: runs an AI agent, with model: AI Chat Model - Claude 3.5 Sonnet; 3 tools (2_Get Table Definition, 3_Execute actual query, 1_Get DB Schema and Tables List)
- Google Sheets: uses Google Sheets
- Pinecone Vector Store: stores documents in the Pinecone vector store, with embeddings: Embeddings - Tech Radar Data Embedding; document loader: Doc File Data Loader
- Determine if is 'RAG' (If): checks a condition and branches into true / false
- MySQL: uses MySQL
- Code: runs custom JavaScript code
- Code: runs custom JavaScript code
…plus 8 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- Cron: replace with Schedule Trigger.
- AI Agent v1 (old agent modes) in AI Agent - Output Guardrail (v1.7), AI Agent -DB Sql Agent (v1.7), AI Agent - RAG (v1.7): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
| Removed in 3.0 | Replace with |
|---|---|
| Cron Cron | Schedule Trigger |
| AI Agent v1 (old agent modes) AI Agent - Output Guardrail (v1.7), AI Agent -DB Sql Agent (v1.7), AI Agent - RAG (v1.7) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (24)
- Google Drive
n8n-nodes-base.googleDrive - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Cron
n8n-nodes-base.cron - MySQL
n8n-nodes-base.mySql - Google Sheets
n8n-nodes-base.googleSheets - Code
n8n-nodes-base.code - Google Docs
n8n-nodes-base.googleDocs - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Recursive Character Text Splitter
@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter - Execute Sub-workflow
n8n-nodes-base.executeWorkflow - AI Agent
@n8n/n8n-nodes-langchain.agent - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Execute Workflow Trigger
n8n-nodes-base.executeWorkflowTrigger - My Sql Tool
n8n-nodes-base.mySqlTool - Pinecone Vector Store
@n8n/n8n-nodes-langchain.vectorStorePinecone - Vector Store Question Answer Tool
@n8n/n8n-nodes-langchain.toolVectorStore - Embeddings Google Gemini
@n8n/n8n-nodes-langchain.embeddingsGoogleGemini - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Respond to Webhook
n8n-nodes-base.respondToWebhook - Webhook
n8n-nodes-base.webhook - If
n8n-nodes-base.if - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow
From the author
AI-Powered Tech Radar Advisor This project is built on top of the famous open source ThoughtWorks Tech Radar. You can use this template to build your own AI-Powered Tech Radar Advisor for your company or group of companies. Target Audience This template is…