Workflow Automation for Google Sheets System

Google Apps Script Expert Needed – Workflow Automation in Google Sheets
I have an existing Google Sheets workflow management system that is already built and partially functional.
Current Workflow
Production Team
Video Editor Team
Graphic Design Team
HR / Influencer Team
GM Approval
Social Media Team
CEO Dashboard
What is Working
Workflow tracking
Reporting dashboards
Department sheets
GM Approval sheet
Social Media reporting
What Needs to Be Automated
1. Video Editor → GM Approval
When:
Progress = 100% OR
Status = "Pending Approval"
Automatically:
Create/Move record to GM Approval sheet
Prevent duplicate entries
2. Graphic Design → GM Approval
When design task reaches completion or approval stage:
Auto-create GM Approval record
3. HR/Influencer → GM Approval
When campaign/deliverables are completed:
Auto-create GM Approval record
4. GM Approval Actions
If Status = Approved:
Auto-send task to Social Media sheet
If Status = Rejected:
Return task to original department
If Status = Revision Required:
Return task to original department with comments
5. Activity Log
Automatically create audit logs whenever:
Task moves between departments
Approval status changes
Revisions are requested
Requirements
Google Apps Script only
Clean and maintainable code
No duplicate records
Existing sheet structure should not be broken
Proper error handling
Easy to extend later
Deliverables
Complete Apps Script code
Installation/setup instructions
Testing of workflow automation
Documentation of triggers and functions
Notes
The spreadsheet is already created and partially working. I need automation added without damaging the existing dashboard, formulas, summaries, and reports.