Skip to content
FlowHubFluxonLab
A
AI Automationfree

🗼 AI powered supply chain control tower with BigQuery and GPT-4o

by Samir Saciadapted from n8n official workflow galleryUpdated Aug 2026
RequiresAAI AgentCall n8n Workflow ToolCall n8n Workflow ToolCCodeGoogle BigQueryGoogle BigQueryOpenAI Chat ModelOpenAI Chat ModelSSimple Memory
Share Post Share
OpenAI Chat ModelOpenAI Chat Mod…AgAI Control Tower AgentAI Control Towe…TWCall Query ToolQuery DatabaseEWTrigger Executed by the AI ToolTrigger Execute…CoSanitising the QuerySanitising the …MBChat MemoryChChat with the UserChat with the U…1234
1/5
FLOWS
STEPS · 4
Starts from a chat message

Tags: Supply Chain, Logistics, Control Tower Context Hey! I’m Samir, a Supply Chain Engineer and Data Scientist from Paris, and the founder of LogiGreen Consulting. We design tools to help companies improve their logistics processes using data analytics, AI, and automation—to reduce costs and minimize environmental impact. > Let’s use N8N to build smarter and more sustainable supply chains! 📬 For business inquiries, you can add me on LinkedIn Who is this template for? This workflow template is designed for logistics operations that need a monitoring solution for their distribution chains. Connected to your Transportation Management Systems, this AI agent can answer any question about the shipments handled by your distribution teams. How does it work? The workflow is connected to a Google BigQuery table that stores outbound order data (customer deliveries). Here’s what the AI agent does: 🤔 Receives a user question via chat. 🧠 Understands the request and generates the correct SQL query. ✅ Executes the SQL query using a BigQuery node. 💬 Responds to the user in plain English. Thanks to the chat memory, users can ask follow-up questions to dive deeper into the data.

Tags

n8nreference-onlyagentgoogle-big-querylm-chat-open-aimemory-buffer-windowtool-workflow
Connects
AAI Agentcalln8nworkflowtoolCall n8n Workflow ToolCCodegooglebigqueryGoogle BigQueryopenaichatmodelOpenAI Chat ModelSSimple Memory
CategoryAI Automation
Triggermanual
Complexitymedium
Nodes8
AddedMar 24, 2025
ACembeddingsopenai
free

Route WhatsApp support requests with Claude, Supabase, HubSpot and Slack

Quick overview This workflow turns incoming WhatsApp messages (text, audio, images, and documents) into actionable support interactions by extracting content, detecting sentiment, and using an AI agent with a Supabase knowledge base to route requests to Google Calendar, HubSpot, Slack, Gmail, and back to WhatsApp. How it works Receives incoming WhatsApp messages via a WhatsApp webhook trigger. Routes the message by type and converts it into text using OpenAI Whisper for audio, OpenAI GPT-4o Vision for images, or a PDF extractor for documents (or passes text messages through). Loads the sender’s session context from Supabase and runs sentiment/language detection on the extracted text. Uses a LangChain AI agent (Claude) with Supabase vector search (with OpenAI embeddings and Cohere reranking) plus tool access (Google Calendar, HubSpot, Slack, and Gmail) to produce a structured intent, response, and metadata. Logs conversation analytics (intent, sentiment, message type, and response length) to an n8n Data Table. Routes by intent to either create a Google Calendar event, create/update a HubSpot contact, email a document via Gmail (and upload it to Google Drive), create a HubSpot ticket

by Multifly
AopenaichatmodelserpapigooglesearchS
free

AI chatbot that can search the web

This workflow is designed for dynamic and intelligent conversational capabilities. It incorporates OpenAI's GPT-4o model for natural language understanding and generation. Additional tools include SerpAPI and Wikipedia for enriched, data-driven responses. The workflow is triggered manually, and utilizes a 'Window Buffer Memory' to maintain the context of the last 20 interactions for better conversational continuity. All these components are orchestrated through n8n nodes, ensuring seamless interconnectivity. To use this template, you need to be on n8n version 1.50.0 or later.

by n8n Team
AopenaichatmodelserpapigooglesearchS
free

AI agent chat

This workflow employs OpenAI's language models and SerpAPI to create a responsive, intelligent conversational agent. It comes equipped with manual chat triggers and memory buffer capabilities to ensure seamless interactions. To use this template, you need to be on n8n version 1.50.0 or later.

by n8n Team