Extract and log Outlook invoices to OneDrive Excel with GPT-4.1-mini
Ready for 3.0What this workflow does
This AI workflow has 24 nodes and runs on a schedule (every day). Along the way it connects Microsoft Outlook, OpenAI Chat Model and Microsoft Excel 365.
How it runs
Trigger: On a schedule (every day).
- Outlook — Get Unread Emails (Microsoft Outlook): uses Microsoft Outlook
- Code: runs custom JavaScript code
- AI — Extract Invoice Fields (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI — GPT-4.1-mini Model
- Code: runs custom JavaScript code
- Set — Format Excel Row (Edit Fields (Set)): sets or maps fields
- If: checks a condition and branches into true / false
- HTTP — Get Attachments (HTTP Request): calls an HTTP API
- Code: runs custom JavaScript code
- Code: runs custom JavaScript code
- Merge: merges the data from its input branches
…plus 12 more steps. See the full node list below.
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 (11)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Microsoft Outlook
n8n-nodes-base.microsoftOutlook - Code
n8n-nodes-base.code - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - Microsoft Excel 365
n8n-nodes-base.microsoftExcel - Filter
n8n-nodes-base.filter
From the author
Quick overview Automatically extract, log, and archive emailed invoices using GPT-4.1-mini, OneDrive, and Excel. Designed for small business owners, finance teams, and operations managers, this Microsoft 365 workflow eliminates manual data entry while keeping…