Automate SQL Workflows with n8n: Scheduled Database Reviews by way of E mail

Picture by Creator | ChatGPT

The Hidden Value of Routine SQL Reporting

 
Knowledge groups throughout organizations face the identical recurring problem: stakeholders require common reviews, however guide SQL reporting consumes helpful time that could possibly be spent on evaluation. The method stays constant no matter firm measurement — connect with the database, execute queries, format outcomes, and distribute findings to decision-makers.

Knowledge professionals routinely deal with reporting duties that do not require superior statistical information or area experience, but they eat important time by repetitive execution of the identical queries and formatting procedures.

This workflow addresses a elementary effectivity drawback: remodeling one-time setup into ongoing automated supply {of professional} reviews on to stakeholder inboxes.

The Resolution: A 4-Node Automated Reporting Pipeline

 
Constructing on our earlier n8n exploration, this workflow tackles a unique automation problem: scheduled SQL reporting. Whereas our first tutorial targeted on knowledge high quality evaluation, this one demonstrates how n8n handles database integration, recurring schedules, and e mail distribution.

Not like writing standalone Python scripts for reporting, n8n workflows are visible, reusable, and straightforward to change. You may join databases, carry out transformations, run analyses, and ship outcomes — all with out switching between completely different instruments or environments. Every workflow consists of “nodes” that signify completely different actions, linked collectively to create an automatic pipeline.

Our automated SQL reporter consists of 4 linked nodes that remodel guide reporting right into a hands-off course of:

1. Schedule Set off – Runs each Monday at 9 AM
2. PostgreSQL Node – Executes gross sales question towards database
3. Code Node – Transforms uncooked knowledge into formatted HTML report
4. Ship E mail Node – Delivers skilled report back to stakeholders

Constructing the Workflow: Step-by-Step Implementation

Conditions

Step 1: Set Up Your PostgreSQL Database

We’ll create a practical gross sales database utilizing Supabase for this tutorial. Supabase is a cloud-based PostgreSQL platform that gives managed databases with built-in APIs and authentication—making it preferrred for fast prototyping and manufacturing purposes. Whereas this tutorial makes use of Supabase for comfort, the n8n workflow connects to any PostgreSQL database, together with AWS RDS, Google Cloud SQL, or your group’s present database infrastructure.

Create Supabase Account:

1. Go to supabase.com and join free
2. Create new challenge – select any title and area
3. Await setup – takes about 2 minutes for database provisioning
4. View your connection particulars from the Settings > Database web page (or the “join” button on the principle web page)

Load Pattern Knowledge:

Navigate to the SQL Editor in Supabase and run this setup script to create our gross sales database tables and populate them with pattern knowledge:

-- Create staff desk
CREATE TABLE staff (
    emp_id SERIAL PRIMARY KEY,
    first_name VARCHAR(50),
    last_name VARCHAR(50),
    division VARCHAR(50)
);

-- Create gross sales desk
CREATE TABLE gross sales (
    sale_id SERIAL PRIMARY KEY,
    emp_id INTEGER REFERENCES staff(emp_id),
    sale_amount DECIMAL(10,2),
    sale_date DATE
);

-- Insert pattern staff
INSERT INTO staff (first_name, last_name, division) VALUES
('Mike', 'Johnson', 'Gross sales'),
('John', 'Doe', 'Gross sales'),
('Tom', 'Wilson', 'Gross sales'),
('Sarah', 'Chen', 'Advertising and marketing');

-- Insert current gross sales knowledge
INSERT INTO gross sales (emp_id, sale_amount, sale_date) VALUES
(1, 2500.00, CURRENT_DATE - 2),
(1, 1550.00, CURRENT_DATE - 5),
(2, 890.00, CURRENT_DATE - 1),
(2, 1500.00, CURRENT_DATE - 4),
(3, 3200.00, CURRENT_DATE - 3),
(4, 1200.00, CURRENT_DATE - 6);

Paste this complete script into the SQL Editor and click on the “Run” button within the bottom-right nook. It is best to see “Success. No rows returned” confirming that your tables and pattern knowledge have been created efficiently.

Check Your Connection:

Inside the similar SQL Editor, run a contemporary question to confirm all the things works: SELECT COUNT(*) FROM staff;

It is best to see 4 staff within the outcomes.

Step 2: Configure Gmail for Automated Sending

Allow App Password:

1. Activate 2-step verification in your Google Account settings
2. Generate app password – go to Safety > App passwords
3. Choose “Mail” and “Different” – title it “n8n reporting”
4. Copy the 16-character password – you may want this for n8n

Step 3: Import and Configure the Workflow

Import the Template:

1. Obtain the workflow file
2. Open n8n and click on “Import from File”
3. Choose the downloaded file – all 4 nodes seem robotically
4. Save the workflow as “Automated SQL Reporting”

The imported workflow accommodates 4 linked nodes with all of the advanced SQL and formatting code already configured.

Configure Database Connection:

1. Click on the PostgreSQL node
2. Get your connection particulars from Supabase by clicking the “Join” button in your primary web page. For n8n integration, use the “Transaction pooler” connection string because it’s optimized for automated workflows:

3. Create new credential together with your Supabase particulars:
   • Host: [your-project].supabase.com
   • Database: postgres
   • Consumer: postgres…..
   • Password: [from Supabase settings]
   • Port: 6543
   • SSL: Allow
4. Check connection – you need to see a inexperienced success message

Configure E mail Settings:

1. Click on the Ship E mail node
2. Create SMTP credential:
   • Host: smtp.gmail.com
   • Port: 587
   • Consumer: your-email@gmail.com
   • Password: [your app password]
   • Safe: Allow STARTTLS
