AI-powered accounting reports from Sabre EDI with GPT-4 and Pinecone RAG
Needs changesWhat this workflow does
This AI workflow has 18 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Pinecone Vector Store, Embeddings OpenAI, Google Drive and OpenAI Chat Model.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Google Drive: work with file folder
- Google Drive: download
- Extract from File: extracts data from a file (text)
- Account Receivable Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 1 tool (Pinecone Vector Store)
- Google Drive: work with file folder
- Google Drive: download
- Pinecone Vector Store: stores documents in the Pinecone vector store, with embeddings: Embeddings OpenAI; document loader: Default Data Loader
- Tax and Surcharges Report (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 1 tool (Pinecone Vector Store)
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- AI Agent v1 (old agent modes) in Account Receivable Agent (v1.9), Tax and Surcharges Report (v1.9): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| AI Agent v1 (old agent modes) Account Receivable Agent (v1.9), Tax and Surcharges Report (v1.9) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Pinecone Vector Store
@n8n/n8n-nodes-langchain.vectorStorePinecone - Embeddings OpenAI
@n8n/n8n-nodes-langchain.embeddingsOpenAi - Default Data Loader
@n8n/n8n-nodes-langchain.documentDefaultDataLoader - Recursive Character Text Splitter
@n8n/n8n-nodes-langchain.textSplitterRecursiveCharacterTextSplitter - Google Drive
n8n-nodes-base.googleDrive - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Extract from File
n8n-nodes-base.extractFromFile - AI Agent
@n8n/n8n-nodes-langchain.agent
From the author
This workflow automates the process of reading EDI files generated by Sabre, parsing them using an AI Agent, and producing structured accounting reports like: 📌 Accounts Receivable (AR) Summary 📌 Tax and Surcharges Report It also uses Retrieval-Augmented…