Gather school financials into a spreadsheet

A writer used Operator to pull public financial figures for independent schools into a sheet before sending the data to o1 for analysis.

Done with Operator· Intermediate

What they did
The writer started with a Google Sheet containing 100 school names, which had been assembled from an earlier query. Operator then opened each school’s listing in ProPublica’s Nonprofit Explorer, copied the summary financial information, and filled the spreadsheet row by row. The writer let it run in the background, then moved the partially collected sheet into o1, which generated code for an interactive chart dashboard.
How it went
Operator moved slowly and was stopped after roughly 25 schools. It also rounded some values differently as it went and occasionally chose the wrong organization when names overlapped. The dashboard from o1 was usable but basic, needed label cleanup, and was not shared.
Tips
For work like this, verify each row before analysis, especially when organization names are similar. It also helps to pause after a small batch so you can catch rounding issues early.

Try it yourself with Operator

I have a spreadsheet with [number] [type of organizations] in [region]. For each row, find the public financial summary in [source/database], add the figures to the sheet, and include a link to the source. Work on the first [batch size] rows only, then stop and wait for my approval before continuing. If a name could match more than one organization, flag it instead of guessing. Do not send, submit, or finalize anything without asking me first.

Fill in the [brackets]. Agents can make mistakes, so review anything before it is sent, paid or deleted.

Read the original on fullstackeducator.substack.com ↗

Get 3 agent uses like this every morning

With the day's top AI news. Free, and one click to unsubscribe.