{
  "name": "Send return pickup reminders via WhatsApp & voice calls using Google Sheets",
  "nodes": [
    {
      "id": "8ba000c7-4b3d-4877-923e-363d74c5609e",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        1472,
        1008
      ]
    },
    {
      "id": "c05c0117-a034-4c42-928e-01edaca1aef8",
      "name": "Send WhatsApp Notification",
      "type": "n8n-nodes-base.twilio",
      "position": [
        2368,
        928
      ]
    },
    {
      "id": "cd375f45-06e8-4411-a622-5d3c6b8b4e13",
      "name": "Get Pickup Scheduled Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1696,
        1008
      ]
    },
    {
      "id": "e872f686-6c13-451f-9487-6c52a3df6099",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        2144,
        1008
      ]
    },
    {
      "id": "3510b4bc-0d18-4cd7-b782-66eb1b86edae",
      "name": "Place Voice Call Reminder",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        2592,
        928
      ]
    },
    {
      "id": "4099920f-0be7-44f0-ab25-a7b85ca91933",
      "name": "Update Reminder Status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2864,
        1008
      ]
    },
    {
      "id": "53ca04ed-9108-4e4b-b8c6-bbdefdb59b04",
      "name": "Create WhatsApp & Voice Call Message",
      "type": "n8n-nodes-base.code",
      "position": [
        1936,
        1008
      ]
    },
    {
      "id": "dfefb95b-f47d-4029-b2b1-ad8e15a024ee",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1440,
        1280
      ],
      "parameters": {
        "width": 464,
        "height": 144,
        "content": "## Google sheet\n\nhttps://docs.google.com/spreadsheets/d/1P-rwG-J_Wqj_SAVIgQC49qzp6bA42v-S5Y9vwBASwDg/edit?usp=sharing"
      }
    },
    {
      "id": "8b8aba48-8b61-4592-9c5e-7b6fac9e3cd5",
      "name": "Workflow Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1072,
        848
      ],
      "parameters": {
        "width": 356,
        "height": 572,
        "content": "## How it works\nThis workflow automates return pickup reminders for e-commerce orders. Every day at 10 AM, it checks a Google Sheet for pending pickups scheduled for today, then sends personalized Wha"
      }
    },
    {
      "id": "bf22edaf-70c9-4f80-83d7-dd578c714f98",
      "name": "Data Retrieval",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1440,
        848
      ],
      "parameters": {
        "width": 646,
        "height": 412,
        "content": "## Data Retrieval\nFetches today's pending pickups from Google Sheets and formats notification messages."
      }
    },
    {
      "id": "d5341549-8f2c-4cbd-a0d5-25535ae619d3",
      "name": "Customer Notifications",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2304,
        768
      ],
      "parameters": {
        "width": 440,
        "height": 492,
        "content": "## Customer Notifications\nProcesses each pickup one-by-one, sending WhatsApp message followed by automated voice call reminder."
      }
    },
    {
      "id": "b54c3673-7ef1-4731-bae8-1d051984e483",
      "name": "Status Update",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2752,
        768
      ],
      "parameters": {
        "width": 288,
        "height": 492,
        "content": "## Status Update\nMarks the pickup status as \"Reminder Sent\" in the sheet, then loops back for the next customer."
      }
    }
  ],
  "connections": {
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "Send WhatsApp Notification",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Get Pickup Scheduled Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update Reminder Status": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Pickup Scheduled Data": {
      "main": [
        [
          {
            "node": "Create WhatsApp & Voice Call Message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Place Voice Call Reminder": {
      "main": [
        [
          {
            "node": "Update Reminder Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send WhatsApp Notification": {
      "main": [
        [
          {
            "node": "Place Voice Call Reminder",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create WhatsApp & Voice Call Message": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}