How To Use Google Gemini To Create a Google Sheets Dashboard

Описание: Download all project files here 👇
(i) Google Gemini 2.5 Prompts:
https://docs.google.com/document/d/1g...
(ii) Link to Dashboard (app):
https://script.google.com/macros/s/AK...
(iii) Link to Google Sheet (Dataset):
https://docs.google.com/spreadsheets/...
(iv) Link to Google Apps Script Codes:
https://docs.google.com/document/d/1p...

In this tutorial, we will learn to build a dashboard by using ‪@Google‬ Gemini 2.5 and Google Sheets Apps Script.
First of all, we will ask Google Gemini to analyze our Google Sheet dataset and provide dashboard design suggestions.
Based on the suggestions provided by Gemini, we will generate Apps Script code to pull data from Google Sheet and create the dashboard.
Consequently, we will paste the codes generated by Google Gemini in our apps script project.
The dashboard will show important metrics as well as the charts such as trend, pie, donut, bar and column charts.
Finally, we will discuss different methods to customize the dashboard. For example, how to adjust height, width, add markers to charts, change chart type and add data labels.

#googlesheets #googlegemini #appsscript

Chapters:
0:00 - Introduction
0:24 - Google Sheets Setup
1:42 - Creating Dashboard
6:07 - Customizing Dashboard
13:48 - Conclusion