Onsen Hot Pools Rostering Automation + AI Agent
AI Agent

Onsen Hot Pools Rostering Automation + AI Agent

An AI rostering assistant that automates the process of generating weekly rosters, managing staff and services on behalf of the Onsen Hot Pools team.

Completed: June 30, 2025

Key features

AI AgentAutomationStaff Rostering

Onsen Hot Pools Rostering Automation + AI Agent

Onsen Hot Pools is a iconic tourism destination in Queenstown, offering multiple different kinds of services for travellers looking to be pampered with a view of the iconic Shotover river.

Behind the scences, rostering staff to these services is a time-consuming process that takes hours per week. An AI agent, with access to a custom algorthim, now automatically generates these saving Onsen 5 hours per week.

Overview

This AI agent for Onsens Rostering is powered by N8N, with access to a number of MCP servers and custom defined internal tools to manage Onsens rostering operations. The goal is to save 95% of the work for anyone managing rosters.

In the backend, Onsen has a Airtable database to manage staff, services and leave. Periodically,the Agent is called to generate future rosters which now only require a review from Onsen. This is powered by a custom annealing algoritihm exposed via an web-server, which the Agent can call as it needs to for rostering, forecasting etc.

In the front-end, Onsen can interact with this AI agent by a chat interface, getting it to complete common tasks related to staff management, but also generating rosters on demand formatted in a CSV they can then download to review.

This saves Onsen at minimum 5 hours a week per team (3 teams) making it a very effective automation built on good principles of human review points, and embedding into current workflows.

Key Features

  • AI Agent: A Agent that can be accessed by an interface who has access to all tools to manage staff + rostering.
  • Custom Rostering Algorithm: Powered by 30+ rules for rostering, this generates 98% complete weekly rosters given available staff and services for a week.
  • Airtable Database: Staff, Services, Leave and Logs are all easy to acesss and manage by the team in Airtable.