Библиотека / Календарь и планирование
Календарь и планирование
Отправка напоминаний о техобслуживании и страховке через WhatsApp из Google Sheets с OpenAI
Запускается каждое утро: проверяет сроки техобслуживания и страховки автомобилей, отправляет напоминания в WhatsApp на заданных этапах и ИИ-follow-up лидам, записавшимся на тест-драйв.
Что делает
## 🚘 AutoOS – Car Dealer Reminders & Service NPS For car dealerships in India whose service advisors still call customers from a register. Free services get missed, insurance lapses to another agent, test-drive leads go cold after one follow-up, and an unhappy customer's first complaint is a one-star Google review. ### How it works Every morning the workflow checks each vehicle for service due by kilometres or months, and insurance nearing expiry. It sends WhatsApp reminders at set stages and never repeats a stage. Test-drive leads get AI-written follow-ups on days 1, 3, 7 and 14, and cold leads are flagged to the salesperson. When your DMS closes a job card, the vehicle record is updated, and three hours later the customer gets a short NPS survey. Detractors go straight to the service manager with an AI summary and an apology to the customer. Promoters are asked for a Google review. ### Setup steps 1. Create a Google Sheet with Vehicles, Test Drive Leads, Reminder Log, Service Jobs and NPS Log tabs. 2. Connect WhatsApp Business Cloud, Google Sheets, Gmail and OpenAI. 3. Edit Set AutoOS Config with your dealer name, links, service intervals and manager numbers, and replace the REPLACE_WITH_… IDs. 4. Set your n8n domain in the NPS link inside Normalize Job Card, and point your DMS at the job-card webhook. 5. Run the daily scan once manually, then activate.
Шаги
- Every Day at 9 AM IST
- Set AutoOS Config
- Read Vehicles Sheet
- Read Test-Drive Leads
- Read Reminder Log
- Build Reminder Queue
- Route by Reminder Type
- Send Service Reminder
- Send Insurance Reminder
- AI Write Test-Drive Follow-up
- Send Daily Summary to Manager
- Urgent Insurance?
- Send Test-Drive Follow-up
- Alert Insurance Desk
Всего шагов: 38.
Похожие автоматизации
Календарь и планированиеBook, cancel, and reschedule WhatsApp appointments with Google Calendar and SheetsШагов: 49Автоматизация эл. почтыПочтовый ассистент в WhatsApp с OpenAI, Gmail и AirtableШагов: 20Чат-боты и боты для мессенджеровЧат-бот WhatsApp с памятью OpenAI и Google SheetsШагов: 7Чат-боты и боты для мессенджеровОтветы на сообщения WhatsApp с Llama 4 и поиском GoogleШагов: 8