← Back to portfolio
Google Workspace Automation

BASCA Automated e-Receipt System

2025

A fully automated contribution and receipt workflow built for the Bangladesh Students Community AIU.

BASCA Automated e-Receipt System
Integrated Google Forms, Sheets, Docs, Drive and Apps Script. Automatically matches contributor emails, generates invoice numbers, creates personalized receipts from an official template, converts receipts to PDF, stores them in Drive, emails them and synchronizes a centralized tracking sheet. The system reduces manual work and improves transparency and accuracy.
Google FormsGoogle SheetsGoogle DocsGoogle DriveGoogle Apps ScriptJavaScript