Description
We are looking for an experienced Google Apps Script / Gmail API developer to build a lightweight AI-assisted Gmail workflow automation for a small Finnish service business. The main problem is simple but business-critical: customer emails requiring action can be forgotten when they are read on a mobile phone but cannot be handled immediately. The Phase 1 solution should automatically identify and track customer conversations based on their actual workflow state, primarily: Action Required – the business has an outstanding action Waiting – the business is waiting for the customer Overdue – an outstanding business action has exceeded a configurable time limit The system must track the actual next required action rather than relying on read/unread status or simply whether an email has been replied to. For example, replying "I will prepare a quotation" must leave the conversation in Action Required until the quotation has actually been sent. The primary user must be able to continue working entirely in his existing Gmail inbox on desktop and Android. We do not want a CRM, separate dashboard or separate task management application. The current email setup includes Google Workspace addresses forwarded to the primary user's personal Gmail account, Gmail "Send mail as", and a BCC/forwarding workflow when another person handles a customer conversation. This is described in detail in the attached specification. We prefer Google Apps Script and/or Gmail API with an AI/LLM API where app