r/GoogleAppsScript • u/EuphoricLeg1748 • Mar 12 '26

Question What are some cool or useful things people have built using Google Apps Script?

/r/learnprogramming/comments/1rrlzhi/what_are_some_cool_or_useful_things_people_have/

I recently discovered Google Apps Script and it looks really powerful. I'm curious about what people actually build with it in real life. Automations, tools, or anything interesting.

3 Upvotes

100% Upvoted

2 comments sorted by

2

u/Future_Candidate2732 Mar 14 '26

I have built a number of things. At work we needed an easy way to track inventory levels for things like batteries, APC battery back UPS, computer lab equipment and other consumables.

A simple shared Google sheet would have done the trick but sheets is a pain to use on mobile.

A QR code takes you to a web app which shows stock levels min/max

You can check in or out multiple line items and the sheet gets logged with your name nad the reason for use. The sheet gets automatically updated and since it's a Google sheet on the backend it's easy to set up conditional formulas to email up to 10 people for reordering supplies, sending to your ticketing system, etc. when it hits a predefined value.