Automate Magento 2 Weekly Sales & Performance Reports

This n8n workflow automates weekly sales and performance reporting for Magento 2 stores. It triggers every week via Schedule node, uses HTTP Request to pull the last 7 days of orders from Magento 2 API (Bearer Token auth), and processes data in a Code (JavaScript) node to calculate key metrics like total orders, revenue, top products sold, and performance breakdowns.

The workflow then generates a Google Sheet with two tabs: 'Weekly Summary' for high-level KPIs and 'Product Breakdown' for detailed sales by item. Finally, it crafts a modern dashboard-style HTML report and sends it via Gmail, eliminating manual logins, exports, or custom modules.

Benefits include massive time savings (1-2 hours/week per store), scalability for agencies managing multiple clients, and actionable insights without extra costs. Ideal for e-commerce owners, agencies, marketing teams needing product performance data regularly.

Use cases: Store managers wanting hands-off reporting; agencies delivering client dashboards; growth teams tracking weekly trends in Sheets for analysis.