Automate Gmail & Sheets Workflows

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-out handling compliant with Gmail sending policies
• Test run that proves both workflows end-to-end, with logs I can review

If you have experience chaining Gmail, Google Docs, and Google Sheets together into seamless flows, please let me know your approach and timeline so I can review a quote.