TemplatesFinance & AccountingInvoice Extraction from Outlook Emails
Microsoft OutlookMicrosoft ExcelGoogle Gemini
Workflow template

Invoice Extraction from Outlook Emails

Automates extraction of invoice data from Outlook emails using Microsoft Outlook API and Google Gemini 2.0 for AI-based document classification and OCR. Extracted invoice details are saved to Microsoft Excel, streamlining accounts receivable processing.

Finance & Accounting Starts with: New email Advanced 18 nodes Uses AI Pro

Apps in this workflow

How it works

  1. Schedule Trigger1
  2. Microsoft OutlookMicrosoft Outlook2
  3. Markdown3
  4. Text Classifier4
  5. Loop Over Items5
  6. Microsoft ExcelMicrosoft Excel6
  7. Code7
  8. Extract from File8
  9. HTTP Request9
  10. Filter10
  11. If11
  12. Edit Fields12
  13. +22 more step types

The building blocks this workflow uses, in the order data flows through them.

What you'll need

  • An n8n instance (self-hosted or n8n Cloud).
  • A Microsoft Outlook account, connected in n8n as a credential.
  • A Microsoft Excel account, connected in n8n as a credential.
  • An API key for Google Gemini in n8n: the workflow calls the model each time it runs.

Gydmation shows step-by-step credential setup for each app, so your keys go straight into n8n and never to Gydmation.

Make it yours in plain English

Open the template in Gydmation and describe the change. It edits the workflow, checks it against real n8n node schemas, and deploys it to your n8n. For example:

Also run it every morning at 8 am, not just when it is triggered.
Send me a short summary on Slack when it finishes.
Log every run as a new row in a Google Sheet.
Use Claude instead of the current AI model.

Related Finance & Accounting templates

Microsoft OutlookGoogle Gemini

Daily Financial News Summary Emailer

Automates daily extraction of top financial news from ft.com using HTTP request and CSS selectors, summarizes with…

FreeAdvancedAI
MySQLMicrosoft OutlookGoogle Gemini

Monthly Financial Performance Report Automation

Automates monthly financial reporting by querying MySQL ERP data, analyzing budgets vs actuals, projects, employees…

ProAdvancedAI
Microsoft OutlookOpenAI

Automated Purchase Order Processing from Outlook XLSX

Automates purchase order intake by monitoring Outlook emails with XLSX attachments, converts Excel to markdown, uses…

ProAdvancedAI
TelegramAirtableOpenAI

AI Stock Analysis Bot via Telegram

An n8n workflow that enables real-time stock technical analysis through Telegram. It uses Telegram APIs for message…

FreeAdvancedAI
StripeSlackHubSpot

Stripe Invoice Payment to HubSpot and Slack Alert

Automates workflow for Stripe invoice payments: triggers on payment success, searches and updates HubSpot deals by PO…

FreeIntermediate
TelegramGoogle SheetsTwilio

Telegram Receipt Expense Logger

Automates expense tracking by parsing receipt images sent via Telegram using Mindee API, logs details to Google Sheets…

FreeAdvanced

More Finance & Accounting templates

+63 more Finance & Accounting templates in Gydmation

Download Gydmation AI to browse the full library, customise any template in plain English and deploy it to your n8n in one click. Free includes the top-rated starter templates; Pro unlocks all 10,000+.