How I Built a Free POS System Using Claude AI, Blogger, Google Apps Script, and Google Sheets

Table of Contents

A few days ago, one of my colleagues told me that Claude AI (claude.ai) was better at coding than other AI services.

To be honest, I had mostly been using ChatGPT. Based on my personal experience, I find ChatGPT particularly helpful when it comes to explaining things, solving problems, discussing ideas, and designing application systems.

But his comment made me curious.

So, I decided to give Claude AI a try.

For this experiment, I used the free version of Claude AI. I wanted to see how far I could go in building an application with the help of AI, even though I am not particularly skilled at programming.

My idea was simple: build a free point-of-sale (POS) application using Blogger, Google Apps Script, and Google Sheets.

I chose these three Google-based services because they allowed me to build a simple web application without paying for additional hosting, a server, or a database subscription.

The only things I needed were an internet connection, some time, and a willingness to learn.

After several discussions, coding sessions, and testing, I finally managed to build a simple POS application. I named it Kasir Ndeso.

Here is how I did it.

1. Starting with an Idea and Discussing It with Claude AI

I am not an experienced programmer. My coding knowledge is still quite limited.

However, I enjoy exploring ideas and building systems that can help solve everyday problems.

When I have an idea for an application, I usually start by writing down whatever comes to mind and discussing it with AI.

That was exactly what I did with Claude AI.

Instead of immediately asking Claude to build the entire application, I started by explaining what I wanted to create.

I discussed the application's purpose, the features I needed, how users would interact with it, and what technology could be used to build it.

Claude then suggested several ideas and possible approaches.

I read its suggestions, considered whether they matched my needs, and asked it to continue whenever I was happy with the direction.

In other words, I treated Claude AI as a discussion partner throughout the development process.

Little by little, an idea that originally existed only in my head began to take shape as a working application.

2. Why I Chose Blogger, Google Apps Script, and Google Sheets

One of my main considerations was cost.

I wanted to build a simple application without purchasing additional hosting, renting a server, or subscribing to a paid database service.

So, I decided to combine three Google services.

Blogger

I use Blogger as the front end of the application. It provides the web page where users can access and interact with the POS system.

Google Apps Script

Google Apps Script handles the application's logic and connects the interface to Google Sheets. It processes requests and manages communication between the different components.

Google Sheets

Google Sheets serves as the database, where product information and transaction data can be stored.

By combining these three services, I could build a web-based POS application without setting up my own server or database infrastructure.

Of course, free services still have usage quotas and limitations. However, for a small experiment and a simple application, this combination is quite interesting.

3. Building the Application Step by Step with Claude AI

One thing I found interesting about using Claude AI was that I did not need to understand every line of code before getting started.

I could begin with an idea and follow Claude's instructions throughout the process.

Here is the general workflow I followed:

  1. Explain the kind of application I wanted to build.

  2. Discuss the required features and application workflow with Claude.

  3. Ask Claude to prepare the application's structure.

  4. Follow its instructions, including creating Google Apps Script files and preparing Google Sheets.

  5. Copy the generated code into the appropriate places.

  6. Test the application.

  7. If something went wrong, take a screenshot and send it to Claude.

  8. Let Claude analyze the problem and guide me through the troubleshooting process.

Whenever I did not understand an instruction, I simply asked Claude to explain it again.

There was no need to pretend that I understood everything.

My advice is not to rush into asking AI to build everything at once. It is better to develop the application gradually, understand each step, and move on to the next feature when the previous one works.

This approach gave me more than just a finished application. It also helped me learn how the different components worked together.

4. Why I Did Not Use Agentic AI Features

Some AI tools offer agentic capabilities, allowing them to perform multiple development tasks more independently.

However, I did not use those capabilities in this experiment.

There were two reasons.

First, I was using the free version of Claude AI.

Second, I actually wanted to understand the development process myself.

By following Claude's instructions and completing each step manually, I could learn how the code was structured, how Google Apps Script worked, how the application connected to Google Sheets, and how the different features interacted.

For me, this learning process was just as valuable as the application itself.

I did not simply want an application that was already finished. I wanted to understand how it was built.

5. Introducing Kasir Ndeso: My Simple POS Application

After several rounds of discussion, coding, testing, and troubleshooting, I finally managed to build a simple point-of-sale application.

