Every morning someone on your team opens the admin panel, copies yesterday's orders into a spreadsheet, cross-checks payments, and forwards the file. It takes 30–60 minutes, it is error-prone, and the numbers are stale by lunch. Automating this single report is one of the fastest-paying automation projects we deliver.
The business problem
Manual reporting fails in three predictable ways. It costs hours of skilled time every week. It introduces copy-paste errors that quietly distort decisions. And because it depends on a person being available, the report stops the moment that person is on leave. For a growing store processing dozens or hundreds of orders a day, "we'll check the numbers later" becomes "we don't really know our numbers."
The automation solution
We use n8n — a self-hosted workflow engine you fully control — to move sales data from your store and payment provider straight into Google Sheets on a schedule. No copy-paste, no manual export. n8n pulls orders from OpenCart, WordPress/WooCommerce, or a Laravel application via API, enriches them with payment status from LiqPay or Monobank, and writes a clean, formatted row set into a shared sheet. The report is ready before anyone arrives.
Concrete steps
- Connect the source. n8n queries your store's order API (OpenCart REST, WooCommerce, or a Laravel endpoint) for orders created in the reporting window.
- Reconcile payments. A second node matches each order against LiqPay or Monobank transactions, flagging paid, pending, and refunded states so the report reflects real revenue, not just placed orders.
- Shape the data. A Set/Function node calculates totals, average order value, and per-channel breakdowns, then formats dates and currency consistently.
- Write to Google Sheets. The Google Sheets node appends rows to a daily tab and updates a summary sheet your team and management already use.
- Schedule and notify. A Cron trigger runs the workflow every morning; a final node posts a short summary to Telegram or email so stakeholders see the headline numbers without opening the file.
- Handle errors. We add retry logic and an alert path, so a failed API call notifies us instead of silently producing an empty report.
The result is a report that updates itself seven days a week, survives staff absence, and gives founders and operations leads a single trustworthy source of revenue truth.
Why this scales
Once the pipeline exists, extending it is cheap. Add a profit-margin column, a refunds dashboard, a per-manager sales view, or a second sheet for accounting — each is another node, not another hour of manual work. The same n8n foundation later powers inventory sync, lead routing, and payment reconciliation.
MaxiMoruM has built reporting and integration automations on PHP, Laravel, WordPress, and OpenCart for more than 20 years, with native LiqPay, Monobank, and Nova Poshta integrations. If a person on your team is still building a sales report by hand, we can replace that task with a reliable automated workflow.
Discuss your automation project at https://maximorum.com/