Invoice Payment Schedule Automation
Commissioned Work
Overview
Developed a Google Apps Script system that reads invoice PDFs stored in Google Drive using Gemini API and automatically creates payment schedules in spreadsheets. Significantly streamlined monthly accounting operations.
Key Features
Automatic Invoice Reading: Extracts company name, total amount, and payment method using Gemini API. Prioritizes amounts circled in red pen.
Automatic Company Master Management: Auto-adds new companies, implements sorting by Japanese syllabary using katakana readings. Auto-normalizes company names to official format.
Bulk File Processing: Implemented continuation processing considering GAS execution time limit (5 min). Reliably processes 50+ invoices with auto-pause and resume.
Error Handling: Records failed readings in a review sheet with file links to support manual intervention.
System Architecture
Modular design separating Config/Main/GeminiService/DriveService/SheetService. Built local development environment with clasp for efficient version control and deployment.