# Send car service, insurance, and NPS WhatsApp flows with Google Sheets and OpenAI

> Quick overview This workflow uses Google Sheets, WhatsApp Business Cloud, OpenAI, Gmail, webhooks, and an n8n Form to send automated service and insurance reminders, manage test-drive follow-ups, sync closed job cards from a DMS, and collect and triage post-service NPS feedback. How it works 1. Runs every day at 9 AM (IST) and loads vehicle, test-drive, and reminder-log data from Google Sheets. 2. Builds a capped daily queue (up to 150) of due service reminders, insurance renewal reminders, and scheduled test-drive follow-ups while skipping any reminder stage already logged. 3. Sends service and insurance reminder messages to customers via WhatsApp Business Cloud and appends each send result to the Reminder Log in Google Sheets. 4. Sends urgent insurance cases to your insurance desk on WhatsApp and sends a daily summary of counts to the service manager on WhatsApp. 5. Generates day 1/3/7/14 test-drive follow-up copy with OpenAI, sends it to the lead via WhatsApp, updates the lead in Go

- **Domain**: `n8n-workflow-20880.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/20880
- Page (HTML): https://agenstry.com/agents/n8n-workflow-20880.n8n.io
- Documentation: https://n8n.io/workflows/20880