A newsletter issue: topics, copy, layout and delivery to subscribers

You set the brand and the topic — the scenario picks the issue's themes, gathers fresh facts, writes the copy, lays out the email in your style and sends it to subscribers.

  • The issue's topics are chosen for you, not improvised at the last minute
  • The copy is grounded in fresh material, not generic filler
  • The email is laid out in your site's visual identity
  • A draft of every issue is saved in таблица — a copy and a history
Google Sheetsn8n FormTavily
Set it upScriptera

How it works

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

  1. Starts when: On form submission
  2. Then: HTTP Request
  3. Then: Generate Draft Topics (AI)
  4. Then: Split Topics
  5. Then: Tavily
  6. Then: Generate Newsletter Content (AI)
  7. Then: Merge Content Pieces
  8. Check: Merge
  9. Then: Aggregate
  10. Then: Get row(s) in sheet
  11. Check: Loop Over Items
  12. Then: Convert Newsletter to HTML (AI)
  13. Then: Save Newsletter Draft in Google Sheet
  14. Then: Sending Emails to all the Subscribers
  15. Then: HTTP Request2
  16. Then: AI Agent
  17. Then: HTTP Request6
  18. Then: Information Extractor1
  19. Then: Structured Output Parser
  20. Then: Structured Output Parser1
  21. Then: OpenAI Chat Model
  22. Then: OpenAI Chat Model1
  23. Then: OpenAI Chat Model2
  24. Then: Structured Output Parser2
  25. Then: OpenAI Chat Model4

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

Similar scenarios