Kütüphane / Takvim ve Zamanlama
Takvim ve Zamanlama
OpenAI ile Google Sheets üzerinden servis ve sigorta WhatsApp hatırlatmaları gönderin
Her sabah araç servis ve sigorta vade tarihlerini kontrol eder, belirlenen aşamalarda WhatsApp hatırlatmaları gönderir ve test sürüşü potansiyel müşterilerine AI takip mesajları iletir.
Ne yapar
## 🚘 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.
Adımlar
- 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
Toplam 38 adım.
Benzer otomasyonlar
Takvim ve ZamanlamaBook, cancel, and reschedule WhatsApp appointments with Google Calendar and Sheets49 adımE-posta OtomasyonuOpenAI, Gmail ve Airtable ile WhatsApp E-posta Asistanı20 adımSohbet Botları ve Mesajlaşma BotlarıOpenAI hafızası ve Google Sheets ile WhatsApp chatbot'u7 adımSohbet Botları ve Mesajlaşma BotlarıWhatsApp Mesajlarını Llama 4 ve Google Aramasıyla Yanıtla8 adım