πŸš€ Google Apps Script Full Course in Hindi | Interactive Dashboard Project

πŸš€ **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.