In this video, I’ll be showing you an awesome Google Apps Script Web App I’ve built that simplifies the process of secure code distribution, OTP-based logins, and usage tracking. If you’re looking to share files or code snippets (such as embed videos, direct download links, or code libraries) but also need to control who downloads what and how many times, this web app is perfect for you!
What This Web App Can Do:
1. Login & OTP Verification
- Users can log in with their email and password.
- An OTP (One-Time Password) can be automatically sent to the user’s email for additional security.
- The app supports OTP bypass if the user logs in again within 7 days (or a timeframe you specify).
2. Usage Limit Management
- Each user has a specific download limit.
- The app keeps track of how many downloads a user has used.
- If they reach their usage limit, the app will deny further downloads unless they upgrade or extend their limit.
3. IP Address & Security Checks
- The user’s IP address is recorded to ensure only one device/IP address is used at a time.
- If there’s an IP mismatch, the user must either change their IP or contact admin.
4. Record & Display Login History
- Detailed login history (timestamp, IP address, actions) is saved in a Google Sheet.
- Users can view their own login history in a neat modal window.
5. Forgot Password & Change Password Flows
- Users can reset their password with an OTP-based flow.
- They can also easily change their password from within the app.
6. Sheet-Based Data Retrieval
- The application pulls code/video links from multiple sheets, giving you flexibility to organize content by category, subcategory, etc.
- Search filters let you easily find the right content based on sheet, category, or subcategory.
7. Tailwind CSS & SweetAlert2 UI
- The interface uses Tailwind CSS for a modern, responsive look.
- SweetAlert2 provides user-friendly and attractive popup messages.
Why You’ll Love It:
- No extra dependencies except for standard Google Apps Script, HTML, CSS (Tailwind), and some simple JavaScript libraries (SweetAlert2, jQuery, Select2).
- Perfect if you want to securely distribute premium content or manage membership without paying for external services.
- Fully customizable—change the layout, design, and rules directly in the script.
| Step | Instructions |
|---|---|
| Step 1 | Open the web app link provided. |
| Step 2 |
If you see a Google Sheet in view-only mode:
|
| Step 3 |
If you see a page with two options (Make a Copy and AppScript File):
|
| Step 4 | Follow the on-screen instructions to complete the setup. |
| Step 5 | Click on the Extensions menu at the top of the Google Sheet. |
| Step 6 | Select Apps Script from the dropdown menu. |
| Step 7 | In the Apps Script editor, click on the Deploy button. |
| Step 8 | Select New deployment from the dropdown menu. |
| Step 9 | In the deployment configuration, click on Select type and choose Web app. |
| Step 10 | Fill in the required fields and click on Deploy. |
| Step 11 | Grant the necessary permissions when prompted. |
| Step 12 | Once deployed, copy the web app URL provided. |