Risper
Workflows by Risper
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) | business_id | business_name | business_type | location | phone | email | services | calendar_id | timezone | currency | working_hours | ai_name | ai_personality | ai_role | emergency_available | booking_advance_days | cancellation_hours | |-------------|-----------------|---------------------|----------------------------------|-----------------|---------------------------|----------|-----------------------|----------|----------|--------------------------------|---------|-----------------------------------|------------------------------------------------------------------------------------------------|----------------------|----------------------|-------------------| |001| Luxe Hair Studio | Hair & Beauty Salon | 123 Main Street, New York, NY 10001 | 1 (XXX) XXX-XXXX | [email protected] | “Haircut & Styling (60 minutes, $3500…)<br>Hair Coloring (120 minutes, $8000…)<br>…” | calendar-id-here | GMT -3 | USD | Mon–Sat: 9:00 AM – 7:00 PM, Sun: Closed | bella | Friendly, Stylish, Professional | Manages bookings, answers FAQs, recommends services, gives beauty tips, sends reminders, etc. | no | 10 | 24 | ✅ **Purpose**: Supplies context (services, pricing, hours, AI personality, booking policies). 💡 The AI uses this sheet to answer **general business questions** (e.g., “Where are you located?”, “Do you do hair colouring?”, “What are your working hours?”). --- ## 📊 Appointments Sheet Example | client_number | client_name | event_id | summary | services | |----------------|-------------|-----------|----------------------------------|----------| | 001 | Sarah Lee | evt-10293 | Appointment with Sarah Lee – Haircut & Styling | Haircut & Styling | | 002 | John Smith | evt-10294 | Appointment with John Smith – Highlights | Highlights | ✅ **Purpose**: Logs confirmed bookings with service details and links back to Google Calendar. --- ## 💡 Features - ✅ AI receptionist with **conversation memory** - ✅ **Answers FAQs** – location, services, hours, pricing - ✅ **Google Calendar integration** for real-time availability - ✅ **Google Sheets integration** for customer records & reporting - ✅ Customizable **AI name, role, and personality** --- ## 🔑 Who It’s For - **Salons & Spas** – Manage bookings and FAQs - **Clinics & Health Services** – Automated scheduling + patient info - **Agencies & Consultants** – Answer inquiries + schedule meetings - **Any Service Business** – Save time, improve customer experience
Automated Reddit lead generation with AI analysis and Google Sheets
*This workflow contains community nodes that are only compatible with the self-hosted version of n8n.* ## How It Works This n8n workflow automatically discovers high-quality business leads from Reddit posts by analysing posts across targeted subreddits. 1. Loads your business profile from a connected Google Sheet. 2. Uses AI to identify relevant subreddits where your potential customers engage. 3. Generates intent-based Reddit search queries based on your services, keywords, and client pain points. 4. Searches Reddit in real time using the generated queries. 5. Classifies posts based on whether they show lead potential. 6. Analyses high-potential posts for service-fit, urgency, and estimated value. 7. Filters and scores leads to prioritize high-conversion opportunities. 8. Saves the most promising leads to a dedicated Google Sheet. 9. Sends Slack alerts to notify your sales team for immediate follow-up. ## Requirements Before using this workflow, ensure the following services are connected and configured: 1. Google Sheets (OAuth2): Reads your business profile and writes qualified leads 2. Reddit (OAuth2) Perform Reddit post searches based on generated queries 3. Google Gemini API Analyse posts, generate queries, and extract insights 4. Slack API : Notify your team with qualified lead summaries ### Google Sheets Setup You will need two Google Sheets: 1. Business Profile Sheet (Input) This sheet contains a single row describing your service business. The workflow reads this to generate relevant subreddit selections and search queries. Required Fields (as headers in row 1): - profession - industry - primary_services - service_keywords - target_client_profile - pain_points - intent_signals - urgency_indicators - price_range 2. Reddit Leads Sheet (Output) This sheet stores high-quality Reddit posts identified as potential leads. The workflow appends or updates rows based on post_id to avoid duplication. Expected Columns: - post_id - post_url - post_title - post_post - post_subreddit - post_date