Automate Gmail & Sheets Workflows
Employer not named by the sourceRemote
Frontier is not the employer and does not collect applications.
About this role
PHP, Software Architecture, Email Marketing, Scripting, Google Docs, Automation, API Integration, Workflow Automation · I am a small business, but part of a Franchise System. I'm ready to hand off two related automation chores. Both jobs live entirely inside Google Workspace, so familiarity with Gmail API, Google Apps Script, and the Sheets API will be essential.
Task 1 – Smart reply from Gmail When a message lands in my business Gmail inbox, your script should inspect it, pull the right template from a Google Doc, merge in any dynamic fields, and fire back a detailed response email automatically. Think of it as “if-this-then-that” but with professional-grade polish and error handling (logging, retries, etc.).
Task 2 – Recurring campaign from a Sheet I maintain a Google Sheet that lists all current customers. From that list, I need a recurring email campaign to go out on a schedule I can edit myself. Each message must include an opt-out link and, if someone opts out, the script should record the choice in the same Sheet to be sure they never receive another campaign mail.
Acceptance criteria • Fully commented Apps Script (or equivalent) deployed in my Workspace • Configuration panel or clear variables so I can swap templates, change schedules, and tweak copy without code changes • Opt