Build Interactive Dashboards with Gemini 3.5 Flash and Apps Script

Build fully interactive dashboards with Gemini 3.5 Flash and Apps Script in this tutorial.
No data exposed, no shortcuts.

We'll explore creating interactive dashboards with dynamic KPI trackers and a robust live-offline sync engine. This video demonstrates two hosting options: Google Sites and native Apps Script HTML, making it perfect for anyone looking to enhance their data visualization with gemini ai.

Workflow: convert your sheet data to a secure JSON via Apps Script, feed it to Gemini for dashboard design in Canvas, then lock it down so only authorized users see live data.

📊 Get the code and scripts used in this video:
https://docs.google.com/spreadsheets/d/14_aM1WjB9Bkj4hBK1KIDixpzBwfuKnejExYpPvOhLzE/edit?usp=sharing

🔗 Google Apps Script: https://script.google.com
🔗 Google AI Studio (Gemini): https://aistudio.google.com

Timestamps
0:00 Introduction
0:32 Setting up your Google Sheets data source
0:49 Converting sheet data to JSON with Apps Script
1:19 Deploying the JSON as a web app
2:09 Building the dashboard in Gemini 3.5 Canvas
3:14 Reviewing the live dashboard: KPIs, filters, charts
4:26 Hosting Option 1: Embed in Google Sites
5:08 Hosting Option 2: Native Apps Script HTML web app
6:27 Locking down security and execute as accessing user
7:08 Testing sandbox mode and use cases
Subscribe @analyticswithadam for more practical Google AI workflows

Adam is a Business Systems Analyst at Google and teaches self-taught analysts and data professionals how to build practical, repeatable workflows using Google AI tools — Gemini, NotebookLM, AI Studio, BigQuery, and Google Workspace. Real use cases, no hype.
#googlesheetsautomation #googleappsscript #geminiaitutorial #googleworkspace #aiautomation

Видео Build Interactive Dashboards with Gemini 3.5 Flash and Apps Script канала Analytics with Adam