Case file / E.02
Relationship Radar
A Google Apps Script system that keeps a short list of the people who matter and tells you every Friday which of them have gone quiet. It reads dates and addresses from sent mail and completed meetings, never content, ranks the overdue against a cadence you set, and lands one email. Adding a name takes a tier and a click from inside Gmail.
The Problem
Relationships go quiet without anyone deciding they should. An executive's network lives across sent mail, the calendar and memory, and nobody notices that a board contact or a mentor has gone six weeks without a word until the moment they are needed.
The tools built for this want a CRM's worth of typing, so they stop being fed and then stop being read. The evidence was in sent mail and the calendar the whole time.
The Solution
Thirty to fifty people, each with a tier and a cadence: Inner Circle at 7 days through Outer Circle at 60. Every Friday morning a script inside a Google Sheet finds the last message you sent each person and the last meeting you both attended, compares the gap to the cadence, and emails one ranked list of who is overdue, most overdue first. A Write to link under each name opens Gmail with a compose window docked in the corner, where Schedule send works, so a Friday note can land Monday morning.
Adding a name never leaves the inbox. A Gmail add-on card sits in the side panel, on desktop and on the phone, and adds the sender of any open message at the tier you pick. It reads dates, not content: read-only Gmail and Calendar access, nothing leaves the account, no outside service, no subscription.
How it runs
Four steps, then it is unattended.
- Tag. From any open email, pick a tier and click Add. The card finds the Sheet by itself.
- Watch. The script reads the dates and addresses of sent mail and completed meetings. Never a subject, a body or a title.
- Rank. Anyone past their cadence is ranked by days overdue. A contact with no recorded history is listed as exactly that, never given an invented date.
- Surface. One email on Friday, once a week, with the Sheet as the audit trail. A run that fails stops rather than sending a partial list.