I build a lightweight content-calendar system in Google Sheets with a tiny Google Apps Script layer so content doesn’t slip. You’ll get automatic inbox notifications / Slack pings for due and overdue items, a clear status pipeline (Planned → In Progress → Needs Review → Published), a weekly summary to the lead, and a timestamped change log for accountability. Setup includes a ready-to-use template, documented script, and a short Loom handoff. Typical delivery: 24–72 hours.
What you get
Google Sheet template with validated status tags and color-coding
Apps Script automation with time-based triggers
Notifications for upcoming/overdue items (inbox; Slack optional)
Weekly summary for the lead (late items and blockers)
Change-log tab that records who/what/when on status changes
Notes.txt (config, trigger times, IDs) + 5–7 min Loom walkthrough
Process
Quick audit (10 min) – review your sheet or provide a starter template.
Configure – confirm columns (Title, Owner, Due, Status) and notification rules.
Automate – wire triggers, weekly summary, and change-log.
Handoff – Loom walkthrough + Notes.txt; remove access on request.
Polish – one minor revision within 7 days (timing/labels/field rename).
Packages (managed here—no duplicate services needed)
Starter — $25 — 24–72h• One Sheet + one status pipeline• Inbox notifications for due/overdue tasks• Simple weekly summary for the lead• Notes.txt + Loom handoff• One minor revision (timing, labels, or field rename)
Plus — $75 — 24–72hEverything in Starter, plus:• Slack notifications (channel or webhook)• Up to two sheets / two pipelines (e.g., blog + social)• Backlog section for unassigned/blocked items
Pro — $150 — up to 5 daysEverything in Plus, plus:• Multi-team setup (writers, designers, approvers)• Custom fields & filters (priority, campaign, owner teams, etc.)• Weekly summary with late-items report on a separate tab• White-label optional for agencies
Need something lighter? I can start with a tiny pilot (notifications + weekly summary on your current sheet) and expand after approval.
FAQs
Do I need Slack? No. Inbox notifications are included in all tiers; Slack is optional in Plus/Pro.
Can you install on our current sheet? Yes, if Owner/Due/Status exist; otherwise I’ll migrate to a clean template.
What access do you need? Temporary Editor to install the script and triggers; I can remove myself after handoff.
What counts as a “minor revision”? Small tweaks like trigger time, label names, or a field rename. New features or extra pipelines fall into Plus/Pro.
Work termsSafePay/escrow funded to start. I deliver the template, script, Notes.txt, and a Loom walkthrough. One minor revision is included within 7 days. Access is removed after handoff if requested. NDA-friendly.
Nice-to-have inputs (faster delivery)Link to a sample Sheet (view), the columns you use for Owner / Due / Status, your preferred notification time, and whether Slack is used.