I Used AI + Google Sheets as My Side Project's Backend for 3 Months. Here's What Held Up.
No budget for a real dashboard tool, no time to build one properly, and a side project that needed to track signups, revenue, and a few funnel metrics. So I did what a lot of indie hackers quietly do: built the whole thing in Google Sheets. The difference this time is AI made it good enough to actually rely on.
The problem with the old way
Manually pulling numbers from Stripe, my signup form, and an analytics tool into a spreadsheet every week was exactly the kind of repetitive task that eats indie hacker time without moving the product forward. I needed the data connected, not re-copied every Monday.
What I actually built
Live data connections instead of manual exports. Instead of copy-pasting from each tool weekly, I connected my key data sources directly into the sheet on an automatic schedule — closer to a lightweight Zapier-style automation than a manual habit. This alone killed the weekly "update the numbers" chore.
Native AI functions for the boring analysis. Plain-language prompts to generate summaries, categorize signup sources, and build quick charts from raw data — directly in Sheets, no separate BI tool required. For a one-person project, standing up a real analytics stack never made sense. This got me 80% of the value for near-zero setup cost.
AI-generated formulas instead of me writing them badly. I'm not a spreadsheet power user. Describing what I wanted in plain language and getting a working formula back saved real time I'd otherwise lose to trial-and-error nested functions.
Bulk categorization for messy signup data. Signup source data was inconsistent — different capitalization, extra whitespace, inconsistent naming from different forms. Bulk AI text processing cleaned an entire column in one pass instead of a manual find-and-replace marathon.
Where I drew the line
I didn't try to build anything AI couldn't reliably verify — no AI-generated numbers going straight into anything financial without a manual check first. Fast and cheap is good. Fast, cheap, and wrong is worse than the manual process it replaced.
Was it worth it
For a pre-revenue-to-early-revenue side project, yes, clearly. The alternative was either paying for a proper analytics/BI tool I didn't need yet, or continuing to burn an hour every Monday on manual data pulls. This got most of the value of the first option without the cost, and completely removed the second problem.
Full breakdown
Wrote up the specific tools I used and what each is actually good for here: AI for Google Sheets: The 2026 Guide. Also have a step-by-step version on my blog if you want the more detailed walkthrough: AI for Google Sheets in 2026 — What's Actually Worth Using.
Takeaway
You don't need a real BI stack for a side project doing a few hundred rows of data a month. AI-in-Sheets covers that range surprisingly well, and it's a lot easier to migrate off a spreadsheet later than to justify a BI subscription now.
Anyone else running their whole side-project dashboard out of Sheets? What's your setup look like?
