DEV Community

Alex Kane
Alex Kane

Posted on

Get a daily business report in your inbox every morning — automate it with n8n (free workflow JSON)

#n8n #automation #productivity #javascript

Every founder has some version of a morning ritual: open 4 different tabs, check Stripe, check analytics, check the spreadsheet, try to mentally add up whether yesterday was a good day.

That's 15 minutes every morning. 250+ times a year. 60+ hours you'll never get back.

Here's a 5-node n8n workflow that compiles your daily business metrics and delivers a clean formatted report to your inbox (and Slack) at 7 AM — automatically, every single day.

What the workflow does

Node 1 — Daily schedule trigger

Fires every morning at a configurable time. No polling, no manual runs. Set it once, forget it forever.

Node 2 — Google Sheets: read your metrics

Reads your business data from a Google Sheet — sales rows, revenue, order counts. The default expects columns Date, Revenue, Orders but you can reshape the Code node to match whatever you already track.

Node 3 — Code node: calculate KPIs

Processes the raw rows and computes:

  • Total revenue for the period
  • Order count
  • Average order value
  • Week-over-week change (yesterday vs same day last week)

The math is plain JavaScript — readable and easy to adjust.

Node 4 — Gmail: send the HTML report

Sends a clean, formatted HTML email with metric cards. Revenue in green, orders in blue, average order in purple, week-on-week trend in orange. You open your email and immediately know if yesterday was good or bad.

Node 5 — Slack: post the summary

Posts a concise text summary to a Slack webhook. Optional — just delete this node if you don't use Slack.

Full workflow JSON 

{
  "name": "Daily Business Report Generator",
  "nodes": [
    {"parameters":{"rule":{"interval":[{"field":"cronExpression","expression":"0 7 * * *"}]}},"id":"dr1","name":"Every Day at 7 AM","type":"n8n-nodes-base.scheduleTrigger","typeVersion":1.2,"position":[240,300]},
    {"parameters":{"documentId":{"__rl":true,"value":"YOUR_SHEET_ID","mode":"id"},"sheetName":{"__rl":true,"value":"Sales","mode":"name"},"options":{"rangeDefinition":"specifyRangeA1","range":"A:E"}},"id":"dr2","name":"Read Sales Data","type":"n8n-nodes-base.googleSheets","typeVersion":4.5,"position":[460,300]},
    {"parameters":{"jsCode":"const rows = $input.all();\nconst today = new Date().toLocaleDateString('en-US', { weekday: 'long', year: 'numeric', month: 'long', day: 'numeric' });\nconst sales = rows.map(r => parseFloat(r.json.Revenue || 0));\nconst totalRevenue = sales.reduce((a, b) => a + b, 0);\nconst orderCount = rows.filter(r => r.json.Revenue && parseFloat(r.json.Revenue) > 0).length;\nconst avgOrderValue = orderCount > 0 ? (totalRevenue / orderCount).toFixed(2) : 0;\nconst yesterday = parseFloat(rows.slice(-1)[0]?.json?.Revenue || 0);\nconst weekAgo = parseFloat(rows.slice(-8, -7)[0]?.json?.Revenue || 0);\nconst weekChange = weekAgo > 0 ? (((yesterday - weekAgo) / weekAgo) * 100).toFixed(1) : 'N/A';\nreturn [{ json: { date: today, totalRevenue: totalRevenue.toFixed(2), orderCount, avgOrderValue, weekOverWeekChange: weekChange } }];"},"id":"dr3","name":"Calculate KPIs","type":"n8n-nodes-base.code","typeVersion":2,"position":[680,300]},
    {"parameters":{"sendTo":"you@yourbusiness.com","subject":"={{ '📊 Daily Report — ' + $json.date }}","emailType":"html","message":"=<html><body style='font-family:Arial,sans-serif;max-width:600px;margin:0 auto;padding:20px'><h1 style='color:#2c3e50'>📊 Daily Business Report</h1><p style='color:#7f8c8d'>{{ $json.date }}</p><table width='100%' cellpadding='12'><tr><td style='background:#f8f9fa;text-align:center;border-radius:6px'><div style='font-size:26px;font-weight:bold;color:#2ecc71'>${{ $json.totalRevenue }}</div><div style='color:#7f8c8d;font-size:13px'>Revenue</div></td><td style='background:#f8f9fa;text-align:center;border-radius:6px'><div style='font-size:26px;font-weight:bold;color:#3498db'>{{ $json.orderCount }}</div><div style='color:#7f8c8d;font-size:13px'>Orders</div></td><td style='background:#f8f9fa;text-align:center;border-radius:6px'><div style='font-size:26px;font-weight:bold;color:#9b59b6'>${{ $json.avgOrderValue }}</div><div style='color:#7f8c8d;font-size:13px'>Avg Order</div></td><td style='background:#f8f9fa;text-align:center;border-radius:6px'><div style='font-size:26px;font-weight:bold;color:#e67e22'>{{ $json.weekOverWeekChange }}%</div><div style='color:#7f8c8d;font-size:13px'>WoW Change</div></td></tr></table></body></html>"},"id":"dr4","name":"Send Email Report","type":"n8n-nodes-base.gmail","typeVersion":2.1,"position":[900,200]},
    {"parameters":{"webhookUri":"YOUR_SLACK_WEBHOOK_URL","text":"={{ '📊 *Daily Report — ' + $json.date + '*\n💰 Revenue: $' + $json.totalRevenue + '\n📦 Orders: ' + $json.orderCount + '\n📈 WoW: ' + $json.weekOverWeekChange + '%' }}"},"id":"dr5","name":"Post to Slack","type":"n8n-nodes-base.slack","typeVersion":2.2,"position":[900,420]}
  ],
  "connections": {
    "Every Day at 7 AM":{"main":[[{"node":"Read Sales Data","type":"main","index":0}]]},
    "Read Sales Data":{"main":[[{"node":"Calculate KPIs","type":"main","index":0}]]},
    "Calculate KPIs":{"main":[[{"node":"Send Email Report","type":"main","index":0},{"node":"Post to Slack","type":"main","index":0}]]}
  },
  "settings":{"executionOrder":"v1"},
  "tags":[{"name":"reporting"}]
}
Enter fullscreen mode Exit fullscreen mode

