🗼AI Powered Supply Chain Control Tower with BigQuery and GPT-4o

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:

1. 🤔 Receive 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 .

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 .

🎥 Watch My Tutorial

🚀 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