Track weekly Substack rankings and turn them into a report
Frank Andrade uses Claude in Chrome to capture Substack chart data, then Claude Cowork summarizes the weekly rank changes.
- What they did
- Frank Andrade asked Claude in Chrome to pull the first 250 rows from Reletter’s Substack charts into a CSV with rank, newsletter, date, and free or paid status. He wrapped that into a Tuesday recurring task. A Claude Cowork job later scans the stored files and builds a spreadsheet showing the biggest climbs, drops, and new additions, with paid and free tracked separately.
- How it went
- The scraping step usually finishes in a few minutes, and Cowork places the analysis spreadsheet back in his folder. No accuracy checks or other performance figures are given.
- Tips
- These scheduled jobs depend on the Claude desktop app being open and the machine staying on. They also count against the daily usage limit, so keep the scrape focused and the output location consistent.
Try it yourself with Claude in Chrome
Visit [ranking page URL] and collect the top [number] rows into a spreadsheet. Include rank, newsletter name, collection date, and any visible fields for [free/paid or other stats]. If a file already exists at [file location], add the new rows to it; otherwise create it. Before you do anything that would overwrite, delete, send, or submit data, stop and ask for my approval. When the file is saved, tell me how many rows you added and where you stored it, so I can repeat this as a weekly job.
Fill in the [brackets]. Agents can make mistakes, so review anything before it is sent, paid or deleted.
Get 3 agent uses like this every morning
With the day's top AI news. Free, and one click to unsubscribe.
Related agent uses
Turn a stack of articles into a cited summary
Have an agent compare many articles, pull out shared themes, and draft a source-cited summary document.
Set up a daily Reddit and competitor scan
They use Cowork to gather relevant tech posts, market signals, and draft replies without checking everything by hand.
Collect meeting minutes into yearly text files
A developer used Claude in Chrome to copy three years of meeting minutes into text files for NotebookLM.
Have Claude browse your own feed for post ideas
A writer used Claude in Chrome to scan a logged-in X feed and surface a few possible blog angles from posts with strong engagement.
Inspect a broken book file and search it manually
When an indexer failed on an uploaded book, Claude used shell commands to identify the file type and search the text directly.
Create a multi-agent analysis pipeline in Claude Code
A data analyst had Claude Code assemble a five-part analysis system from a detailed specification.