All ideasMore in Work
Work

A whiskey firm's Shopify reporting runs itself after four weeks of watched runs

Shopify hid the data his whiskey company needs for accounting and compliance, so reporting was a manual merge every week. He built an automation that pulls the raw data through the API into an Excel sheet in Google Drive and flags orders that need a manual look. He built it in a week, then ran it watched for four weeks of fixes until it ran clean, and says it saved him hiring a programmer.

How it works

  1. API pull built with AI
  2. Raw data lands in an Excel sheet in Google Drive
  3. Orders needing review get flagged
  4. Four weeks of watched runs and fixes
  5. Weekly run now clean

Why it’s worth knowing

He is honest about the unglamorous part: a week to build and four weeks of watched runs before he trusted it.

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

WorkFind me 48 school-district customers and draft each pitch — one replied, booked and paidWorkAn agent now makes the promo posts for our 70 radio shows a monthWorkA contractor talks measurements into his phone and QuickBooks sends the estimate in 45 secondsWorkA text and voice agent worked a realtor's 60,000 old leads and turned up 34 closed deals

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.