Services Fulfillment
Master document for automated content fulfillment system
Version: 3.1
Updated: 2026-02-02
Owner: Tyler + Ripper
Vision
-
One touchpoint per month Tyler opens an approval interface, reviews content in batch, checks boxes, walks away. Everything else is automated.
-
Zero data loss Every piece of content ever created is logged and archived.
-
Fail-safe operations Robust alerts when anything breaks. Constant health checks.
System Flow
️ Content is generated for NEXT month, giving Tyler a ~4 week review buffer.
[1st of Month] [Day 1-7] [Day 8+] [Next Month]
│ │ │ │
▼ ▼ ▼ ▼
┌──────────┐ ┌──────────┐ ┌──────────┐ ┌──────────┐
│ Ripper │ → │ Tyler │ → │ Approved │ → │ Auto │
│ Generates│ │ Reviews │ │ Content │ │ Deploy │
│ NEXT mo │ │ in Trello│ │ Locked In│ │ via Crons│
└──────────┘ └──────────┘ └──────────┘ └──────────┘
│ │ │ │
▼ ▼ ▼ ▼
GBP Posts Approve/ Ready for GBP API
Blogs Reject next month Git Push
Pages Vercel
Package Definitions
Pro Website
$29/mo
- Done Website design
- Done Hosting & domain
- Done Service pages
- — No content fulfillment
Marketing Lite
$329/mo
- Done 8 GBP posts/mo
- Done 2 GBP images/mo
- Done Monthly report
- Done Review automation
Local SEO Full
$799/mo
- Done 16 GBP posts/mo
- Done ~4-8 blog posts/mo
- Done 20+ citations/mo
- Done 4+ backlinks/mo
Fulfillment Matrix
| Task | Pro Website | Marketing Lite | Local SEO Full |
|---|---|---|---|
| GBP Posts | — | Done 8/mo | Done 16/mo |
| GBP Images | — | Done 2/mo | Done 2/mo |
| Blog Posts | — | — | Done ~4-8/mo |
| Citations | — | — | Done 20+/mo |
| Backlinks | — | — | Done 4+/mo |
| Monthly Report | — | Done | Done |
Data Architecture
| Priority | Source | Purpose |
|---|---|---|
| 1 | Zoho CRM | Client master data (package, URLs, status) |
| 2 | Trello | Workflow state (drafts, approved, deployed) |
| 3 | Google Drive | Content archive (Customers/{Client}/{Package}/) |
| 4 | Google Sheets | Content calendars per client |
| 5 | GitHub | Client website repos (auto-deploy via Vercel) |
Zoho Fields to Create
| Field | Type | Purpose |
|---|---|---|
| Package | Picklist | Marketing Lite / Local SEO Full |
| GBP_URL | URL | Google Business Profile link |
| Website_URL | URL | Client website |
| GitHub_Repo | Text | Repo name for deploys |
| Content_Calendar_ID | Text | Google Sheet ID |
| Trello_Board_URL | URL | Client's content board |
Trello Approval Flow
One board per customer. Each client gets their own Trello board. Board URL stored in Zoho CRM.
Board name format: {Client Name} - Content Pipeline
| Column | Purpose | Automation |
|---|---|---|
| Drafts Ready | Ripper finished drafts | Cron adds cards |
| Tyler Review | Awaiting approval | Tyler moves here |
| Approved | Ready to deploy | Cron watches this |
| Deployed | Live content | Cron moves here |
| Revisions | Needs rework | Ripper regenerates |
Forgot to approve alert: If cards sit in "Tyler Review" for 7+ days, Slack reminder fires.
Implementation Roadmap
Phase 1: Foundation (This Week)
Done
Set up Trello board template (per-client boards)
Done
Create Zoho fields in Account module
NEW
Build content-generator skill
NEW
Build approval-deployer skill
NEW
Test with 2 pilot clients
Phase 2: Automation (Week 2)
Integrate Git push for blog posts
Build client-onboarder skill
Onboard remaining clients to new system
Scaling Considerations
| Clients | Action Required |
|---|---|
| 27 (current) | Trello works fine |
| 50 | Hire part-time VA for content QA |
| 75 | Implement AI pre-filter (auto-approve high-confidence) |
| 100+ | Full-time ops hire OR enterprise platform |