Send payment reminders and cancel unpaid Shopify orders via Gmail
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 22 nodes and runs when another workflow fails (error workflow) (plus 1 other trigger). Along the way it connects Gmail and GraphQL.
How it runs
Trigger: When another workflow fails (error workflow) (plus 1 other trigger).
- Send Error Notification (Gmail): uses Gmail
- Set Workflow Config (Edit Fields (Set)): sets 8 fields: shopifyDomain, adminEmail, reminder1Days…
- Fetch Unpaid Shopify Orders (GraphQL): uses GraphQL
- Split Orders from GraphQL Response (Split Out): splits a list into separate items
- Filter: keeps only the items that match a condition
- Process Orders in Batches (Loop Over Items (Split in Batches)): loops over the items in batches
- Format Order Data for CSV (Code): runs custom JavaScript code
- Generate Admin Report Email (Code): runs custom JavaScript code
- Calculate Days & Determine Action (Code): runs custom JavaScript code
- Convert to CSV File (Convert to File): converts data to a file
…plus 10 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (13)
- Error Trigger
n8n-nodes-base.errorTrigger - Gmail
n8n-nodes-base.gmail - Edit Fields (Set)
n8n-nodes-base.set - Schedule Trigger
n8n-nodes-base.scheduleTrigger - GraphQL
n8n-nodes-base.graphql - Split Out
n8n-nodes-base.splitOut - Filter
n8n-nodes-base.filter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - Switch
n8n-nodes-base.switch - If
n8n-nodes-base.if - Convert to File
n8n-nodes-base.convertToFile - Merge
n8n-nodes-base.merge
From the author
Quick overview This workflow runs daily to find open, unpaid Shopify orders, send staged payment reminder emails via Gmail, and automatically cancel long-unpaid orders while restocking inventory. It also emails an admin a daily CSV audit report and sends…