WhatsApp , AI, appointment in Google Sheets,

Help me Build my Workflow
1

I need to create a simple chatbot where the patient contacts me via WhatsApp, receives a list containing options such as schedule an appointment, check an appointment, and speak with an agent. Then, the bot would schedule the appointment in Google Sheets, check the appointment in Google Sheets, or transfer the patient to an agent, and during the transfer, the bot would not continue responding in place of the agent.

Describe the problem/error/question

What is the error message (if any)?

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
2

Hey @Everton_Moraes !

What have you tried ?

Here you can find a good list with a lot of examples :

Cheers!

3

You start with a WhatsApp trigger (Twilio / WhatsApp Cloud API / provider you’re using). That trigger fires every time the patient sends a message.

On the first message, you just reply with a list like:
“1. Schedule appointment
2. Check appointment
3. Speak with an agent”

When the user replies with 1, 2, or 3, you route it using an IF or Switch node.

  • Schedule appointment
    Ask for date/time → then use the Google Sheets node (Append row) to store name, phone number, date, time, etc.

  • Check appointment
    Use Google Sheets (Read), filter by phone number, and send the result back to WhatsApp.

  • Speak with an agent
    This part is important: once they choose this, you should stop the workflow from replying automatically.
    Easiest way is to set a flag in Google Sheets or a Data Store (like human_handoff = true) and add an IF at the very start of the workflow that checks this flag.
    If human_handoff is true → do nothing (so the agent can reply manually).

That’s basically it.

You don’t need a loop or a Function node to start. Just:
WhatsApp Trigger → IF/Switch → Google Sheets → WhatsApp Reply.

Once that works, you can improve the conversation flow later.

Please accept and like my solution otherwise i might not get any incentive : )

hope i was helpful