NChatSheets is a lightweight, serverless, and highly responsive instant chat platform that leverages a personal Google Sheet as its secure database. By utilizing Google Apps Script as a web app API backend, this application eliminates the need for complex, costly backend server configurations, providing a fully functional chat room experience right inside your browser.
🤖 AI-Enhanced Development Notice: The visual identity, responsive layout, and modern dark-mode UI/UX design of this platform were developed and polished with the assistance of advanced Artificial Intelligence models to ensure a seamless, high-end user experience.
- 📊 Google Sheets as a Serverless Database: Forget spinning up heavy SQL databases. Your chat logs are stored row-by-row in a standard spreadsheet that you own completely.
- 🔒 Absolute Data Sovereignty & Security: Because the application connects directly to your personal Google Sheet via a Google Apps Script Web App URL, no third-party intermediaries ever touch, harvest, or monitor your conversations. You hold the ultimate key to your data.
- 🕵️♂️ Anonymous Chatting Capabilities: Users can participate fully without invasive sign-ups, email verifications, or identity tracking. You can chat under any alias or remain fully anonymous.
- 🎭 Customizable Avatars: Express yourself uniquely in the chat room by choosing from a rich set of pre-configured, fun emojis and customizable profile identities.
- ⚙️ Dual Operational Modes:
- Live Google Sheets Mode: Connects to your live spreadsheet deployment for persistent real-time global messaging.
- Local Sandbox Mode: A built-in simulator that uses mock data so you can test and preview the application interface instantly without any technical setup.
- 🎨 Modern, Premium UI/UX: A highly responsive, sleek dark-themed interface built using Tailwind CSS, featuring rich interactive components, glassmorphism aesthetics, live toast notifications, and skeleton loader shimmers.
The web application communicates directly with your Google account through a serverless API flow:
- Frontend Interface: Built with native HTML5, modular CSS3 transitions, and vanilla JavaScript optimized for handling application state.
- API Endpoint (Google Apps Script): Acts as a secure middleware layer deployed within your Google Drive that translates incoming
GETandPOSTrequests into spreadsheet actions. - Database Layer (Google Sheets): Appends chat text, timestamps, channel identifiers, and avatar parameters directly into rows in real time.
- Create a new, empty Google Sheet.
- Name the columns in the first row exactly as follows:
Timestamp|Username|Channel|Message|Avatar
- In your Google Sheet, navigate to Extensions > Apps Script.
- Replace the default script boilerplate with a script configured to handle standard HTTP requests (
doGetanddoPost) to write data into the sheet rows. - Click Deploy > New Deployment.
- Set the type to Web App.
- Change Execute as to Me (your email) and Who has access to Anyone.
- Click Deploy, authorize the necessary Google permissions, and copy the generated Web App URL.
If you want to use the application immediately without downloading any source files, you can access the live hosted version directly through the web: 👉 Launch NChatSheets Web Application (Click Here)
- Click the online link above to open the application in your browser.
- Open the Configuration Modal (gear icon) inside the top right corner of the chat UI.
- Toggle the mode selector to Live Google Sheets Mode.
- Paste your copied Google Apps Script Web App URL from Step 2 into the configuration field.
- Click Apply and start chatting instantly!
- Download or clone this project repository to your local machine.
- Navigate to the project root folder and open the
index.htmlfile directly in any modern web browser (Chrome, Edge, Firefox, or Safari). - Open the Configuration Modal within the chat UI.
- Toggle the mode to Live Google Sheets Mode and input your Web App URL.
- Click Apply to sync and connect your local workspace to the cloud database.
This project is fully open-source and built to demonstrate creative engineering options for serverless applications. You are completely free to fork this project, modify the script algorithms, optimize the styling components, or build upon the architecture to fit your own specific needs.
Feel free to download, refactor, and experiment with it as an educational playground or production prototype!
- Developer / Creator: Open Source Community Contribution
- UI/UX Design: Augmented and generated via advanced AI assistance.
This software is released without any license restrictions. It resides entirely in the public domain and is completely free to be used, distributed, commercialized, or rewritten by anyone, anywhere, for any purpose.