Why I stopped using complex databases: Google Sheets as a database for client websites
Most small business sites don't need Supabase or Firebase. Here's how I connect Google Sheets as a database, so clients can manage their own data.
On this page
Most small business websites don't need Supabase or Firebase. They need a database the client can actually understand. That's why I now use Google Sheets as a database for many client projects, and in this post I'll show you exactly how to connect one to your website.
Watch the video

▶ Watch "Why I Stopped Using Complex Databases for AI Websites like Supabase?" on YouTube
The problem with "proper" databases
Supabase and Firebase are powerful, but they come with technical work most small projects don't need. On Supabase's free plan, projects get paused after a week of inactivity. Firebase doesn't pause, but it's still technical to set up and manage.
When people ask me for a CMS video, the CMS isn't really the problem. Any AI model can build a good admin dashboard now. The hard part is the database behind it.
When Google Sheets is the right choice
This is for small to medium businesses: a site getting 10, 20 or 50 orders a day, not thousands. That's most of the clients you'll work with.
The big advantage is that everyone knows how to use Google Sheets. I recently sold an automation to a client that runs on Google Sheets. When I told them anyone on their team could fix a data issue themselves, they were relieved. Nobody needs to be technical to edit a row. Behind the scenes, I use n8n with two sheets: one for the live data, and one as a backup.
What it looks like
On a demo ecommerce site, I changed a product's price in the admin dashboard from $1,200 to $420 and clicked save. The Google Sheet updated instantly. Then I changed the price in the sheet to $3,000, refreshed the dashboard, and the new price was there. Real time, both ways.
How to set it up
1. Build your site and CMS first. At this point, everything can still be dummy data.
2. Tell your AI how to connect it. Give it these three rules:
- Connect the application to Google Sheets using a Google service account.
- Store all credentials only in the
.envfile. - Never expose or hardcode credentials. If a key is hardcoded, anyone can inspect your site, find it and burn through your usage.
3. Create a Google Cloud project at console.cloud.google.com.
4. Enable the Google Sheets API. Go to APIs & Services → Library, search for Google Sheets and click Enable.
5. Create the service account. Under Credentials → Create credentials → Service account, give it a name and click Create and close. This is your "bot": it edits the sheet on your website's behalf. Copy its email into your .env file.
6. Create a key. Open the service account, go to Keys → Add key → Create new key, and download the file. Copy the private key, from the BEGIN line to the END line, into your .env file.
7. Create your Google Sheet and copy its ID from the URL into your .env file.
8. Share the sheet with the service account email as an Editor.
9. Let AI make it functional. Tell your AI the credentials are in place, and ask it to make everything work with the sheet as the database. Mine created tabs for products, product images, orders and customers on its own. I used Codex here, but any model works.
That's all the technical work: the bot's email and its private key. The AI handles everything else.
When to use something else
Google Sheets isn't for every project. If you need user accounts and logins, or you're handling thousands of orders a day, use a real database like Supabase. That's why my LMS website runs on Supabase, while my pharmacy ERP and AI automated website run on Google Sheets.
Using Google Sheets as a database is about picking the simplest tool that does the job, and one your client can manage without calling you.
If you want to learn how to build and sell systems like this, my community takes you from beginner to pro: AI Engineer Academy. Here's what's inside.
Follow along
- YouTube: @AgenticAli
- LinkedIn: Ali Amin
- X: @AgenticAli
- Instagram: @agenticali
- Skool: AI Engineer Academy
Keep building.
Ali Amin