Skip to Content

AI & Automation

Automated Payment Tracking System

A Google Workspace automation (Apps Script and Sheets) for UST CICS that manages $28,000+ in transactions, with complex calculations and real-time email triggers.

Payment TrackingrunningTracked: $27,880
  1. Forms Input
  2. Sheets DB Record
  3. Agency Email Sent
PayerA. MendozaAmount$25Receiptgcash_receipt_0912.jpg
410K. Santos$15411J. Dela Cruz$32412A. Mendoza$25
Tofinance@events-agency.exampleSubjectPayment received: A. Mendoza Sent with receipt attached

Due to NDA, official screenshots can’t be shared. This is an illustrative recreation.

The Challenge

A major university event meant payments from many students, and every payment and receipt had to be recorded, totalled and confirmed without errors.

What I Built

An Apps Script automation on Google Sheets that records each payment with its receipt, runs the calculations and sends real-time email notifications.

Results

  • Managed $28,000+ in transactions
  • Every payment recorded with its receipt and calculated automatically
  • Real-time email triggers on each payment