Weekly Magento 2 Stuck Orders Report via Gmail & Sheets

This n8n workflow automatically identifies Magento 2 orders stuck in the same status (e.g., 'processing') for the past 7 business days (excluding weekends). It runs every Monday at 8 AM via Schedule Trigger, fetches order data using Magento 2 REST API, filters key details like customer name, order value, phone, and email, then compiles them into a dated Google Sheet report.

The workflow formats a professional HTML email sent via Gmail to the store manager, including a summary table of stuck orders and a direct link to the full Google Sheet for immediate action. Dynamic business day calculations ensure accurate stale order detection, preventing fulfillment delays and lost revenue.

Ideal for Magento 2 store owners, operations teams, and automation engineers. Benefits include reduced manual monitoring, better visibility on delayed orders, proactive issue resolution to maintain customer trust, and seamless integration of Magento with Google Workspace. Streamline e-commerce operations and boost efficiency with this ready-to-deploy solution.