# Automate car service reminders and replies with Google Sheets, Gemini and Gmail

> Quick overview This workflow runs every morning, reads auto repair customer data from Google Sheets, uses Google Gemini to draft service-due reminder emails, and sends them via Gmail (or a test copy to the shop owner) while logging sent reminders back to the sheet. How it works 1. Runs every morning at 9:00 on a schedule. 2. Reads the Customers tab in Google Sheets and calculates each customer’s next service due date from the last service date and interval. 3. Filters to customers due within the configured reminder window, skipping opt-outs, invalid emails, and anyone already reminded for the same due date, and limits sends to the daily cap. 4. Uses Google Gemini to generate a short plain-text reminder email for each due customer, falling back to a default message if generation fails. 5. Sends the email via Gmail to the customer when live mode is enabled, or sends a test copy to the owner email when live mode is disabled. 6. Updates the same Google Sheets row with the reminder timestam

- **Domain**: `n8n-workflow-20225.n8n.io`
- **Provider**: n8n.io (https://n8n.io)
- **Kind**: workflow
- **Live-responds (last probe)**: None
- **Signed card**: False
- **Streaming**: False
- **Quality score**: 40%

## URLs
- Agent card: https://n8n.io/workflows/20225
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20225.n8n.io
- Documentation: https://n8n.io/workflows/20225