Pull fresh articles from multiple sites into one feed

Checks a list of websites for new articles, pulls the details, and builds one clean, up-to-date feed.

How the work actually flows

A straight line. Runs once per one per source website.

Pattern: Sequence (1) ยท Multiple Instances with a priori Design-Time Knowledge (13)

flowchart TD trig(["scheduled or manual run"]):::trigtime s0[("read source site list")]:::store s1[["pull each site's articles"]]:::mi s2["filter out stale articles"]:::task s3[("save fresh articles to feed")]:::store trig --> s0 s0 -->|"one per one per source website"| s1 s1 --> s2 s2 --> s3 out[/"fresh curated article feed"/]:::out pay{{"no manual site checking needed"}}:::pay s3 --> out out --> pay classDef task fill:#e7f6fe,stroke:#34b8f0,color:#2c2a29 classDef svc fill:#f6f8fa,stroke:#7c8795,color:#2c2a29 classDef mi fill:#e7f6fe,stroke:#0079a8,color:#2c2a29,stroke-width:2px classDef human fill:#fff,stroke:#0079a8,color:#0079a8 classDef store fill:#f6f8fa,stroke:#0079a8,color:#2c2a29 classDef trig fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigtime fill:#00a4eb,stroke:#0079a8,color:#fff,font-weight:bold classDef trigdata fill:#8ad4f5,stroke:#0079a8,color:#06314c,font-weight:bold classDef gate fill:#fff,stroke:#e8a23d,color:#6b4708,font-weight:bold classDef out fill:#1f9d6b,stroke:#167a53,color:#fff,font-weight:bold classDef pay fill:#06314c,stroke:#021f33,color:#fff
Starts itA stepRuns once per itemA record or sheetResultPayoff
Build size
Advanced

A larger build with multiple systems, AI reasoning, and custom rules.

Business functions
Spreadsheet & Database OpsWeb Scraping & Data Collection
Connects
Google Sheets

The problem it solves

You're checking the same handful of publisher sites every day to see if there's anything new, then copying the title, author, and date into a spreadsheet by hand. Older stories that are no longer relevant clutter the list unless you remember to clean it out.

Who it fits

Content curators, media monitoring teams, or research teams tracking multiple sources.

How it works

  1. The automation runs on a schedule or is started manually
  2. The list of source websites is read from Google Sheets
  3. Each site's article title, author, date, and image are pulled in
  4. Articles older than the freshness window are filtered out and the rest saved to the feed
What you get

Fresh articles gathered in one place daily

New articles from all your tracked sites land in one clean, up-to-date feed automatically.

What you get

An organized, deduplicated feed of recent articles with full metadata, tracked in a spreadsheet.

What you need

A Google Sheets account.

We can build this. But should you?

The hard question is not how to build it. It is whether this is the right thing to build first.

That is what a Fractional Chief AI Officer figures out with you, before anyone writes a line of code.

Let's Talk Strategy

Related automations

Find matching job listings and draft AI cover letters daily

Searches for jobs matching your skills each morning and writes a tailored cover letter for each one.

Advanced

Automatically pull LinkedIn company posts into a Google Sheet

Scrapes public LinkedIn company posts and saves the content, timestamps, and engagement stats into a spreadsheet automatically.

Standard

Send a daily email digest of your top-performing YouTube videos

Tracks your YouTube channels, spots videos performing above average, and emails you a daily digest of the best ones.

Advanced

Turn Reddit questions into content ideas in a Google Sheet

Scans chosen subreddits for real questions people are asking and turns them into ready-to-use content ideas in a spreadsheet.

Advanced
Back to the AI Playbook