Data & Databases

Extract MySQL data, analyze with AI, and send reports via Outlook

30 nodes 118 76 Scheduled trigger
Download

Workflow Description

A scheduled automation that retrieves data from MySQL databases, processes it in batches, applies intelligent analysis using a Gemini-powered agent, and automatically sends formatted reports and summaries via Outlook email on a recurring basis.

How it works

  1. 1.Trigger automation on a predefined schedule daily
  2. 2.Query and extract records from specified MySQL tables
  3. 3.Batch process large datasets into manageable chunks
  4. 4.Analyze each batch using an AI agent powered by Gemini
  5. 5.Generate comprehensive HTML-formatted summary report
  6. 6.Send results and insights to recipients via Outlook

Use cases

  • Send automated daily database monitoring reports to team members
  • Process large transaction logs with AI insights and email results
  • Extract and analyze customer or sales data with AI recommendations

Requirements

  • Valid MySQL server connection credentials
  • Active Microsoft Outlook account configured
  • Google Gemini API key with appropriate permissions
  • Predefined SQL queries or table schemas to monitor

Service Value

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

Apps Used

MySQL Split In Batches Outlook Tool AI Agent Gemini

Details

Trigger Scheduled trigger
Nodes 30
Apps 6
Views 118
Downloads 76

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

/

Schedule Trigger

Schedule Trigger

#1

YTD vs Prevoius Month1

My Sql

#2

Loop Over Items

Split In Batches

#3

CostCentrs

Set

#4

Date & Time

Date Time

#5

PreviousMonth

Code

#6

Selected Cost Center

Set

#7

Get Cost Centers with Budgets

My Sql

#8

Filter

Filter

#9

HTML

HTML Page

#10

verticalPL

Code

#11

Merge

Merge

#12

Code

Code

#13

Microsoft Outlook2

Microsoft Outlook

#14

CostCenter

Code

#15

WIP1

Code

#16

Employees

My Sql

#17

Employees1

Code

#18

Wait

Wait

#19

Financial Performance

Code

#20

Email Data

Set

#21

Calculator

Tool Calculator

#22

Business Performance AI Agent (Analyst)

Agent

#23

Think

Tool Think

#24

Google Gemini Chat Model

Gemini Model

#25

Departments

My Sql

#26

Projects

My Sql

#27

Sticky Note

Sticky Note

#28

Sticky Note1

Sticky Note

#29

Sticky Note11

Sticky Note

#30

Similar Templates

Analyze queries and store AI responses in databases

12 nodes

Collect X posts, analyze sentiment, and store in MongoDB with Slack alerts

9 nodes

Extract PostgreSQL data and save to spreadsheet file

3 nodes

Extract MySQL data and update Google Sheets on a schedule

3 nodes

Extract Website Analytics and Store in Airtable

4 nodes

Sync Airtable data to Google Sheets and Calendar automatically

33 nodes