How AI Helps Pharmacists Streamline Routine Tasks: A Two-Week Audit

Coding Liquids tutorial cover featuring Sagnik Bhattacharya for How AI Helps Pharmacists Streamline Routine Tasks: A Two-Week Audit.
Coding Liquids tutorial cover featuring Sagnik Bhattacharya for How AI Helps Pharmacists Streamline Routine Tasks: A Two-Week Audit.

AI helps pharmacists most with jobs that involve words and sorting, not clinical judgement: drafting patient letters and staff rotas, summarising supplier emails, answering repeat phone questions and tidying stock lists. Find your own by logging every task for two weeks, then sorting each into hand over, assist or never.

The common mistake is starting from the tool. An owner reads about an AI product, buys it, and then hunts for something to point it at. The audit works the other way round: it starts from where your team's hours actually go, which is rarely where you think. Most owners guess the dispensing process. The log usually shows phone calls, chasing, retyping and message-writing.

Follow me on Instagram@sagnikteaches

Why a log beats a brainstorm

Ask a pharmacist what wastes time and you will hear about the day's most irritating problem, not the largest one. Memory favours dramatic interruptions: the wholesaler that shorted an order, the angry caller at closing time. The quiet, repeated jobs that eat an hour a day go unmentioned because nobody notices them any more.

Connect on LinkedInSagnik Bhattacharya

A log fixes that by making every minute visible. It also gives you something concrete to take to the team, and to a supplier or adviser if you later want help. If you would rather work through the result with someone, that is what my AI implementation consultation covers, but the method below works on your own.

Subscribe on YouTube@sagnikteaches

It only needs a shared sheet or a clipboard by the till. Four columns are enough: who, what the job was, roughly how many minutes, and one word for the type (phone, message, paperwork, stock, rota, other). Ask people to write it down at the moment they finish, not in a batch when you lock up. Two weeks matters because a single week can be distorted by a public holiday, a flu rush or a locum, and the second week tells you whether the first was typical.

The Complete Excel Course with AI Integration thumbnail

The Complete Excel Course with AI Integration

From formulas and pivot tables to Power Query, DAX, VBA and AI with Copilot, ChatGPT and Claude — hands-on from the first lesson.

By Sagnik Bhattacharya and Virginia Thorn, Primetime Emmy Award winner

Buy now

Setting up the two-week log

Decide the rules before you start, or you will get forty half-filled sheets. Here is a set that works for a team of five to ten people in an independent pharmacy.

  • Log threshold: any job that takes three minutes or more, or that happens more than five times in a day. A quick tally column handles the frequent small ones, such as "Where is my prescription?" calls.
  • Interruptions count. Add a column for "stopped what I was doing", because a two-minute call that breaks a clinical check costs more than two minutes.
  • No names. Record the type of job, never patient or customer names. The log itself should hold nothing you would mind a colleague seeing over your shoulder.
  • One owner for the sheet. Somebody collects it each Friday and checks nobody has stopped filling it in.

Be honest with the team about the purpose. If staff think the log is a productivity check, they will log less or log flatteringly. Say plainly that you are looking for jobs to take off their plates, and that nobody's hours are being cut on the back of it.

Sorting every job: hand over, assist or never

After two weeks, take the sheet and put each recurring job into one of three piles. The rules are simple, and they matter more than any tool choice.

PileWhat it meansTest questionWho checks
Hand overAI or automation does it start to finishIs the worst-case error cheap, obvious and easy to reverse?Spot check weekly
AssistAI drafts, a person reviews and sendsCould a wrong word reach a patient or supplier?A named person, every time
NeverA human does it, no AI in the loopDoes it involve a clinical decision, a legal record or a controlled step?Not applicable

The tricky pile is "hand over". Be strict about it. A job only qualifies if a mistake is cheap and visible: a shelf-talker with a typo, an internal reminder that fires a day late. Anything that reaches a patient goes to assist, however good the tool seems. And anything that touches the clinical check of a prescription, the controlled-drugs register or a professional judgement is "never" without discussion.

One pharmacy's two-week log, sorted into piles

Here is an illustration, with made-up but plausible figures. Say an independent pharmacy with seven staff logs two weeks and finds about 41 hours a week spent on recurring jobs. The biggest lines, in the log's own words, look like this.

Logged jobHours a weekPileReason
Phone: "Is my order ready?" and opening-hours calls9.0Hand over (answers) / assist (anything personal)Repeat questions with fixed answers
Writing delivery and missed-collection messages3.5AssistReaches patients, so review each batch
Chasing wholesaler and supplier emails4.0AssistDrafts are quick, tone needs a human
Staff rota and holiday juggling3.0AssistConstraints change daily
Retyping stock-shortage lists into messages2.5Hand overLow-risk wording from a fixed list
Writing and updating procedures2.0AssistDrafted by AI, approved by the responsible person
Checking and recording prescriptions10.0NeverClinical and legal
Controlled-drugs register1.5NeverStatutory record
Social posts and shop window signs2.0Hand over (first draft)No patient data, visible, easy to fix
Everything else3.5MixedSort individually