Setup (10 minutes)

  1. Import the JSON into n8n (New Workflow → Import from clipboard)
  2. Create your metrics sheet in Google Sheets with columns: Date, Revenue, Orders — or adapt the Code node to match your existing data
  3. Connect your Google account in both the Sheets and Gmail nodes (one OAuth connection covers both)
  4. Replace YOUR_SHEET_ID with your actual sheet ID — it's in the URL: docs.google.com/spreadsheets/d/[SHEET_ID]/edit
  5. Replace you@yourbusiness.com with your email address in the Gmail node
  6. (Optional) Set up a Slack Incoming Webhook and paste the URL in Node 5, or delete that node entirely
  7. Adjust the cron in Node 1 — 0 7 * * * fires at 7 AM UTC. Change 7 to any hour you prefer.
  8. Activate the workflow — it runs automatically from now on

First run: manually trigger Node 1 to verify it reads your sheet correctly before activating.

Customizations

Multiple data sources

Add more Sheets nodes before the Code node — one sheet for sales, one for support tickets, one for email open rates. In the Code node, access them by index: const salesRows = $input.all() (with a Merge node upstream to combine them).

Pull from Stripe or Shopify directly

Replace the Sheets node with an HTTP Request node hitting the Stripe API (/v1/charges?created[gte]=YESTERDAY_TIMESTAMP) or Shopify Orders API. Same Code node logic applies — just adjust the field names.

Weekly digest instead of daily

Change the cron to 0 8 * * 1 (every Monday at 8 AM). Update the Code node to sum the last 7 rows instead of just yesterday's data.

Add traffic data

Add an HTTP Request node that calls the Google Analytics Data API for sessions, bounce rate, and top pages from the previous day. Merge it into the Code node alongside your sales data.

Color-coded status (green/red)

In the Code node, add: targetMet: parseFloat($json.totalRevenue) >= YOUR_DAILY_GOAL. In the email HTML, reference it to make the Revenue card green when you hit target and red when you miss.

Real impact

For a solo founder running an online store, this means waking up to a clean summary instead of opening 5 apps. You know within 10 seconds of looking at your phone whether yesterday was good.

For agency owners with multiple clients: add a loop over an array of sheet IDs. One workflow run, one report per client, all in your inbox by 7:05 AM.

The workflow runs on n8n — self-hosted, open source, no monthly per-workflow fees.

Get the full automation bundle

This workflow is part of the FlowKit 15-template n8n bundle — each template covers a different business use case: lead capture, invoice generation, AI customer support, social media automation, price monitoring, appointment reminders, and more.

Grab the full bundle at stripeai.gumroad.com — pre-tested, documented, ready to activate.

Built with n8n. Self-hostable, open source, no vendor lock-in.

Top comments (0)