📁 Auto-add new Calendly bookings to Google Sheets

⚡ 186 views · 📁 File Management

Description

📅 Auto-Log Calendly Bookings to Google Sheets

This workflow automatically captures new Calendly bookings and saves them into a structured Google Sheet. It records all important details like invitee name, email, phone, event type, date, time, status, meeting link, and notes. No more manual copy-pasting from Calendly into your CRM or sheets.

⚙️ How It Works

1. Calendly Booking Webhook

   • Listens for new bookings (invitee.created event).
   • Triggers every time someone schedules a meeting.

2. Normalize Booking Data

   • A Code node parses Calendly’s payload.
   • Extracts invitee name, email, phone number, event type, time, notes, and meeting link.
   • Ensures consistent data format for Sheets.

3. Save Booking to Google Sheets

   • The Google Sheets node appends a new row with the booking details.
   • Prevents duplicate entries using append/update mode.

4. Log Booking Success

   • A Code node logs the successful save.
   • Can be extended to send confirmation emails, Slack alerts, or calendar invites.

🛠️ Setup Steps

1. Create Google Sheet

• In Google Sheets, create a new sheet with headers:
• Copy the Sheet ID from the URL.
• Replace YOUR_GOOGLE_SHEET_ID in the workflow with your actual ID.

2. Calendly Webhook

• In your Calendly account:
• Go to Integrations → Webhooks
• Add a new webhook with the URL from the Webhook node in n8n.
• Select event type: invitee.created.

3. Google Sheets OAuth

• In n8n, connect your Google account credentials.
• Grant permission for reading/writing Sheets.

📊 Example Output (Google Sheets Row)

⚡ With this workflow, every new Calendly booking is instantly logged into your Google Sheet, keeping your scheduling records accurate and centralized.

🔗 Nodes Used

Google Sheets, Webhook

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup