Google Sheets Workflow System

I need a single, easy-to-maintain workspace—built in Google Sheets and any no-code tools you feel are essential—that lets my social media agency keep every task, teammate and client visible in one view. Our biggest pain-point is tracking team workflows, so the heart of the build must be a clear pipeline that handles task assignment and records progress updates automatically.

Here is how I picture it working:
• Each department enters its daily activity in a simple form or protected sheet.
• Those entries feed a master dashboard that rolls up the data, shows workload by teammate and client, and pushes out a concise weekly summary I can review at a glance.
• Status changes trigger colour-coded queues so everyone sees what still needs attention before the next hand-off.

I don’t mind whether you rely purely on Sheets formulas, App Script, Make, Zapier, Glide, or a mix—as long as the result is low-code enough for us to tweak later. Give me:
1. A linked set of Sheets (or equivalent tables) ready for real-time collaboration.
2. An automated weekly summary report.
3. Clear instructions or short loom videos so my team can onboard themselves.

If you can future-proof the structure so client management and content approval modules could slot in later, that’s a bonus, but right now the deliverable is a rock-solid workflow tracker that makes weekly performance crystal-clear.