Google Sheets Workflow Automation

Job ID: 39916872

Budget: $250 – $750 USD

I want a fully-automated performance tracker built in Google Sheets and powered by Google Apps Script. When our custom website form is submitted, the script should:

• Add a new row with every field auto-populated.
• Instantly email the nominated list of recipients through Gmail, pulling data from the new row.
• Monitor a “Team Approval” column so that once any three (or more) members switch their toggle to “Yes,” the row status updates automatically and a follow-up email is sent.

Additional needs
• Commenting must be enabled so team members can discuss each entry right inside the sheet.
• Users should be able to attach or paste images; store the files in our Google Drive and place the link or thumbnail in the relevant cell.
• Clean, intuitive layout with protected ranges so core formulas and scripts can’t be overwritten.
• A short hand-off guide explaining how to edit recipient lists, modify trigger wording, or extend the form fields.

Everything—spreadsheet, scripts, and documentation—remains my property in perpetuity. Please deliver the finished Sheet, the underlying Apps Script project, and the instructions.