AI Chatbot Call Center: Taxi Booking Support (Production-Ready, Part 7)

Description

Workflow Name: 🫶 Taxi Booking Support

Template was created in n8n v1.90.2

Skill Level: Mid

Categories: n8n, Chatbot

Stacks

Schedule Trigger node
Postgres node
AI Agent node
Google Calendar node
Execute Sub-workflow
If node, Switch node, Code node, Edit Fields (Set)

Prerequisite

Sub-workflow: Demo Call Back (or your own node)

Production Features

Scaling Design* for n8n *Queue mode** in production environment
Customize Expired Booking Actions example
Multi-Language** Design

What this workflow does?

This is a n8n Taxi Booking Support, the background node to process the job at scheduled. It is scheduled to check the database for outstanding booking and handle the after sales process. In this particular case, it will check for OPEN booking over 10 minutes, then update the booking status from OPEN to CANCELLED, delete the Calendar event and send a reply to the user.

How it works

The Schedule Trigger node is scheduled to run every 5 minutes.
It will check the database for OPEN or HOLD booking.
For OPEN booking
update the booking status to CANCELLED
delete the Calendar event
send a reply to the user
Optional: The AI Agent is used to create the reply message to the user in Multi-language based on the language set in the booking.

Set up instructions

Pull and Set up the required SQL from our Github repository.
Create you Postgres credentials, refer to n8n integration documentation for more information.
Select your Credentials in Open Hold Booking and Set Cancel Booking.
Create your Google Calendar credentials, refer to n8n integration documentation for more information.
Create a Google Calendar, e.g. DEMO
Select your Credentials in Delete Event, and select the above Calendar
Remember to activate this workflow for schedule to run.

How to adjust it to your needs

There should be more status for the booking.
The current action only check for OPEN and HOLD booking, you can do more based on your needs.
You can replace the sub-workflow trigger Call Back to another flow as needs.