CONTENT CREATION

Weekly podcast digest newsletter from recent episodes

On a weekly schedule, gathers the week's published episodes from Notion, has OpenAI write a newsletter digest with per-episode blurbs and pull-quotes.

CategoryContent Creation
Enginesim
Difficultybeginner
Triggerschedule
Steps5
Setup~5 min

How it runs

The automated pipeline, trigger to output.

  • TriggerWeekly schedule (Friday morning)
  • ActionQuery Notion for episodes published this weekNotionNotion
  • LogicStop if no episodes were published
  • ActionCompose newsletter digest with OpenAIOpenAI
  • OutputEmail draft to editor via GmailGmailGmail

What it does

Assembles a weekly listener newsletter from whatever episodes shipped that week. It pulls each episode's notes, writes a cohesive digest with blurbs and standout quotes, and emails a ready-to-send draft.

When to use it

Use it for shows that publish a recurring email rounding up recent episodes. It saves the editor from re-reading every episode's notes and rewriting them into newsletter voice each week.

How it works

  1. 1A weekly schedule trigger fires every Friday morning.
  2. 2The workflow queries Notion for episodes published in the last seven days, pulling their summaries and pull-quotes.
  3. 3A logic step ends the run quietly if no episodes were published, avoiding an empty newsletter.
  4. 4OpenAI composes the digest — an intro, a blurb and quote per episode, and a closing call to action — in the newsletter's established voice.
  5. 5The draft is emailed via Gmail to the editor for a final pass before it goes to the list.

Set it up

What you configure once, before turning it on.

  1. 1
    Connect NotionPages, databases, comments.
  2. 2
    Connect OpenAIModels, embeddings, files.
  3. 3
    Connect GmailRead, draft, send, label.
  4. 4
    Set each agent's modelWe leave models unset so you pick the tier — fast + cheap, or top-quality.
  5. 5
    Tune it to your dataEdit the prompts, filters, and field mappings so it matches how your team works.
  6. 6
    Test, then turn it onRun once against a sample, confirm the output, then enable the trigger.

Run this workflow in your colony.

14-day trial. No DevOps. No Sales call. Provisioned in under a minute.