Build a Weekly Staff Schedule with Constraints
Use this prompt each week to generate a complete staff schedule. Fill in your shift structure, staff availability, business rules, and any week-specific commitments before sending. It works for cafés, retail stores, or any small team running recurring shifts.
The Prompt
I need a weekly staff schedule for [business type], Monday to Sunday. Please build a shift grid and flag any constraint violations. **Shift structure:** [Paste your shift times and minimum staffing requirements here] **Staff availability:** | Name | Available Days | Available Hours | |------|---------------|----------------| | [Name 1] | [Days] | [Hours] | | [Name 2] | [Days] | [Hours] | | [Name 3] | [Days] | [Hours] | **Business rules:** - [Rule 1 — e.g., "At least one keyholder on every shift. Keyholders: Marcus, Priya."] - [Rule 2 — e.g., "No one works more than 5 shifts per week."] - [Rule 3 — e.g., "Minimum 10 hours between end of one shift and start of next."] **This week's fixed commitments:** - [e.g., "Marcus unavailable Wednesday — confirmed leave."] - [e.g., "Saturday is a long weekend — expect high volume, staff to maximum."] **Output requested:** 1. A Monday–Sunday grid showing who covers each shift, formatted as a markdown table. 2. Total scheduled hours per person this week. 3. A plain-English summary of any gaps, constraint violations, or coverage risks. 4. Flag if anyone is scheduled for less than 10 hours between shifts. 5. Flag any shift where no keyholder is present.
From the guide
Using AI to build a simple weekly staff schedule from your availability constraints and job requirements →Related Prompts
Revise a Staff Schedule for a Single Employee Change
Use this as a follow-up message in the same chat session when the generated schedule incorrectly assigns someone to a day they are unavailable, or when you need to make a targeted revision without re-pasting all your constraints.
Format a Staff Schedule as a Table
Use this as a follow-up message in the same chat if the AI returns the schedule as prose instead of a structured table.
Calculate Safety Stock from Supplier Delivery Records
Use this prompt when you have historical supplier delivery dates and want to calculate a more accurate safety stock figure based on real lead time variability rather than averages. Paste your actual order and delivery date records into the chat along with this prompt.
Auto-Email Inventory Reorder Alerts from Google Sheets
Use this prompt to generate a working Google Apps Script that automatically emails you when any inventory item falls below its reorder point. Paste it into Claude, ChatGPT, or Gemini after setting up your spreadsheet columns.