← ClaudeAtlas

cron-bridge-daily-publisherlisted

End-to-end architectural pattern for "daily auto-publish N curated items from D1 → social platform (FB Page, IG Business, LinkedIn Page, etc.) via the existing Multi-Reach scheduler worker". Includes fair-rotation selector, content-hash idempotency, sentinel-keyed daily dedup, R2 image mirror via serve endpoint, D1 audit trail, and a companion retract sweep for platform ToS SLA (e.g. EasyBroker 24h). Reusable across white-label / franchise / multi-tenant scenarios.
CarlosCaPe/octorato · ★ 5 · AI & Automation · score 73
Install: claude install-skill CarlosCaPe/octorato
# Cron Bridge — Daily Auto-Publisher ## When this skill fires Client asks for a variant of: "I want my <catalog of N items> to auto-post to <social Page/Account>, M items per day, no repeats until we've cycled through all N, and respect any ToS removal SLAs". This skill is the architectural recipe. Pre-flight check: confirm the target platform allows API publishing for the surface you're targeting (Page yes, Group no — see `tos-safe-social-share-helper` for the no-API case). ## Architecture overview ``` ┌──────────────────┐ cron */30 ┌──────────────────┐ │ Upstream feed │ ────────► │ ingest worker │ ──┐ │ (REST API) │ │ → D1 catalog │ │ idempotent UPSERT └──────────────────┘ │ → R2 images │ │ + tombstone sweep │ → audit rows │ ◄─┘ └────────┬─────────┘ │ ┌─────────────────────────────────────────┐ │ │ ▼ cron 1×/day @ 14:00 UTC ▼ cron */1 (publisher worker) ┌──────────────────┐ ┌──────────────────┐ │ bridge endpoint │ │ multireach │ │ /api/.../bridge │ ── INSERT KV Posts ──► │ scheduler worker │ │ + sentinel │ ── INSERT D1 audit ──► │ → Graph API │ │ + fair rotation │ │ → updates KV │ └──────────────────┘