A month of blog and social content — from a single brief

From a company brief the scenario uses AI to build a strategy, write articles and posts, generate images, store them in Google Drive and Databricks, and publish to the blog, Medium and Facebook Graph API.

  • A full month's content plan from one brief
  • AI creates both the copy and the images
  • Publishing across every channel — automatically
  • Failures trigger an alert to your inbox
n8n Form
Set it up for yourselfScriptera

How it works

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

  1. Starts when: Company Data Form
  2. Then: Build Prompt
  3. Then: Generate Strategy
  4. Then: Parse Response
  5. Then: Format to Markdown
  6. Then: Export MD File
  7. Then: Save to Drive
  8. Then: Fetch GA Data
  9. Check: Merge Data Sources
  10. Then: Compress Brand Context
  11. Then: Build Content Plan Prompt
  12. Then: Generate Content Plan
  13. Then: Validate Content Plan
  14. Then: Build Batch Prompt
  15. Then: Write Batch Content
  16. Then: Parse Content Sections
  17. Check: Merge Content Output
  18. Then: Assembled Doc
  19. Then: Build DOCX
  20. Then: Upload to Drive
  21. Then: Send Notification Email
  22. Then: Log Errors
  23. Check: Any Errors?
  24. If yes: Send Error Alerts
  25. If no: Pipeline Success
  26. Then: Build Guides Prompt
  27. Then: Write Guides
  28. Then: Extract Guides
  29. Then: Fetch Trending Topics
  30. Then: Search Drive for DOCX
  31. Check: Has DOCX Files?
  32. If yes: Download DOCX
  33. Then: Prepare DOCX Archive
  34. Then: Unzip DOCX
  35. Then: Extract XML Text
  36. Then: Process Blog Articles
  37. Check: Loop Over Blogs
  38. Then: Generate Blog Image
  39. Then: Upload to WP Media
  40. Then: Publish Blog Post
  41. Then: Wait After Blog Publish
  42. Then: Process LinkedIn Posts
  43. Check: Loop Over LinkedIn Posts
  44. Then: Generate LinkedIn Image
  45. Then: Post to LinkedIn
  46. Then: Wait After LinkedIn Post Publish
  47. Then: Process Social Posts
  48. Check: Loop Over Social Posts
  49. Then: Generate Social Image
  50. Then: Save Image into S3 Bucket
  51. Then: Create Instagram Container
  52. Then: Publish to Instagram
  53. Then: Wait After Social Posts Publish
  54. Then: Post to Facebook
  55. If no: Error Notification
  56. Then: Config: Pipeline B
  57. Then: Fetch Brand Context
  58. Then: Convert Context Binary to Text
  59. Then: Config: Pipeline C
  60. Then: Get LinkedIn User Info
  61. Starts when: Trigger: Pipeline B
  62. Starts when: Trigger: Pipeline C

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

Similar scenarios