Automate Calendly sales meetings with HubSpot, Google, ClickUp and Slack

How it works This workflow automatically manages every new Calendly booking from start to finish. When a prospect books a meeting, it captures all details, syncs everything to HubSpot, creates a prep task for the sales rep, sends confirmation and reminder emails, and notifies the team — all without any manual effort. Step-by-step - Trigger & format - Calendly — New Booking – Listens for new invitee.created events when a prospect books a meeting. - Format Booking Data – Extracts and normalizes all booking details including name, email, company, phone, meeting time, join URL, reschedule and cancel links, and computes reminder timestamps. - Logging - Google Sheets — Log Booking – Appends all booking details including name, email, company, event type, meeting time, and join URL to a Google Sheets tracker. - CRM sync - HubSpot — Search Contact by Email – Searches HubSpot to check if the prospect already exists by email. - IF — Contact Exists in HubSpot? – Routes to update or create based on whether a matching contact is found. - Update HubSpot Contact – Updates the existing contact with the latest name, phone, company, and lead source. - Create HubSpot Contact – Creates a new HubSpot contact with all prospect details if none exists. - Set — Contact ID – Normalizes the contact ID from either branch so all downstream nodes reference it consistently. - Calendar & deal creation - Google Calendar — Create Rep Event – Creates a 30-minute meeting event on the sales rep's Google Calendar with join URL, prospect details, and reschedule/cancel links. - HubSpot — Get Owner ID – Fetches the HubSpot owner to assign the deal to the correct sales rep. - HubSpot — Create a Deal – Creates a new deal in the appointmentscheduled stage linked to the contact, with meeting details and next steps. - Preparation & confirmation - ClickUp — Create Prep Task – Creates a pre-call research task in ClickUp with a full checklist covering LinkedIn research, company background, discovery questions, and competitor analysis. Due 2 hours before the meeting. - Gmail — Send Confirmation – Sends a polished HTML confirmation email to the prospect with meeting details, join button, and reschedule/cancel options. - Team notification & CRM logging - HubSpot Log Note – Logs a full activity note in HubSpot linked to both the contact and the deal, including all meeting details and the ClickUp prep task link. - Slack — Notify Sales Channel – Posts a booking alert to the sales Slack channel with prospect info, meeting time, join URL, and confirmation of all actions taken. - Automated reminders - Wait — Until 24h Before Meeting – Pauses execution until exactly 24 hours before the scheduled meeting. - Gmail — Send 24h Reminder – Sends an HTML reminder email with meeting details, join link, and a pre-call checklist. - Wait — Until 1h Before Meeting – Pauses execution until exactly 1 hour before the meeting. - Gmail — Send 1h Reminder – Sends a final HTML reminder email with a prominent join button and last-minute tips. Why use this? - Eliminates all manual admin after a Calendly booking by instantly syncing data across HubSpot, Google Sheets, and Google Calendar - Auto-creates or updates HubSpot contacts and deals so no lead ever falls through the cracks - Gives sales reps a structured ClickUp prep task with a research checklist before every call - Keeps prospects engaged and informed with a confirmation email plus automated 24h and 1h reminders - Notifies the entire sales team in Slack the moment a new meeting is booked