AutomationFlowsData & Sheets › Abandoned Cart Recovery for Shopify via Gmail, Google Sheets & Twilio (no-code)

Abandoned Cart Recovery for Shopify via Gmail, Google Sheets & Twilio (no-code)

ByVelebit from Innovatio @innovatio on n8n.io

This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to recover lost revenue without coding.

Event trigger★★★★★ complexity60 nodesHTTP RequestGmailTwilioGoogle SheetsShopify TriggerAirtable
Data & Sheets Trigger: Event Nodes: 60 Complexity: ★★★★★ Added:

This workflow corresponds to n8n.io template #3415 — we link there as the canonical source.

This workflow follows the Airtable → Gmail 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 →

Download .json
{
  "id": "DW3ksS9uXl0bZqpA",
  "name": "Abandoned Cart Recovery Email Automation Workflow",
  "tags": [],
  "nodes": [
    {
      "id": "dbcb5a20-ffab-448c-a3ac-1d7b1266a161",
      "name": "Fetch Cart",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1480,
        -140
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "41ac1023-1875-4036-8f5a-61002acecc83",
      "name": "Send Email (Gmail)",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2360,
        -140
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "18129749-d33a-47ea-b7fd-7ab1034b0a6c",
      "name": "Wait 24 Hours",
      "type": "n8n-nodes-base.wait",
      "disabled": true,
      "position": [
        2900,
        460
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d8ed04f0-2860-4ba6-9b60-b04dc2ff047e",
      "name": "Send SMS (Twilio)",
      "type": "n8n-nodes-base.twilio",
      "disabled": true,
      "position": [
        2700,
        460
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "75a6bdf0-a76d-4e69-b0f1-43fb9858e13c",
      "name": "Log to Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2840,
        -140
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "0843ecb9-1ee5-4d7b-8218-31fab02cd2cf",
      "name": "Shopify Trigger",
      "type": "n8n-nodes-base.shopifyTrigger",
      "position": [
        -460,
        -140
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "a05b26e8-81c5-434c-b66c-073601f4110d",
      "name": "GET Checkout Status",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        860,
        -140
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "5ea4e065-2a7a-4104-a2b0-c773f47c9d74",
      "name": "Completed Checkout?",
      "type": "n8n-nodes-base.if",
      "position": [
        1080,
        -140
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "a2650e46-464b-4781-93a5-03a3e5464bf7",
      "name": "Mark as \"Recovered Naturally\"",
      "type": "n8n-nodes-base.googleSheets",
      "disabled": true,
      "position": [
        800,
        840
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "84ae9b4f-0dfc-4082-92f2-2e38bf176424",
      "name": "Extract Key Values",
      "type": "n8n-nodes-base.set",
      "position": [
        140,
        -140
      ],
      "parameters": {},
      "typeVersion": 3.4
    },
    {
      "id": "f5f92cb4-2877-407c-b70d-18b764f18ea2",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -840,
        -580
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "187a22d7-9eed-4120-ad7e-07260789478b",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -240,
        -660
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "88e3aa40-3a4a-459e-8602-9c1d20cbbc04",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1640,
        -820
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "97a284e8-dd3f-438b-a1fc-5ec69662c9e1",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -840,
        20
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "848abc27-e2e4-4b64-a8d4-8ecd27b9bcff",
      "name": "Webhook",
      "type": "n8n-nodes-base.webhook",
      "disabled": true,
      "position": [
        -640,
        500
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "f84d8c8a-66d4-4fdc-a5e8-c8b3b877dd09",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -240,
        20
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "7330df7b-49af-4d8e-8150-e5a746d5fc01",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -820,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "3de41525-1e55-4841-8376-32d73c21f031",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        -400
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "23ce859c-ada9-4146-853d-e91747fffc75",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -520,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "61a233e5-9c8d-46c0-b3e5-f6e36d5efcc8",
      "name": "Sticky Note9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        80,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "090bb1ac-8169-46fa-8b38-7fad10b9d328",
      "name": "Sticky Note10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        360,
        -740
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "814a3f7b-3e5b-4cfa-8c2a-04150e8e9649",
      "name": "Sticky Note11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        420,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "24dc49f2-2253-4787-ba16-a2c6d1df500f",
      "name": "Sticky Note12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        420,
        -400
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "94e7faa2-6496-4a17-834a-ce8345ebdfdd",
      "name": "Sticky Note13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        760,
        -1000
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "f62ce466-2417-483b-8118-0e30c585ee80",
      "name": "Sticky Note14",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        760,
        20
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "7ceb6745-5581-4ccb-9c01-89e3d661aebb",
      "name": "Sticky Note15",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        800,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "52b21512-635e-4655-814b-9f11e91941cd",
      "name": "Sticky Note16",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        780,
        -640
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c0191d35-5107-47fe-b573-d660392d3139",
      "name": "Sticky Note17",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1040,
        -520
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "10fae9e4-833b-42d1-991d-7faf8546fc37",
      "name": "Sticky Note18",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -520,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6bc23e15-de2b-4b15-8fcb-4e0b04c297c1",
      "name": "Sticky Note19",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        760,
        420
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "cb906b46-aa88-4373-8106-4c33fba5f0e8",
      "name": "Airtable",
      "type": "n8n-nodes-base.airtable",
      "disabled": true,
      "position": [
        1120,
        840
      ],
      "parameters": {},
      "typeVersion": 2.1
    },
    {
      "id": "9b237c7c-567c-404b-8d03-738061457925",
      "name": "Sticky Note20",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1340,
        -1120
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "9a3f776b-6e1f-4313-8e88-8f0fe62870f1",
      "name": "Sticky Note21",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1420,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fa1ba6f9-8a00-472f-a731-5711bb27f3ca",
      "name": "Sticky Note22",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1360,
        -640
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "068a63c5-ab3e-405d-b61a-29e46a791c0b",
      "name": "Sticky Note23",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1340,
        20
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "36dcbbda-2c4a-4e1d-a5a5-c1509a154e71",
      "name": "Sticky Note24",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1780,
        -1260
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fde98405-859a-4022-8a79-e2f550833ff8",
      "name": "Sticky Note25",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1860,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "22cfecf9-1988-4016-8b07-3fec67082457",
      "name": "Sticky Note26",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1800,
        -760
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "9b721f12-ca57-44df-a84b-a9500bb546a2",
      "name": "Sticky Note27",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1780,
        20
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fa06a2f6-9209-4608-b5be-66e77164ed97",
      "name": "Sticky Note28",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1780,
        600
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "50bceea4-ca69-4c5f-8500-3057c1814b27",
      "name": "Sticky Note29",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1780,
        1180
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c7b6737c-d7a6-47cb-8e32-0c46465e1717",
      "name": "Apply Global Discount Code",
      "type": "n8n-nodes-base.set",
      "position": [
        1920,
        -140
      ],
      "parameters": {},
      "notesInFlow": false,
      "typeVersion": 3.4
    },
    {
      "id": "9f42e402-4850-4a34-bbb0-585f26f6a8cc",
      "name": "Sticky Note30",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2220,
        -1380
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fbc42590-c833-436a-8f48-8846cef0cbe8",
      "name": "Sticky Note31",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2300,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c2859ff4-4867-472a-a790-6a5f10776550",
      "name": "Sticky Note32",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2240,
        -820
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "a01cbb1a-f02e-4c95-998f-96c3e28b2cee",
      "name": "Sticky Note33",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2220,
        20
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d9d57bb6-4a96-4bd2-a1f0-3afd87b2cb2c",
      "name": "Sticky Note34",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2220,
        640
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "3dbc18de-6e44-4805-be96-f3a40b13a854",
      "name": "Sticky Note35",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2660,
        -1600
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "0305e2f6-3212-4172-8731-7e43df65962a",
      "name": "Sticky Note36",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2740,
        -200
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "971196b7-d84a-41cb-997d-a339d2a7f123",
      "name": "Sticky Note37",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2680,
        -1180
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "20dc36d2-74cb-484e-9a2e-829888ab4dfe",
      "name": "Sticky Note38",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3140,
        -560
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "f36e17cf-ff68-4d3b-800b-a1faff1b7f12",
      "name": "Sticky Note39",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2660,
        20
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "1c779e0d-a8d1-4e18-864e-8a8cc4a169d7",
      "name": "Sticky Note40",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2660,
        640
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6515c0ff-09aa-4d35-a999-be06198cf02d",
      "name": "Wait some hours",
      "type": "n8n-nodes-base.wait",
      "position": [
        480,
        -140
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "aa2b3690-c86f-473b-a908-3f81e660db7a",
      "name": "Wait some days",
      "type": "n8n-nodes-base.wait",
      "position": [
        3220,
        -160
      ],
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "70381b8c-0553-4104-ba61-fc18d3f86900",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "disabled": true,
      "position": [
        2840,
        1080
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "53ef93d0-4a1d-4b07-8f88-3487b2a391db",
      "name": "GET Checkout Status1",
      "type": "n8n-nodes-base.httpRequest",
      "disabled": true,
      "position": [
        3040,
        1180
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "03231319-5aa5-48e9-aaa8-fb210ad17c21",
      "name": "Ready to take this to the next level? We at Innovatio are cheering for you!!! Best of luck and great successes to you all <3 Velebit from Innovatio",
      "type": "n8n-nodes-base.noOp",
      "disabled": true,
      "position": [
        3540,
        -160
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "007fe0ad-d301-49c4-8039-4909baff7ff6",
      "name": "Sticky Note8",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3720,
        -820
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c743633f-ad54-4dc0-81c6-3e3049ab2e66",
      "name": "Sticky Note41",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -260,
        -820
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "4e663998-3ff1-4920-8686-05b60dad1e93",
  "connections": {
    "Fetch Cart": {
      "main": [
        [
          {
            "node": "Apply Global Discount Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait some days": {
      "main": [
        [
          {
            "node": "Send SMS (Twilio)",
            "type": "main",
            "index": 0
          },
          {
            "node": "Ready to take this to the next level? We at Innovatio are cheering for you!!! Best of luck and great successes to you all <3 Velebit from Innovatio",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "GET Checkout Status1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Shopify Trigger": {
      "main": [
        [
          {
            "node": "Extract Key Values",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait some hours": {
      "main": [
        [
          {
            "node": "GET Checkout Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send SMS (Twilio)": {
      "main": [
        [
          {
            "node": "Wait 24 Hours",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Key Values": {
      "main": [
        [
          {
            "node": "Wait some hours",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Email (Gmail)": {
      "main": [
        [
          {
            "node": "Log to Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Completed Checkout?": {
      "main": [
        [
          {
            "node": "Mark as \"Recovered Naturally\"",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Fetch Cart",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "GET Checkout Status": {
      "main": [
        [
          {
            "node": "Completed Checkout?",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Log to Google Sheet": {
      "main": [
        [
          {
            "node": "Wait some days",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "GET Checkout Status1": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Apply Global Discount Code": {
      "main": [
        [
          {
            "node": "Send Email (Gmail)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Mark as \"Recovered Naturally\"": {
      "main": [
        []
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to recover lost revenue without coding.

Source: https://n8n.io/workflows/3415/ — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.

Data & Sheets

This guide will walk you through setting up your n8n workflow. By the end, you'll have a fully automated system for managing your recruitment pipeline.

Google Calendar Trigger, Slack, HTTP Request +4
Data & Sheets

This template is perfect for Gumroad creators, solopreneurs, digital product sellers, and freelancers who want to track and thank customers automatically — without spending time on manual work.

Google Sheets, Gumroad Trigger, Telegram +8
Data & Sheets

This workflow triggers when a HubSpot deal stage changes to Closed Won and automatically generates an invoice. It collects deal and contact data, builds a styled invoice, converts it into a PDF, and s

HubSpot Trigger, HTTP Request, Google Sheets +4
Data & Sheets

This workflow automates tax compliance by aggregating multi-channel revenue data, calculating jurisdiction-specific tax obligations, detecting anomalies, and generating submission-ready reports for ta

Gmail, Google Sheets, Airtable +1
Data & Sheets

This n8n workflow automates the end-to-end client onboarding process: capturing client details, validating emails, assigning tiers, generating welcome packs, creating tasks, notifying teams, archiving

Google Sheets, Gmail, Airtable +5