AutomationFlowsE-commerce › Automated Woocommerce Abandoned Cart Recovery with Google Sheets Email Reminders

Automated Woocommerce Abandoned Cart Recovery with Google Sheets Email Reminders

ByJacob @jacobgad on n8n.io

This workflow connects directly to your WooCommerce store using the REST API to fetch all recent orders. It logs them in Google Sheets for easy tracking and visibility. Every day at a scheduled time, it checks for orders with the "pending" status that haven't received a reminder…

Cron / scheduled trigger★★★★☆ complexity11 nodesHTTP RequestGoogle SheetsEmail Send
E-commerce Trigger: Cron / scheduled Nodes: 11 Complexity: ★★★★☆ Added:

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

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

Download .json
{
  "id": "70dLD2GDb2VSXLjF",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "WooCommerce Abandoned Cart Recovery",
  "tags": [],
  "nodes": [
    {
      "id": "684c3f0b-9ef5-459f-a221-6d7e6ba2d381",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1264,
        0
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "c780c6b1-1bf3-4284-a6ab-95c0cbbab24d",
      "name": "Schedule Trigger1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1216,
        352
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "a777804c-bcd7-4821-800e-25785a2dc906",
      "name": "Date & Time",
      "type": "n8n-nodes-base.dateTime",
      "position": [
        -624,
        352
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "e96dcd48-58f7-4336-a2fd-3214a3f776f4",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1296,
        -176
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b9724f32-e22f-48a2-b679-f54838ad18d0",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1296,
        224
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "9579d2f4-fa35-4176-9b2d-ec7925623856",
      "name": "HTTP Request1",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1088,
        0
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "93375dcd-fceb-4da7-a0ac-6c83580c6308",
      "name": "Convert data",
      "type": "n8n-nodes-base.code",
      "position": [
        -912,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "a1d137a4-3a7c-4211-b5e7-07f445470343",
      "name": "Adding orders to Google Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -720,
        0
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "caa2b8cf-b75f-455b-82b0-5f8c33d272ee",
      "name": "Get order with pending status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -992,
        352
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "407435eb-4bf3-46c8-895f-571e37635908",
      "name": "Reminder Sent Email Update",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -448,
        352
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "4b2f6389-42bf-4e5c-84a5-bb1525a18681",
      "name": "Send remider email",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        -800,
        352
      ],
      "parameters": {},
      "typeVersion": 2.1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "bab8b6c4-e419-48d9-b3f9-20f35ad25263",
  "connections": {
    "Date & Time": {
      "main": [
        [
          {
            "node": "Reminder Sent Email Update",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert data": {
      "main": [
        [
          {
            "node": "Adding orders to Google Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request1": {
      "main": [
        [
          {
            "node": "Convert data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "HTTP Request1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger1": {
      "main": [
        [
          {
            "node": "Get order with pending status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send remider email": {
      "main": [
        [
          {
            "node": "Date & Time",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Reminder Sent Email Update": {
      "main": [
        [
          {
            "node": "Get order with pending status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get order with pending status": {
      "main": [
        [
          {
            "node": "Send remider email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

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

About this workflow

This workflow connects directly to your WooCommerce store using the REST API to fetch all recent orders. It logs them in Google Sheets for easy tracking and visibility. Every day at a scheduled time, it checks for orders with the "pending" status that haven't received a reminder…

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

More E-commerce workflows → · Browse all categories →

Related workflows

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

E-commerce

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

Shopify, Google Sheets, Gmail +2
E-commerce

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

HTTP Request, Google Sheets, Gmail
E-commerce

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

HTTP Request, Google Sheets
E-commerce

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

HTTP Request, N8N Nodes Rapiwa, Google Sheets
E-commerce

E-commerce store owners and sales managers who want AI-powered insights from their Shopify data without manually crunching numbers every week.

Shopify, HTTP Request, Slack +2