Build An Ai Powered Tech Radar Advisor With Sql Db Rag And Routing Agents

Command Palette

Search for a command to run...

Back

Build An Ai Powered Tech Radar Advisor With Sql Db Rag And Routing Agents

n8nRAG & Memory

Build An Ai Powered Tech Radar Advisor With Sql Db Rag And Routing Agents — n8n automation workflow template.

DatabaseGeminiGoogle SheetsPinecone
Workflow Structure
Nodes53
Triggers4
Connections32
Services4
Workflow Diagram

Loading visualizer...

Node Network (53)
Download Doc File From Google Drivev3

n8n-nodes-base.googleDrive

Doc File Data Loaderv1

@n8n/n8n-nodes-langchain.documentDefaultDataLoader

Sticky Notev1

n8n-nodes-base.stickyNote

Cronv1

n8n-nodes-base.cron

MySQL -delete all datav2.4

n8n-nodes-base.mySql

MySQL - insert all from sheetsv1

n8n-nodes-base.mySql

Sticky Note1v1

n8n-nodes-base.stickyNote

Google Sheets - Tech Radarv4.5

n8n-nodes-base.googleSheets

Code - Transform table into rowsv2

n8n-nodes-base.code

Google Docs - Update GDocv2

n8n-nodes-base.googleDocs

Sticky Note2v1

n8n-nodes-base.stickyNote

Google Drive - Doc File Updatedv1

n8n-nodes-base.googleDriveTrigger

Content - Recursive Character Text Splitterv1

@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter

Google Sheets - Read TechRadarv3

n8n-nodes-base.googleSheets

Sticky Note3v1

n8n-nodes-base.stickyNote

Sticky Note4v1

n8n-nodes-base.stickyNote

Sticky Note11v1

n8n-nodes-base.stickyNote

Code - Simplify Mapping to Original Queryv2

n8n-nodes-base.code

Codes - Simplify Mapping to Original Queryv2

n8n-nodes-base.code

Execute Workflow - Sql Agentv1.2

n8n-nodes-base.executeWorkflow

Execute Workflow - RAG Agentv1.2

n8n-nodes-base.executeWorkflow

AI Agent - Output Guardrailv1.7

@n8n/n8n-nodes-langchain.agent

LLM - Determine - Agent Input Routerv1.5

@n8n/n8n-nodes-langchain.chainLlm

Sticky Note6v1

n8n-nodes-base.stickyNote

Sticky Note7v1

n8n-nodes-base.stickyNote

Sticky Note12v1

n8n-nodes-base.stickyNote

Sticky Note8v1

n8n-nodes-base.stickyNote

Sticky Note9v1

n8n-nodes-base.stickyNote

When Executed by Another Workflowv1.1

n8n-nodes-base.executeWorkflowTrigger

1_Get DB Schema and Tables Listv2.4

n8n-nodes-base.mySqlTool

2_Get Table Definitionv2.4

n8n-nodes-base.mySqlTool

3_Execute actual queryv2.4

n8n-nodes-base.mySqlTool

AI Agent -DB Sql Agentv1.7

@n8n/n8n-nodes-langchain.agent

Sticky Note10v1

n8n-nodes-base.stickyNote

Sticky Note13v1

n8n-nodes-base.stickyNote

Pinecone Vector Store (Retrieval)v1

@n8n/n8n-nodes-langchain.vectorStorePinecone

4_RagToolv1

@n8n/n8n-nodes-langchain.toolVectorStore

Sticky Note14v1

n8n-nodes-base.stickyNote

AI Agent - RAGv1.7

@n8n/n8n-nodes-langchain.agent

Sticky Note15v1

n8n-nodes-base.stickyNote

Sticky Note16v1

n8n-nodes-base.stickyNote

Embeddings - Tech Radar Data Embeddingv1

@n8n/n8n-nodes-langchain.embeddingsGoogleGemini

Pinecone - Vector Store for Embedding Contentv1

@n8n/n8n-nodes-langchain.vectorStorePinecone

Retrieve Embeddings - Tech Radar Vector DBv1

@n8n/n8n-nodes-langchain.embeddingsGoogleGemini

AI Agent - Retrievalv1

@n8n/n8n-nodes-langchain.lmChatGoogleGemini

AI Chat Model - Claude 3.5 Sonnetv1.2

@n8n/n8n-nodes-langchain.lmChatAnthropic

AI Chat Model - QwQ 32bv1

@n8n/n8n-nodes-langchain.lmChatGroq

AI Chatmodel - Deepseek 32Bv1

@n8n/n8n-nodes-langchain.lmChatGroq

AI Chat Model - llama3-8bv1

@n8n/n8n-nodes-langchain.lmChatGroq

API Response - Respond to Webhookv1.1

n8n-nodes-base.respondToWebhook

API Request - Webhookv2

n8n-nodes-base.webhook

Determine if is 'RAG'v2.2

n8n-nodes-base.if

User Conversation historyv1.3

@n8n/n8n-nodes-langchain.memoryBufferWindow