The recruitment agency used:
Recruitee ATS for internal hiring pipeline management
20+ Google Sheets shared with different clients. Clients would update candidate statuses directly inside their respective Google Sheets.
The problem:
The agency had to manually check each sheet. Any status change had to be manually updated inside Recruitee
This created:
They needed real-time synchronization between client sheets and their ATS.
We built a centralized automation system using Zapier, Google Apps Script, and a Master Tracker.
We created a central Google Sheet acting as a control panel. Whenever a new client sheet link was added:
This made scaling simple.
Each client sheet had a lightweight Apps Script function installed.
Whenever a candidate’s status was changed:
The script detected the change instantly
It sent the updated status to a Zapier webhook
This eliminated the need to “check sheets manually.”
The Zapier workflow:
All updates happened automatically.
Final flow:
Client updates status → Apps Script detects change → Webhook sent to Zapier → Zapier updates Recruitee → Pipeline stays accurate in real-time.
No manual intervention required.
After implementation:
Recruiters no longer spent hours checking spreadsheets. Their ATS always reflected the latest candidate status automatically.
“We were constantly checking spreadsheets and updating Recruitee manually. Now everything syncs automatically. It removed a huge operational headache”