Kanaka Kishore Kandregula This workflow corresponds to n8n.io template #6989 — we link there as the canonical source.
This workflow follows the Gmail → Google Sheets recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"meta": {
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "032b7669-be9a-44dd-8331-5be93cf23f5c",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-760,
-260
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "239c0712-f73d-421d-b085-18a445e7e9f1",
"name": "Get Media Path",
"type": "n8n-nodes-base.httpRequest",
"position": [
-320,
-260
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "c3b506a2-a646-4378-ba8b-3445dc7b2a85",
"name": "SetOrGet Logo",
"type": "n8n-nodes-base.code",
"position": [
-100,
-260
],
"parameters": {},
"typeVersion": 2
},
{
"id": "dc638923-e113-41c9-8dbf-eb23b54fa4e6",
"name": "Get Processing Orders",
"type": "n8n-nodes-base.httpRequest",
"position": [
340,
-260
],
"parameters": {},
"typeVersion": 2
},
{
"id": "4d21f976-7869-4f6a-b1c1-a1fa116e2b6a",
"name": "Get Order Data",
"type": "n8n-nodes-base.code",
"position": [
560,
-260
],
"parameters": {},
"typeVersion": 2,
"alwaysOutputData": true
},
{
"id": "f2278b9b-199e-4655-9b68-4decdc9effd8",
"name": "Create spreadsheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-540,
-260
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "38f0dc2a-c9a2-494e-b7d5-3c93c568440a",
"name": "Send a message",
"type": "n8n-nodes-base.gmail",
"position": [
1320,
-260
],
"parameters": {},
"typeVersion": 2.1
},
{
"id": "7239f5a5-d009-4522-8c8a-dffddee99979",
"name": "Append or update row in sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
800,
-260
],
"parameters": {},
"typeVersion": 4.6
},
{
"id": "1925c63a-2e37-41c9-8fdb-16a9a1ec44d0",
"name": "Built Reporting Email",
"type": "n8n-nodes-base.code",
"position": [
1060,
-260
],
"parameters": {},
"typeVersion": 2
},
{
"id": "57751ae4-5892-4ec6-bb34-f0dd749f4566",
"name": "Get Past 5 Days Excluding Weekends",
"type": "n8n-nodes-base.code",
"position": [
120,
-260
],
"parameters": {},
"typeVersion": 2
}
],
"connections": {
"SetOrGet Logo": {
"main": [
[
{
"node": "Get Past 5 Days Excluding Weekends",
"type": "main",
"index": 0
}
]
]
},
"Get Media Path": {
"main": [
[
{
"node": "SetOrGet Logo",
"type": "main",
"index": 0
}
]
]
},
"Get Order Data": {
"main": [
[
{
"node": "Append or update row in sheet",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Create spreadsheet",
"type": "main",
"index": 0
}
]
]
},
"Create spreadsheet": {
"main": [
[
{
"node": "Get Media Path",
"type": "main",
"index": 0
}
]
]
},
"Built Reporting Email": {
"main": [
[
{
"node": "Send a message",
"type": "main",
"index": 0
}
]
]
},
"Get Processing Orders": {
"main": [
[
{
"node": "Get Order Data",
"type": "main",
"index": 0
}
]
]
},
"Append or update row in sheet": {
"main": [
[
{
"node": "Built Reporting Email",
"type": "main",
"index": 0
}
]
]
},
"Get Past 5 Days Excluding Weekends": {
"main": [
[
{
"node": "Get Processing Orders",
"type": "main",
"index": 0
}
]
]
}
}
}
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This n8n automation identifies Magento 2 orders that have been stuck in the same status (like "processing") for the past 7 weekdays (excluding weekends), compiles them into a clean Google Sheet report, and emails the store manager every Monday morning with a snapshot and link to…
Source: https://n8n.io/workflows/6989/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
This workflow automates inventory management and predictive reordering for Shopify stores. It integrates Shopify, Google Sheets, and Slack to monitor inventory levels, calculate dynamic reorder points
A webhook or timer triggers the workflow to automatically fetch inventory data from multiple platforms. Stock levels are compared across stores to identify discrepancies, and any inconsistencies are u
E-commerce store owners and sales managers who want AI-powered insights from their Shopify data without manually crunching numbers every week.
This n8n workflow automatically identifies customers who have abandoned their carts on your Shopify store, cleans and verifies their WhatsApp numbers, and sends them personalized reminders via the Rap
This workflow is perfect for e-commerce store owners using Shopify who want to automatically recover abandoned carts through personalized WhatsApp messages. It's ideal for businesses looking to increa