Google Sheets Automation & Visualization

I have several interconnected Google Sheets that are starting to outgrow basic formulas. I need a specialist who can streamline data processing and automate recurring report-generation steps using Apps Script, advanced functions, and Power Queries. Beyond the back-end, I would like the numbers to come alive in Looker Studio dashboards so that trends are obvious at a glance and stakeholders can slice the data without touching the spreadsheets themselves. Core objectives • Replace my manual data-processing routines with reliable, self-running scripts. • Build or refine Power Queries that pull, clean, and reshape raw tables for analysis. • Generate recurring reports automatically, scheduling them to update and distribute on set intervals. • Design clear, interactive Looker Studio views that tie directly to the automated Sheets. Deliverables 1. Google Sheets file(s) containing all finished automation scripts and documented Power Queries. 2. Looker Studio dashboard linked to those sheets, complete with filters and date controls. 3. A short hand-off guide or Loom walkthrough so I can adjust ranges, triggers, or visuals later. If this sounds like a routine you have mastered, let’s get started—my goal is a system that updates itself and presents insights in real time.

Project ID: 40270252