Automations
Content calendar review automation
Friday: next week's content slots vs what is actually ready, gaps named early.
Last reviewed July 17, 2026
A cron automation recipe that reconciles your content calendar with draft reality every Friday: what ships, what slips, and which slot has no draft.
Schedule: Fridays at 15:00
0 15 * * 5Automation instructions
Read /Content/calendar.md (planned slots: date, title, owner, status) and the drafts in /Content/drafts. Reconcile plan against reality: (1) next week's slots with a ready draft (exists and status marked final or review); (2) slots whose draft is missing or stale (file untouched 7+ days), named plainly as at-risk with the owner; (3) drafts that exist but have no slot, as candidates. Propose the minimal fix for each gap: move the slot, swap in a ready candidate, or cut. Write the reconciliation to /Content/friday-check-YYYY-MM-DD.md, at-risk items first. Do not edit the calendar; propose.
Set it up
- 1
Keep calendar and drafts in Drive
One calendar file, one drafts folder, statuses in the calendar; the recipe reconciles the two.
- 2
Copy the instructions
Friday 15:00 leaves the afternoon to fix next week while fixes are still cheap.
- 3
Create the automation
Pair with the editorial pipeline board template if your team plans in a task board instead of a file.