Automate Provide Chain Analytics Workflows with AI Brokers utilizing n8n

Why construct issues the arduous means when you’ll be able to design them the sensible means?

As a Provide Chain Knowledge Scientist, I’ve explored numerous frameworks like LangChain and LangGraph to construct AI brokers utilizing Python.

Leveraging LLMs with LangChain for Provide Chain Analytics — A Management Tower Powered by GPT — (Picture by Samir Saci)

The illustration above is from an article I wrote on the finish of 2023, titled “Leveraging LLMs with LangChain for Provide Chain Analytics — A Management Tower Powered by GPT.”

On the time, I used to be exploring how you can use LangChain to construct an agent appearing as a Provide Chain Management Tower.

A 12 months later, I found the ability of the low-code platform n8n to construct the identical type of answer in just some clicks.

AI-Powered E mail Parser used for the processing of Warehouse Orders acquired by E mail — (Picture by Samir Saci)

On this article, we’ll discover how you can simply construct AI brokers to automate provide chain analytics workflows utilizing n8n.

AI Agent for Provide Chain Management Tower — (Picture by Samir Saci)

We’ll additionally see how you can deploy the identical AI-powered Management Tower agent I initially constructed with LangChain 18 months in the past — now utilizing solely low-code.

AI Agent for Provide Chain Management Towers utilizing LangChain

My first venture of AI Automation venture utilizing n8n was for a buyer who wished a Provide Chain Management Tower geared up with a chat interface.

A Provide Chain Management Tower is a set of dashboards and experiences linked to Warehouse and Transport Administration Methods that use knowledge to watch important occasions throughout the availability chain.

Instance of a management

In an earlier article revealed on In direction of Knowledge Science, I experimented with LangChain to attach a management tower to an AI agent.

Excessive-Stage Overview of the Answer introduced within the article — (Picture by Samir Saci)

The concept was to construct a plan-and-execute agent that may

  • Course of the consumer’s request written in plain English
  • Generate the suitable SQL question
  • Question the database and retailer the outcomes
  • Formulate a transparent response in plain English

After a number of iterations, I discovered the precise chain construction and prompts to ship correct outcomes.

Instance of iterations that you’ll find within the article — (Picture by Samir Saci)

The answer labored properly as a result of I had already gained expertise utilizing LangChain and different frameworks to construct AI brokers.

How are we supposed to keep up this complicated setup?

Nonetheless, to supply this as a service, I wanted instruments that may make the answer simpler to deploy, keep, and enhance — even with restricted Python information.

That’s after I found n8n.

Let’s dive into that within the subsequent part.

AI Agent for Provide Chain Management Towers — Constructed with n8n

What’s n8n?

n8n is an open-source workflow automation software that allows you to simply join apps (e mail, CRMs, messaging methods), APIs, and AI mannequin frameworks like LangChain.

You construct workflows by connecting pre-built nodes.

AI-Powered E mail Parser utilizing 4 nodes — (Picture by Samir Saci)

As an illustration, the workflow above processes emails

  • The primary node collects emails from a Gmail account.
  • The e-mail content material and metadata are despatched to the AI Agent node, which extracts the related data.
  • The third node processes the output utilizing JavaScript.
  • The ultimate node hundreds the outcomes right into a Google Sheet.

No code was wanted to construct this workflow — apart from the third node, which makes use of simply two strains of JavaScript.

Since I work with a workforce of Provide Chain consultants who’ve restricted Python expertise, this was a game-changer for me as I seemed to develop my service providing.

They’ll simply use, adapt, and keep this workflow after a brief coaching session on n8n.

AI Provide Chain Management Tower n8n workflow

The AI Provide Chain Management Tower workflow is a little more complicated — however nonetheless far less complicated than its Python model.

It contains two sub-workflows.

Foremost sub-workflow together with the AI agent — (Picture by Samir Saci)

The principle sub-workflow contains each a chat interface and the AI agent.

For the AI Agent node, it’s essential to

  • Join an LLM (chat mannequin) utilizing a node the place you enter your API credentials
  • Add a reminiscence node to handle the dialog
  • Add a software node for SQL querying, linked to the second sub-workflow

The AI agent generates an SQL question and sends it to the “Name Question Instrument” node, which executes the question.

Second sub-workflow linked through the “Name Question Instrument” — (Picture by Samir Saci)

The sub-workflow features a code node that cleans the question (eradicating further areas and blocking dangerous instructions like DELETE).

The output is shipped to a BigQuery node, which runs the question and returns the outcomes.

The method may be very easy and requires restricted configuration:

  • System Immediate (within the AI Agent node)
  • Consumer Immediate (within the AI Agent Node)
System Immediate Window of the AI Agent Node — (Picture by Samir Saci)

This setup requires no Python expertise and might be dealt with straight by my consultants.

Chat Window exhibiting an interraction with the AI Agent — (Picture by Samir Saci)

The outcomes are akin to these of the Python model.

For step-by-step setup directions, take a look at my YouTube tutorial 👇

Conclusion

This instance reveals how straightforward it’s to duplicate an AI agent constructed with Python — utilizing n8n and minimal code.

Does that imply Python is not wanted for Provide Chain Analytics? Positively not!

Like many low-code platforms, the options are restricted to what’s accessible inside the framework.

That’s why I exploit it as a complement to my analytics merchandise.

Join an AI Agent with one in every of my analytics merchandise’ backend utilizing an HTTP node — (Picture by Samir Saci)

To try this, you should utilize the HTTP Request node to attach your workflow to your analytics backend.

What else? Straightforward connectivity to many companies.

One more reason I selected n8n to complement my analytics merchandise is how straightforward it’s so as to add extra connections.

For instance, if you wish to add a Slack interface or log conversations to a Google Sheet, simply add a brand new node to your workflow.

When you’re beginning your n8n journey and want inspiration, be at liberty to discover my templates.

About Me

Let’s join on Linkedin and Twitter; I’m a Provide Chain Engineer utilizing knowledge analytics to enhance Logistics operations and scale back prices.

For consulting or recommendation on analytics and sustainable Provide Chain transformation, be at liberty to contact me through Logigreen Consulting.

Samir Saci | Knowledge Science & Productiveness
A technical weblog specializing in Knowledge Science, Private Productiveness, Automation, Operations Analysis and Sustainable…samirsaci.com