I built a WhatsApp bot that automatically tracks your expenses into Google Sheets — my first public project 🚀

ChrolloLW — Wed, 05 Nov 2025 20:07:45 +0000

Hey everyone 👋

I’ve been learning programming little by little through different personal and work projects — building things that help me automate tasks, organize data, or just make life a bit easier.

Recently, I decided to publish one of them for the first time: RemmiV1, a WhatsApp bot that automatically logs your daily expenses into Google Sheets 💬💸

💡 What it does

The idea is simple: you send a normal message in WhatsApp like:

chicken food 20 cash

and the bot automatically registers:

🏷️ Category: food
🍗 Item: chicken
💰 Amount: 20
💳 Payment method: cash

Everything goes directly into a Google Sheet, ready for reports or monthly summaries.

💭 Why I built it

The idea came from something personal.

My girlfriend usually writes down her daily expenses in a WhatsApp chat — just as quick notes — but by the end of the month it was always complicated for her to organize and calculate everything.

So I thought: what if I could make that chat itself do the job?

That’s how RemmiV1 started — as a way to help her keep track of expenses more easily, while learning how to integrate WhatsApp with Google Apps Script.

This project helped me understand more about APIs, automation, and the power of combining small, everyday habits with simple tech.

⚙️ How it works

I used the Meta Cloud API (WhatsApp Business) to receive messages and connected it with Google Apps Script, which writes the data into Google Sheets.

The bot uses a few simple rules:

The word before the amount becomes the category
Detects payment method (cash, card, transfer, etc.)
Adds the date automatically

It’s a lightweight setup that doesn’t need any external servers — just Meta and Google Workspace tools.

📊 Features

✅ One-line expense tracking via WhatsApp

✅ Detects category and payment method

✅ Generates monthly reports automatically

✅ Works entirely with free Google tools

🧠 Stack used

Meta Cloud API (WhatsApp Business)
Google Apps Script
Google Sheets

🌍 Repository

📦 GitHub: RemmiV1 – WhatsApp Expense Bot

🗣️ The repository is available in both English and Spanish.

🚀 What’s next

Support multiple users: make it possible to store and organize data from different WhatsApp numbers in separate sheets or tabs.

So far, I’ve tested it with two friends and my girlfriend — and it works great!

This is my first public project, so any feedback or suggestions are really welcome 🙏

I’m from Peru, and I enjoy learning by building — especially projects that connect daily life with tech.

Forem: ChrolloLW