I’m sharing this because I needed it myself and I keep seeing the same question on here. A row gets added to the sheet, by hand, from a form or from another app, and nobody knows about it until they open the app. Bots don’t fire on changes made outside the app, and AppSheet’s own push needs the AppSheet app installed on each phone. So I built something that sends a proper push notification straight from the sheet, and it’s free.
It’s called Push from sheet. You copy a Google Sheet, and its own Apps Script sends a notification to phones and computers whenever a row is added, whether that’s by hand, a form, another script or your AppSheet app. It all runs in your own Google account. There’s no subscription, no paid service and no server of your own to run. The sign-up page sits on your own free Firebase project.
How it works
- Copy the sheet, paste your Firebase project address in, and run Push from sheet › Set up. It takes about a minute.
- Send the sign-up link or QR code to whoever needs the notifications. On iPhone they add it to the Home Screen first; on Android and computers they just tap Turn on.
- Tick them in on the Devices tab.
- Add a row and it pops up with that row’s words. You pick which columns make the title and message, and you can choose who gets it and what link it opens.
For AppSheet: set “Making an AppSheet app?” to Yes. Your tab gets moved to the front so AppSheet builds the app from it, and every row saved in the app pushes within a few seconds.
What’s going on under the hood
- The script makes its own keys and signs every push itself (Web Push, VAPID). Apps Script has nothing built in for this, so the maths is written in plain JavaScript.
- The words are encrypted for each device, so Apple’s or Google’s push service delivers them but can’t read them.
- A change trigger picks up new rows from anywhere, and a backup check catches anything that gets missed.
- It has 441 automated tests, written before the code.
What I’ve tested: iPhone (including after sitting idle for 12 hours), Android, and Chrome and Safari on Mac, plus a fresh account setting it up from scratch. I haven’t tried Windows, Firefox or Google Workspace business accounts yet, and on those an admin might block it.
Good to know: anyone who can add a row can send a notification, so only let people you trust add rows. A row sent with the 30-second typing wait uses about half a minute of Google’s 90 minutes a day of free script time. With the wait turned off it’s a few seconds.
Credit where it’s due: sending Web Push from Apps Script isn’t new. Plenty of people have built it into their own apps, and there are examples listed on the GitHub page. Mathieu_Matek’s Chrome extension (built on Rifad’s) does desktop alerts for AppSheet too. What I’ve done is package it up so anyone can copy one sheet and set it up.
@Jose_Arteaga, I think this one fits Tips & Tricks as well, but my account still can’t post there. Could you move it if you agree?
My account is still new here, so I’ve left the links out for now: the copy link for the sheet and the code on GitHub. I’ve asked the moderators to check it, and I’ll add the links as soon as they’re happy. If you’d like to try it before then, the GitHub repo is sheet-works/push-from-sheet.


