Automated Management System for Photography Business

I run a photography and video editing business and need an automated project & client management system.

Currently, I use Excel/Google Sheets to track projects, but I want to upgrade to a more automated workflow to save time, avoid errors, and scale my business.

The system should help me manage:
• Client details
• Project requirements & deadlines
• Editor assignments
• Multiple re-edits & delivery tracking
• Approval status
• Payment tracking

Key Features Needed:
• Google Sheet Database (expandable for unlimited re-edits).
• Google Form integration for easy project entry.
• Automated reminders for deadlines, re-edits, and payments.
• Editor task assignment in Trello/ClickUp/Asana.
• Automatic client communication (emails/WhatsApp) for project updates.
• (Optional) Dashboard to see active projects, pending payments, and upcoming deadlines.

Tech Preferences:
• Google Sheets + Google Apps Script (preferred, free).
• Or Zapier/Make integration with Trello/ClickUp (okay if faster, but has a small recurring cost).

Deliverables:
• Fully working system
• Documentation on how to use/edit
• Short training/demo (screen share or Loom video)