Email Automation
Run pest control jobs with guaranteed callbacks using Google Sheets, Gmail, Telegram, and
When a form is submitted, it handles email with OpenAI / ChatGPT and DeepSeek using Gmail, Google Sheets, Telegram.
What it does
## Run pest control jobs with callbacks and reminders ### How it works 1. A form request is normalized and validated. Incomplete ones go to the office. 2. Repeat pests inside the guarantee window become free callbacks, not new quotes. 3. New jobs are priced from your Catalog and DeepSeek drafts the plan email. 4. A check holds weak drafts or wrong prices for the office. 5. Sent emails are tracked, failures and urgent pests alert the office, and recurring plans join the Plans tab. 6. Daily, due plans get spaced reminders, then an office call request. 7. Mondays, the owner gets a digest. ### Setup steps - [ ] Connect Google Sheets, Gmail, Telegram and DeepSeek (OpenAI-compatible) - [ ] Create Catalog, Requests, Plans and Callbacks tabs - [ ] Replace user@example.com and chat id 123456789 - [ ] Share the form link ### Customization Change the 3 day spacing and 14 day call rule in Compute Due Services, the plan intervals in Build Plan Row, or the price check in Check Plan Email Quality.
The steps
- When Service Request Received
- Normalize Request
- Validate Request
- Email Office Incomplete Request
- Alert Office Incomplete
- Read Pest Playbook
- Match Pest Playbook
- Check Recognized Pest
- Email Office Manual Review
- Build Plan Prompt
- Draft Service Plan
- Plan Model
- Parse Service Plan
- Log Service Request
45 steps in total.
Similar automations
RAG & Knowledge BasesAlert on Pest Outbreaks with OpenAI RAG and Pinecone10 stepsMonitoring, Ops & IncidentsTrack ElevenLabs voice callbacks with data tables and Telegram alerts43 stepsCode, Git & Developer ToolsControl IoT Devices On and Off via MQTT Webhook3 stepsEmail AutomationControl invoice reminders and escalations with Google Sheets and Gmail15 steps