This project was developed for a customer who runs an international HR and recruitment agency that hires people across multiple countries and industries.
Before we started, the agency was managing dozens of spreadsheets manually — tracking candidates, roles, payments, and commissions separately.
The goal was to centralize everything into a single connected system that could automate repetitive work and provide clear visibility into every aspect of the business.
Complete Business System in Google Sheets
I built a set of linked Google Sheets, each handling a different part of the operation:
Roles & Candidate Tracking – manage open positions, candidate pipelines, interviews, and hiring progress.
Customer Payments – automatically track payments received for each filled position, linked directly to the related role and candidate.
Recruiter Commissions – calculate employee commissions automatically based on placements and customer payments.
Monthly Salaries – generate personalized PDF salary slips for every recruiter, automatically saved to Google Drive each month.
All these sheets are connected through a shared Apps Script backend, which ensures that data stays synced and updated across the entire system.
Apps Script Automation Highlights
The custom Apps Script code automates core workflows such as:
Creating new candidate records automatically when a role is opened.
Updating recruiter commissions when customer payments are logged.
Generating monthly salary PDFs in Drive folders with a single click.
Sending automatic status updates and summary reports.
This setup replaces hours of manual data handling with clean, dependable automation.
Dashboards and Metrics
To help the agency’s management team stay on top of operations, I also built a collection of interactive dashboards that visualize:
Open and filled roles by recruiter, region, and customer.
Conversion and placement rates.
Monthly income and commission trends.
Total payouts and profitability metrics.
These dashboards pull data from live sheets, updating automatically whenever new entries are added — giving the owner instant insights into business performance.
Results
The entire business now runs seamlessly inside Google Sheets — fully integrated, automated, and transparent.
Recruiters, finance, and management all work from the same data source, with zero duplicate entry and full visibility across departments.