AI Ecommerce Intelligence Report

An n8n automation workflow that collects multi-platform sales data, analyzes it with AI, and delivers a beautifully formatted HTML report to the business owner every Monday morning.

n8n AI Google Sheets Gmail

AI Ecommerce Intelligence Report Workflow

Key Features

A five-stage automated pipeline that transforms raw sales data into actionable business intelligence

⏰

Scheduled Trigger

Runs every Monday at 1:00 AM automatically using n8n's Schedule Trigger node. No manual intervention required — the workflow kicks off like clockwork each week.

📥

Data Collection

Pulls the latest sales data directly from Google Sheets via the Google Sheets API. Aggregates orders, revenue, and platform metrics from the connected spreadsheet.

⚙️

JavaScript Processing

Structures and cleans the raw spreadsheet data using JavaScript within n8n's Code node. Calculates week-over-week changes, growth rates, and platform breakdowns.

🤖

AI Analysis

An AI/LLM node generates human-readable insights and actionable recommendations. Identifies trends, flags anomalies, and suggests optimizations for each sales channel.

📧

Email Delivery

Sends a beautifully formatted HTML report via Gmail to the business owner. Includes data tables, growth metrics, AI insights, and platform-specific recommendations.

Tech Stack

Built entirely within n8n's visual workflow builder — no external code or servers required

n8n

Workflow automation platform orchestrating the entire pipeline

Schedule Trigger

Cron-based trigger for weekly Monday 1:00 AM execution

JavaScript

Code node for data transformation and calculations

AI / LLM

Generates natural language insights and recommendations

Google Sheets

Source of truth for multi-platform sales data

Gmail

Delivers formatted HTML reports to the business owner

// n8n Workflow Pipeline
1. Schedule Trigger
   → Every Monday @ 1:00 AM

2. Google Sheets
   → Pull weekly sales data

3. Code (JavaScript)
   → Clean, structure, calculate

4. AI Agent
   → Analyze trends & insights

5. Gmail
   → Send HTML report
                        

How It Works

Four-step automated pipeline from scheduled trigger to delivered report

Monday Trigger

The n8n Schedule Trigger fires every Monday at 1:00 AM, initiating the workflow automatically without any manual input.

Pull Sales Data

The Google Sheets node fetches the latest rows from the connected spreadsheet — orders, revenue, platform, and date columns.

AI Analyzes

An AI/LLM node processes the structured data, identifies week-over-week trends, and generates actionable business insights in plain English.

Email Report

A polished HTML report with data tables, growth metrics, and AI insights is sent to the business owner via Gmail — ready to read.