Case Studies — Real Projects by Rameez Scripts

A school in Mumbai was spending 20+ hours per week manually tracking fee payments across hundreds of students in Google Sheets.

Built a Google Apps Script automation that tracks fee payments, sends automated reminders to parents, generates receipts, and produces monthly collection reports — all from the same Google Sheet.

An operations team in Texas needed to track inventory across 3 US states. Their existing spreadsheet system was causing stock discrepancies.

Built a PHP/MySQL inventory management system with role-based access control, real-time stock levels, purchase order tracking, and automated low-stock alerts.

A retail owner in Toronto needed to see real-time sales data across 5 stores in one place, with automated reports sent weekly.

Built a Google Sheets dashboard with clean charts showing store-by-store performance, automated email reports, and data syncing from individual store sheets.

A logistics company in London was tracking warehouse stock in separate spreadsheets per location. No one knew exact stock levels without manually checking each file, and low-stock situations were only discovered after items ran out.

Built a Google Sheets inventory dashboard that consolidates stock data from multiple warehouse sheets. Apps Script handles automated low-stock email alerts, purchase order generation, and a web app interface for quick stock lookups by warehouse.

A school administrator in Lagos was manually creating report cards for 500+ students each term — hours of copy-paste work.

Built an Apps Script system that manages student grades, generates report cards as PDFs, and sends them to parents via email notification — handles 500+ students without slowing down.

A company in Dubai was creating invoices manually in Word and tracking payments in a separate spreadsheet. Invoice numbers were inconsistent, overdue payments were slipping through, and there was no clear picture of monthly revenue.

Built a Google Sheets invoicing system with Apps Script — auto-numbered invoices generated from a template, payment status tracking with color-coded rows, automated overdue reminder emails, and a revenue dashboard with monthly charts and client-wise breakdowns.

A company in Qatar was tracking employee attendance on paper sign-in sheets. The HR team had no way to spot late arrivals, calculate working hours, or generate monthly attendance reports without manually going through stacks of paper.

Built a Google Sheets attendance system with an Apps Script web app for employee check-in and check-out. The system automatically logs timestamps, flags late arrivals, calculates daily and monthly working hours, and sends a summary report to the manager every Monday via email.

An import-export company in Saudi Arabia was managing shipments, suppliers, and customs paperwork across separate spreadsheets and email threads. Shipments were getting delayed because no one could quickly check which documents were missing for which container.

Built a Google Sheets shipment tracking system with Apps Script. Each shipment has a row with supplier info, status, customs document checklist (with checkboxes), and profit/loss calculation. Apps Script sends automated email alerts when a shipment's documents are incomplete or a clearance deadline is approaching.

A small business owner in Bangladesh was logging expenses in a plain spreadsheet with no structure. There was no budget comparison, no category breakdown, and at the end of the month nobody knew where the money went.

Built a Google Sheets expense management system with Apps Script. Expenses are logged with category, amount, and date through a custom sidebar form. The dashboard shows budget vs actual spending per category, weekly summaries sent via email, and charts that update automatically as new entries come in.

A consulting firm in France was managing client records, project milestones, and billing data across multiple Google Sheets with no connection between them. Finding a client's project history meant opening 4 different files.

Built a unified Google Sheets data manager with an Apps Script web app front-end. Custom forms for adding clients and projects, dropdown filters to search by client or status, automatic linking between client sheets and project sheets, and one-click export to CSV and PDF for reporting.

A training institute in Sri Lanka was running quizzes through Google Forms but grading manually. Scores were tallied by hand, certificates were made one by one in a document, and students waited days to get their results.

Built an Apps Script system that auto-grades Google Forms quiz responses as they come in. Scores are calculated instantly and written to a Google Sheet. For students who pass, a PDF certificate is generated from a template with their name and score, and emailed to them automatically. The teacher dashboard shows class-wide analytics — pass rate, average score, weakest topics.

A company in Jordan was handling HR operations — employee records, attendance, leave requests, payroll — through a mix of Excel sheets and paper forms. The HR team was spending hours on data entry and manual calculations every pay cycle.

Built a complete PHP/MySQL HR management system with employee profiles, attendance tracking (check-in/check-out), leave request and approval workflow, payroll calculation with deductions and allowances, and department-level access control so managers only see their own team.

A sales team in Morocco was tracking leads and customer interactions in spreadsheets. Follow-ups were getting missed, deal stages were unclear, and the manager had no visibility into the pipeline.

Built a PHP/MySQL CRM with lead capture forms, a visual sales pipeline (drag-and-drop stages), contact and company management, automated follow-up reminders via email, activity logging for every interaction, and a manager dashboard with performance metrics per sales rep.