π **Google Apps Script Full Course in Hindi | Interactive Dashboard Project**
Welcome to **SSR Tech Edu β Learn β’ Build β’ Grow!**
In this practical Google Apps Script tutorial, learn how to use Google Sheets, JavaScript, HTML, CSS and Chart.js to build a beautiful, interactive Immunization Survey Dashboard from scratch.
π― **WHAT YOU WILL LEARN**
β
What is Google Apps Script and how it works
β
Practical uses of Apps Script and Google Workspace automation
β
Create a Google Sheet with survey data
β
Work with State, District and Block/Municipality-wise data
β
Read Google Sheets data using Apps Script
β
Build a full-screen interactive web dashboard
β
Create KPI cards for Eligible Children, Surveyed Children, Fully Immunized and Coverage
β
Build 4 chart types: Line, Bar, Doughnut and Polar Area
β
Create dependent dropdown filters
β
Design a modern interface using HTML, CSS and Bootstrap
β
Use SweetAlert2 and Testify for notifications
β
Deploy your project as a web app
π **ABOUT THE PROJECT**
We will transform a synthetic immunization survey dataset into an interactive dashboard. Select a State, District or Block/Municipality to update the dashboard’s KPIs, charts and data table.
π **VIDEO CHAPTERS**
00: 00 β Introduction and Project Preview
00: 20 β What Is Google Apps Script?
00: 30 β Uses of Google Apps Script
00: 49 β Create Google Sheets Survey Data
03: 06 β Open Apps Script and Set Up the Project
04: 20 β State, District and Block Filters and Test the Web App
*Adjust the timestamps to match your final video before publishing.*
πΊ *MY OTHER YOUTUBE VIDEOS*
1. Excel Basic to Advanced:
β’ π https://youtu.be/BA707-GcP8c?si=20S29wGJof4ELPix
2. Google Sheets Basic to Advanced:
β’ π https://youtu.be/ZnP5p7F8a_M?si=HecYTIGB7T8–VaA
3. Google Forms Basic to Advanced :
β’ π https://youtu.be/-_qUXgcVr1o?si=LhNfaPPNtFuVO78w
π’ *JOIN OUR TELEGRAM CHANNEL*
π Get updates, useful resources and tech learning content:
https://t.me/omssrtechedu
π‘ **WHO SHOULD WATCH?**
Beginners, students, data analysts, Excel and Google Sheets users, and anyone interested in learning automation and dashboard development.
π **SUBSCRIBE TO SSR TECH EDU**
Learn practical technology, Google Sheets, Excel, Google Apps Script, automation and AI tools.
If you find this tutorial helpful, LIKE the video, SHARE it with others and SUBSCRIBE for more practical projects.
#GoogleAppsScript #GoogleSheets #Dashboard #Automation #HindiTutorial
β οΈ **Disclaimer:** The immunization dataset is synthetic and for educational demonstration only. It does not represent official government statistics or real patient records.