Back to Templates
Automatically fetches last week’s Magento 2 orders, summarises sales and product performance, logs the data to Google Sheets, and emails a polished report — all without logging into admin or buying extra modules.
Perfect for store owners and agencies.
✅ What This Workflow Does:
This workflow automatically fetches the last 7 days of orders from your Magento 2 store, summarizes key metrics (orders, revenue, products sold), groups product performance data, generates a Google Sheet with two tabs (Weekly Summary & Product Breakdown), and emails the report to your team in a modern dashboard-style HTML format — all without ever logging into Magento admin.
🔧 Modules Used:
🕒 Schedule Trigger
⚙️ Code (JavaScript)
🌐 HTTP Request
📊 Google Sheets
✉️ Gmail (HTML Email with custom design)
💼 Use Cases:
- E-commerce store managers who want weekly sales snapshots without logging into Magento 2.
- Agencies managing multiple Magento clients and reporting to them weekly.
- Business owners who want automated insights without paying for extra reporting modules.
- Marketing or growth teams that need product-wise performance regularly in Google Sheets.
🔒 Credentials Required:
- Magento 2 API (Bearer Token)
- Google Sheets OAuth2
- Gmail OAuth2 (for sending HTML email reports)
📂 Category:
E-commerce / Magento 2 / Reporting / Automation
✨ Why This Saves Hours:
This workflow replaces manual Magento report exports, repetitive data cleanup, and weekly email formatting. Store managers often waste 1–2 hours/week collecting data — now it takes 0 minutes. Just set it and forget it.
You don’t need to buy reporting extensions, log into the admin, or manually touch a spreadsheet again.
🤝 Need a Custom Workflow?
If you need this tailored for your own workflow, store, or client —
📩 Let’s connect. I build custom, high-performance n8n automations for e-commerce, growth, and reporting.
Contact: Author
👤 Author
Kanaka Kishore Kandregula
Certified Magento 2 Developer
https://gravatar.com/kmyprojects
https://www.linkedin.com/in/kanakakishore