Agent Insider Lab Put AI Agents to Work for Your Business.
Idea or playbook

Staff Schedule Drafts and Shift-Swap Messages with AI Agents

For: Operations · Difficulty: Beginner

The problem: Every week you juggle who's available, who asked for time off, and who wants extra hours. Then come the shift-swap texts, at all hours.

What you end up with: A draft weekly schedule built from your staff's availability and your coverage needs, plus clear, friendly messages for posting the schedule and handling swap requests, all for you to approve.

What you'll need

A simple spreadsheet with each person's availability and time-off requests, your coverage needs (how many people per shift), and any scheduling rules you follow.

Getting set up

Juggling staff availability every week? Let's walk through it, using what each tool's official docs say it does. First, pick a tool. Google says Gemini in Sheets can build spreadsheets and fill in tables from plain-English prompts. Microsoft says Copilot in Excel can analyze data, and Copilot in Teams can respond to chats. Notion says Notion Agent can complete multi-step tasks using your Notion pages. Next, keep availability in one spreadsheet that staff update. Then, write your rules in plain words, like minimum rest between shifts or max hours. And last, the agent drafts. You finalize and post the schedule yourself.

Step by step

  1. Each week, have the agent read the availability sheet and time-off requests.
  2. Ask it to draft a schedule that covers every shift and follows your rules.
  3. Have it flag any shift it couldn't fill, and anyone over or under their hours.
  4. Review and adjust. You know your team.
  5. Have it draft a friendly message posting the schedule.
  6. When a swap request comes in, have it check who's available and draft a reply.
  7. Approve every change and message before it goes out.

A prompt to start with

Here's a starter prompt. Change the details to fit your business. "Using this availability sheet, time-off list, and these rules: [rules], draft next week's schedule covering these shifts: [shifts]. Only schedule people when they're available. Flag any shift you can't fill and anyone above [X] hours. Then draft a short, friendly message posting the schedule. Don't send anything or change the sheet."

What you'll get

A draft schedule table, flags for gaps and hours, and a ready-to-approve schedule message.

If something goes wrong

If it schedules someone who's unavailable, check that the availability sheet is clear and up to date. If it ignores a rule, list rules as short bullet points. If swaps get messy, handle one request at a time.

Keep in mind

You're responsible for following the labor and scheduling rules where you operate, like breaks, overtime, and notice periods. Keep staff info private, and have a person approve every schedule.

Sources

Where each fact came from

Heads-up: some links here may become affiliate links down the road. Here's how that works. Right now, no affiliate programs are connected.