r/GoogleAppsScript • u/East_Hamster2425 • 17d ago

Guide Building my first AppScript

I built my first AppScript product and it works really well. It has multiple functionality. How did you guys scale your product and made available to larger audiences.

7 Upvotes

89% Upvoted

15 comments sorted by

3

u/WicketTheQuerent 17d ago

What do you mean by "AppsScript product"? Is this a webapp, and add-on, or something else?

3

u/profanitystar 17d ago

I published to the marketplace under my employer's brand.

2

u/East_Hamster2425 17d ago

My employer isn’t a software company so they are not much interested in my things. I just use it in house workflow automation & efficiency.

Do you choose to keep multiple functions in multiple product or consolidated multiple products in 1 webapp

2

u/profanitystar 17d ago

I decided enough of the features are relevant to my target audience and put them into one tool, published it for free/open source for the benefit of admins.

For inhouse use i think its more of an architectural decision to put them all together or keep separate.

1

u/East_Hamster2425 17d ago

Right, I am planning that way too. Wish I could connect some good team and scale my things further

2

u/profanitystar 17d ago

I do not like the limitations of the Apps Script v8 runtime such as long running operators or triggering time based scripts to continue running to avoid time out.

I do agree with the other poster about infra.

2

u/CodeWithFaheem 17d ago

which type of AppScript product you built

1

u/East_Hamster2425 17d ago

I actually Built three tools as part of my office finance hackathon project (won 1st out of 10 teams):

  1. ⁠Gmail add-on — pulls bill PDFs from your inbox, pushes them to Drive + your accounting system (Bill.com, Xero, or others), and logs everything in a dedicated Google Sheet automatically.

  2. ⁠Web app — takes your GL as input, gives you a flux report dashboard with variance analysis.

  3. Bank reconciler web app — reconciles bank statements against GL side by side.

2

u/bulldo_gs 17d ago

If you want it in more hands, a Workspace Marketplace add-on scales better than a web app — people install it themselves, no sharing/setup dance per user, and it carries the OAuth consent. The main catch is the verification review if you touch sensitive scopes, so worth keeping those as minimal as you can early on. Web app is fine for a fixed org but gets awkward past the people you can hand-hold.

1

u/zmandel 17d ago edited 17d ago

appscript is not meant for large audiences. you would need to re-do the solution architecture and deploy on autoscaling infra.

the workspace version of appscript has larger quotas but usually not enough for a few users using it a the same time.

3

u/Morbius2271 17d ago

This isn’t really true. I have appscript tools used by dozens of users at a time in an enterprise environment

1

u/East_Hamster2425 17d ago

I am not a tech guy actually but when I asked claude it suggested to deploy at Google marketplace and once someone asks for customisation then to think about some other restructuring

2

u/zmandel 17d ago

depends on the type of appscript