SEO blog articles — written for you from a topic list

The scenario takes a topic from Supabase, several AI helpers assemble an article with headings and links tuned for search, and the finished text is saved to Google Cloud Firestore.

  • A ready SEO article from a single topic
  • With headings, links and search-friendly structure
  • Texts in Google Cloud Firestore, files in Google Drive
  • Topics and statuses tracked in Supabase
WebhookHTTP Request Tool
Set it upScriptera

How it works

To move data from Supabase to Google Drive automatically, use a ready-made scenario — no manual exports.

  1. Starts when: Webhook
  2. Then: Set Airtable Fields
  3. Then: Airtable Get Article Data
  4. Then: HTTP Request
  5. Then: XML
  6. Then: Split Out
  7. Then: HTTP Request1
  8. Then: XML1
  9. Then: Aggregate
  10. Then: Set list URLs
  11. Then: Set Airtable Fields for Agent
  12. Then: URLs Selection
  13. Then: Set best urls
  14. Then: Set Airtable Fields for Agents
  15. Then: SERPs, Writing, KWs, Insights
  16. Then: Code in JavaScript
  17. Then: Set KWs and Insights fields
  18. Then: Update Article Writer table
  19. Then: Refine the Title
  20. Then: Sets New Title Field
  21. Then: Update Article Title
  22. Then: Key Takeaways AI Agent
  23. Then: Set Key Takeaways
  24. Then: Introduction Agent
  25. Then: Set Introduction Field
  26. Then: Outline Agent
  27. Then: Set Outline Fields
  28. Then: Main Body Prompt Writer
  29. Then: Content Writer Agent
  30. Then: Edit Fields1
  31. Then: AI Agent Conclusion Writer
  32. Then: Set Conclusion
  33. Then: Final Article
  34. Then: Create Article Folder
  35. Then: Create Doc Filename is title
  36. Then: Add Final Article
  37. Then: OpenAI Meta
  38. Then: Add Meta Description
  39. Then: Google Drive
  40. Then: Edit Fields
  41. Then: Airtable
  42. Then: Tavily search results
  43. Then: Anthropic Chat Model
  44. Then: OpenAI Chat Model
  45. Then: OpenAI Chat Model2
  46. Then: OpenAI Chat Model3
  47. Then: Open AI
  48. Then: OpenAI Key Takeaways
  49. Then: OpenAI
  50. Then: OpenAI Chat Model1
  51. Then: OpenAI Chat Model5
  52. Then: Update Article Writer table1
  53. Then: OpenAI Image Prompt1
  54. Then: Add Image Prompt1
  55. Then: Set KWs and Insights fields1
  56. Then: Article Assembly Agent1
  57. Then: Final Edit Agent1
  58. Then: OpenAI Chat Model6
  59. Then: Final Article1
  60. Then: Open AI1

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

Similar scenarios