• Fully automated — runs every day at 8 AM via Schedule Trigger
• 3 parallel PostgreSQL queries — clean, no data duplication
• Formatted HTML email with KPI cards, category table & top products table
• Built on free tools — Neon PostgreSQL + Resend free tier

• Go to neon.tech → Click “Sign Up” (free)
• After login → Click “New Project”
• Project Name: hr-demo
• Region: Choose closest to you
• Click “Create Project”
• You’ll see a Connection String like:

postgresql://username:password@ep-xxx.neon.tech/neondb

Save these details:

CREATE TABLE products (
  id       SERIAL PRIMARY KEY,
  name     VARCHAR(100),
  category VARCHAR(50),
  price    NUMERIC(10,2)
);

CREATE TABLE customers (
  id        SERIAL PRIMARY KEY,
  full_name VARCHAR(100),
  email     VARCHAR(100)
);

CREATE TABLE orders (
  id           SERIAL PRIMARY KEY,
  customer_id  INT REFERENCES customers(id),
  product_id   INT REFERENCES products(id),
  quantity     INT,
  total_amount NUMERIC(10,2),
  order_date   DATE DEFAULT CURRENT_DATE,
  status       VARCHAR(20) DEFAULT 'Completed'
);

INSERT INTO products (name, category, price) VALUES
  ('Laptop Pro',     'Electronics', 85000),
  ('Office Chair',   'Furniture',   12000),
  ('Standing Desk',  'Furniture',   25000),
  ('Wireless Mouse', 'Electronics',  1500),
  ('Notebook Pack',  'Stationery',    500),
  ('USB Hub',        'Electronics',  2000),
  ('Whiteboard',     'Stationery',   3500);

INSERT INTO customers (full_name, email) VALUES
  ('Rahul Sharma', 'rahul@example.com'),
  ('Priya Mehta',  'priya@example.com'),
  ('Amit Patel',   'amit@example.com'),
  ('Sneha Joshi',  'sneha@example.com');

INSERT INTO orders (customer_id, product_id, quantity, total_amount, order_date, status) VALUES
  (1, 1, 1,  85000, CURRENT_DATE - 1, 'Completed'),
  (2, 2, 2,  24000, CURRENT_DATE - 1, 'Completed'),
  (3, 4, 3,   4500, CURRENT_DATE - 1, 'Completed'),
  (4, 5, 5,   2500, CURRENT_DATE - 1, 'Completed'),
  (1, 3, 1,  25000, CURRENT_DATE - 1, 'Completed'),
  (2, 6, 2,   4000, CURRENT_DATE - 1, 'Completed'),
  (3, 7, 1,   3500, CURRENT_DATE - 1, 'Completed'),
  (4, 1, 1,  85000, CURRENT_DATE - 1, 'Completed');

• Click “+” after Merge → Search “Code” → Select it.
• Set Language → “JavaScript” → Paste the following code:

// Pull results from each named node
const categories  = $('Query_CategoryRevenue').all();
const topProducts = $('Query_TopProducts').all();
const totals      = $('Query_OverallTotals').all();
const t = totals[0].json;

// Format yesterday's date
const yesterday = new Date();
yesterday.setDate(yesterday.getDate() - 1);
const dateStr = yesterday.toLocaleDateString('en-IN', {
  weekday: 'long', year: 'numeric', month: 'long', day: 'numeric'
});

// Currency formatter (Indian Rupees)
const formatCurrency = (val) =>
  '₹' + Number(val).toLocaleString('en-IN', { maximumFractionDigits: 0 });

// Build category & product rows, then return HTML + subject
const categoryRows = categories.map(c => `<tr>...</tr>`).join('');
const productRows  = topProducts.map((p, i) => `<tr>...</tr>`).join('');

return [{ json: {
  html: `... full HTML template ...`,
  subject: `Daily Sales Report — ${'$'}{dateStr}`
}}];