A messaging app built on Google Sheets that behaves the way people expect a chat app to behave — ticks that turn blue when the message is read, a green dot when the other person is online, a timestamp on every line — with an admin layer underneath that most chat demos never bother with.
Users sign up themselves with a username, password, email, phone, address and profile picture, and the app refuses a username already taken. Send a message and it shows one tick; when the recipient opens the conversation it becomes a double blue tick. Their avatar carries a green indicator when they are signed in and a red one when they are not, so you know before you type whether anyone is there.
A new message also sends an email alert naming the sender, and logins are emailed too, so the app reaches people who are not sitting in the tab.
An account can be blocked from the admin side, and the next login tells that user plainly that their account has been blocked rather than failing silently. Beyond that, a restrictions sheet pairs a sender with a receiver to forbid that specific conversation — the app refuses the send and says so. Login and signup history is logged, and every user can edit their own profile, photo and online status.
| Version | v1.0 |
| Published | Aug 22, 2025 |
| Platform | Google Apps Script |
| Database | Google Sheets |
| Category | Chat & Messaging |
| Tags | |
| Video | Watch walkthrough |
| License | Regular License |
Subscribe on YouTube, then verify with one click. No payment, no card. Google is used only to confirm your subscription.
What you get
Not subscribed yet? Subscribe to our channel
Extra modules, your branding, integrations or reports built on top of this file. You get a clear quote and timeline before any work starts, and support after delivery.
What We Customize
20-30% advance to start • Clear quote before work begins • Support included after delivery
Paid picks from the same category
What buyers and viewers say about Chat Web App Using Google Sheet & Appscript | C17.