DM Calendly demo bookings on Messenger and log to Sheets

Build an agent workflow that turns every new Calendly booking into a Messenger prep touch instead of another no-show. Trigger on the Calendly outgoing webhook for invitee.created.

When the webhook fires, read the invitee payload from Calendly. I need the invitee name, email, meeting start time in the invitee's timezone, the event type name, the host name, any answers the invitee gave to custom booking questions, and whether the event is still active. If the payload does not already contain everything, use Calendly Get Event Invitee and Get Scheduled Event to fill in what's missing. If the event status is canceled, stop the run cleanly. Do not tag, do not DM, do not log.

Next, look up the invitee in Manychat. Use Manychat Find Subscriber by System Field with the invitee's email. If no subscriber comes back, skip the Manychat steps entirely but still continue to the Sheets log. Do not create a new subscriber. Do not fall back to another Manychat lookup.

If a Manychat subscriber does exist, do two things. First, use Add Tag to Subscriber by Name to tag them booked-demo and also add a second tag that matches the event type name (for example demo-30min). Second, use Send Content to DM them a short, warm prep note in Dynamic Block v2 format. The DM should greet them by first name, name the host, restate the meeting time in their timezone in a human-friendly way, reference one specific detail they wrote in their booking answers so it does not feel like a template, and end with a one-tap button that links to their Calendly reschedule URL labeled Need to reschedule.

Finally, append one row to a Google Sheet called Demo Pipeline using Google Sheets Append Values. Columns: invitee name, invitee email, event type, scheduled time (invitee timezone), host, Manychat DM sent (true or false), and booking created timestamp. Log the row whether or not the DM was sent, so the sheet is a single source of truth for every booking that hit the system.

Guardrails: never message anyone whose event is canceled, never message anyone who is not already a Manychat subscriber, and never send more than one DM per invitee.created event. The Messenger prep DM is the whole point of this workflow. That is the touch that moves the attendance rate, so keep it warm, specific, and short.