Automation Engineer
21 active projects, two linked automations, one person who never touches it.
21 projects, PDFs in Gmail, manual reconciliation, 3-5 day lag in financial visibility.
Job ID mapping + Gmail scan with Gemini extraction, 3x daily.
Runs monthly without intervention or manual correction.
Job ID mapping (Sheets to Drive API). Gmail scan (Apps Script, 7am/12pm/3pm). Gemini extraction handles unstructured invoice formats.
3x daily chosen over continuous for cost efficiency. No manual correction since deployment.