Automate invoice processing & weekly spending reports with GPT-4 and Airtable
Ready for 3.0What this workflow does
This AI workflow has 12 nodes and runs when someone submits an n8n form (“Invoice Upload”) (plus 1 other trigger). Along the way it connects OpenAI Chat Model and Airtable.
How it runs
Trigger: When someone submits an n8n form (“Invoice Upload”) (plus 1 other trigger).
- Workflow Configuration (Edit Fields (Set)): sets 3 fields: airtableBaseId, airtableTableId, reportRecipientEmail
- Fetch Weekly Invoices (Airtable): search
- Extract Invoice Data (AI Agent): runs an AI agent, with model: OpenAI Chat Model; output parser: Invoice Data Parser
- Generate Spending Report (AI Agent): runs an AI agent, with model: OpenAI Chat Model
- Validate Invoice Data (If): checks a condition and branches into true / false
- Send Weekly Report Email (Send Email): sends an email over SMTP
- Store Invoice in Airtable (Airtable): create
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (9)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Edit Fields (Set)
n8n-nodes-base.set - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - If
n8n-nodes-base.if - Airtable
n8n-nodes-base.airtable - Schedule Trigger
n8n-nodes-base.scheduleTrigger - Send Email
n8n-nodes-base.emailSend
From the author
Invoice Automation Kit: AI-Powered Invoice Processing and Weekly Reports This n8n workflow is designed to automate invoice processing and streamline financial management. It leverages AI to extract key invoice data, validate it, and store it in Airtable.…