Automated Timesheet Parsing and Mail Merge for Indeed Flex

Client: Leading Temporary Staffing Platform (Indeed Flex)

Tools Used: Google Sheets • Google Apps Script • Gmail • Salesforce

Each week, administrators manually distributed timesheets and purchase orders to multiple staffing agencies. This process involved filtering large data sets, preparing agency-specific files, and sending individual emails — all done by hand. It was slow, error-prone, and risky, with occasional data breaches caused by incorrect attachments or human error.

I built an end-to-end automated workflow that replaced the manual process with a secure, scalable system. Using Google Apps Script and Gmail, the workflow:

Automatically split and organized timesheets by agency

Matched data to the correct recipients using Salesforce records

Prepared and sent emails with relevant attachments through a mail merge process

Logged and tracked all distributions for accountability and compliance

This eliminated the need for administrators to handle files directly while maintaining a clear audit trail of every sent document.

Zero data breaches after implementation

Faster, more reliable communication with agency partners

The automation significantly improved both operational efficiency and data security. By removing manual handling, the company reduced compliance risk, improved delivery times, and freed up staff to focus on higher-value work — turning a critical weekly pain point into a seamless background process.