The surprise is the first line. Nine hours a week on the phone, almost all of it repeat questions, is more than the rota and supplier chasing combined. Before reaching for a tool, count how many of those calls a sign on the door, a text message or a short recorded greeting could remove. The tutorial on shortening phone queues in an independent pharmacy goes through that one in depth.

Notice also what does not move. Ten hours of prescription checking and 1.5 hours on the controlled-drugs register sit in "never", and together they are 28% of the log. Nothing in this audit is trying to shrink them. That is the point of the third pile: it protects the work that must stay human and stops anyone in the team drifting towards it.

Counter examples: jobs that look small and add up

The counter is where the repeat questions land, and where AI is least visible but most useful. Three jobs from the log, each with how you would actually treat it.

Answering "is my prescription ready?" without a phone call

This is a text-message or web-form job, not an AI-writing job. If your patient-record system can send a "ready for collection" message, switch it on and measure how many calls disappear. Where it cannot, a simple automation can send a templated text from a list your team confirms. AI contributes the wording and the handling of replies, but the decision to send stays with a person who has confirmed the order is ready. Pile: assist for personal messages, hand over for fixed answers such as opening hours.

A sample message a team might set for the common case, written in plain words:

Hello [first name], your order is ready to collect from the pharmacy counter.
We are open until 6pm today. Please bring ID if someone else is collecting for you.
Reply STOP if you would prefer not to get text updates.

Shelf-talkers, window signs and short social posts

No patient data is involved and a mistake is visible and easily fixed, so this is a genuine hand-over candidate. Give an assistant the product, the offer and the tone, and ask for three versions. The weak spot is claims: an AI will happily write "relieves symptoms in minutes" for a product that makes no such promise. Keep a rule that product claims are copied from the packaging or the supplier sheet, never generated.

Answering supplier and wholesaler emails

Paste the incoming email with details removed, ask for a polite reply that states your order number, the shortfall and what you need back by Thursday, and edit the result. This is the classic assist job: the drafting saves four minutes, the check takes thirty seconds. For the ordering side, AI stock ordering in an independent pharmacy shows how far it can be taken and what still needs a person.

Dispensary examples: where the lines get sharper

The dispensary is where owners most often want to over-reach and where the "never" pile earns its keep. Here are three jobs that sit near the line and how to place them.

Writing and tightening standard operating procedures

Drafting is a good fit. You describe the steps in rough notes, the assistant turns them into a numbered, plain-English procedure, and the pharmacist in charge checks every step against what really happens and signs it off. The risk is a plausible-sounding step that your pharmacy does not actually do. That is why it is assist, never hand over. The full workflow is in writing pharmacy SOPs with AI.

Summarising a long supplier or guidance document

A 40-page change notice from a supplier can be summarised into a one-page list of what changes for your counter. This is assist, because the summary is only a map: the pharmacist who relies on it should open the original for anything that affects dispensing. A useful check is to ask the AI to quote the sentence each point came from, then spot-check three.

Anything near the clinical check

Interaction checks, dose queries, labelling, owing quantities and anything that goes into the clinical record belong to the clinical systems and to the pharmacist. The audit should record them in "never" with a one-line reason, so a keen new starter does not paste a prescription into a chatbot to "double check". If you want a fuller list, the pharmacy tasks that should never go to AI sets out the reasoning.

Scoring the candidates before you touch a tool

With the piles sorted, rank the hand-over and assist jobs with a simple score. For each job, give 1 to 5 on three things: hours saved a week, how repeatable the wording or decision is, and how cheap a mistake would be. Multiply the three. A job scoring above about 60 is worth starting with; below 20, leave it.

Using the illustration above: the repeat phone questions score 5 for hours, 5 for repeatability and 4 for cheap mistakes, so 100. Supplier-email drafting scores 3, 4 and 4, so 48. Rota juggling scores 3, 2 and 3, so 18, because the constraints change daily and the worst case, a gap in cover, is expensive. That ranking puts the phone questions first, supplier emails second, and the rota last or not at all, which matches intuition once it is written down.

Check the result against two practical limits. First, how many different tools you can ask a small team to learn: one or two, at most. Second, whether the tool can be used without patient details. If a job can be done on a template with placeholders such as [first name] and [medicine], choose that version.

One shortage text, drafted two ways

The assist pile is easier to picture with a pair of messages. Say the counter team writes about eight "we have a shortage" texts a week and each takes five minutes of rewording.

Before, someone types from scratch, forgets the date, and ends up phoning back.

After, the owner keeps one prompt saved in a shared project in their chosen assistant:

Write a short, friendly text for a pharmacy patient. A product is delayed.
Facts you must use exactly: the product is [product]; the expected date is [date];
the alternative is [alternative or "none"]. Do not give medical advice or say
anything about the product's effects. Ask them to reply or call [number]
if they need to talk to a pharmacist. Under 50 words, plain language.

