Route tech radar queries to RAG or SQL agents

# Route HTTP queries on tech radar between RAG and SQL agents with response validation

This automation processes incoming questions about the company´s technology radar, intelligently routing each query to either a RAG agent (for document-based context) or an SQL agent (for structured data). It ensures accurate, up-to-date responses by syncing source data from Google Sheets into both MySQL and Pinecone vector store.

## Who it´s for
- Internal employees requesting information on technology strategy
- Solution architects needing quick access to technology status
- IT managers tracking tech adoption across subsidiaries
- Developers seeking guidance on stack selection

## What the automation does
- Accepts HTTP webhook requests with questions about the tech radar
- Analyzes query type and routes it to either RAG (Pinecone + Google Docs) or SQL (MySQL) agent
- Retrieves precise answer from the appropriate data source
- Validates final output using a guardrail LLM (Google Gemini / Groq) before returning
- Triggers sync on schedule (cron) or when Google Drive file is updated

## What´s included
- Ready-to-use n8n workflow with LangChain agent logic
- Trigger logic: HTTP webhook, cron schedule, Google Drive file update
- Integrations with Google Sheets, Google Docs, Google Drive API, Pinecone, MySQL, and Webhook API
- Basic text instructions for setup and adaptation

## Requirements for setup
- n8n instance with external API access
- Google Workspace account (Sheets, Docs, Drive)
- Active Pinecone and MySQL accounts with configured connections
- API keys for Google Gemini and Groq
- Source tech radar sheet in Google Sheets, properly formatted

## Benefits and outcomes
- Reduces expert workload by automating routine inquiries
- Ensures single source of truth with synchronized data
- Enables fast access to current tech status without manual lookup
- Supports both structured queries and open-ended questions
- Self-updating system: data syncs automatically from Google Sheets

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via chat