We’ve designed a fully documented, multi-stage BOFU blog automation system that uses: - Google Sheets + Apps Script - OpenAI & Perplexity APIs - Zapier (scheduled workflows, filters, code steps) The system is already architected in detail. The only blocker is that our website CMS cannot emit outgoing RSS feeds, which requires a clean, reliable workaround so new blogs are still logged into our content library automatically. We are looking for an automation engineer who can implement and finalize this system exactly as designed, while replacing the RSS dependency with a stable alternative. This is not a “design from scratch” project — the logic, prompts, and workflow are already defined. Your job is to execute, adapt the RSS-dependent portions, and harden the system. What’s Already Built You will be given: - A Google Sheet with attached Apps Script - A full Zapier workflow (16+ steps) including: - Weekly scheduling - Persona lookup - Live trend research - Funnel intent validation - Duplication guardrails - Compliance injection - Long-form blog generation - Google Docs creation - Blog library logging The only missing piece is how to replace RSS-based blog syncing when the CMS doesn’t allow feeds. Your Core Responsibilities: - Replace RSS dependency - Implement a non-RSS method to log newly created blogs into the Blog Library - Must be CMS-agnostic - Finalize Apps Script + Zapier integration - Ensure blog library stays accurate over time - Confirm guardrails, filters, and JSON handling are stable - Ensure no duplicate or rejected topics slip through - Propose and implement the cleanest workaround - Possible solutions (examples, not requirements): - Google Sheets as source of truth (push-based logging) - Public JSON endpoint (hosted externally) - Drive-based ingestion - Zap-based logging as replacement for RSS sync - Document the final setup - Short internal documentation - Clear explanation of how blogs are tracked without RSS - Instructions a non-technical team can follow Hard Requirements - Google Apps Script (not just basic formulas) - Zapier (filters, code steps, line-item handling) - API-driven workflows (OpenAI / Perplexity) - Comfort working with long, multi-step automations - Ability to follow an existing architecture without “simplifying it away” What This Is NOT ❌ A basic Zapier setup ❌ A CMS plugin install ❌ A scraping workaround ❌ A rewrite of our prompts or logic ❌ A junior VA task This is systems implementation, not experimentation. To Apply — You MUST Answer These Please answer directly and concisely: - If a CMS cannot emit RSS, what is the cleanest replacement for keeping a blog content library in sync long-term? - Have you worked with Apps Script + Zapier together before? Briefly explain what you built. - How would you ensure no duplicate content is generated week-over-week in a system like this? - What part of this workflow do you expect to be the most fragile, and how would you harden it? - What is your estimated fixed price and hourly range time for completing this project? Budget Fixed-price implementation upon completion and verification of a working product Nice to Have (Not Required) - SEO or content automation experience - Familiarity with long-form AI content pipelines - Experience designing systems that operate without CMS dependencies