Skip to content
NEWMarketplace and the trig8n Agent: sell what you build, and get plans and changes that are tested before you see them. See what is new

Library / Email Automation

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

  1. When Shift Changes
  2. On-Demand Handover
  3. Normalize Handover Trigger
  4. Validate Request
  5. Alert Invalid Handover
  6. Email Invalid Handover
  7. Read Open Items
  8. Collapse Before Notes
  9. Read Shift Notes
  10. Compute Handover Data
  11. If Has Open Work
  12. Post All Clear
  13. Draft Handover Brief
  14. Brief Model

47 steps in total.

Similar automations