Automate your Magento 2 weekly sales & performance reports

by Kanaka Kishore Kandregula ✓ · 153 views · created 2025-08-03 · CRM

What this workflow does

This workflow has 10 nodes and runs on a schedule (every day). Along the way it connects Google Sheets and Gmail.

How it runs

Trigger: On a schedule (every day).

1. GET Week Dates (Code): runs custom JavaScript code
2. Create spreadsheet (Google Sheets): uses Google Sheets
3. Get Last Week Orders (HTTP Request): calls an HTTP API
4. Code: runs custom JavaScript code
5. Product Breakdown (Code): runs custom JavaScript code
6. Weekly Summary (Code): runs custom JavaScript code
7. Log Products Breakdown (Google Sheets): uses Google Sheets
8. Log Weekly Summary (Google Sheets): uses Google Sheets
9. Send a message (Gmail): uses Gmail

Services it uses

Google SheetsGmail

Before you upgrade to n8n 3.0

Nodes used (5)

• Coden8n-nodes-base.code
• HTTP Requestn8n-nodes-base.httpRequest
• Google Sheetsn8n-nodes-base.googleSheets
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Gmailn8n-nodes-base.gmail

From the author

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…

View the original on n8n.io → Check your own copy