Extend our working Python/Sheets script into an automated, always-current content dashboard

We're a digital marketing agency. We track content production for ~8 recurring clients, each in its own Google Sheet. We've already built a working Python tool that pulls every client's calendar and merges them into one consolidated "master" workbook with dashboard views. Right now we run it manually. We want it to run on its own on a schedule and publish an always-current live view our team can open anytime — no manual re-running. Important: you are not starting from scratch. You'll receive a working build script, a written build spec, a config file, and a system diagram. Your job is to extend a documented, validated foundation — not invent it. We'll weight proposals that clearly engage with what already exists. What's already built: Python build that reads each client's Google Sheet and merges into one workbook Standardized schema + controlled status/type vocabularies Dashboard, Pipeline, By-Client, By-Producer, By-Month, and Config views Built-in validation (totals reconcile, zero formula errors) A registry file (one line per client) so new clients onboard without code changes A system diagram and a written spec The scope (Phase 1): Take our existing build and make it run automatically on a schedule (e.g. daily) without anyone kicking it off. Publish the consolidated output as an always-current live view — a Google Sheet that refreshes itself, or a Looker Studio dashboard reading the live data (recommend what you'd use and why). The live view should let our team filter by client and by month, and show: status funnel, producer workload, overdue tracking, and monthly throughput. (Our current build already computes all of this — the job is to surface it in an auto-refreshing view.) Preserve our existing validation so a bad run never silently publishes wrong numbers. Explicitly out of scope (possible later phases, not now — please do not price these in): a custom hosted web app, per-client client-facing share links, a cost/billing engine, and migrating our source of truth to monday.com. Deliverables: The build running automatically on a schedule, where we can maintain it An always-current live view (Sheet or Looker Studio) fed from the source Google Sheets A clear README / handoff doc covering how to add a client and how to change the schedule A short (5–10 min) screen-recorded walkthrough What we'll provide: the build script, spec, config file, diagram, and a sample dataset. (We won't share real client data or live credentials during the build — you'll work against the sample, and we'll connect real data ourselves at handoff.) Must-have skills: Python (pandas), Google Sheets API / gspread or Apps Script, scheduling/automation (cron, Cloud Scheduler, Apps Script triggers, or similar), and Looker Studio or equivalent live-dashboarding. Bonus: marketing or agency reporting experience. Budget & approach: Fixed-price, milestone-based. We'll start with a small paid first milestone (review our assets, get the build running on the sample data, and propose the scheduling + live-view approach) before committing to the full build. We value clean, maintainable, well-documented work over anything flashy. To apply, briefly answer: How would you schedule our existing Python build to run automatically, and where would you host it cheaply? Would you publish the live view as a self-refreshing Google Sheet or a Looker Studio dashboard, and why? Describe a similar Sheets automation you've built (link if possible). Please begin your proposal with the word "Pipeline" so we know you read this through.