Sync AI-enriched TimeRex bookings to Google Sheets and Slack with Gemini

Description

TimeRex AI-Powered Booking Automation

Description (for n8n template submission)

Transform your TimeRex booking management with AI-powered automation. This workflow automatically processes bookings, enriches data with AI insights, and keeps your team informed via Slack—all in real-time.

What This Workflow Does

🤖 AI-Powered Intelligence
Smart Company Detection**: Automatically identifies company names from guest email domains
Booking Categorization**: Uses Google Gemini to classify bookings (Sales/Support/Interview/Partnership/Media)
Meeting Brief Generation**: AI creates actionable preparation notes for hosts before each meeting

⚡ Automated Processing
Receives webhooks from TimeRex for confirmed and cancelled bookings
Validates requests with security token verification
Logs enriched booking data to Google Sheets
Sends detailed Slack notifications with AI-generated insights

🛡️ Security & Reliability
Token-based webhook authentication
Security alerts for unauthorized access attempts
Automatic cancellation handling with data cleanup

Use Cases

Sales Teams**: Automatically categorize leads and prepare meeting briefs
Recruitment**: Streamline interview scheduling with AI-powered candidate insights
Customer Success**: Track support meetings and prepare context for calls
Media Relations**: Manage press interviews with automated briefings

How It Works

TimeRex sends a webhook when a booking is confirmed or cancelled
Security token is verified (failed attempts trigger Slack alerts)
For confirmed bookings:
Media source is detected from calendar name
Company name is extracted from email domain
AI categorizes the booking purpose
AI generates a meeting preparation brief
Enriched data is saved to Google Sheets
Slack notification is sent with AI insights
For cancellations:
Booking is found by Event ID
Row is deleted from Google Sheets
Cancellation alert is sent to Slack

Setup Instructions

Webhook Configuration
Copy the webhook URL from the "TimeRex Webhook" node
Paste it in TimeRex Settings → Webhook

Security Token
Copy your TimeRex security token
Update the Verify Security Token node with your token

Google Sheets
Create a spreadsheet with these columns:
event_id, booking_date, guest_name, guest_email, calendar_name, meeting_url, host_name, media_source, company_name, booking_category, ai_meeting_brief, created_at
Update all Google Sheets nodes with your Sheet ID

AI Credentials
Connect your Google Gemini API credentials to both AI model nodes

Slack
Connect your Slack account
Select your notification channel in all Slack nodes

Activate
Turn on the workflow and start receiving AI-enhanced booking notifications!

Requirements

TimeRex account with webhook access
Google Cloud account (for Sheets & Gemini API)
Slack workspace
n8n instance (self-hosted or cloud)

Customization Tips

Modify the Filter by Calendar Type node to match your calendar naming convention
Adjust AI prompts in the LLM Chain nodes for different categorization or brief styles
Add more media sources to the Media Master sheet for accurate source tracking
Extend the workflow with email confirmations or calendar event creation

Short Description (100 characters max)

Automate TimeRex bookings with AI-powered categorization, meeting briefs, and Slack notifications.

Categories

Sales
Productivity
AI
Scheduling

Tags

TimeRex, Booking, AI, Google Gemini, Slack, Google Sheets, Automation, Meeting Management, LLM, Scheduling