I Turned This Spreadsheet Into a $30K/Month Micro-SaaS

By Starter Story

Share:

Key Concepts

  • Spreadsheet-to-SaaS: The methodology of identifying repetitive, manual data-processing tasks performed in spreadsheets and converting them into automated software applications.
  • AI-Assisted Development: Using AI coding tools (like Cursor and Claude Code) to build functional software without traditional programming expertise.
  • Profit Analytics: A niche within e-commerce SaaS focused on providing real-time visibility into profit margins, ad spend efficiency, and cost-of-goods-sold (COGS).
  • Micro-SaaS: Small, focused software products that solve specific problems for a niche audience, often managed by a single founder or a very small team.
  • Cloud Wrapper: A software architecture that leverages existing cloud services and APIs to provide a simplified user interface for complex data tasks.

1. Business Overview: Profit AI

Profit AI is a Shopify application designed to provide store owners with instant profit analytics. It aggregates data from various marketing channels to show spend, attributed sales, and net profit after all associated costs.

  • Performance: Launched in December, the app reached $30,000 Monthly Recurring Revenue (MRR) by May, with an additional $10,000 MRR from related services.
  • Total Revenue: $147,000 since launch.
  • User Base: 122 total users, with approximately 38–39 paying customers.
  • Pricing Model: A "Freemium" model where users get a 30-day trial of the paid plan upon signing up. The paid tier is priced at $800/month (reduced from an initial $5,000/month).

2. Methodology: The "Spreadsheet-to-App" Framework

Jack’s success stems from his background as a consultant who built complex spreadsheets for e-commerce agencies.

  • Step 1: Identify the Pain Point: Recognize repetitive, manual tasks performed in spreadsheets (e.g., calculating P&L, analyzing ROAS, or scenario planning).
  • Step 2: Simplify Complexity: Take complex, "Deloitte-style" financial models and distill them into accessible, user-friendly interfaces.
  • Step 3: AI-Driven Development: Instead of hiring developers, Jack used AI coding tools to translate his spreadsheet logic into a functional app.
    • Process: Exporting spreadsheet logic as a CSV, uploading it to an AI coding environment (Cursor), and iteratively refining the code through prompts.
  • Step 4: Integration: Using AI to create "connectors" that pull data from Shopify and ad platforms directly into the app, allowing for automated reporting.

3. Tech Stack and Tools

Jack emphasizes that modern AI tools have lowered the barrier to entry for non-technical founders:

  • Development: Claude Code (for building and feature updates) and Cursor (initial development).
  • Website/Frontend: Framer (with potential plans to migrate to a Claude-generated site).
  • Data Management: Google Sheets (as the backend logic source).
  • Communication: A Slack bot integration that allows users to interact with their data and generate reports via natural language prompts.

4. Key Arguments and Perspectives

  • The "Boring" Advantage: Jack argues that the best SaaS ideas come from work you are already doing. By solving problems for clients in a service capacity, you gain deep insight into what they are willing to pay for.
  • Avoid "Aiming for Laziness": Jack warns against the misconception that SaaS is a "get rich quick" scheme for doing nothing. He emphasizes that the market moves fast and requires constant iteration and active management.
  • E-commerce Tooling as a High-Growth Niche: Both the host and the guest highlight that e-commerce infrastructure (reporting, analytics, and automation) is an underrated space compared to generic "AI wrappers."

5. Notable Quotes

  • "Good decision-making comes from information." — Jack, explaining the philosophy behind his analytics app.
  • "Don't aim for laziness. If your goal is 'I want to make lots of money while doing nothing,' you're going to get quickly replaced." — Jack, on the reality of building a sustainable SaaS business.
  • "Just ask Claude if it can do the thing... I'm so surprised by things as long as it has connections to everything, how much it can do from just one prompt." — Jack, on the power of AI-assisted development.

6. Synthesis and Conclusion

The transition from service-based work (trading hours for dollars) to product-based revenue (SaaS) is more accessible than ever due to AI coding assistants. The core takeaway is to leverage existing workflows: if you have a spreadsheet that solves a complex problem for a client, that is a validated business idea. By using tools like Claude Code to automate these manual processes, solopreneurs can build high-value, revenue-generating software in a matter of months rather than years. The current market opportunity lies in "boring" but essential e-commerce infrastructure that provides clear, actionable data to business owners.

Chat with this Video

AI-Powered

Load the transcript when you're ready to chat so the initial page stays lighter.

Ready to summarize another video?

Summarize YouTube Video