Weekly Magento 2 stuck order reporting with Gmail & Google Sheets

by Kanaka Kishore Kandregula ✓ · 62 views · created 2025-08-05 · Content Creation, Multimodal AI

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. Create spreadsheet (Google Sheets): uses Google Sheets
2. Get Media Path (HTTP Request): calls an HTTP API
3. SetOrGet Logo (Code): runs custom JavaScript code
4. Get Past 5 Days Excluding Weekends (Code): runs custom JavaScript code
5. Get Processing Orders (HTTP Request): calls an HTTP API
6. Get Order Data (Code): runs custom JavaScript code
7. Append or update row in sheet (Google Sheets): uses Google Sheets
8. Built Reporting Email (Code): runs custom JavaScript code
9. Send a message (Gmail): uses Gmail

Services it uses

Google SheetsGmail

Before you upgrade to n8n 3.0

Nodes used (5)

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

From the author

Automatically identifies and reports Magento 2 orders stuck for the past 7 business days. Sends a weekly email alert to the store manager with a Google Sheets report, helping streamline order follow-ups and prevent fulfilment delays. 🔍 What It Does: This n8n…

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