What are some cool or useful things people have built using Google Apps Script?
Posted by EuphoricLeg1748@reddit | learnprogramming | View on Reddit | 8 comments
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.
ar92ldm@reddit
Automate a lightweight CRM for a small service company.
sudheerpaaniyur@reddit
Could you please explain
Single_Camera_2124@reddit
Found this setup on iOS to easily track your expenses for free, save them in a Google Sheet and display Monthly totals in an iOS widget, all for free.
It does require a bit of work to start with but afterwards it just works and it's an alternative to expense tracking apps. It could be adapted for Android as well.
Anyhow here's the link:
https://medium.com/@aspiringwriter001/how-i-track-my-finances-step-by-step-guide-to-build-your-own-free-expense-tracking-system-1ba03a11afed
AppropriateRecipe685@reddit
I built the Lyric Feedback Service using GAS.
AppropriateRecipe685@reddit
Should have mentioned too that it’s a pretty ambitious project. It utilizes a Google form to take in lyrics. Automatically bills the songwriter via PayPal. System automatically polls PayPal API for paid orders. Submits orders that have been paid to AI API asking for 16 separate analyses. Automatically produces and emails the report (about 20 pages) as a pdf to the songwriter. It uses three separate Google scripts interacting with one another and has taken about a year and a half to do. It runs itself. I don’t have to do a thing.
SpreadsheetMemo@reddit
Another example
https://www.reddit.com/r/SpreadsheetMemo/
Google Apps Script is indeed really powerful.
AggressiveCover2873@reddit
Purchase-to-fulfillment process integration for brand-owned garment factory (32 employees currently) handling customized and mass orders, whitout any need of a factory manager as all ressources and tasks are allocated optimally and dashboards fully show the current workload and performance of the factory on an individual level.
RealMadHouse@reddit
I was using it to automate repetitive task in google sheets.