CRUD Web App Dashboard with Dependent Dropdown Using #googlesheet & #appsscript | C16

📄 Get Free Google Sheet Source Code

📺 Watch Tutorial Video

🛡️ Your Privacy & Security is Our Top Priority
We use industry-standard security practices and work exclusively with Google's official systems to ensure your data remains safe and private.

🔍 How Our Secure Verification System Works

Simple & Transparent Process: We verify your YouTube subscription, then provide you with a direct copy of our educational Google Sheet from our Google Drive. No complex downloads, no personal data collection.

1

Google OAuth Authentication
Secure authentication with Google - bank-level security. We never see your password.

2

YouTube Subscription Check
Direct verification with Google's servers - we only get "yes" or "no" response.

3

Server Validation
Our servers validate access and prepare your Google Sheet from our Drive.

4

Instant Sheet Access
Direct link to Google Sheet copy - no downloads, instant access.

🎯 Why This Verification System Exists

⚡

Simplified Access
Instead of complex download procedures, we simply copy our Google Sheet from our Drive to provide you immediate access - no file conversions or complicated setups.

🎁

Value for Subscribers
This system allows us to offer premium educational content as a thank-you to our loyal YouTube subscribers who support our channel.

📚 Official Documentation & Standards:
Google YouTube API Documentation | Google OAuth 2.0 Security | Google Drive API Security

📋 How to Download Source Code

1. Subscribe to Channel: Subscribe to @rameezimdad
2. Sign in with Google: Use the same Gmail account you used for YouTube subscription
3. Verify Subscription: Click "Check Subscription" button below
4. Download: After verification, download button will appear
5. Make a Copy: Go to File → Make a copy in Google Sheets
6. Deploy: Follow the setup instructions below

Step 1: Verify Your Subscription to Access the File

Use the same Gmail account that you used to subscribe to the YouTube channel.

For Customized Google Sheet & Appscript Project

✨ We Deliver Quality Solutions | 100% Satisfaction Guaranteed | Trusted by 1000+ Clients Worldwide

💬 WhatsApp Us for Custom Projects

Step 2: Verify Your Subscription

We'll check if you're subscribed to @rameezimdad channel.

✅ Verification successful! Your Google Sheet is ready for download.

⚙️ Quick Setup Guide

1

Download the Google Sheet above

2

Open Google Sheets and go to File → Make a copy

3

Go to Extensions → Apps Script

4

Click Deploy → New deployment

5

Select type: Web app

6

Execute as: Me

7

Who has access: Anyone

8

Click Deploy and authorize

9

Copy the web app URL and test it

🔧 How to Change Sheet ID and Folder ID

⚠️ Important: You need to update these IDs in the Apps Script code to make it work with your own Google Drive files.

📋 Step 1: Get Your Google Sheet ID

1

Open your Google Sheet

2

Look at the URL in your browser
Example: https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms/edit

3

Copy the long ID between /d/ and /edit

1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms

📁 Step 2: Get Your Google Drive Folder ID

1

Open Google Drive and create/open a folder

2

Look at the URL in your browser
Example: https://drive.google.com/drive/folders/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms

3

Copy the long ID after /folders/

1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms

🔧 Step 3: Update the Apps Script Code

1

In your Google Sheet, go to Extensions → Apps Script

2

Find this code in the script editor:

const SHEET_ID = "YOUR_SHEET_ID_HERE";
const FOLDER_ID = "YOUR_FOLDER_ID_HERE";

3

Replace with your actual IDs:

const SHEET_ID = "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms";
const FOLDER_ID = "1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgvE2upms";

4

Save the script (Ctrl + S)

5

Deploy again following the setup steps above

💡 Pro Tip: Make sure your Google Sheet and folder are set to "Anyone with the link can view" for the web app to work properly.

📞 Need Help?

Contact us for custom solutions:

💬 WhatsApp Support 👥 Join Community