[jamesrwhite]

Over the past year I've been working on Check Sheet in my spare time which is an add-on for Google Sheets. It lets you define rules or "checks" for your spreadsheet and will then send you a notification when they match via Email, Slack or Teams. Google used to have a similar thing built in directly but decided to remove it, there still seems to be demand for such a thing so I've been working on something that adds that functionality back.

The add-on runs primarily in Google's Apps Script environment which is essentially like Lambda/Cloud Functions although it's been around for way longer. In terms of the tech stack the frontend is a fairly simple Vue app and the backend is written in TypeScript. Apps Script is quite restrictive in terms of some of the quotas and limitations they apply so over time I've moved some of the logic and data out into Firestore and Cloud Functions.

You can install it for free on the marketplace: https://workspace.google.com/marketplace/app/check_sheet_not...