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.

Why I stopped using complex databases for AI websites video thumbnail by Ali Amin
On this page
  1. Watch the video
  2. The problem with "proper" databases
  3. When Google Sheets is the right choice
  4. What it looks like
  5. How to set it up
  6. When to use something else
  7. Follow along

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

▶ 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 .env file.
  • 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

Keep building.

Ali Amin

The community

Learn it with me, not alone.

AI Engineer Academy on Skool is where the courses, live calls and other builders are. Learn at your own pace, with people who are building too.