All ideasMore in Work
Work

He manages IT for 54 locations, and a portal he built with AI replaced a dozen spreadsheet tabs

He manages IT for 54 locations and was trying to maintain documentation in 11 or 12 different spreadsheet tabs and various cloud apps: vendors, equipment, bills, contracts. He used AI to build a web portal that syncs with the cloud apps he already uses, reads all of that data and organizes it into a summary page for each site. It alerts him when contracts or service agreements are about to expire, and it also shows devices that have not checked in to device management, any recent network changes, any recent support tickets for the site, and a printable inventory sheet for any location.

How it works

  1. Build a web portal with AI
  2. Sync it with his existing cloud apps
  3. Generate a summary page for each of the 54 sites
  4. Get alerts before contracts and service agreements expire

Why it’s worth knowing

The spreadsheet pile did not get cleaned up. It got replaced by a portal that reads it all for him.

Where it’s from

Summarized from a public post on reddit.com. See the original ↗

Upgraded prompt

A ready-to-use prompt for this idea, built from research on what makes AI agents do the job right: who the AI should be, the exact steps, and a check to make sure it was done the way you wanted.

1Who the AI should be
2The prompt, with the steps
3The check when it’s done
Upgraded prompts are coming soon.

Try next

WorkA bookkeeping file sorter over 40 companies logs every move with a hashWorkForemen file the daily log with a three-minute phone call, and the agent chases anyone who forgets30 min savedWorkThe AI audited my eBay store, found 28 listings going nowhere, and sold a bundle for meWorkA contractor talks measurements into his phone and QuickBooks sends the estimate in 45 seconds

Every idea is a real post from someone who tried it, summarized in our words, with a link to the original. App names are swapped for plain words.