Skip to content

Recipe: next week's appointments per staff member

Give Hermes the export of your booking system. It builds next week's schedule for each person, flags double bookings and long empty gaps, and tells you how much revenue the week should bring in.
Time needed 5 minutes
You need A Hermes agent connected to an AI model and your appointments exported as a CSV file (date, time, client, service, length, price, staff)
Result A schedule per staff member with start and end times, the problems flagged, and the expected revenue, saved in schedule-16-nov.md

1. Export and upload your appointments

Export your bookings from your booking software or spreadsheet as a CSV file. It needs, for each appointment: the date, the start time, the client, the service, how many minutes it takes, the price and the staff member. Upload it in FILES → workspace (see Hermes reads a contract for you).

Our test file, salon-appointments.csv, is for a small hair salon with three people (Joana, Marco and Rita), open Tuesday to Saturday. It has 54 appointments: 31 past visits and 23 bookings for next week. The first lines:

date,time,client,service,minutes,price_eur,staff
2026-08-04,10:00,Daniela Rocha,Highlights,150,70,Rita
2026-08-06,11:00,Vasco Moreira,Men's haircut,30,15,Marco
...
2026-11-19,14:00,Filipa Gomes,Colour,120,55,Joana
2026-11-19,15:00,Patrícia Ribeiro,Women's haircut,60,25,Joana
...

We put one problem in on purpose: on Thursday 19 November Joana has a 2-hour colour at 14:00 and a haircut at 15:00. A good assistant should notice that.

2. Ask for the schedule

Give the dates of the week you want and the days you are open. In CHAT we wrote:

Open workspace/salon-appointments.csv (my hair salon, open Tuesday to Saturday). Make next week's schedule (Mon 16 to Sun 22 Nov 2026) for each staff member, with start and end times. Flag any double bookings and any gaps of 60 minutes or more between two appointments of the same person. Then give the expected revenue per person and in total. Save it as workspace/schedule-16-nov.md.

Hermes answered in about a minute:

Hermes summarises next week's appointments

  1. The double booking: Joana, Thursday 19 November, Filipa Gomes (14:00–16:00) overlaps Patrícia Ribeiro (15:00–16:00).
  2. The gaps of an hour or more: 75 minutes for Joana on Saturday, 120 and 255 minutes for Rita on Tuesday and Friday. Marco has none.
  3. The expected revenue per person and in total: €617 for 23 appointments. Hermes says that this counts the double-booked appointment as if both go ahead.

3. Read the full schedule

The file schedule-16-nov.md in FILES → workspace has one table per person and per day, with the end time worked out from the length of each service. This is Joana's Thursday, exactly as Hermes wrote it:

**Thu 19 Nov**

| Start | End | Client | Service | € | Note |
|---|---|---|---|---|---|
| 14:00 | 16:00 | Filipa Gomes | Colour | 55 |  |
| 15:00 | 16:00 | Patrícia Ribeiro | Women's haircut | 25 | ⚠ DOUBLE BOOKING |

You can print it or send it to your team.

Check that it worked

We worked out the week ourselves before asking Hermes. Everything matched:

Check Our answer Hermes
Appointments next week Joana 7, Marco 7, Rita 9 Same
Revenue per person €220, €95, €302 Same
Total revenue €617 (€592 without the double-booked haircut) €617, with a note about the double booking
Double bookings Joana, Thu 19, 14:00 colour and 15:00 haircut Same
Gaps of 60+ minutes Joana Sat 21 (75 min), Rita Tue 17 (120 min), Rita Fri 20 (255 min) Same

To check your own result, take one person and one day and add the minutes of each appointment to its start time with a calculator: the end time of one appointment must not be later than the start of the next.

Make it yours

  • Every week: schedule it for Saturday evening, after you export the new bookings.
  • Fill the gaps: "For each gap, suggest a service of the right length that we could offer to clients on the waiting list."
  • Your own rules: "Flag any day where one person works more than 8 hours."
  • Ask for a version per person: "Make one short message per staff member with only their own appointments."

Common problems

The end times are wrong

Hermes needs the length of each appointment. Keep a column with the minutes (or an end time) in your export. Without it, Hermes has to guess how long a service takes.

Days from the wrong week are included

Write the exact dates in the message, as we did ("Mon 16 to Sun 22 Nov 2026"), not just "next week".

The revenue is higher than what you will really make

The forecast adds up every booking in the file, including double bookings and appointments that may be cancelled. Hermes said so in its answer. Solve the double booking first, then ask again.

Next steps