Chat assistant (OpenAI assistant) with Postgres memory and API calling capabalities
Needs changesWhat this workflow does
This AI workflow has 11 nodes and runs when a chat message arrives. Along the way it connects OpenAI, Postgres Chat Memory, MySQL and HTTP Request. It also calls quotation.joov.com.br and integracao-sed-alb-323570099.us-east-1.elb.amazonaws.com over HTTP.
How it runs
Trigger: When a chat message arrives.
- If: checks a condition and branches into true / false
- Edit Fields (Edit Fields (Set)): sets 2 fields: chatInput, session_id
- OpenAI: work with assistant, with 3 tools (External API, Knowledge Base, Products in Daatabase); memory: Postgres Chat Memory
- OpenAI: work with assistant, with memory: Postgres Chat Memory
- Edit Fields (Edit Fields (Set)): sets 2 fields: chatInput, session_id
Services it uses
HTTP calls to: quotation.joov.com.br, integracao-sed-alb-323570099.us-east-1.elb.amazonaws.com
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- HTTP Request Tool (legacy) in Knowledge Base, External API: replace with HTTP Request node connected to the AI Agent's Tool input.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| HTTP Request Tool (legacy) Knowledge Base, External API | HTTP Request node connected to the AI Agent's Tool input |
Nodes used (7)
- If
n8n-nodes-base.if - Edit Fields (Set)
n8n-nodes-base.set - OpenAI
@n8n/n8n-nodes-langchain.openAi - Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Postgres Chat Memory
@n8n/n8n-nodes-langchain.memoryPostgresChat - My Sql Tool
n8n-nodes-base.mySqlTool - HTTP Request Tool
@n8n/n8n-nodes-langchain.toolHttpRequest
From the author
Workflow Description Your workflow is an intelligent chatbot, using ++OpenAI assistant++, integrated with a backend that supports WhatsApp Business, designed to handle various use cases such as sales and customer support. Below is a breakdown of its…