Collate WHO data into a multi-tab spreadsheet
Testers had ChatGPT Agent navigate the WHO site, extract the latest data and organise it by indicator, country and trend; it often fails on logins or dynamic pages.
Done withChatGPT Agent
- What they did
- In ChatGPT Agent mode, the testers gave a single prompt asking it to retrieve the most recent publicly available World Health Organisation data. The agent navigated the WHO site by itself, pulled out the relevant figures and arranged them into a multi-tab spreadsheet. The tabs were sorted by indicators, countries and trends. The source doesn't describe any human steps beyond the prompt.
- How it went
- The source says the agent produced a clean multi-tab spreadsheet. It gives no figures on accuracy or time. It also warns that agent outputs often need reformatting or correction.
- Worth knowing
- Agents often fail on sites with logins, unsupported browser states or dynamic single-page apps, so check the output and be ready to fix or reformat it.
Try it yourself with ChatGPT Agent
Go to [data source website, e.g. WHO data portal] and pull the latest figures on [indicator] for [list of countries]. Build a spreadsheet with tabs organized by indicator, country and trend over time, with source links and the date of each data point. Finish when it's complete, and list any pages you couldn't access because of logins or dynamic content.
Source: timeundertension.substack.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
Plan a family trip and pre-fill bookings
A reporter had ChatGPT Agent plan a 4-day San Diego trip: it searched flights, compared hotels, built an itinerary and pre-filled booking forms, stopping before purchase.
Plan Saturday errands and book haircuts
ChatGPT Agent planned errands, found salons with online booking and worked on booking kids' haircuts, with some steps needing human confirmation.
Build a benchmark image collage in Canva
The author had ChatGPT Agent log into Canva and build a collage of benchmark results; after over 75 minutes the result was poor as it fumbled the interface and drew shapes in Python.
Find connections across 100 non-fiction books
Claude Code browses a personal library with CLI tools and surfaces trails of related excerpts across books.
Turn YouTube videos into cited research notes
The author uses Claude Code with NotebookLM and Obsidian to turn 20 videos into cited notes, audio overviews, a knowledge graph and flashcards.
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.