No-show and cancellation recovery desk for Calendly

Build me a recovery desk app where I work through last week's damaged meetings one case at a time and decide each one myself. This is not a scheduled sequence and it must never fire an automated blast: I open the app, look at each row, and choose what happens. Nothing is sent without me clicking send.

The main view is a single queue of past and canceled meetings from the last seven days, with the lookback window adjustable in the UI. Build the queue with Calendly List Scheduled Events. Because that operation filters by status, pull it twice: once for canceled events, and once for active events whose end time is already in the past, since a completed meeting is where a no-show actually lives. For every event in both sets, call Calendly List Event Invitees to get the people, and Calendly Get Invitee No-Show to resolve the attendance record for any invitee that carries one.

Each row shows the invitee name and email, the host, the event type, the scheduled start time, whether the meeting was canceled or simply missed, the cancellation reason and who canceled when there is one, and a clear badge if the invitee is already flagged as absent in Calendly.

Next to every invitee, show a repeat offender count: how many times that email address has canceled or been flagged absent across all history, not just the current window. Key this on the invitee email, because Calendly has no cross-event person record that links someone across separate bookings. Make the count visually loud once it reaches three so I can decide to stop chasing that person.

Give each row these actions. Mark the invitee absent with Calendly Mark Invitee as No-Show, and undo a flag I set wrongly with Calendly Delete Invitee No-Show, so the row toggles both ways and reflects the real state in Calendly after the write. Generate a fresh booking link with Calendly Create Single-Use Scheduling Link against the same event type they missed. Then open a short recovery email in a composer with that link already pasted into the body and the invitee in the To field. The draft is fully editable, and it only goes out through Gmail Send a Message when I click send on that row.

When I send a recovery email, log the attempt in the CRM. Find the person with HubSpot Search Contacts by their email address, then write the attempt with HubSpot Create Note associated to that contact, recording what they missed, the date, and that a rebooking link was sent. If no contact matches, say so on the row and skip the note rather than failing the send.

Every row carries a status of untouched, rebooking sent, or written off. Store that status in the app so it persists between sessions and I can close the tab and come back to a half-worked queue. Sending a recovery email moves a row to rebooking sent automatically, and I can set written off by hand on anyone not worth another attempt.

Add filters for host and for event type at the top of the queue, so a manager can narrow the list to one person and hand them their own queue. Show a small summary of how many rows are untouched versus handled so I know when I am done for the week.