A social content pipeline with a quality gate

The scenario gathers topics, an AI drafts them into a queue, and on publish days it picks the best, checks it and publishes, reporting to your messenger.

  • Topics are gathered and de-duplicated
  • An AI writes drafts into a queue
  • The best post passes a quality check
  • Publish status lands in your messenger
Google SheetsLinkedIn
Set it up for yourselfScriptera

How it works

To connect okoCrm and Google Sheets, you don't need a developer: a ready-made scenario links them in minutes.

  1. Starts when: ⏰ Daily 6 AM — Research
  2. Then: 🟠 Fetch Hacker News
  3. Then: 🔧 Normalize HN
  4. Check: ⏳ Wait for ALL Sources
  5. Then: 📦 Collect All Items
  6. Then: 🧹 Deduplicate + Rank
  7. Check: 📊 Has Items?
  8. If yes: 🤖 AI LinkedIn Writer
  9. Then: 📝 Extract Posts
  10. Then: 📋 Save to Queue
  11. If no: 💤 No Items
  12. Then: 🔴 Fetch Reddit
  13. Then: 🔧 Normalize Reddit
  14. Then: 🟣 Fetch Product Hunt
  15. Then: 🔧 Normalize PH
  16. Starts when: ⏰ Tue-Thu 9:30 AM — Publish
  17. Then: 📋 Read ALL Drafts
  18. Then: 📦 Collect All Drafts
  19. Check: 📄 Has Drafts?
  20. If yes: 🧠 AI Post Selector
  21. Then: 🎯 Extract Selection
  22. Then: 🛡️ AI Quality Gate
  23. Then: 🎯 Extract Review
  24. Check: 🔀 Review Decision
  25. If yes: 📤 Publish to LinkedIn
  26. Then: 💬 Hashtags Comment
  27. Then: ✅ Mark Published
  28. Then: 📲 Published ✅
  29. If no: 💾 Save Revised
  30. If no: ❌ Mark Rejected
  31. Then: 📲 Rejected ❌
  32. If no: 💤 No Drafts
  33. Then: Ollama Writer
  34. Then: Ollama Selector
  35. Then: Ollama Reviewer

You can launch this okoCrm + Google Sheets integration in Scriptera: describe the task in plain words — the scenario is built, launched and monitored for you.

Similar scenarios