# Chatbot for customer support and appointment scheduling: n8n workflow > Started by someone opening a chat with it, and works across Google Calendar and Google Sheets. Source: https://millionrounds.com/workflow/chatbot-for-customer-support-and-appointment-scheduling (Millionrounds; every figure on the page links to its filing or article) [Automation library](https://millionrounds.com/workflows) · [Customer support](https://millionrounds.com/workflows?category=Customer+support#library) # Chatbot for customer support and appointment scheduling Started by someone opening a chat with it, and works across Google Calendar and Google Sheets. It puts OpenAI behind a retrieval step, so answers are drawn from documents you supply rather than from the model alone. 25 steps: large, and worth reading before you trust it with anything live. Large Calls a model: OpenAI Retrieval [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fchatbot-for-customer-support-and-appointment-scheduling) **25 steps** Large: read it before trusting it with anything live **0** Branches: places the flow splits **0** Loops or waits **2** Services it connects to ## The flow Starts it 1 Model 8 Service 16 The steps in the order they run, from what starts it. - 1 **Chat Trigger** Chat trigger *Starts it* - 2 **OpenAI Chat Model** Lm Chat Open Ai *Model* - 3 **Simple Memory** Memory Buffer Window *Model* - 4 **Generate Ticket ID** Tool Code *Model* - 5 **Get Ticket Status** Google Sheets Tool *Service* - 6 **Create Support Ticket** Google Sheets Tool *Service* - 7 **Get Orders** Google Sheets Tool *Service* - 8 **Get Policies** Google Sheets Tool *Service* - 9 **Get Products** Google Sheets Tool *Service* - 10 **Appointments** Google Sheets Tool *Service* - 11 **Check Availability** Google Calendar Tool *Service* - 12 **Create Event** Google Calendar Tool *Service* - 13 **Retreive Event** Google Calendar Tool *Service* - 14 **Update Event** Google Calendar Tool *Service* - 15 **Delete Event** Google Calendar Tool *Service* - 16 **OpenAI Chat Model1** Lm Chat Open Ai *Model* - 17 **Simple Memory1** Memory Buffer Window *Model* - 18 **Generate Ticket ID1** Tool Code *Model* - 19 **Get Ticket Status1** Google Sheets Tool *Service* - 20 **Create Support Ticket1** Google Sheets Tool *Service* - 21 **Get Orders1** Google Sheets Tool *Service* - 22 **Get Policies1** Google Sheets Tool *Service* - 23 **Get Products1** Google Sheets Tool *Service* - 24 **Core Support Agent** Agent *Model* - 25 **Core Support Agent with Appointment Scheduling** Agent *Model* ## How it's built - **Starts on:** Someone opening a chat with it - **Steps:** 25 - **Size:** Large: read it before trusting it with anything live - **Connects to:** Google Calendar, Google Sheets - **Model:** OpenAI - **Retrieval:** Answers are drawn from documents you supply, not from the model alone ## Questions What does it need to run? An n8n account, plus your own Google Calendar and Google Sheets accounts, and a key for OpenAI. You connect your own accounts after importing it; none are included. What starts it? It starts on someone opening a chat with it. Does it use AI? Yes. It calls OpenAI. Its answers draw on documents you give it, not on the model alone. Model calls are billed by the provider, not by n8n. How long does it take to set up? Take your time. At 25 steps it is large: read it before trusting it with anything live. How do I import it? Copy the workflow, open a new workflow in n8n and paste. The steps appear on the canvas, ready for your own accounts. **Before you run it** Nothing here has been tested by us. It is somebody's working automation, read and described from its own steps. Treat the connections it wants as a list of accounts it will touch, and read the 25 steps before you point it at anything that matters. ## Run it in n8n - **Create your n8n account** Free to start. n8n is where the workflow runs. [Create an n8n account ↗](https://millionrounds.com/n8n) - **Download the workflow** Free with a Millionrounds account. [Download free](https://millionrounds.com/login?next=%2Fapp%2Fworkflow%2Fchatbot-for-customer-support-and-appointment-scheduling) - **Paste it into n8n** Open a new workflow in n8n and paste. Then connect your own accounts. Stored with the author's traces removed: canvas notes, instance identifiers, saved credential names and any live document they had left behind. ## Connects to Each opens the other workflows that use it. [Google Calendar](https://millionrounds.com/workflows?service=Google+Calendar#library)[Google Sheets](https://millionrounds.com/workflows?service=Google+Sheets#library) ## Workflows like it Also customer support, with the same services where possible, closest in size first. - [**Answer Telegram data questions with DeepSeek and Open-Meteo** 25 steps · calls a model · Google Sheets, Telegram](https://millionrounds.com/workflow/answer-telegram-data-questions-with-deepseek-and-open-meteo) - [**Automate Airbnb guest support with OpenAI and Google Drive** 24 steps · calls a model · Google Drive, Google Sheets](https://millionrounds.com/workflow/automate-airbnb-guest-support-with-openai-and-google-drive) - [**Email sorting & drafting for customer support with Gemini** 26 steps · calls a model · Gmail, Google Sheets](https://millionrounds.com/workflow/email-sorting-and-drafting-for-customer-support-with-gemini) - [**SEO FAQ generator for websites with Google Sheets** 24 steps · calls a model · Gmail, Google Sheets](https://millionrounds.com/workflow/seo-faq-generator-for-websites-with-google-sheets) - [**AI email support system: Gmail, Gemini, GPT-4, Slack & Google** 23 steps · calls a model · Gmail, Google Drive](https://millionrounds.com/workflow/ai-email-support-system-gmail-gemini-gpt-4-slack-and-google) - [**Automate customer support with Slack and CRM** 27 steps · calls a model · Gmail, Google Sheets](https://millionrounds.com/workflow/automate-customer-support-with-slack-and-crm)