Quick Overview
This workflow polls a Microsoft Outlook folder for new supplier emails, sends each message to a companion n8n sub-workflow that creates an incoming invoice in work4all, and then categorizes the email (green/yellow/red) and emails errors via Outlook.
How it works
- Runs every minute on a schedule.
- Fetches all emails from a specified Microsoft Outlook folder that are not already categorized as Red or Green, downloading any attachments.
- Sends each email to a companion sub-workflow that extracts invoice data from attachments and creates the incoming invoice in work4all.
- If the sub-workflow returns errors, sends an error notification email via Microsoft Outlook and categorizes the original message as Red.
- If no errors occur, categorizes the message as Green when booking is clean, or as Yellow + Green when a supplier was created or an account/tax key was set automatically.
Setup
- Import and publish the companion workflow "Create a work4all incoming invoice from email attachments using AI" and select it in the Execute Workflow step.
- Add Microsoft Outlook credentials with permission to read the target mailbox and send emails.
- Update the Outlook folder ID to monitor and ensure the mailbox has the categories "Red category", "Green category", and "Yellow category".
- Set the error notification recipient address(es) in the configuration value (errorRecipients).
- Adjust the schedule interval if you don’t want it to poll every minute.