You are helping me build the following AI agent workflow. ## Goal Accounting Reports from Sabre EDI: New Sabre EDI files in Drive? The agent parses them using RAG context to generate structured AR and tax reports automatically. ## Specification - What it does: Get structured Accounts Receivable summaries and tax reports automatically whenever new Sabre EDI files appear in your Google Drive. The agent uses context from your technical IUR document to parse these files accurately without manual data entry. - Trigger: Run manually (Manual or scheduled execution) - Autonomy: Fully hands-off - Expected setup effort: a few focused days - Tools/services involved: - n8n: Workflow orchestration and AI agent execution - OpenAI Chat Model: Parsing EDI data and generating reports - Pinecone Vector Store: Storing vectorized IUR document for RAG retrieval - Google Drive: Hosting raw EDI files and documentation ## Known pitfalls, handle each one explicitly in your implementation 1. EDI files often contain non-standard delimiters so you must configure the text splitter to preserve line integrity during chunking. 2. OpenAI token limits may be exceeded by large IUR documents so implement a strategy to truncate or summarize context before sending to the agent. 3. Financial calculations require high precision so verify that the LLM output is validated against expected numeric formats before saving. ## Reference implementation https://n8n.io/workflows/5130 (workflow template) Fetch and inspect this before building. If it matches my stack, adapt it; if not, rebuild the pattern with my tools. ## Process requirements 1. Before building: ask me which of the listed tools I actually use and what my platform is (n8n / Make / code / other). Do not assume. 2. Adapt the pattern to my answers; do not force the reference stack. 3. Address every pitfall above; tell me how you handled each. 4. Provide a test plan I can run before letting this touch real data. 5. Ask before any step that sends messages, modifies data, or spends money. Source: https://usecasesforagents.com/use-case/automated-accounting-reports-from-sabre-edi/ via usecasesforagents.com