Automate with Aariene
← Back to projects
PRACTICE PROJECTMAKE

Calendly Booking & Lead Tracking Automation

// THE CHALLENGE

When someone books a consultation through Calendly, their booking information needs to be recorded in a tracking sheet and the appropriate team member needs to be notified. Without automation, checking for existing leads, recording booking details, and sending notifications can become repetitive and inconsistent.

// THE SOLUTION

A Make scenario that monitors new Calendly bookings, checks Google Sheets for an existing lead, and uses a Router to handle the booking based on whether the lead already exists in the database. Slack notifications keep the team informed, while new booking details are automatically recorded in Google Sheets.

Make scenario: Calendly trigger, Google Sheets duplicate check, Router, Slack alerts, and row update

// HOW IT WORKS

  1. 01Calendly detects a new booking through its Watch Events trigger.
  2. 02Google Sheets searches the existing records to check whether the lead is already in the database.
  3. 03

    A Router splits the workflow into two conditional routes:

    • If the lead already exists, Make sends a Slack notification indicating that the lead is already in the database.
    • If the lead is new, Make sends a Slack notification, adds the booking details to Google Sheets, waits briefly, and updates the record to indicate that the notification has been sent.
  4. 04Google Sheets stores the booking information, including the client's name, email, event name, start and end date/time, notes, and notification status.

// TESTING OUTPUT

Tested with sample Calendly bookings, including existing and new lead scenarios, confirming duplicate lead detection and live Slack notifications in #new-bookings.

Slack #new-bookings notification showing duplicate lead detection and booking details

// OUTCOME

What this workflow delivers

  • New Calendly bookings are automatically checked against existing records, helping prevent duplicate lead entries.
  • New booking details are stored in Google Sheets without manual data entry.
  • Slack notifications provide visibility into new bookings and existing leads.
  • The notification status is tracked in the spreadsheet for easier monitoring.

Tested with sample Calendly bookings, including existing and new lead scenarios. In a live setup, I would monitor duplicate detection accuracy, notification delivery, and failed scenario runs.

← Back to projects

Practice project based on a real-world brief.