Automate a weekly task safely, then schedule it
https://patrickz.ai/learn/automate-a-repeatable-task/

OUTCOME
Map a weekly task, test a draft-only version on three cases, then run it on a schedule you control, with a manual fallback.

YOU NEED
Three fictional examples of the same task and a chat assistant. A spreadsheet is enough for the first version. Scheduling is optional: use a tool you already have that can run a saved prompt on a schedule (Microsoft 365 Copilot Cowork can, but it needs a Copilot license and IT enablement), or set a calendar reminder to run the saved prompt yourself.

1. Map the process in four parts
Pick a task you do every week, such as turning meeting notes into a draft action list. Write when it runs, what it reads, the yes/no decisions it makes and what it does. List the exceptions, then do it by hand once.

2. Standardize the output
Define fields such as action, owner, due date and source sentence. Use unknown for missing information. Keep the original input attached.

3. Test three cases
Try a normal note, one with missing dates and one with conflicting owners. Compare with your manual answer before adding tool connections.

4. Add a guardrail, then schedule the draft-only version
Anything that sends, deletes or changes another system waits for your approval. Save the tested prompt, schedule it (or set a reminder) and watch the first run next to your hand-done version. Record failures and keep the manual route written down.

PROMPT
Design a draft-only workflow for [task]. When it runs: [schedule]. What it reads: [input]. Decisions: [yes/no rules]. Example inputs: [examples]. Specify the output fields, missing-data rules, three tests, what to do when there is no new input, the review point and the manual fallback. Do not send messages or modify external records.

EXAMPLE / EXPERIMENT
A Monday 9:00 run that finds no new notes should report “nothing new”, not produce an empty list or re-send last week’s actions.

CHECK YOUR RESULT
[ ] Three different inputs produce reviewable drafts.
[ ] Exceptions remain visible.
[ ] The workflow has a clear human decision before external action.
[ ] The first scheduled or reminded run was watched and matched your hand-done result.

IF IT FAILS
If you cannot explain the manual task, do not automate it yet. If the draft needs more correction than doing it yourself, simplify the output or improve the input.

MY RESULT / NEXT CHANGE