{
  "openruna_format": "flow-graph-v1",
  "title": "Tech Radar",
  "slug": "tech-radar",
  "source_filename": "1836_Code_Googledocs_Automation_Webhook.json",
  "nodes": [
    {
      "id": "Download Doc File From Google Drive",
      "name": "Download Doc File From Google Drive",
      "integration": "googleDrive",
      "kind": "action"
    },
    {
      "id": "Doc File Data Loader",
      "name": "Doc File Data Loader",
      "integration": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
      "kind": "action"
    },
    {
      "id": "Cron",
      "name": "Cron",
      "integration": "cron",
      "kind": "action"
    },
    {
      "id": "MySQL -delete all data",
      "name": "MySQL -delete all data",
      "integration": "mySql",
      "kind": "action"
    },
    {
      "id": "MySQL - insert all from sheets",
      "name": "MySQL - insert all from sheets",
      "integration": "mySql",
      "kind": "action"
    },
    {
      "id": "Google Sheets - Tech Radar",
      "name": "Google Sheets - Tech Radar",
      "integration": "googleSheets",
      "kind": "action"
    },
    {
      "id": "Code - Transform table into rows",
      "name": "Code - Transform table into rows",
      "integration": "code",
      "kind": "logic"
    },
    {
      "id": "Google Docs - Update GDoc",
      "name": "Google Docs - Update GDoc",
      "integration": "googleDocs",
      "kind": "action"
    },
    {
      "id": "Google Drive - Doc File Updated",
      "name": "Google Drive - Doc File Updated",
      "integration": "googleDrive",
      "kind": "trigger"
    },
    {
      "id": "Content - Recursive Character Text Splitter",
      "name": "Content - Recursive Character Text Splitter",
      "integration": "@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter",
      "kind": "action"
    },
    {
      "id": "Google Sheets - Read TechRadar",
      "name": "Google Sheets - Read TechRadar",
      "integration": "googleSheets",
      "kind": "action"
    },
    {
      "id": "Code - Simplify Mapping to Original Query",
      "name": "Code - Simplify Mapping to Original Query",
      "integration": "code",
      "kind": "logic"
    },
    {
      "id": "Codes - Simplify Mapping to Original Query",
      "name": "Codes - Simplify Mapping to Original Query",
      "integration": "code",
      "kind": "logic"
    },
    {
      "id": "Execute Workflow - Sql Agent",
      "name": "Execute Workflow - Sql Agent",
      "integration": "executeWorkflow",
      "kind": "action"
    },
    {
      "id": "Execute Workflow - RAG Agent",
      "name": "Execute Workflow - RAG Agent",
      "integration": "executeWorkflow",
      "kind": "action"
    },
    {
      "id": "AI Agent - Output Guardrail",
      "name": "AI Agent - Output Guardrail",
      "integration": "@n8n/n8n-nodes-langchain.agent",
      "kind": "action"
    },
    {
      "id": "LLM - Determine - Agent Input Router",
      "name": "LLM - Determine - Agent Input Router",
      "integration": "@n8n/n8n-nodes-langchain.chainLlm",
      "kind": "action"
    },
    {
      "id": "When Executed by Another Workflow",
      "name": "When Executed by Another Workflow",
      "integration": "executeWorkflow",
      "kind": "trigger"
    },
    {
      "id": "1_Get DB Schema and Tables List",
      "name": "1_Get DB Schema and Tables List",
      "integration": "mySqlTool",
      "kind": "action"
    },
    {
      "id": "2_Get Table Definition",
      "name": "2_Get Table Definition",
      "integration": "mySqlTool",
      "kind": "action"
    },
    {
      "id": "3_Execute actual query",
      "name": "3_Execute actual query",
      "integration": "mySqlTool",
      "kind": "action"
    },
    {
      "id": "AI Agent -DB Sql Agent",
      "name": "AI Agent -DB Sql Agent",
      "integration": "@n8n/n8n-nodes-langchain.agent",
      "kind": "action"
    },
    {
      "id": "Pinecone Vector Store (Retrieval)",
      "name": "Pinecone Vector Store (Retrieval)",
      "integration": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
      "kind": "action"
    },
    {
      "id": "4_RagTool",
      "name": "4_RagTool",
      "integration": "@n8n/n8n-nodes-langchain.toolVectorStore",
      "kind": "action"
    },
    {
      "id": "AI Agent - RAG",
      "name": "AI Agent - RAG",
      "integration": "@n8n/n8n-nodes-langchain.agent",
      "kind": "action"
    },
    {
      "id": "Embeddings - Tech Radar Data Embedding",
      "name": "Embeddings - Tech Radar Data Embedding",
      "integration": "@n8n/n8n-nodes-langchain.embeddingsGoogleGemini",
      "kind": "action"
    },
    {
      "id": "Pinecone - Vector Store for Embedding Content",
      "name": "Pinecone - Vector Store for Embedding Content",
      "integration": "@n8n/n8n-nodes-langchain.vectorStorePinecone",
      "kind": "action"
    },
    {
      "id": "Retrieve Embeddings - Tech Radar Vector DB",
      "name": "Retrieve Embeddings - Tech Radar Vector DB",
      "integration": "@n8n/n8n-nodes-langchain.embeddingsGoogleGemini",
      "kind": "action"
    },
    {
      "id": "AI Agent - Retrieval",
      "name": "AI Agent - Retrieval",
      "integration": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
      "kind": "action"
    },
    {
      "id": "AI Chat Model - Claude 3.5 Sonnet",
      "name": "AI Chat Model - Claude 3.5 Sonnet",
      "integration": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
      "kind": "action"
    },
    {
      "id": "AI Chat Model - QwQ 32b",
      "name": "AI Chat Model - QwQ 32b",
      "integration": "@n8n/n8n-nodes-langchain.lmChatGroq",
      "kind": "action"
    },
    {
      "id": "AI Chatmodel - Deepseek 32B",
      "name": "AI Chatmodel - Deepseek 32B",
      "integration": "@n8n/n8n-nodes-langchain.lmChatGroq",
      "kind": "action"
    },
    {
      "id": "AI Chat Model - llama3-8b",
      "name": "AI Chat Model - llama3-8b",
      "integration": "@n8n/n8n-nodes-langchain.lmChatGroq",
      "kind": "action"
    },
    {
      "id": "API Response - Respond to Webhook",
      "name": "API Response - Respond to Webhook",
      "integration": "respondToWebhook",
      "kind": "action"
    },
    {
      "id": "API Request - Webhook",
      "name": "API Request - Webhook",
      "integration": "webhook",
      "kind": "trigger"
    },
    {
      "id": "Determine if  is 'RAG'",
      "name": "Determine if  is 'RAG'",
      "integration": "if",
      "kind": "logic"
    },
    {
      "id": "User Conversation history",
      "name": "User Conversation history",
      "integration": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "kind": "action"
    }
  ],
  "edges": [
    {
      "from": "Cron",
      "to": "MySQL -delete all data"
    },
    {
      "from": "API Request - Webhook",
      "to": "LLM - Determine - Agent Input Router"
    },
    {
      "from": "Determine if  is 'RAG'",
      "to": "Code - Simplify Mapping to Original Query"
    },
    {
      "from": "Determine if  is 'RAG'",
      "to": "Codes - Simplify Mapping to Original Query"
    },
    {
      "from": "MySQL -delete all data",
      "to": "Google Sheets - Read TechRadar"
    },
    {
      "from": "Google Sheets - Tech Radar",
      "to": "Code - Transform table into rows"
    },
    {
      "from": "AI Agent - Output Guardrail",
      "to": "API Response - Respond to Webhook"
    },
    {
      "from": "Execute Workflow - RAG Agent",
      "to": "AI Agent - Output Guardrail"
    },
    {
      "from": "Execute Workflow - Sql Agent",
      "to": "AI Agent - Output Guardrail"
    },
    {
      "from": "Google Sheets - Read TechRadar",
      "to": "MySQL - insert all from sheets"
    },
    {
      "from": "Google Drive - Doc File Updated",
      "to": "Download Doc File From Google Drive"
    },
    {
      "from": "Code - Transform table into rows",
      "to": "Google Docs - Update GDoc"
    },
    {
      "from": "When Executed by Another Workflow",
      "to": "AI Agent -DB Sql Agent"
    },
    {
      "from": "Download Doc File From Google Drive",
      "to": "Pinecone - Vector Store for Embedding Content"
    },
    {
      "from": "LLM - Determine - Agent Input Router",
      "to": "Determine if  is 'RAG'"
    },
    {
      "from": "Code - Simplify Mapping to Original Query",
      "to": "Execute Workflow - RAG Agent"
    },
    {
      "from": "Codes - Simplify Mapping to Original Query",
      "to": "Execute Workflow - Sql Agent"
    }
  ]
}