{
  "name": "Manage garage service reminders, pickups and feedback with Airtable, WhatsApp and Gmail",
  "nodes": [
    {
      "id": "290e4899-52ef-4fdc-94ad-bf50f9e756cd",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        976,
        688
      ],
      "parameters": {
        "width": 412,
        "height": 588,
        "content": "## How it works\nThis workflow automates customer communication for a car service garage across four stages:\n\n1. **Daily reminders** for upcoming services (7-day window)\n2. **Pickup notifications** whe"
      }
    },
    {
      "id": "d4e7a2d2-b11d-4309-a734-2747ef2a7fa4",
      "name": "Fetch Pending Services (±7 Days)",
      "type": "n8n-nodes-base.airtable",
      "position": [
        1696,
        768
      ]
    },
    {
      "id": "fb293841-20e0-49a8-8f35-6aec3eb5d857",
      "name": "Iterate Services",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1888,
        768
      ]
    },
    {
      "id": "9836616b-6868-4cc1-90fd-ef3e8e5f143d",
      "name": "Build Reminder Messages",
      "type": "n8n-nodes-base.code",
      "position": [
        2096,
        784
      ]
    },
    {
      "id": "d82831f8-c284-4d55-abc8-9a208d3ff7c4",
      "name": "Send WhatsApp Reminder",
      "type": "n8n-nodes-base.twilio",
      "position": [
        2256,
        784
      ]
    },
    {
      "id": "771cc8f7-31e9-407e-9ec5-48d9d70fecfe",
      "name": "Send Email Reminder",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2432,
        784
      ]
    },
    {
      "id": "475fe83c-3d54-4e8e-ae21-63fd5689bba2",
      "name": "Mark Reminder Sent",
      "type": "n8n-nodes-base.airtable",
      "position": [
        2608,
        784
      ]
    },
    {
      "id": "26c0b88a-cf22-4c70-9a0b-bf484f0b0861",
      "name": "Run to Service Status Changed → Done",
      "type": "n8n-nodes-base.airtableTrigger",
      "position": [
        1472,
        1104
      ]
    },
    {
      "id": "2dcb2d29-674b-4b76-9c8b-abed43ce0864",
      "name": "Iterate Completed Services",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1648,
        1104
      ]
    },
    {
      "id": "2070157d-dc5f-49ca-b544-bf42cf885440",
      "name": "Build Pickup Messages",
      "type": "n8n-nodes-base.code",
      "position": [
        1856,
        1120
      ]
    },
    {
      "id": "29a6fffe-5f4a-447b-89c4-cf1b18a62f06",
      "name": "Send Pickup WhatsApp",
      "type": "n8n-nodes-base.twilio",
      "position": [
        2048,
        1120
      ]
    },
    {
      "id": "216f3894-6257-423d-b231-9788f962fdc4",
      "name": "Send Pickup Email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2240,
        1120
      ]
    },
    {
      "id": "d2d897f9-73fe-4767-a978-fd779171a6a1",
      "name": "Mark Pickup Notification Sent",
      "type": "n8n-nodes-base.airtable",
      "position": [
        2432,
        1120
      ]
    },
    {
      "id": "076f433f-5c9c-4fd8-af9a-adf18ea78971",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1408,
        688
      ],
      "parameters": {
        "width": 1376,
        "height": 288,
        "content": "## Scheduled Service Reminders\nRuns daily at 9 AM. Fetches pending services within ±7 days, builds personalized messages, and sends via WhatsApp + Email."
      }
    },
    {
      "id": "c7afdca0-fb7b-46f6-a110-4e5437a844cc",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1408,
        1008
      ],
      "parameters": {
        "width": 1376,
        "height": 336,
        "content": "## Pickup Notifications\nTriggered when service status changes to \"Done\". Notifies customers their vehicle is ready for collection."
      }
    },
    {
      "id": "0451ba63-1e9e-44bf-87ba-2daa28f1e6e2",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1408,
        1376
      ],
      "parameters": {
        "width": 1376,
        "height": 320,
        "content": "## Feedback Collection\nTriggered when status changes to \"Delivered\". Sends feedback form link to gather customer reviews."
      }
    },
    {
      "id": "41483f9d-75df-45ba-95d3-8dedee72dfc3",
      "name": "Daily Service Reminder Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        1504,
        768
      ]
    },
    {
      "id": "c630f7c7-d52e-4f9e-93ca-bfa45cc26e8b",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        976,
        1296
      ],
      "parameters": {
        "width": 408,
        "height": 124,
        "content": "📋 **Feedback Form**\n\nhttps://forms.gle/LHfFRQPU9fKaH8LB8\n\nUpdate this link in the \"Build Feedback Messages\" node."
      }
    },
    {
      "id": "b24c9cb7-f45e-44f4-95cc-2665294bd0b8",
      "name": "Next Service Reminder Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        1456,
        1824
      ]
    },
    {
      "id": "873cc2b5-29a9-4847-85d9-7f74abf33ee3",
      "name": "Fetch Next Services (±7 Days)",
      "type": "n8n-nodes-base.airtable",
      "position": [
        1648,
        1824
      ]
    },
    {
      "id": "eec70787-dfe9-4286-b69c-b307320e33b8",
      "name": "Iterate Services ",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1840,
        1824
      ]
    },
    {
      "id": "2ddd1089-dd3b-4d0a-b7bf-0ebd881eb324",
      "name": "Build Next Service Reminder Messages",
      "type": "n8n-nodes-base.code",
      "position": [
        2032,
        1840
      ]
    },
    {
      "id": "a3ea2fbf-97ed-40b7-989f-0df0abfe515c",
      "name": "Send Next Service WhatsApp",
      "type": "n8n-nodes-base.twilio",
      "position": [
        2208,
        1840
      ]
    },
    {
      "id": "b5dafd0e-e82a-4af1-a29a-30f6cc8a242a",
      "name": "Send Next Service Email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2400,
        1840
      ]
    },
    {
      "id": "46a861ec-cb06-4e02-85ce-76d607bf639d",
      "name": "Mark Next Service Reminder Sent",
      "type": "n8n-nodes-base.airtable",
      "position": [
        2592,
        1840
      ]
    },
    {
      "id": "a1ca1f15-da9a-40d0-83f6-41cc4658da35",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1408,
        1712
      ],
      "parameters": {
        "width": 1376,
        "height": 368,
        "content": "## Next Service Reminders\nRuns daily at 9 AM. Reminds customers about their next scheduled maintenance (±7 day window)."
      }
    },
    {
      "id": "5f74a602-cf69-461a-a8f8-65c2cbaeadbc",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        976,
        1440
      ],
      "parameters": {
        "width": 400,
        "height": 112,
        "content": "### Google sheet (Feed-Back Collect)\nhttps://docs.google.com/spreadsheets/d/1SIIABzc81XSeJTDqAEWVbj4G5NP7nOPObytjokqKkMM/edit?usp=sharing"
      }
    },
    {
      "id": "bd5f2a20-c33e-4043-8d3b-4c9832ab668f",
      "name": "Vehicle Delivered Trigger",
      "type": "n8n-nodes-base.airtableTrigger",
      "position": [
        1472,
        1472
      ]
    },
    {
      "id": "db9cad37-2bbc-4e4d-8f3b-eeb396bb019a",
      "name": "Iterate Delivered Records",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1696,
        1472
      ]
    },
    {
      "id": "46deea68-142d-494f-9878-ca8f7c239716",
      "name": "Build Feedback Messages",
      "type": "n8n-nodes-base.code",
      "position": [
        1920,
        1488
      ]
    },
    {
      "id": "5b489143-7919-462e-9029-fd774ab5e558",
      "name": "Send Feedback WhatsApp",
      "type": "n8n-nodes-base.twilio",
      "position": [
        2128,
        1488
      ]
    },
    {
      "id": "4fd1c9e9-7122-408f-96d2-c17b5550828d",
      "name": "Send Feedback Email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2336,
        1488
      ]
    },
    {
      "id": "29ad73e0-6d3a-4278-93b2-830de995eff5",
      "name": "Mark Feedback Sent",
      "type": "n8n-nodes-base.airtable",
      "position": [
        2560,
        1488
      ]
    }
  ],
  "connections": {
    "Iterate Services": {
      "main": [
        [],
        [
          {
            "node": "Build Reminder Messages",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Iterate Services ": {
      "main": [
        [],
        [
          {
            "node": "Build Next Service Reminder Messages",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Pickup Email": {
      "main": [
        [
          {
            "node": "Mark Pickup Notification Sent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Mark Feedback Sent": {
      "main": [
        [
          {
            "node": "Iterate Delivered Records",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Mark Reminder Sent": {
      "main": [
        [
          {
            "node": "Iterate Services",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Email Reminder": {
      "main": [
        [
          {
            "node": "Mark Reminder Sent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Feedback Email": {
      "main": [
        [
          {
            "node": "Mark Feedback Sent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Pickup WhatsApp": {
      "main": [
        [
          {
            "node": "Send Pickup Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Pickup Messages": {
      "main": [
        [
          {
            "node": "Send Pickup WhatsApp",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Feedback WhatsApp": {
      "main": [
        [
          {
            "node": "Send Feedback Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send WhatsApp Reminder": {
      "main": [
        [
          {
            "node": "Send Email Reminder",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Feedback Messages": {
      "main": [
        [
          {
            "node": "Send Feedback WhatsApp",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Reminder Messages": {
      "main": [
        [
          {
            "node": "Send WhatsApp Reminder",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Next Service Email": {
      "main": [
        [
          {
            "node": "Mark Next Service Reminder Sent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Iterate Delivered Records": {
      "main": [
        [],
        [
          {
            "node": "Build Feedback Messages",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Vehicle Delivered Trigger": {
      "main": [
        [
          {
            "node": "Iterate Delivered Records",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Iterate Completed Services": {
      "main": [
        [],
        [
          {
            "node": "Build Pickup Messages",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Next Service WhatsApp": {
      "main": [
        [
          {
            "node": "Send Next Service Email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Mark Pickup Notification Sent": {
      "main": [
        [
          {
            "node": "Iterate Completed Services",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Next Service Reminder Trigger": {
      "main": [
        [
          {
            "node": "Fetch Next Services (±7 Days)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Service Reminder Trigger": {
      "main": [
        [
          {
            "node": "Fetch Pending Services (±7 Days)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Next Services (±7 Days)": {
      "main": [
        [
          {
            "node": "Iterate Services ",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Mark Next Service Reminder Sent": {
      "main": [
        [
          {
            "node": "Iterate Services ",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Pending Services (±7 Days)": {
      "main": [
        [
          {
            "node": "Iterate Services",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Build Next Service Reminder Messages": {
      "main": [
        [
          {
            "node": "Send Next Service WhatsApp",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Run to Service Status Changed → Done": {
      "main": [
        [
          {
            "node": "Iterate Completed Services",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}