ClickUp and ThoughtfulGPT integration

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