Instant iMessage booking confirmations for Calendly

Build a code workflow that sends an instant iMessage confirmation through Sendblue and logs the booking to Google Sheets whenever someone books a meeting on Calendly. The flow is fully deterministic: three known steps, no branching judgement required.

Trigger: Calendly webhook on the invitee.created event. Subscribe at the user or organization scope so any new booking on the selected event types fires the workflow.

Step 1, Calendly Get Event Invitee. Use the invitee URI from the webhook payload to pull the full invitee record. We need this to read the phone number captured in the booking form, the invitee's first name, timezone, the scheduled meeting start time, the event type name, the reschedule URL, and the cancel URL. Also read any question_and_answers entries in case the message copy should reference one.

Step 2, Sendblue Send Message. Send a single iMessage (with SMS fallback) to the invitee's phone number in E.164 format. The number must be normalized before the call. From_number should be the Sendblue line configured in the workflow. The message body should be a short, friendly confirmation that includes the invitee's first name, the meeting topic (event type name), the scheduled start time formatted in the invitee's timezone, and the reschedule link from Calendly. Keep it under a few hundred characters. If no phone number was captured on the booking, skip this step gracefully and proceed to logging.

Step 3, Google Sheets Append Values. Append a single row to the configured spreadsheet and sheet/tab with these columns in order: booking timestamp (UTC), invitee full name, invitee email, invitee phone, event type name, scheduled start time (in the invitee's timezone), reschedule URL. Use USER_ENTERED so dates and links render cleanly. Assume the first row of the sheet is a header row.

Inputs the user should configure on the workflow: the Calendly event type(s) to subscribe to, the Sendblue line phone number to send from, the message template copy, the Google Sheets spreadsheet ID and sheet name to append to.

Keep it deterministic. No LLM steps. Webhook → Get Event Invitee → Send Message → Append Values.