Scrape weekly Substack rankings and write a report
Claude in Chrome runs weekly to scrape Substack ranking data into a dataset, and Cowork analyzes it and writes a weekly report.
Done withClaude in ChromeClaude Cowork
- What they did
- Frank Andrade prompts Claude in Chrome to scrape the first 250 rows of Reletter's Substack charts (rank, newsletter, date, free/paid) into a CSV, then converts that prompt into a task that runs every Tuesday. A Cowork task at 5:10 PM reads the saved folder and builds a spreadsheet of the biggest rank gains, losses and new entrants, for paid and free separately.
- How it went
- Each week the scrape takes a couple of minutes, and Cowork drops the analysis spreadsheet into his folder. The source gives no accuracy checks or other figures.
- Worth knowing
- Scheduled tasks only run while the computer is awake and the Claude desktop app is open, and each run draws on your daily usage allowance.
Try it yourself with Claude in Chrome
Go to [ranking page URL, such as a Substack leaderboard for my category] and scrape the top [50] entries with rank, name, and any visible stats into a spreadsheet, adding a column for today's date. Append to the existing file at [file location] if it exists. Stop when the data is saved and tell me how many rows were added, so I can run the same job weekly.
Source: artificialcorner.com · Undated
Five of these in your inbox every morning
The best things people got an AI agent to do, each with the prompt to try it.
More like this
Fill in a tax organizer and review last year's return
Claude in Chrome captured the organizer's fields and entered data, Claude Code filled them in, and Claude reviewed the prior return; it sometimes claimed work was done without the info.
Delegate calendar, inbox and travel booking to a personal work agent
Authors use Cowork or Claude Code to schedule invites, triage email, book flights and hotels, pull Airtable data and scrape exhibitor lists.
Test local web apps and fix errors in one session
Claude Code with Claude in Chrome writes code, opens localhost, clicks through the UI, reads console errors and fixes them without the developer touching the browser.
Find connections across 100 non-fiction books
Claude Code browses a personal library with CLI tools and surfaces trails of related excerpts across books.
Search years of research files in an Obsidian vault
Claude Code, guided by a CLAUDE.md, searches research papers, scans and PDFs via Spotlight, extracts text, and files daily notes in dated folders.
Use Cursor for academic paper writing with citations
Forum users write papers in markdown with Zotero citations and a bibtex file for Cursor to pick references from, converting to Word with pandoc.