Templates / Automate purchase order form submissions from Outlook Excel attachments with AI

Automate purchase order form submissions from Outlook Excel attachments with AI

Ready for 3.0

by Jimleuk ✓ · 4,321 views · created 2025-04-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 16 nodes and runs on Microsoft Outlook events. Along the way it connects OpenAI Chat Model and Microsoft Outlook.

How it runs

Trigger: On Microsoft Outlook events.

  1. Is Submitting a Purchase Order? (Text Classifier): classifies text into categories with AI, with model: OpenAI Chat Model
  2. Is Excel Document? (If): checks a condition and branches into true / false
  3. Extract from File: extracts data from a file (xlsx)
  4. Reply Invalid Format (Microsoft Outlook): reply
  5. XLSX to Markdown Table (Code): runs custom JavaScript code
  6. Extract Purchase Order Details (Information Extractor): extracts structured fields from text with AI, with model: OpenAI Chat Model
  7. Fix Excel Dates (Edit Fields (Set)): sets or maps fields
  8. Run Checks (Edit Fields (Set)): sets 4 fields: has_po_number, has_valid_po_date, has_items…
  9. Is Valid Purchase Order? (If): checks a condition and branches into true / false
  10. Reply Accepted (Microsoft Outlook): reply

…plus 1 more step. See the full node list below.

Services it uses

OpenAI Chat ModelMicrosoft Outlook

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 (10)

From the author

This n8n template imports purchase order submissions from Outlook and converts attached purchase order forms in XLSX format into structured output. Data entry jobs with user-submitted XLSX forms are time consuming, incredibly mundane but necessary tasks which…

Excerpt from Jimleuk'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.