Auto-built newsletter digest from your sites

The scenario visits the sites on your list, summarizes the fresh articles and builds a ready digest email, then sends it to your subscribers.

  • A digest from your sites, on its own
  • Fresh articles as short summaries
  • A ready, formatted email
  • You keep the site list in a sheet
Set it up for meScriptera

How it works

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

  1. Starts when: Start Workflow Manually
  2. Then: Get Website URLs from Google Sheet
  3. Then: Crawl and Extract Site Content with Dumpling AI
  4. Then: Split Extracted Results into Individual Items
  5. Then: Map Title, URL, and Page Text
  6. Then: Combine Articles into Single Prompt Format
  7. Then: Generate HTML Newsletter with Subject Using GPT-4o
  8. Then: Send Newsletter via Gmail

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

Similar scenarios