Skip to content
AI Agents

Extract invoice data from Outlook emails and log to Excel

18 nodes 548 174 Scheduled trigger
Download

Loading workflow…

Workflow Description

An automated workflow that runs on a defined schedule to monitor incoming Outlook emails, classify messages using Google Gemini's AI capabilities, and automatically publish summaries and insights to Twitter/X accounts without manual intervention.

How it works

  1. 1.Execute workflow on a predefined schedule
  2. 2.Retrieve new messages from Outlook inbox
  3. 3.Process emails in batches and classify them using Gemini
  4. 4.Extract attachments and convert data into formatted text
  5. 5.Publish analyses and summaries to Twitter/X

Use cases

  • Automatically monitor and organize incoming emails by priority and topic
  • Convert important emails into social media posts for wider audience reach
  • Analyze customer sentiment and trends from email content for reporting

Requirements

  • Active Outlook account with full inbox access permissions
  • Google Gemini API key for classification
  • Twitter/X account with publishing permissions
  • Configured schedule for recurring execution (daily or weekly)

Service Value

Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.

Apps Used

Code Outlook Set Split In Batches No Op If Twitter/X Markdown Wait Filter Schedule Gemini HTTP Request

Details

Trigger Scheduled trigger
Nodes 18
Apps 13
Views 548
Downloads 174

How to Use

  1. 1.Click "Download Template"
  2. 2.Open your n8n dashboard
  3. 3.Go to Workflows > Import from File
  4. 4.Select downloaded file and configure credentials

Nodes Used (18)

/

Split Attachments

Code

#1

Download Attachments

Microsoft Outlook

#2

Parse Output

Set

#3

For Each Message

Split In Batches

#4

Message Ref

No Op

#5

Message Classifier

If

#6

Extract from File

Extract From File

#7

Markdown

Markdown

#8

Empty Response

Set

#9

Wait

Wait

#10

Filter Invoices

Filter

#11

Has Invoice?

If

#12

Schedule Trigger

Schedule Trigger

#13

Sticky Note1

Sticky Note

#14

Sticky Note2

Sticky Note

#15

Get Recent Messages

Microsoft Outlook

#16

Model

Gemini Model

#17

Sticky Note

Sticky Note

#18

Microsoft Excel 365

Microsoft Excel

#19

Sticky Note3

Sticky Note

#20

Sticky Note4

Sticky Note

#21

Invoice Classifier With Gemini 2.0

HTTP Request

#22

File-Based OCR with Gemini 2.0

HTTP Request

#23

Sticky Note5

Sticky Note

#24
Stay in the loop

Fresh workflows, straight to your inbox

Get newly published DROPIDEA workflows, a clear overview of what they do, and a link to explore them.

  • New workflows
  • Clear overviews
  • Setup guides

Be first to discover what is new

Your name, your email, and one confirmation.

Email confirmation · Unsubscribe anytime