Most teams still start the day by exporting yesterday's orders, pasting them into a spreadsheet, and counting revenue by hand. It works — until it costs an hour a day and quietly drifts out of date. An n8n workflow removes that work entirely: it pulls orders from your store, aggregates the numbers, and writes a clean daily report into Google Sheets before anyone logs in.
The business problem
Manual reporting is slow, error-prone, and impossible to scale. When the report lives in one person's head and one local file, decisions wait on availability, numbers get miscounted, and there is no audit trail. As order volume grows, the daily export becomes a bottleneck that delays the exact data your team needs to act on.
The solution
A scheduled n8n workflow connects your store database or API directly to Google Sheets. It runs on a fixed schedule, calculates the metrics that matter — total revenue, order count, average order value, top products — and appends a dated row to a shared sheet. The report is consistent, timestamped, and available to everyone the moment they open the file.
Build it in five steps
- Trigger on a schedule. Add a Schedule Trigger node set to run once daily, for example at 06:00. This replaces the manual "remember to do it" step.
- Pull yesterday's orders. Use an HTTP Request node against your store API (OpenCart, WooCommerce) or a Postgres/MySQL node against a Laravel database. Filter by date so you only fetch the previous day's completed orders.
- Aggregate the numbers. With a Code or Set node, sum order totals, count orders, compute average order value, and rank top products. Keep the logic in one node so the calculation is easy to audit and adjust.
- Write to Google Sheets. The Google Sheets node appends a new row — date, revenue, order count, AOV, top SKU — to your reporting tab. Each run adds one clean, dated line, building a running history automatically.
- Notify the team. Add a Telegram or email node to post the headline numbers to your sales channel, so the report reaches people without anyone opening the sheet.
Why it pays off
The workflow runs in seconds and costs nothing in labor. You reclaim the daily reporting hour, eliminate copy-paste errors, and gain a continuous, trustworthy revenue history. Because n8n is self-hosted, your order data never leaves your infrastructure — a real advantage when sales figures are sensitive. The same pattern extends easily: add weekly summaries, low-stock alerts, or a second sheet for refunds without rebuilding anything.
At MaxiMoruM we have spent 20+ years building and integrating systems on PHP, Laravel, WordPress, and OpenCart — including automation pipelines that connect stores, payments, and reporting. We design n8n workflows around how your business actually operates, then keep them running in production.
Want automated reporting wired into your store? Talk to our team at maximorum.com