Morning Digest SMS
Daily 7am SMS recapping the last 24h of missed calls, texts, and booked leads
I built a scheduled n8n workflow that fires at 7am daily, reads the shared activity log from Google Sheets, and rolls the last 24 hours into a single plain-text SMS for the business owner: missed calls caught and texted back, live text conversations, flagged emergencies, and leads ready to book. A deterministic Code node (no LLM) builds the message, keeps it GSM-7 friendly and bounded to three segments, and adds a staleness sentinel that warns the owner to test the system if the whole log has gone silent for 3+ days instead of sending a false "quiet night." The daily read and send are deliberately not fail-open, so a broken sheet or dead line raises an error and alerts me rather than silently reassuring the client.
◆Deterministic daily SMS digest with staleness fail-safe