Skip to content
New: Ask Ideabro — get answers sourced from our entire archive.Try it

Volunteer scheduling for a food bank with three prompts and a shared sheet (template inside)

Started 3w ago 5 replies 1.4K views

Daniel Okoro

Daniel OkoroOP

We have about 70 volunteers, four shifts a day and a lot of last-minute cancellations. I was spending most of Friday on scheduling. Now it takes about 40 minutes, and here's the whole setup.

The sheet: first names, availability, skills (driving, warehouse, front desk) and "never" notes.

Prompt 1, draft: paste the sheet, ask for next week as a table, NEVER rules listed first.

Prompt 2, check: in a fresh chat, paste the draft and the rules and ask "find every rule this schedule breaks." A second pass with fresh eyes catches far more than asking the first chat to check itself.

Prompt 3, messages: turn the final schedule into short, friendly reminder texts, one per volunteer, which I send myself.

The fresh-chat check is the trick. The first chat defends its own work; the second one doesn't care.

5 replies

  1. The fresh-chat check is a great insight and works in data work too. Asking the same conversation to verify its own output gets you a lot of 'looks good to me'. A new conversation with only the output and the rules behaves like a different reviewer.

  2. We have a similar volunteer pool at the library. Do you send reminder texts the evening before or the morning of? We've found the evening before cuts no-shows in half.

  3. Daniel Okoro

    Daniel OkoroOP

    Evening before, around 6 p.m., with a one-word reply option ('OK' or 'SWAP') so people can flag problems without a phone call. Swaps go to a waiting list I handle by hand.

  4. Maya Okafor

    Maya OkaforStaff · Editor

    · Editor-in-Chief

    Daniel, this is exactly the kind of small, practical build we love. Would you be up for a short Field Notes piece? The fresh-chat check deserves a wider audience.

  5. Found this after posting my bakery rota. The fresh-chat check is going into my Sunday routine too, right after the NEVER list. Thank you, Daniel.

Join the conversation

Sign in to reply, upvote and follow this thread.