AI Agents

Collect and organize Outlook emails in Airtable using AI

28 nodes 268 154 Automatic trigger
Download

Workflow Description

Automation that retrieves Outlook emails and processes them through an AI agent to extract key information, stores structured data in Airtable tables, and creates synchronized tasks in Monday.com for team tracking.

How it works

  1. 1.Trigger collection of new Outlook messages manually or on schedule
  2. 2.AI agent analyzes email content and extracts structured information
  3. 3.Categorize results and save them to appropriate Airtable tables
  4. 4.Send Monday.com notifications to assign tasks to team members
  5. 5.Process data in batches to ensure reliability and prevent bottlenecks

Use cases

  • Automatically organize customer inquiries from email into a searchable database
  • Convert incoming emails into tracked tasks in your project management system
  • Extract and categorize lead information from email for sales pipeline management

Requirements

  • Active Outlook account with API access permissions
  • OpenAI API key with sufficient credits configured
  • Connected Airtable and Monday.com integrations in n8n

Service Value

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

Apps Used

Outlook OpenAI Output Parser AI Agent Monday Com Airtable Split In Batches

Details

Trigger Automatic trigger
Nodes 28
Apps 7
Views 268
Downloads 154

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

/

When clicking ‘Test workflow’

Manual Trigger

#1

Sticky Note8

Sticky Note

#2

Sticky Note10

Sticky Note

#3

Microsoft Outlook23

Microsoft Outlook

#4

Sticky Note11

Sticky Note

#5

Sticky Note12

Sticky Note

#6

OpenAI Chat Model

OpenAI

#7

Set Category

Microsoft Outlook

#8

Structured Output Parser

Output Parser Structured

#9

If

If

#10

Set Importance

Microsoft Outlook

#11

AI: Analyse Email

Agent

#12

Sticky Note

Sticky Note

#13

Sticky Note1

Sticky Note

#14

Sticky Note2

Sticky Note

#15

Check Mail Schedule Trigger

Schedule Trigger

#16

Update Contacts Schedule Trigger

Schedule Trigger

#17

Monday.com - Get Contacts

Monday Com

#18

Airtable - Contacts

Airtable

#19

Convert to Markdown

Markdown

#20

Email Messages

Set

#21

Rules

Airtable

#22

Categories

Airtable

#23

Delete Rules

Airtable

#24

Contact

Airtable

#25

Loop Over Items

Split In Batches

#26

Merge

Merge

#27

Sticky Note3

Sticky Note

#28