Templates / Extract and log Outlook invoices to OneDrive Excel with GPT-4.1-mini

Extract and log Outlook invoices to OneDrive Excel with GPT-4.1-mini

Ready for 3.0

by AI Solutions ✓ · 62 views · created 2026-05-14 · Invoice Processing, AI Summarization

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

What 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).

  1. Outlook — Get Unread Emails (Microsoft Outlook): uses Microsoft Outlook
  2. Code: runs custom JavaScript code
  3. AI — Extract Invoice Fields (Basic LLM Chain): sends a prompt to an LLM, with model: OpenAI — GPT-4.1-mini Model
  4. Code: runs custom JavaScript code
  5. Set — Format Excel Row (Edit Fields (Set)): sets or maps fields
  6. If: checks a condition and branches into true / false
  7. HTTP — Get Attachments (HTTP Request): calls an HTTP API
  8. Code: runs custom JavaScript code
  9. Code: runs custom JavaScript code
  10. Merge: merges the data from its input branches

…plus 12 more steps. See the full node list below.

Services it uses

Microsoft OutlookOpenAI Chat ModelMicrosoft Excel 365

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)

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…

Excerpt from AI Solutions's description on n8n.io.

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.