Too many stories
Hundreds of weekly items had to be reviewed before a usable issue could take shape.
ClientHarbour Weekly
Harbour Weekly turned hundreds of news items into an AI-assisted newsletter draft
A publishing workflow that collects the week's Notion research, asks AI to shape it into a structured EDM, then stores the Google Docs draft back into the editorial record.
The pain point
The news was collected, but the weekly draft still took too much editorial time.
The team already kept AI and automation news in Notion. The bottleneck was turning more than a hundred raw items into a clear EDM with sections, links, analysis, and a ready-to-review draft.
Changing themes
Each issue needed a different editorial hierarchy, not a fixed newsletter template.
Drafts lived apart
The final Google Docs draft and the Notion record needed to stay connected for review.
The Flow2 solution
Flow2 built a weekly drafting engine from research database to editable issue.
The automation filters the past seven days of Notion items, compresses the material into a single editorial brief, asks Gemini to write a structured Traditional Chinese issue, then creates a Google Docs draft and stores the link back in Notion.
Seven-day source window
Only the current week's research enters the drafting run.
AI acts as editor
The prompt builds sections, focus topics, data angles, and practical takeaways.
Draft link returns to Notion
The issue is easy to review, approve, and find again later.
The workflow turns raw weekly research into an editable EDM draft.
The chart simplifies the Make.com blueprint into the editorial flow: filter the week, pack the sources, draft the issue, preserve references, and return the review record.
Hover or focus a node to see how the Harbour Weekly drafting workflow works.
The outcome
The team moved from manual compilation to a repeatable editorial system.
The final asset is not an auto-sent email. It is a high-quality first draft with the right sections, links, and review trail, so editors spend time judging the issue instead of assembling it.
Faster first draft
The weekly issue starts from AI-organised source material instead of a blank document.
Editorial control
Google Docs keeps the final review human, collaborative, and easy to approve.
Clean audit trail
Notion stores the generated draft link and body, so each issue remains searchable.