I named it Kasir Ndeso.

The name reflects the simple concept behind the project: a basic application built using free services, developed independently with the help of AI.

The application has two types of user accounts: Admin and Cashier.

A. Login Page

When users open the application, they are directed to the login page.

There are two types of access:

  • Admin: Can manage and add new product information.

  • Cashier: Can view available products and process sales transactions.

B. Admin Dashboard

The admin has access to the product management feature.

New products can be added to the system, making them available for cashiers to use when processing transactions.

This way, cashiers do not need to manually enter product information every time a customer makes a purchase.

C. Cashier Dashboard

The cashier interface is designed to make transactions as simple as possible.

The cashier only needs to enter the product code and the quantity purchased.

The application then automatically displays the product information, price, quantity, and total amount.

Once the transaction is completed, the application generates a receipt that can be printed or saved as a PDF file.

D. Automatic Sales Receipt

One of the features I find particularly useful is automatic receipt generation.

Cashiers no longer need to prepare payment receipts manually after completing a transaction.

The receipt can be printed directly or saved as a PDF document.

E. Transaction History and Sales Reports

I also tried to add transaction history and sales reporting features.

The goal was to allow users to review previous transactions and monitor sales performance.

However, I encountered a problem during development.

The transaction history and sales reporting features were not yet properly synchronized with Google Sheets.

I wanted to continue discussing the issue with Claude and ask it to fix the synchronization problem.

Unfortunately, because I was using the free version, I reached Claude's usage limit and had to wait approximately five hours before I could continue the conversation.

As a result, I decided to postpone further development of these features.

This experience reminded me that building applications with AI can be much easier, but testing and troubleshooting are still necessary.

6. Understanding the Application's Code Structure

During the development process, Claude AI provided several code files that I needed to place in their respective locations.

The application consists of three main code components.

1. Code.gs

This file contains the Google Apps Script code responsible for connecting the application to Google Sheets and handling data processing.

2. Menu.gs

This file contains additional code used for the application's menu configuration and related functions.

3. Blogger HTML Code

This is the application's user interface code, which I placed inside a Blogger page.

For the database, I created a separate Google Sheets file named Kasir Ndeso.

Here are some screenshots documenting the development process.

Code.gs

Menu.gs


Blogger HTML Code

Google Sheets Database

In this structure, Blogger provides the interface, Google Apps Script handles the application logic, and Google Sheets stores the data.

7. Try the Kasir Ndeso POS Application

I decided to share this project so anyone interested can see what I managed to build with the help of Claude AI.

You can try the application using the following link:

Admin
Username : admin
Pin : 123456

Kasir
Username : kasir
Pin : 123456

You can also view the Google Sheets database here:

VIEW THE KASIR NDESO GOOGLE SHEETS DATABASE

By trying the application yourself, you can explore the login page, product management, sales transactions, and receipt generation features.

Please note that this is still an experimental project under development. Do not use it for actual business transactions or store important data until its security, data consistency, and functionality have been properly tested.

8. Final Thoughts: You Don't Have to Be an Expert Programmer to Start Building Applications

This experiment gave me a new perspective.

Apparently, with the help of AI, someone without advanced programming skills can start building an application.

The key is not simply giving instructions to AI. It is about explaining what you need, discussing possible solutions, understanding the suggestions, following the instructions, and testing the results.

I also realized that different AI services have their own strengths and weaknesses.

I have been comfortable using ChatGPT for discussions, understanding problems, and designing systems. But after trying Claude AI, I experienced a different workflow, particularly when it came to writing code.

Is Claude AI better than ChatGPT?

I don't think I can draw that conclusion based on just one experiment.

What I can say is that both tools can be extremely useful when we know how to make the most of them.

Kasir Ndeso may still be a simple application, and it is far from perfect. There are features that still need improvement and further development.

But for me, successfully building this application has been a rewarding learning experience.

It made me think: if a simple POS application can be built with AI and free services, there must be many other ideas worth exploring.

You don't have to wait until you become an expert programmer to start building something. Start with an idea, discuss it with AI, and learn one step at a time.

Who knows? A simple idea might eventually turn into something useful for many people.


This article documents my personal experience using the free version of Claude AI to build a web-based application with Blogger, Google Apps Script, and Google Sheets.

Post a Comment