How to Use Gemini AI to Create a Google Sheets Dashboard, by DNhanlab on YouTube. 15 min 17 s.
- Video length
- 15 min 17 s
- Time to do it
- 30 minutes
- Difficulty
- Medium
- Steps
- 8
What you need
Steps
Open your data in Google Sheets and clean it up. Put each field in its own column, use one header row, and remove blank rows so the AI has tidy data to work with.
Write a clear prompt for Gemini. State the dashboard goal, the columns you have, the charts you want, the filters, and that you need HTML, CSS and Apps Script code.
Paste the prompt into Gemini and review the generated code. Ask it to fix or adjust any part that does not match your column names before you use it.
In your sheet, open Extensions, then Apps Script. Create a new project and paste the Apps Script code Gemini gave you into the editor.
Add an HTML file in Apps Script for the dashboard page and paste the generated HTML and CSS into it. Keep the file name matching what the script calls.
Save the project, then deploy it as a web app. Set who can access it, authorize the permissions, and copy the web app URL.
Open the web app URL and check that your sheet data loads. If numbers or labels are wrong, fix the column references in the script and redeploy.
Add filters, dark mode or extra pages by asking Gemini for the code, then paste it in and deploy a new version. Test each change before moving on.
Tips and common mistakes
Name your sheet tabs and columns exactly as the prompt says, or the script will pull the wrong data.
Deploy a new version after every code change, since the old web app URL keeps serving the previous version.
Keep a copy of your sheet before you add scripts so you can restore it if something breaks.
Only share the web app with people you trust, because anyone with the link can view the dashboard.
Questions
Do I need to know how to code?
No. Gemini writes the code, but you need to copy it into Apps Script correctly and match your column names. Basic comfort with Sheets helps.
Will the dashboard update when I change the sheet?
Yes, if the script reads live from the sheet. Refresh the web app page to see new data after you edit the spreadsheet.
Is this free?
Google Sheets, Apps Script and a Gemini account can be used at no cost on standard plans. Check your own account limits before relying on it.
This guide was drafted from the video's details and general task knowledge. It has not been checked against the full video. Check the video and relevant product instructions before following a procedure. Report a correction.