3. Replace recipient within the “To E mail” area

That is it! The evaluation logic robotically adapts to completely different database schemas, desk names, and knowledge varieties.

Step 4: Check and Deploy

1. Click on “Execute Workflow” within the toolbar
2. Watch every node flip inexperienced because it processes
3. Verify your e mail – you need to obtain the formatted report
4. Toggle to “Energetic” to allow Monday morning automation

As soon as the setup is full, you may obtain computerized weekly reviews with none guide intervention.

Understanding Your Automated Report

This is what your stakeholders will obtain each Monday:

E mail Topic: 📊 Weekly Gross sales Report – June 27, 2025

Report Content material:

• Clear HTML desk with correct styling and borders
• Abstract statistics calculated robotically from SQL outcomes
• Skilled formatting appropriate for government stakeholders
• Timestamp and metadata for audit trails

This is what the ultimate report appears to be like like:

The workflow robotically handles all of the advanced formatting and calculations behind this skilled output. Discover how the report consists of correct foreign money formatting, calculated averages, and clear desk styling—all generated immediately from uncooked SQL outcomes with none guide intervention. The e-mail arrives with a timestamp, making it simple for stakeholders to trace reporting intervals and preserve audit trails for decision-making processes.

Technical Deep Dive: Understanding the Implementation

 
Schedule Set off Configuration:

The workflow runs each Monday at 9:00 AM utilizing n8n’s interval scheduling. This timing ensures reviews arrive earlier than weekly staff conferences.

SQL Question Logic:

The PostgreSQL node executes a complicated question with JOINs, date filtering, aggregations, and correct numeric formatting. It robotically:

• Joins worker and gross sales tables for full data
• Filters knowledge to final 7 days utilizing CURRENT_DATE - INTERVAL '7 days'
• Calculates whole gross sales, income, and averages per particular person
• Orders outcomes by income for enterprise prioritization

HTML Era Logic:

The Code node transforms SQL outcomes into skilled HTML utilizing JavaScript. It iterates by question outcomes, builds styled HTML tables with constant formatting, calculates abstract statistics, and provides skilled touches like emojis and timestamps.

E mail Supply:

The Ship E mail node makes use of Gmail’s SMTP service with correct authentication and HTML rendering help.

Testing with Totally different Situations

 
To see how the workflow handles various knowledge patterns, attempt these modifications:

1. Totally different Time Durations: Change INTERVAL '7 days' to INTERVAL '30 days' for month-to-month reviews
2. Division Filtering: Add WHERE e.division="Gross sales" for team-specific reviews
3. Totally different Metrics: Modify SELECT clause to incorporate product classes or buyer segments

Based mostly on what you are promoting wants, you possibly can decide subsequent steps: weekly reviews work effectively for operational groups, month-to-month reviews swimsuit strategic planning, quarterly reviews serve government dashboards, and day by day reviews assist with real-time monitoring. The workflow adapts robotically to any SQL construction, permitting you to rapidly create a number of reporting pipelines for various stakeholders.

Subsequent Steps

1. Multi-Database Assist

Substitute the PostgreSQL node with MySQL, SQL Server, or any supported database. The workflow logic stays equivalent whereas connecting to completely different knowledge sources. This flexibility makes the answer helpful throughout numerous expertise stacks.

2. Superior Scheduling

Modify the Schedule Set off for various frequencies. Arrange day by day reviews for operational metrics, month-to-month reviews for strategic planning, or quarterly reviews for board conferences. Every schedule can goal completely different recipient teams with tailor-made content material.

3. Enhanced Formatting

Lengthen the Code node to incorporate charts and visualizations utilizing Chart.js, conditional formatting based mostly on efficiency thresholds, or government summaries with key insights. The HTML output helps wealthy formatting and embedded graphics.

4. Multi-Recipient Distribution

Add logic to ship completely different reviews to completely different stakeholders. Gross sales managers obtain particular person staff reviews, executives obtain high-level summaries, and finance groups obtain revenue-focused metrics. This focused strategy ensures every viewers will get related info.

Conclusion

 
This automated SQL reporting workflow demonstrates how n8n bridges the hole between knowledge science experience and operational effectivity. By combining database integration, scheduling, and e mail automation, you possibly can get rid of routine reporting duties whereas delivering skilled outcomes to stakeholders.

The workflow’s modular design makes it notably helpful for knowledge groups managing a number of reporting necessities. You may duplicate the workflow for various databases, modify the SQL queries for varied metrics, and alter the formatting for various audiences—all with out writing customized scripts or managing server infrastructure.

Not like conventional ETL instruments that require in depth configuration, n8n’s visible interface makes advanced knowledge workflows accessible to each technical and non-technical staff members. Your SQL experience stays the core worth, whereas n8n handles the automation infrastructure, scheduling reliability, and supply mechanisms.

Most significantly, this strategy scales together with your group’s wants. Begin with easy weekly reviews, then increase to incorporate knowledge visualizations, multi-database queries, or integration with enterprise intelligence platforms. The inspiration you construct right this moment turns into the automated reporting infrastructure that helps your staff’s progress tomorrow.
 
 

Born in India and raised in Japan, Vinod brings a worldwide perspective to knowledge science and machine studying training. He bridges the hole between rising AI applied sciences and sensible implementation for working professionals. Vinod focuses on creating accessible studying pathways for advanced matters like agentic AI, efficiency optimization, and AI engineering. He focuses on sensible machine studying implementations and mentoring the subsequent era of information professionals by stay periods and customized steerage.