Create an AI-powered virtual receptionist with Google Calendar & Sheets

AI-Powered Appointment Scheduling with Google Calendar & Sheets Virtual Receptionist Automate customer conversations with an AI-powered virtual receptionist. This workflow can chat naturally with clients, answer general business questions (like services, location, and hours), check availability in Google Calendar, book appointments, and save customer details in Google Sheets. Fully customizable for any business type — salons, clinics, agencies, consultants, and more. --- 📖 How It Works 1. Welcome the customer when the customer says hi - AI greets warmly: “Hello! I’m [AI name] from [Business name].” 2. Answer general questions - Provides instant replies about services, pricing, business location, hours, and availability. 3. Understand their need - Identifies the service requested and preferred time. 4. Check availability - Queries Google Calendar for open slots. 5. Gather customer details - Collects name, phone, and email (optional). 6. Confirm booking - Creates the appointment in Google Calendar. 7. Save records - Logs booking and customer info into Google Sheets. --- ⚙️ Setup Steps (Quick) 1. Connect your Google Calendar and Google Sheets accounts. 2. Add your business details (name, type, services, hours, policies) to the Business Info Sheet. 3. Configure your OpenAI API key (or use n8n free credits). 4. Optional: Connect Twilio WhatsApp for direct chat responses. --- 🏢 Example Business Info (Google Sheet) | businessid | businessname | businesstype | location | phone | email | services | calendarid | timezone | currency | workinghours | ainame | aipersonality | airole | emergencyavailable | bookingadvancedays | cancellationhours | |-------------|-----------------|---------------------|----------------------------------|-----------------|---------------------------|----------|-----------------------|----------|----------|--------------------------------|---------|-----------------------------------|------------------------------------------------------------------------------------------------|----------------------|----------------------|-------------------| |001| Luxe Hair Studio | Hair & Beauty Salon | 123 Main Street, New York, NY 10001 | 1 (XXX) XXX-XXXX | yourbusiness@email.com | “Haircut & Styling (60 minutes, $3500…)