AI powered supply chain control tower with BigQuery and GPT 4
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 Cons...
🔌 Nodes & Integrations Used (7)
📖 Implementation & Setup Guide
*Tags: Supply Chain, Logistics, Control Tower*
Context
Hey! I’m [Samir](https://samirsaci.com), a Supply Chain Engineer and Data Scientist from Paris, and the founder of [LogiGreen Consulting](https://logi-green.com).
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](https://www.linkedin.com/in/samir-saci)
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: 1. 🤔 Receives a user question via chat. 2. 🧠 Understands the request and **generates the correct SQL query**. 3. ✅ Executes the SQL query using a **BigQuery** node. 4. 💬 Responds to the user in **plain English**.
[](https://www.loom.com/share/50271f9d50214d7184830985497a75ec?sid=d0c410dc-29f1-488f-b89a-4011de0ded07)
Thanks to the chat memory, users can ask follow-up questions to dive deeper into the data.
What do I need to get started?
This workflow requires **no advanced programming skills**.
You’ll need: - A **Google BigQuery account** with an SQL table storing transactional records. - An **OpenAI API key** (GPT-4o) for the chat model.
Next Steps
Follow the sticky notes in the workflow to configure each node and start using **AI to support your supply chain operations**.
[](https://www.loom.com/share/50271f9d50214d7184830985497a75ec?sid=d0c410dc-29f1-488f-b89a-4011de0ded07)
[🎥 Watch My Tutorial](https://www.loom.com/share/50271f9d50214d7184830985497a75ec?sid=d0c410dc-29f1-488f-b89a-4011de0ded07)
🚀 Curious how N8N can transform your logistics operations?
Notes
- The chat trigger can easily be replaced with **Teams**, **Telegram**, or **Slack** for a better user experience.
- You can also connect this to a customer chat window using a **webhook**.
*This workflow was built using N8N version 1.82.1* *Submitted: March 24, 2025*
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
_AI_powered_supply_chain_control_tower_with_BigQuery_and_GPT_4.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related AI Agents Workflows
View All in AI Agents →5 ways to process images PDFs with Gemini AI in n8n
How it works Many users have asked in the support forum about different methods to analyze images and PDF documents with Google Gemini AI in n8n. This workfl...
7 AI Sales Assistant
Production-ready n8n automation template for 7 AI Sales Assistant built by AhiXLight. Seamlessly connects Airtop Tool, Slack, Airtop with 24 configured nodes.
AAVE portfolio professional AI agent Telegram Email GPT 4o
A next-generation AI-powered DeFi health monitor that tracks wallet positions across Aave V3 using GPT-4o and LangChain. It delivers human-readable reports v...
Access control for AI agents RBAC using Airtable and Telegram
Purpose This workflow allows granular control over the access to tools connected to AI Agents (including Multi-Agent setups) using Role Based Access Control....