# Garage Service Reminder & Follow-up System

**Category:** Automotive  
**Tools:** n8n, Airtable, Gmail  
**Nodes:** 32  
**Built by:** Forgent Systems

Keeps a garage's customers informed across the whole service cycle. Upcoming service reminders, pickup notices, feedback requests and next-service alerts go out automatically over WhatsApp and email.

![Workflow](preview.webp)

## How it works

1. Services due in the next few days are pulled from Airtable and reminders are sent.
2. When a job is marked done, the customer gets a pickup notification.
3. After delivery, a feedback request with a form link is sent.
4. A next-service reminder is scheduled and every message is marked as sent in Airtable.

## Use cases

- Car and bike workshops
- Fleet maintenance teams
- Service centers that want repeat visits

## Data setup

**Airtable** (table: fields)

- **Garage / Car Service Reminder System → Tables**: `Phone`, `Reminder_Sent`, `Reminder_Sent_On`, `Pickup_Notification_Sent`, `Pickup_Notification_Sent_On`, `Feedback_Sent`, `Feedback_Sent_On`, `Next_Service_Notification_Sent_On`
- **Base → Table**: _(columns as used in the nodes)_

## Setup

1. In n8n open **Workflows → Import from File** and choose `workflow.json`.
2. Connect these credentials:
   - Airtable account
   - Gmail account
   - Twilio account
3. Point the Sheets / Airtable / Drive / Slack nodes at your own resources (structure above).
4. Replace placeholder emails, phone numbers and `YOUR-FORM-ID` links with your own.
5. Times use the America/New_York timezone and dates use MM/DD/YYYY. Adjust if needed.
6. Run a test execution, then activate.

## Nodes

- **Sticky Note** — `n8n-nodes-base.stickyNote`
- **Fetch Pending Services (±7 Days)** — `n8n-nodes-base.airtable`
- **Iterate Services** — `n8n-nodes-base.splitInBatches`
- **Build Reminder Messages** — `n8n-nodes-base.code`
- **Send WhatsApp Reminder** — `n8n-nodes-base.twilio`
- **Send Email Reminder** — `n8n-nodes-base.gmail`
- **Mark Reminder Sent** — `n8n-nodes-base.airtable`
- **Run to Service Status Changed → Done** — `n8n-nodes-base.airtableTrigger`
- **Iterate Completed Services** — `n8n-nodes-base.splitInBatches`
- **Build Pickup Messages** — `n8n-nodes-base.code`
- **Send Pickup WhatsApp** — `n8n-nodes-base.twilio`
- **Send Pickup Email** — `n8n-nodes-base.gmail`
- **Mark Pickup Notification Sent** — `n8n-nodes-base.airtable`
- **Vehicle Delivered Trigger** — `n8n-nodes-base.airtableTrigger`
- **Iterate Delivered Records** — `n8n-nodes-base.splitInBatches`
- **Build Feedback Messages** — `n8n-nodes-base.code`
- **Send Feedback WhatsApp** — `n8n-nodes-base.twilio`
- **Send Feedback Email** — `n8n-nodes-base.gmail`
- **Mark Feedback Sent** — `n8n-nodes-base.airtable`
- **Sticky Note1** — `n8n-nodes-base.stickyNote`
- **Sticky Note2** — `n8n-nodes-base.stickyNote`
- **Sticky Note3** — `n8n-nodes-base.stickyNote`
- **Daily Service Reminder Trigger** — `n8n-nodes-base.scheduleTrigger`
- **Sticky Note4** — `n8n-nodes-base.stickyNote`
- **Next Service Reminder Trigger** — `n8n-nodes-base.scheduleTrigger`
- **Fetch Next Services (±7 Days)** — `n8n-nodes-base.airtable`
- **Iterate Services ** — `n8n-nodes-base.splitInBatches`
- **Build Next Service Reminder Messages** — `n8n-nodes-base.code`
- **Send Next Service WhatsApp** — `n8n-nodes-base.twilio`
- **Send Next Service Email** — `n8n-nodes-base.gmail`
- **Mark Next Service Reminder Sent** — `n8n-nodes-base.airtable`
- **Sticky Note5** — `n8n-nodes-base.stickyNote`
