Articles from a spreadsheet plan — image and publishing included

Every morning the scenario takes the next topics from your spreadsheet, writes the articles, picks cover images, publishes them as drafts and reports by email.

  • The plan lives in an ordinary spreadsheet
  • The cover image fits the article instead of being random
  • Failures show up in the spreadsheet instead of vanishing
  • A closing email: what shipped, what broke
Google Sheets
Set this upScriptera

How it works

To move data from enkod to Medium automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Every Day at 8am
  2. Then: Get All Info Required from Sheets
  3. Check: Check Rows Found
  4. If yes: Loop for Each Row
  5. Then: Send Completion Email
  6. Then: Set Complete
  7. Then: Log Complete
  8. Then: Current Row Context
  9. Then: SEO Blog AI Agent
  10. Then: Fetch Images from Pexels
  11. Then: Image AI Agent
  12. Then: Pack Image Data
  13. Then: Update Image Details
  14. Then: Download Image
  15. Check: Map to WordPress Site
  16. If yes: Media Upload (website1)
  17. Then: Update Media Alt Text (website1)
  18. Then: Create Draft Post (website1)
  19. Then: Prepare Data (website1)
  20. Then: Set Featured Image (website1)
  21. Then: Gather All Data for Update
  22. Then: Update wp_url and status
  23. Then: Wait 5 Seconds Between Iterations
  24. Then: Set HTTP Error
  25. Then: Log HTTP Error
  26. If no: Media Upload (website2)
  27. Then: Update Media Alt Text (website2)
  28. Then: Create Draft Post (website2)
  29. Then: Prepare Data (website2)
  30. Then: Set Featured Image (website2)
  31. If no: Set Error
  32. Then: Log Error
  33. If no: Nothing to Process
  34. Then: Log Empty Run
  35. Then: Blog JSON Output Parser
  36. Then: Image JSON Output Parser
  37. Then: Fallback Image Model
  38. Then: Image Model
  39. Then: Fallback Blog Model
  40. Then: Blog Model
  41. Then: Template - Media Upload
  42. Then: Template - Update Media Alt Text
  43. Then: Template - Create Draft Post
  44. Then: Template - Prepare Data
  45. Then: Template - Set Featured Image

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

Similar scenarios