A lightweight authentication system built with Google Apps Script that uses Google Spreadsheet as a database. This project provides a simple but functional login, registration, and session management system that can be quickly deployed as a web app.
- 🔐 User registration with basic validation
- 🔑 Secure login system with password encryption (HMAC-SHA256)
- 📊 Google Spreadsheet as database for user management
- 💾 Session management using Google Apps Script Properties Service
- 📱 Responsive design that works on mobile and desktop
- 🚀 Easy deployment as a Google Web App
Try the live demo: GAS Simple Auth System Demo
- Open this Google Apps Script project (request access if needed)
- Make a copy: File > Make a copy
- Set your encryption key in the
Code.gsfile - Deploy as a web app (Deploy > New deployment > Web App)
- Create a new Google Apps Script project at script.google.com
- Create two files:
Code.gs: Copy the content from Code.gs in this repositoryindex.html: Copy the content from index.html in this repository
- Update the
ENCRYPTION_KEYvariable in theCode.gsfile - Deploy as a web app (Deploy > New deployment > Web App)
See the Installation Guide for detailed step-by-step instructions.
This system provides basic authentication capabilities but has some security limitations:
- Password encryption uses HMAC-SHA256 which is better than plain text but not as secure as bcrypt
- Google Apps Script Properties Service has storage limits for session data
- No CSRF protection is implemented in this basic version
- No rate limiting for login attempts
For production environments, we recommend enhancing the security or using dedicated authentication services.
You can easily customize:
- The visual design by modifying the CSS in
index.html - Form validation rules in the JavaScript code
- User data structure by adding columns to the spreadsheet and updating the code
Contributions are welcome! Feel free to:
- Open issues for bugs or feature requests
- Submit pull requests with improvements
- Share your customizations or extensions
This project is licensed under the MIT License - see the LICENSE file for details.
- Google Apps Script documentation and community
- All contributors and users providing feedback
⭐ If you find this project useful, please consider giving it a star on GitHub! ⭐
