← GTM case studies/Content Automation

AI Agent That Repurposes Web Sources into a Weekly Newsletter

An n8n pipeline pulls news from Google SERP, Bing, Perplexity, RSS feeds, and newsletters, scores it for relevance, filters out the noise, and turns the best of it into emails, LinkedIn posts, and other formats automatically.

AI Agent That Repurposes Web Sources into a Weekly Newsletter
Before
  • ×Someone read a dozen sources a day
  • ×Highlights written up by hand
  • ×It stopped happening whenever things got busy
After
  • ✓News pulled from SERP, Bing, Perplexity, newsletters, news APIs and RSS
  • ✓Every item scored for relevance, low-quality news filtered out
  • ✓Emails, stories and LinkedIn posts generated from the best items
  • ✓Sent through Kit or Brevo on schedule

Stack

n8nOpenAI APIAirtableMongoDBPineconeKitBrevo

How It Works

1

Pull from multiple sources

News is fetched from Google SERP, Bing, Perplexity, newsletters, News APIs, and RSS feeds in one pass.

2

Score and filter

Each item gets a relevance score, and low-quality news is filtered out before it reaches a draft.

3

Generate multiple formats

The same source material becomes an email, a story, or a LinkedIn post depending on the target channel.

4

Send it out

The finished newsletter goes out automatically through Kit or Brevo on schedule.

Results

Multi-source

SERP, RSS, newsletters, News API

Scored

for relevance before publishing

Multi-format

email, LinkedIn, stories

The Workflows

Source collection

  • ✓Newsletters, RSS feeds, Google SERP and Reddit in one pipeline
  • ✓An AI agent extracts the stories worth keeping from each source
Newsletters in, raw content out: an AI agent extracts the stories worth keeping.
Newsletters in, raw content out: an AI agent extracts the stories worth keeping.
RSS feeds processed the same way.
RSS feeds processed the same way.
Google SERP and Reddit searched for fresh material on the topic.
Google SERP and Reddit searched for fresh material on the topic.

Scoring with a RAG news agent

  • ✓Every item scored for relevance before it reaches a draft
  • ✓Low-quality and duplicate news filtered out
A RAG news agent that scores and summarizes the collected items.
A RAG news agent that scores and summarizes the collected items.

Generation and delivery

  • ✓The weekly newsletter written from the top-scored items
  • ✓Sent through Brevo on schedule, with no one assembling it by hand
Generating the weekly newsletter from the scored items.
Generating the weekly newsletter from the scored items.
The master workflow that runs the pipeline on schedule and sends through Brevo.
The master workflow that runs the pipeline on schedule and sends through Brevo.

FAQ

Which sources can it read?+

Newsletters, RSS feeds, Google SERP, Bing, Perplexity, Reddit and news APIs.

How is quality controlled?+

Every item is scored for relevance, and low-quality or duplicate items are filtered out before the newsletter is written.

How is it sent?+

Through Brevo or Kit on a schedule.