Looker Studio Dashboard from Google Sheets

I have several regularly-updated Google Sheets that need to be turned into a single, interactive dashboard in Looker Studio (or a comparable Google-friendly BI tool). The core requirement is that the dashboard stays in sync with the source files in near real-time; an automated import or scheduled refresh that mimics live data is essential so my team never works with stale numbers.

Once the data is connected, I’ll need it cleaned, joined where necessary, and presented with clear visualisations. We’ll finalise exactly which graphs, tables, and filters to show together, but the build should already allow for drill-downs, period comparisons, and snapshot exporting.

Deliverables:
• Data connection configured to pull the Google Sheets sources automatically
• Data model and calculated fields set up inside Looker Studio
• Polished dashboard with interactive visuals and date filters
• Short hand-off document (or walkthrough video) explaining refresh logic and how to modify charts

I’ll supply sample files and naming conventions as soon as we start.