Automate SQL Workflows with n8n: Scheduled Database Stories through Electronic mail -

Picture by Writer | ChatGPT

The Hidden Price of Routine SQL Reporting

Knowledge groups throughout organizations face the identical recurring problem: stakeholders require common studies, however guide SQL reporting consumes precious time that could possibly be spent on evaluation. The method stays constant no matter firm measurement — hook up 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 data or area experience, but they eat vital time via repetitive execution of the identical queries and formatting procedures.

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

The Resolution: A 4-Node Automated Reporting Pipeline

Constructing on our earlier n8n exploration, this workflow tackles a distinct automation problem: scheduled SQL reporting. Whereas our first tutorial targeted on information 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 simple to switch. You’ll be able to 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:

Schedule Set off – Runs each Monday at 9 AM
PostgreSQL Node – Executes gross sales question towards database
Code Node – Transforms uncooked information into formatted HTML report
Ship Electronic 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 speedy prototyping and manufacturing functions. 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 current database infrastructure.

Create Supabase Account:

Go to supabase.com and join free
Create new venture – select any identify and area
Watch for setup – takes about 2 minutes for database provisioning
View your connection particulars from the Settings > Database web page (or the “join” button on the primary 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 information:

-- Create workers desk
CREATE TABLE workers (
    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 workers(emp_id),
    sale_amount DECIMAL(10,2),
    sale_date DATE
);

-- Insert pattern workers
INSERT INTO workers (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 information
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 whole script into the SQL Editor and click on the “Run” button within the bottom-right nook. You need to see “Success. No rows returned” confirming that your tables and pattern information have been created efficiently.

Check Your Connection:

Throughout the identical SQL Editor, run a contemporary question to confirm all the things works: SELECT COUNT(*) FROM workers;

You need to see 4 workers within the outcomes.

Step 2: Configure Gmail for Automated Sending

Allow App Password:

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

Step 3: Import and Configure the Workflow

Import the Template:

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

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

Configure Database Connection:

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

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
Check connection – you must see a inexperienced success message

Configure Electronic mail Settings:

Click on the Ship Electronic mail node
Create SMTP credential:
- Host: smtp.gmail.com
- Port: 587
- Consumer: [email protected]
- Password: [your app password]
- Safe: Allow STARTTLS
Replace recipient within the “To Electronic mail” subject

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

Step 4: Check and Deploy

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

As soon as the setup is full, you will obtain automated weekly studies with none guide intervention.

Understanding Your Automated Report

This is what your stakeholders will obtain each Monday:

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

Report Content material:

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

This is what the ultimate report seems like:

The workflow routinely handles all of the complicated 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 instantly from uncooked SQL outcomes with none guide intervention. The e-mail arrives with a timestamp, making it straightforward 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 studies arrive earlier than weekly crew conferences.

SQL Question Logic:

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

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

HTML Technology Logic:

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

Electronic mail Supply:

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

Testing with Totally different Eventualities

To see how the workflow handles various information patterns, strive these modifications:

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

Based mostly on your online business wants, you possibly can decide subsequent steps: weekly studies work effectively for operational groups, month-to-month studies go well with strategic planning, quarterly studies serve government dashboards, and day by day studies assist with real-time monitoring. The workflow adapts routinely 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 an identical whereas connecting to completely different information sources. This flexibility makes the answer precious throughout numerous know-how stacks.

2. Superior Scheduling

Modify the Schedule Set off for various frequencies. Arrange day by day studies for operational metrics, month-to-month studies for strategic planning, or quarterly studies 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 primarily based 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 studies to completely different stakeholders. Gross sales managers obtain particular person crew studies, executives obtain high-level summaries, and finance groups obtain revenue-focused metrics. This focused method ensures every viewers will get related data.

Conclusion

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

The workflow’s modular design makes it notably precious for information groups managing a number of reporting necessities. You’ll be able to duplicate the workflow for various databases, modify the SQL queries for numerous 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 intensive configuration, n8n’s visible interface makes complicated information workflows accessible to each technical and non-technical crew members. Your SQL experience stays the core worth, whereas n8n handles the automation infrastructure, scheduling reliability, and supply mechanisms.

Most significantly, this method scales together with your group’s wants. Begin with easy weekly studies, then broaden to incorporate information visualizations, multi-database queries, or integration with enterprise intelligence platforms. The inspiration you construct at the moment turns into the automated reporting infrastructure that helps your crew’s progress tomorrow.

Born in India and raised in Japan, Vinod brings a world perspective to information science and machine studying schooling. He bridges the hole between rising AI applied sciences and sensible implementation for working professionals. Vinod focuses on creating accessible studying pathways for complicated matters like agentic AI, efficiency optimization, and AI engineering. He focuses on sensible machine studying implementations and mentoring the following technology of knowledge professionals via reside periods and personalised steerage.

Automate SQL Workflows with n8n: Scheduled Database Stories through Electronic mail