The Full-Stack Guide: Automating Google Calendar Bookings with ABC Sales AI

Google Calendar Integration Tutorial

This guide provides a comprehensive walkthrough for creating a powerful, automated system that connects your Google Calendar directly to ABC Sales AI.

When a lead books an appointment, this integration will automatically:

• Tag the contact as "booked"
• Remove them from your initial follow-up sequence
• Enroll them in a new "Appointment Reminder" automation
• Update their contact record with the exact appointment time and Google Meet link

Part 1: Prerequisites & System Cleanup

1. Prepare Your Automations

In your ABC Sales AI dashboard, ensure you have:

• An automation for booking follow-ups (to stop when appointment is made)
• An automation for appointment reminders (to start after booking)

2. Create Custom Fields

Create two Custom Fields in ABC Sales AI settings:

• \Appointment Time\
• \Google Meet Link\

3. System-Wide Cleanup

• Review your AI's system prompts and booking automation messages
• Replace any outdated booking links with your Google Calendar link

Part 2: Configuring the Google Apps Script

1. Navigate to Google Apps Script: Go to \script.google.com\ and click Start Scripting.

1. Create a New Project: Click + New project.

1. Get the Integration Code:

- In ABC Sales AI dashboard, go to Integrations

- Find Google Calendar Integration section

- Click Copy to copy the code snippet

1. Paste the Code: Delete default code and paste the copied script.

1. Customize the Script:

1. Control Automations:

- \unsubscribeFrom\: Paste your booking follow-up Slug ID

- \subscribeTo\: Paste your appointment reminder Slug ID

- \replace\: Set to \true\ to remove from all automations

1. Save and Rename the project.

Part 3: Activating the Automation

1. Add Google Calendar Service:

- Click \+\ next to Services

- Select Google Calendar API and click Add

1. Set Up the Trigger:

- Click the clock icon for Triggers

- Click + Add Trigger

- Choose function: \syncGoogleCalendar\

- Select event source: From calendar

- Select event type: An event is updated

- Click Save

1. Authorize Permissions when prompted.

Part 4: See It in Action

1. Inquiry: Lead asks for appointment link
2. Booking: AI provides Google Calendar link, lead books
3. Automation: Apps Script triggers instantly

Results in ABC Sales AI:

• Lead receives confirmation message
• Contact tagged with \booked-appointment\
• Removed from follow-up automation
• Custom fields populated with appointment details