How to make Dynamic Realtime Firebase Crud web app | E1

📄 Get Free Google Sheet Source Code

📺 Watch Tutorial Video

📋 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

🔒 Security & Verification Process

🛡️ 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.

🔐 What We Do & What We DON'T Do

✅ What We DO

• Verify subscription only
• Use Google's official APIs
• Protect your privacy
• Serve from Google Drive

❌ What We DON'T Do

• Store personal data
• Access private info
• Share with third parties
• Track your activity

🎯 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

🤝 Our Commitment to You: We operate with complete transparency, use only official Google services, and prioritize your security above all else. Our system is designed to be as secure as Google's own applications, because we use their exact same security infrastructure.

🔐 Download Source Code

Step 1: Sign in with Google

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

Need help or having issues?

💬 Get Help via WhatsApp

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