Pull supplier email data into an inventory sheet
A built email scraping agent extracts relevant data from supplier emails and updates a Google Sheet in real time for a small e-commerce store.
Done with a custom-built or unnamed agent
- What they did
- The poster built a private script for a friend’s small e-commerce store that watched supplier emails, used OpenAI’s o3-mini plus o1-mini to extract and clean the inventory details, saved the output to CSV, and then uploaded it into Google Sheets. The store owner had been entering the data manually; the poster then sold the same setup to other businesses and handled ongoing maintenance.
- How it went
- They say it saved clients hours each week, improved stock management, and brought in more than $2,000 in revenue. Pricing in the thread was $200 to set up and $50 per month, with the poster saying scaling the service was the main problem.
- Worth knowing
- The clearest copyable detail is the business model: $200 upfront plus $50 monthly to keep it running and maintain it.
Try it yourself with n8n
Build a workflow that watches my inbox for emails from suppliers like [supplier names or label]. For each one, extract [SKU, quantity, price, ship date, order number] and add or update a row in my Google Sheet [sheet name]. It's finished when a test email produces a correct row; flag any email it can't parse for me to review instead of guessing.
Want help getting this working? Join the Vibe Coding Academy ↗ Run by Alex Finn, who also runs this site.
Source: Reddit · Undated
Related use cases
Run a solo company with eight agent departments
A founder set up CEO, CFO, COO, lawyer, accountant, marketing, CTO, and improver agents that share memory and consult each other.
Deliver scheduled article digests to Telegram with OpenClaw cron jobs
A developer fixed OpenClaw cron jobs that ran without delivering by turning thinking mode off, after which six articles reached Telegram in 30 seconds.
Screen candidates and summarize resumes with AI
Commenters describe AI used to summarize resumes, mass-screen candidates, skip boolean queries, and an agent that screens candidates anytime.
Custom agent
Generate and send invoice PDFs for approval
An AI skill prepares an invoice PDF for work or reimbursements and emails it to the user, then sends it once he replies yes or with corrections.
Custom agent
Check a domain's email records and fix missing DMARC
An agent ran a mail check on its own domain, found no DMARC record, and after one TXT record was added the score rose from 80 to 96.
Submitted by OpenKrill
Custom agent
Run a side hustle with three agents for content, email and books
A working parent uses three agents: one researches and drafts content, one handles client emails and books calls, one categorizes Etsy income and expenses and writes monthly summaries.
Submitted by from search gap: side hustle ceo
Custom agent
Get 5 like this every morning
The best things people got an AI agent to do, each with the prompt to try it.