Google Sites & Sheets Interactive Dashboard

Interactive Dashboard Development on Google Sites with Google Sheets Integration
Project Overview
I need a professional, interactive dashboard built on Google Sites that automatically pulls data from Google Sheets. The solution should allow me to simply upload new data files to refresh the dashboard without requiring technical expertise.
Requirements
Core Functionality

Platform: Google Sites-based dashboard
Data Source: Google Sheets (exported/uploaded files)
Update Method: Simple file upload process that refreshes all dashboard data
User-friendly: No coding knowledge required for data updates

Dashboard Features Needed

Clean, professional visual design
Interactive charts and graphs
Key performance indicators (KPIs) display
Responsive design that works on desktop and mobile
Automatic data refresh when new files are uploaded
Filter/sorting capabilities for data exploration

Technical Requirements

Integration between Google Sites and Google Sheets
Automated data processing from uploaded files
Charts/visualizations using Google Charts or similar
Documentation for the upload process
Error handling for data format issues

Deliverables

Fully functional Google Sites dashboard
Google Sheets template with proper formatting
Step-by-step guide for uploading new data
Basic troubleshooting documentation
One revision round included

Ideal Candidate

Proven experience with Google Sites development
Strong knowledge of Google Sheets integration and Google Apps Script
Experience creating interactive dashboards and data visualizations
Portfolio showing similar Google Workspace projects
Excellent communication skills and ability to explain technical processes simply