A typical illustrative output is: "Hello [first name], the [product] you ordered is delayed and should arrive on [date]. If it would help to talk through an alternative, please call us on [number] and a pharmacist will help. Thank you for your patience." The human check is quick: are the date and product right, and is there a sentence that sounds like advice? If so, delete it. Five minutes becomes about one, and nothing patient-specific has gone into the tool.

When the automatic opening-hours reply went stale

Say a pharmacy sets up an automatic reply to its social-media messages with a fixed list of opening hours. A public-holiday rota changes and nobody updates the list. For three days the automated reply confidently tells patients the pharmacy is open when it is shut. The error is cheap, visible and reversible, so the job was properly "hand over", but it needed an owner. Put one weekly line in the log sheet: "Who checked the opening hours the AI is using?" and give it a name.

Choosing a tool for the piles you ended up with

With a ranked list, tool choice is easier. For drafting and summarising, a general assistant such as ChatGPT, Claude, Gemini or Microsoft Copilot can all do the job; what separates them for a pharmacy is the data terms. On the vendors' own pages as of November 2026, the business plans (ChatGPT Business, Claude Team, Microsoft Copilot for work accounts, Gemini in Workspace) do not train on business content by default. The personal plans differ: ChatGPT Free and Plus use your chats for training unless someone turns off the setting called "Improve the model for everyone", and Claude's consumer plans use chats for training when the "Model Improvement" setting is on. A shared counter laptop signed in to someone's personal account is the usual way patient-adjacent text ends up on the wrong terms, so give the team one work account. Read the current page for the plan you pick, and keep patient details out regardless of the plan.

Business plans for ChatGPT and Claude both need at least two seats, at $20 a seat a month billed annually or $25 monthly on each vendor's pricing page, so a one-pharmacist business pays for two (about $40 to $50 a month) or uses an individual plan. Phone-handling products are a separate market; the question there is what your phone system and patient-record software already offer before you buy anything new. Our guide to AI agents for pharmacies compares phone, chat and refill requests as a first project.

Rolling out one job at a time

Start with the single top-scoring job. Write it up as one page: what the job is, which pile, the prompt or template, who reviews, and what a mistake would look like. Run it for two weeks, then re-log only that job. If the minutes did not fall by at least a third, stop and find out why before adding another.

Review the log every quarter. Jobs move between piles as tools improve and as your confidence grows, but they should only ever move one step at a time, hand over to assist or assist to hand over, and never move out of "never" without the pharmacist in charge agreeing in writing. Teach the team using real examples from the log rather than abstract training; a two-session plan for pharmacists and counter staff sets out how.

Three questions to put to the log before you act on it

Before you commit to anything, read the finished sheet once more with three questions. Which job appears on every person's sheet, not only one? That is usually a process problem, such as a missing text-message step, rather than a task for AI. Which job has the highest "stopped what I was doing" count? Fixing that protects the dispensary even if the minutes saved are small. And which job did people write down with a sigh? Morale is a legitimate tiebreaker: handing over a job the team hates builds trust in the whole exercise, and trust is what you need when you later ask them to review AI drafts carefully rather than wave them through.

How to tell the audit worked

Three signs. The minutes on the targeted job drop by a third or more. Nobody has had to undo a message that reached a patient wrongly. And the team reports fewer interruptions at the dispensary bench, which is the number that matters most and appears on no spreadsheet unless you added that column in week one.

If none of those happen, the usual cause is that the job was bigger than it looked. Split it: the phone-question job might really be three jobs (opening hours, order status, medicine queries), and only the first two belong in hand over. Re-sort and run again.

Questions pharmacy owners ask about the audit

Do I have to log every single task for two weeks?

No. Log anything that takes more than about three minutes or happens more than five times a day, plus every interruption to the dispensary. Tiny jobs add up, but the log only needs to be good enough to rank candidates. A tally mark on a clipboard is often enough for the repetitive ones.

Should the whole team keep the log, or just me?

The whole team, ideally on one shared sheet or a paper form by the till. The owner sees a different set of jobs from the dispenser, the counter assistant and the delivery driver. If only you log, you will capture your own admin and miss the interruptions that cost the dispensary most.

What if a task I want to hand over touches patient information?

Treat it as assist at most until you have checked the tool's data terms, and prefer a version of the task that needs no patient details at all. Many jobs can be done on a template with placeholders. Ask the supplier in writing how data is stored, who can see it and whether it trains models.

Further reads

Sources: OpenAI ChatGPT business pricing page and Data Controls FAQ, Claude pricing page and Claude privacy centre, Microsoft Learn (Copilot data, privacy and security), Google Workspace generative AI privacy hub, all checked November 2026.

Want help reading your own pharmacy task log?

On a 1:1 call we can go through your two-week log, pick the two or three jobs worth handing over first, and agree where a person always stays in the loop.

Book a 1:1 call with me