Need a customized project? We build it to your exact requirements.Contact us on WhatsApp

Free Chat App with Seen Ticks – Google Apps Script

C17 Chat & Messaging Premium Plan Weekly Plan VIP Premium Plan
❤️
Need a Custom Business Solution?
Connect with us on WhatsApp to discuss your requirements. Our team will design and develop a tailored software solution aligned with your business workflow, operational needs, and growth objectives.
Chat Web App Using Google Sheet & Appscript | C17
You get
  • Google Sheet link
  • Source code file
  • Resale rights
  • Edit rights
  • Setup guide
  • AI setup help

Key Features

Signup with username password email phone address and photo Duplicate username check at signup Single tick for sent and double blue tick for seen Green and red indicator for online and offline users Timestamp on every message Email alert when a new message arrives Email notification on login Admin can allow or block any account Blocked account told clearly it has been blocked Restriction sheet stopping one user messaging another Editable profile with photo and online status User list with search Login and signup history log Profile images stored in your Google Drive

Description

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.

Messaging

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.

Email in the loop

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.

Control over who talks to whom

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.

Requirements

  • A Google account (Gmail or Google Workspace)
  • Google Sheets, Google Drive and Google Apps Script
  • A Drive folder ID for profile images pasted into the script
  • Deployment access set to Anyone with the link
  • A modern browser (Chrome, Edge, Firefox or Safari)

What's Included

  • Complete Google Apps Script source code
  • Chat front-end with signup, profile and user list
  • Google Sheets structure for users, messages, access and restrictions
  • Message and login email templates
  • Step-by-step video walkthrough of the setup
  • Free support from the developer

Item Details

Versionv1.0
PublishedAug 22, 2025
PlatformGoogle Apps Script
DatabaseGoogle Sheets
CategoryChat & Messaging
Tagsgoogle apps script chat appchat app apps scriptfree chat app source codechat application google sheetsreal time chat applicationlive chat app source codechat app with seen tickschat app admin block users
VideoWatch walkthrough
LicenseRegular License
Subscription Verification Required
This is a free file. Subscribe to our YouTube channel to unlock the source code + Google Sheet. One click — no payment. Google only confirms you are subscribed.
Verify Now
Free download

Subscribe & Unlock Source Code

Subscribe on YouTube, then verify with one click. No payment, no card. Google is used only to confirm your subscription.

What you get

  • Code.gs + HTML filesThe complete Apps Script project
  • Google SheetYour own copy with the data
  • Setup guideInstall steps from start to finish

Not subscribed yet? Subscribe to our channel

Browse More Free Files

Need This Customized For Your Business?

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.

400+
Projects Delivered
91+
Countries Served

What We Customize

Features & Functions
Add new features, modify existing scripts, custom formulas & automations
API & Integrations
Connect with WhatsApp, Payment Gateways, CRM & more
Design & UI Changes
Custom branding, layout redesign, dark mode, mobile optimization
Full Custom Projects
Dashboards, billing systems, inventory, CRM — built from scratch
Get Free Quote on WhatsApp

20-30% advance to start • Clear quote before work begins • Support included after delivery

Free
Source Code File

People choose these

Paid picks from the same category

How to Build Realtime Chat Messaging App Using Appscript & Google sheet | B14 How to Build Realtime Chat Messaging App Using Appscript & Google sheet | B14 26 views this month Apps Script Chat Web App Using Google Sheet & Appscript V2 | C18 Chat Web App Using Google Sheet & Appscript V2 | C18 26 views this month Apps Script Chat Web Application with Connections Request using Google Sheet & Appscript | C29 Chat Web Application with Connections Request using Google Sheet & Appscript | C29 28 views this month Apps Script

Reviews & Feedback

What buyers and viewers say about Chat Web App Using Google Sheet & Appscript | C17.

No star ratings yet Tap a star to be the first to rate it.
9 comments from
YouTube viewers
Sort
@graphicshacker7333 via YouTube
I am your old subscriber and watch all videos from your 1st video... welldone and keep it up ❤
@DurvishJawaleOfficial via YouTube
Well done Keep it up
@Akstudy4gk via YouTube
Bhai iska charge kya hai
@Prabh_hundal_01 via YouTube
Want how to add custom domain with apps script project without embedding it in I frame
@rex.aditya via YouTube
I m your old subscriber.. fantastic work .. Aditya from India ❤
@khanjan12 via YouTube
Ap aik course bnye ye ap knse language use krty hn muji blikul smaj nhe arha hn ye Jo script ap bnty hn
@tusharmishra2518 via YouTube
Please share the code on git because all time after clicking Copy the code it is showing *Dashboard for YouTube Users* Anyways great work ❤❤
@BotFire-s7i via YouTube
GOOD one i also implemented but without much features try
@likhanlpc3807 via YouTube
Good work sir