Banner Image

All Services

Programming & Development Programming & Software

Google Sheet Content Calendar Automation

$15/hr Starting at $25

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

  1. Quick audit (10 min) – review your sheet or provide a starter template.

  2. Configure – confirm columns (Title, Owner, Due, Status) and notification rules.

  3. Automate – wire triggers, weekly summary, and change-log.

  4. Handoff – Loom walkthrough + Notes.txt; remove access on request.

  5. 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.


About

$15/hr Ongoing

Download Resume

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

  1. Quick audit (10 min) – review your sheet or provide a starter template.

  2. Configure – confirm columns (Title, Owner, Due, Status) and notification rules.

  3. Automate – wire triggers, weekly summary, and change-log.

  4. Handoff – Loom walkthrough + Notes.txt; remove access on request.

  5. 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.


Skills & Expertise

Automation EngineeringGoogle AppsGoogle Apps ScriptGoogle SheetsTemplates

0 Reviews

This Freelancer has not received any feedback.