From RSS to a digest: sheets, filters and a model in the middle

Collect items from several feeds into a sheet, de-duplicate them, and let a model rank and summarize what is worth your time. The backbone of the news digest project.

RSS is still the most reliable way to get a stream of new items from many sources without scraping anyone. This lesson turns a handful of feeds into one short digest, with a spreadsheet as the memory in between.

Why a sheet in the middle

A model step is stateless: it sees what you give it and forgets. A sheet gives the workflow three things it needs:

  • De-duplication. The same story appears in three feeds. A sheet keyed by URL lets you keep one.
  • History. You can see what was collected last week, and what the model said about it.
  • A manual override. Mark a row "skip" or "always include" and the next run respects it.
Members read the full version

The step-by-step section, the resources and the troubleshooting notes are part of membership.

Done with this one? Mark it to track your path.Sign in
Save it for laterSign in
Questions about this piece?Ask AI about this

Comments (0)

No comments yet. Start the conversation.

Sign in to join the discussion.Sign in