Build a free Telegram automation that automatically logs Cash In / Cash Out transactions into Google Sheets and calculates transaction revenue.

Cost: ₱0/month

Tools: Telegram + Google Apps Script + Google Sheets

Skill level: Beginner-friendly

<aside> 🚀

📬 Stay in the Loop

I post weekly breakdowns of automation builds, lifecycle marketing tactics, and behind-the-scenes of running AGC on YouTube, Facebook, LinkedIn, and Pinterest.

• Youtube: https://www.youtube.com/@ShielaDeLaCruzAGC
• LinkedIn: https://www.linkedin.com/company/anchor-growth-co/
• Pinterest: https://ph.pinterest.com/shieladelacruz_agc/
• Facebook: https://www.facebook.com/anchorgrowthco
• Tiktok: https://vt.tiktok.com/ZS44MnNk5/ </aside>

🎯 What We're Building

The goal is to be able to send a Telegram message like:

Cash in 500

and automatically have the system:

1. Detect the transaction type
2. Extract the amount
3. Calculate the revenue
4. Save the transaction to Google Sheets
5. Send a confirmation back to Telegram

Example

Telegram:

Cash in 2500

Bot:

✅ Transaction Logged!

Type: Cash In

Amount: ₱2,500.00

Revenue: ₱30.00

Google Sheets: