Email Automation
Run acknowledged ops shift handovers with Google Sheets, Gmail, Telegram, and DeepSeek
On a schedule, it handles email with OpenAI / ChatGPT and DeepSeek using Gmail, Google Sheets, Telegram.
What it does
## Ops shift handovers with acknowledgements ### How it works 1. A shift schedule or webhook starts the run, and invalid or duplicate requests stop early. 2. Open items and shift notes are reduced to a snapshot. 3. DeepSeek drafts an SBAR brief, and a quality check adds any critical item it missed. 4. The brief is logged, posted to Telegram and emailed to the incoming lead. 5. Critical items page the on-call lead, and items without a next step ping their owners. 6. Leads acknowledge by webhook. Unacknowledged briefs get one nudge. 7. Monday brings a review of rolling items. ### Setup steps - [ ] Create the OpenItems, ShiftNotes and HandoverLog tabs - [ ] Connect Google Sheets, Gmail, Telegram and your DeepSeek model - [ ] Replace user@example.com and chat ID 123456789 - [ ] Share both webhook URLs with the team ### Customization Change the shift cron, the two hour duplicate window, the 45 minute nudge delay or the priority words that count as critical.
The steps
- When Shift Changes
- On-Demand Handover
- Normalize Handover Trigger
- Validate Request
- Alert Invalid Handover
- Email Invalid Handover
- Read Open Items
- Collapse Before Notes
- Read Shift Notes
- Compute Handover Data
- If Has Open Work
- Post All Clear
- Draft Handover Brief
- Brief Model
47 steps in total.
Similar automations
RAG & Knowledge BasesSummarize Shift Handovers with Hugging Face RAG10 stepsEmail AutomationRun a school admin assistant on Telegram with DeepSeek and Google Sheets58 stepsAlerts & NotificationsTrack AdSense review changes with DeepSeek verdicts and Telegram alerts17 stepsEmail AutomationGrade and escalate truck defects with Forms, Google Sheets, Gmail, Telegram, and DeepSeek33 steps