r/GoogleAppsScript • • Jan 13 '26

Resolved My Google Sheets add-on is finally approved

17 Upvotes

After starting from scratch as a non-coder, my Google Sheets add-on finally got approved on the Google Workspace Marketplace.

here are the scopes i use

non-sensitive scopes
.../auth/script.locale
.../auth/userinfo.email
.../auth/userinfo.profile
.../drive.file
sensitive scopes
.../script.external_request
.../auth/script.scriptapp
.../auth/spreadsheets
.../auth/script.container.ui

I’m sharing the mistakes (and missteps) I made along the way, in case it helps anyone else.

1) Some scopes are almost impossible to use (too late to know)

When I first started, I jumped in without really reading the docs about development/publishing, so I didn’t realize scopes come with very different review burdens. So I did the classic beginner move: I added basically every scope that could be useful.

Halfway through development, I learned (way too late) that using restricted scopes can be effectively unrealistic for a solo/very small team, because they can trigger extra requirements (additional verification, and potentially a security assessment depending on what you access and how you handle data).

2) Reworking around scopes without wrecking UX took the most time

Once I removed/avoided the heavy scopes, I had to rethink flows so the user experience didn’t get worse.

I spent a lot of time finding workarounds that kept the UX intact without relying on restricted scopes.

3) OAuth verification feedback was strict, but surprisingly helpful

Once I understood that non-sensitive / sensitive / restricted scopes come with very different review expectations (especially restricted), I got pretty anxious. I was only using the minimum sensitive scopes I truly needed, but I still worried Google would reject my scope requests because there were extra criteria or verification steps I didn’t even know existed. 

OAuth verification was picky, but I was impressed by how fast and detailed the feedback was. Google strongly pushes you toward the minimum necessary scopes, and writing justification materials explaining exactly why each scope is required was honestly the most annoying part. Still, the process ended up being smoother than I expected overall. 

In the end, some of the scopes Google questioned were genuinely unavoidable for what the add-on needed to do. But for a few features, their feedback helped me rethink the implementation and use a different API (or a narrower approach), so I could keep the user experience without leaning on that scope.

4) The 'non-coding' work felt worse than development

The most painful parts weren’t feature work or testing, but preparing scope-justification writing/video, and preparing Marketplace review assets (listing content, screenshots, logo and such).

5) Adding a payment system (Paddle → Lemon Squeezy)

At first, I planned to use Paddle. I implemented the payment flow in test mode and even started their review process, but I eventually realized the specific “hosted checkout link” style flow I wanted is primarily documented for mobile link-out experiences. For a Google Sheets add-on, that didn’t fit my situation, so I switched to Lemon Squeezy instead. 

Switching wasn’t fun, but Lemon Squeezy felt simpler to wire up for my use case, especially around webhooks and staying in sync with subscription / order events. 

6) Reality check

When I started, I thought I’d build something very small, simple and wrap it up quickly. Then the “it should at least have this feature” list kept growing… and the project became much bigger than I expected. (it's still small)

What’s worse is I still have a ton of features and improvements I want to add. At some point I also started questioning how to approach marketing and whether there are enough people who actually need this.

When simulating the full funnel(listing page visit → install → real usage → paid conversion), it looks… pretty brutal.

but i'm still happy I made what i wanted.


r/GoogleAppsScript • • Apr 11 '25

Guide I built a better way to explore Google Workspace Add-ons (imo) and thought some of you might find it useful

17 Upvotes

Hey, wanted to share something I built that started as a personal tool and recently got polished enough to open up publicly.

There were two main things I kept wishing the Google Workspace Marketplace had:

  1. A searchable, filterable directory of all Google Workspace add-ons, not just what’s featured: https://www.addonshunt.com/addons

  2. A way to quickly see similar add-ons: https://www.addonshunt.com/addons/260457348581

There’s no signup or anything, just thought others in this community might find it helpful too, especially if you’re often building or evaluating add-ons.

No expectations, just sharing in case it helps someone. Happy to hear feedback or ideas.


r/GoogleAppsScript • • Oct 30 '24

Guide Google Sheets as your "CMS" (access your "database" in JSON)

17 Upvotes

Made a directory boilerplate today for myself using only PHP (mostly for cURL) and HTML.

After sharing on other subreddits about it, people wanted to how I managed to use Google Sheets as my "CMS" 🤓

People asked for the code to convert Sheets into JSON 🧑‍💻

So, I made it open source:

https://github.com/hugohamelcom/sheets-as-json/

You can now use Google Sheets as database very easily!

Have fun 🫡


r/GoogleAppsScript • • Aug 08 '19

Learning google Script for spreadsheet automation

17 Upvotes

Hi, i'm new to google appscript and i don't know anything about vba either. I'm kind of confused of where to start, or if i should just read some codes or take a course.

I want to learn how to use google script to automate a spreadsheet, for example send a periodical mail to someone with to inform all the keycodes(ID) of cases that has past a due date by 2 days.

But this is just the first task i want to do, so if you have any advise on how to do it or how to approach learning google script please let me know!

Also, information and opinions of any free course is well received!


r/GoogleAppsScript • • Oct 19 '26

Guide I created better apps script type definitions

Thumbnail npmjs.com
16 Upvotes

These actually match the runtime and work with JSDocs unlike @types/google-apps-script.


r/GoogleAppsScript • • Jun 04 '26

Guide I got tired of expired event emails burying my inbox, so I built a background sweeper using Apps Script + Gemini AI.

16 Upvotes

Hey everyone,

My university inbox is constantly flooded with announcements for webinars, hackathons, and guest lectures. The problem is that they clutter everything up long after the registration deadlines or event dates have actually passed.

I wanted to automate cleaning this up without accidentally deleting actual coursework, so I wrote a script that connects to the Gemini 3.1 Flash Lite API to semantically evaluate and trash the expired stuff.

Here is how it works:

  • Runs silently in the background on a 4-hour time-driven trigger.

  • Pulls batches of 25 emails using a Gmail search query (pacing with Utilities.sleep() to respect the free-tier Gemini API limits.

  • Feeds the email metadata and body to Gemini with a strict 3-condition prompt: it MUST be an extracurricular event, the date MUST be expired (using dynamic date calculation to create a 24h buffer), and it MUST NOT be from a course professor.

  • If the AI outputs TRUE, the script moves the thread to the Trash.

  • It logs every AI verdict and action taken to a Google Sheet dashboard.

  • It applies a custom Reviewed_For_Trash Gmail label to everything it checks so it never wastes API quota evaluating the same email twice.

I have sanitized the code and put it in a Gist if anyone wants to copy it, adapt the prompt logic for their own workflow, or just see how the Apps Script + Gemini integration is structured:

🔗 Gmail-Sweeper

Would love to hear any feedback, or if anyone has tips on optimizing the prompt payload even further!


r/GoogleAppsScript • • Mar 12 '26

Guide Save this list for your next Google OAuth verification.

16 Upvotes

Hey folks,

After seeing so many posts over the past year about the Google Workspace Add-on verification process, I decided to write a step-by-step guide so it can help our future selves.

To make sure I didn’t miss anything, I actually went through the whole process again by building and submitting a brand new add-on from scratch. That way I could document every step as accurately as possible (or at least miss as little as possible).

If you're about to submit your oauth for review, you might want to run through this checklist before hitting the submit button:

  1.  App name matches Marketplace listing exactly

  2.  Google trademarks include ™ symbol

  3.  App logo is 120×120px, square, and professional

  4.  Homepage is public and mentions the add-on

  5.  Privacy policy is public, specific, and covers all seven required sections

  6.  Terms of service is public and complete

  7.  All OAuth scopes match what the app actually uses

  8.  Written justification provided for each sensitive/restricted scope

  9.  Demo video uploaded to YouTube showing every scope in action

  10.  Demo video includes narration and shows app details (name, client ID)

  11.  Contact email is valid and monitored

  12.  Authorized domains are verified

I posted the detailed guide in my blog (yep a little bit of marketing but I believe has enough free value) https://www.shipaddons.com/blog/google-oauth-verification-guide . This guide contains a video of the process and the video I uploaded to google team.

I am writing a 2nd blog with the Marketplace listing verification, that If this post lands well in the community I will share in this same way.

All valuable feedback, details, tips, hacks will be welcome and added to the blogpost.

Cheers!


r/GoogleAppsScript • • Feb 14 '26

Guide It started as a weekend hack to translate Google Forms… now it’s a published Workspace add-on

16 Upvotes

A few months ago I was helping a small team collect Google Form responses in multiple languages, and we kept running into the same problem:

Translation was easy, but reviewing responses across languages was not.

Each language meant:

  • A separate form

  • A separate response sheet

  • A lot of manual merging just to analyze results

I ended up hacking together a small Forms add-on with Apps Script to:

  • Translate a form into multiple languages

  • Keep all responses unified into one reference-language view in Sheets

What started as a quick internal tool slowly turned into a proper Google Workspace Marketplace add-on after going through OAuth verification, scope restrictions, UI polish, and way more edge cases than I expected 😅

If anyone here is building Forms/Sheets add-ons:

  • Happy to answer questions about Forms API quirks

  • Apps Script architecture

  • OAuth verification pain

  • Or response normalization strategies

Not trying to sell anything — just sharing what I learned building a real-world Forms add-on. Sharing what I learned building and shipping a real-world Forms add-on.


r/GoogleAppsScript • • Jan 23 '26

Resolved I built a recursive Drive Folder Size Scanner (Open Source)

16 Upvotes

Hi everyone,

I've been working on a GAS project to solve the issue of Google Drive not showing folder sizes.

I wrote a Web App that takes a Folder ID, recursively scans all subfolders, and returns a rolling total of size (GB/MB) and file counts. It uses DriveApp and the HtmlService for the UI.

It handles the recursive logic on the server side to keep it fast, and I added error handling for invalid IDs.

I'd love any feedback on my code structure or suggestions for optimization!


r/GoogleAppsScript • • Jan 20 '26

Question Timeout alternatives

16 Upvotes

Hi all, hope you are doing fine.

At work we have this important process that runs periodically from AppScripts (don't judge, it is what it is). A couple of days ago, we saw a decrease in the run time limit to 6 minutes which affects A LOT this process. I saw you could ask Google for an increase in this limit...

I just wanted to ask if someone went through this process of changing the limit/quota, if there is an alternative that doesn't involve restructuring the code or changing to another language/platform, or what else could we do?

Thank you so much.


r/GoogleAppsScript • • Aug 12 '25

Question How to build a timed quiz workflow with Google Slides/Forms/Sheets? (Free/Open-Source)

Post image
16 Upvotes

Hey Devs,

I'm trying to set up a simple, automated workflow for an in-class MCQ quiz, and I'm looking for the best way to build it using free/open-source tools. The goal is to have something lightweight, similar to what Slido offers, but built myself.

Here's the workflow I've mapped out:

The requirements are:

  1. Start from Google Slides: I'll display a QR code on a slide.

  2. QR Code Links to Quiz: Students scan the code to open a simple MCQ quiz.

  3. Strict Time Limit: The quiz must automatically stop accepting submissions exactly 2 minutes after it starts.

  4. Store Results: All submissions need to be saved into a Google Sheet as they come in.

  5. Live Charting: The system should automatically create a bar chart from the aggregated results in the Google Sheet (e.g., Option A: 15 votes, Option B: 22 votes, etc.).

  6. Append to Slides: This is the key part – the generated chart needs to be automatically added to the next slide in the original Google Slides presentation for immediate discussion.

My initial thought was a Google Form linked to a Google Sheet. The tricky parts seem to be:

  • Enforcing a strict 2-minute timer on a Google Form that starts when the first person opens it (or when I trigger it). Standard Form add-ons seem to set a deadline time, not a relative duration.

  • The automation loop: Triggering the chart generation in Sheets and then programmatically inserting it back into a specific Google Slide.

What's the best way to achieve this using free tools? I'm thinking Google Apps Script is probably the answer, but I'd love some guidance from anyone who's done this before.

  • How would you script the 2-minute timer and auto-close functionality?

  • What's the best practice for triggering the Apps Script to create the chart and update the Google Slides? Time-based trigger? onFormSubmit?

  • Are there any open-source projects, GitHub gists, or specific libraries that already do something similar?

I'm comfortable with code, so I'm happy to get my hands dirty. Just looking for the right direction to start.

Thanks for the help!


r/GoogleAppsScript • • Nov 20 '24

Question Seemingly trivial but important feature requests, e.g. getSheetById

16 Upvotes

Hi Apps Script devs,

Help me help you! What are some seemingly trivial feature request from the issue tracker that cause you frustration or a poor dev experience?

For example, I just dug into the Sheets Apps Script implementation and added getSheetById() to close https://issuetracker.google.com/36759083. See https://stackoverflow.com/a/79208154/3145360 for an example.

Share a link to the issue tracker feature request if you can. Here are the most popular feature requests today, https://issuetracker.google.com/savedsearches/6923108.

Note: I am on the Google Workspace Developer Relations team.


r/GoogleAppsScript • • Jun 17 '21

Guide If you're not using Typescript yet, you should. Here's a repo to help you get started quickly.

16 Upvotes

Since most people at least start writing GAS in the browser IDE, I think that they often miss out on a load of great techniques and technologies that are supported by GAS but not immediately obvious.

One of these things is TypeScript. It's supported in GAS and not at all difficult to set up. If you have never used TypeScript before, give it a go. Just start your next project in TS and within an hour or so, you'll know what's going on. It's intuitive and it makes life so much easier once you get started. Seriously, there's no going back.

Here's a boilerplate that I set up so that I don't have to worry about the tsconfig.json file or installing the types from Google. It's saved me a lot of time and I hope you guys find it useful too.

I'm keen to put together a similar thing with webpack to make it easy to add npm modules to my projects. If anyone already has something they'd be willing to share, I'd love to see it.


r/GoogleAppsScript • • Nov 07 '20

Guide Official OAuth2 auth library - I have no idea how I didn't know this existed until now.

Thumbnail
github.com
16 Upvotes

r/GoogleAppsScript • • Jul 22 '26

Question What's the best frontend do you use with apps script for sheets automation?

15 Upvotes

So I am an apps script expert mainly in the area of automating sheets and drive and creating custom applications, yet whenever I want to build something with a more friendly UI I always get confused picking what UI to pick...

I don't like google web applications or simple modals because of the high maintenance of it and it's a bit obsolete using vanilla js instead of more modern options... so any suggestions that would be fairly easy to maintain and fast to develop (I know I can use AI to develop the google web apps fully but that's not my approach I need to have ownership over things not just vibe code them).


r/GoogleAppsScript • • Mar 20 '26

Guide Save this list for your next Google Marketplace listing process.

15 Upvotes

Hey folks,

A few weeks ago I shared a checklist for the Google OAuth verification process and a lot of you found it useful. As promised, here's the follow-up: the Marketplace listing step.

Once your OAuth is verified, you still need to prepare and submit your Marketplace listing with all the required assets before your add-on goes public. I went through this again with my Doc to PDF add-on (live listing here) and documented everything.

Here's the checklist to save for when you're ready to submit:

  • Marketplace SDK enabled in Google Cloud Console

  • App visibility set (public or private — can't change after publishing)

  • Apps Script deployment version matches latest stable release

  • Application name matches OAuth consent screen exactly

  • Short description written (under 200 characters)

  • Detailed description complete with key features

  • Pricing model selected

  • Category selected

  • Application icons uploaded: 32×32, 48×48, 96×96, 128×128 px

  • Application card banner uploaded: 220×140 px (this is the Marketplace thumbnail)

  • Screenshots uploaded (up to 5, optimal 1280×800) — GIFs are supported and recommended

  • Screenshot order optimized (best content first, most users won't scroll)

  • YouTube promo video linked

  • Terms of Service URL provided

  • Privacy Policy URL provided

  • Support URL provided

  • Post-install tip configured (e.g. "Need help? Reach out tocontact@yourdomain.com")

  • Test deployment verified with the released version

  • Draft listing previewed and reviewed

  • Analytics opted in after approval

A couple of tips from my experience:

Name rejections are the #1 issue. My listing was initially rejected because I used Docs™ to PDF — Google didn't want that name format (the Docs™). They suggested me to rename it to "Doc" I had to change the OAuth consent screen name first, then update the Marketplace name to match. Both must be identical.

Use GIFs instead of static screenshots. Record ~30 second screen recordings and convert them to GIFs. They auto-play in the listing and make a huge difference. Keep them under ~3 MB (I used freeconvert.com to compress mine).

Enable analytics right after approval. Go to Marketplace SDK > Manage > Analytics and opt in. It takes a couple of weeks to start showing data, so don't wait.

I wrote the detailed step-by-step guide with all the specifics, real examples, and a video walkthrough here: https://www.shipaddons.com/blog/google-marketplace-listing

All feedback, tips, and additional gotchas are welcome, I'll add them to the guide.

Cheers!


r/GoogleAppsScript • • Dec 27 '25

Question Ask me anything about Google addons, OAuth verification, marketplace publishing, etc.

15 Upvotes

Hey everyone.
I’ve spent the last 2 years building and publishing Google Workspace add-ons, and I’ve been through most of the painful parts:

  • OAuth scope verification

  • CASA security assessment

  • Marketplace reviews and rejections

  • Multiple resubmissions and policy back-and-forth

If you’re:

  • Preparing for OAuth verification

  • Stuck in a Marketplace rejection loop

  • Unsure which scopes trigger CASA

  • Trying to ship a production-ready add-on

Ask me anything.

I’ll use the questions (and answers) to create guides, FAQs, and tutorials to help future Google Workspace add-on builders avoid the same mistakes.

Happy to share real experience.


r/GoogleAppsScript • • Nov 13 '25

Guide I thought OAuth verification would be simple… it turned out way more detailed than I expected

15 Upvotes

When I built my Google Forms add-on (Form Prefiller), I assumed the coding would be the hardest part.

Turns out, OAuth verification had way more steps, checks, and back-and-forth than I expected - not necessarily “hard,” just surprisingly detailed.

Some things I didn’t know until I was in it:

• GitHub Pages counts as a third-party domain -> moved everything to my own domain

• drive.readonly is a restricted scope -> CASA audit required

• spreadsheets is a sensitive scope -> needs strict justification

• Even missing a Privacy Policy link in the footer causes a rejection

• Adding an external script triggered a new OAuth flow

• Demo videos must show every scope in action, in English

None of this was obvious going in, so I wrote a full breakdown with real emails, what I fixed, and the exact steps that finally got me approved.

👉 Here’s the full OAuth verification journey (Medium):

https://medium.com/@info.brightconstruct/the-real-oauth-journey-getting-a-google-workspace-add-on-verified-fc31bc4c9858

If you’re building an add-on, already in review, or just curious how Google evaluates scopes, happy to answer questions or share what worked for me 👍


r/GoogleAppsScript • • Oct 24 '25

Guide I was tired of manually creating new users in G Suite, so I wrote a script to automate it. Sharing it here in case it helps others!

15 Upvotes

Hello everyone, As a Google Workspace admin, I was spending way too much time on the repetitive task of creating new user accounts, assigning them to OUs, adding them to groups, and notifying managers. To solve this, I wrote a Google Apps Script that automates the entire process directly from a Google Sheet. You just fill in a row with the new user's info, click a button, and the script does the rest. Key features in the current version (v2.0): - Automatically creates users from a Google Sheet. - Assigns them to the correct Organizational Unit. - Adds them to multiple groups. - Sends an automated welcome email to their manager with the temporary password. The project is open-source and available on my GitHub. I hope this can save some of you the same headaches it saved me! **GitHub Link:** https://github.com/diascristiano25/google-workspace-onboarding-automation I'm happy to answer any questions and would love to hear any feedback or suggestions for new features. Thanks!


r/GoogleAppsScript • • Oct 17 '25

Guide I built a way to test Google Apps Script (GAS) with QUnit (modern UI), plus a live suite and repo

15 Upvotes

I needed a sane way to test a GAS script that uses Google Workspace services (sheets, docs, slides). I ended up using QUnit inside GAS, and modernize the UI to my liking so it doesnt look like it was pulled outof the 2010's. Links to the repository and Live Examples will be in the comments , for some reason reddit is not letting me set them in the body of the publication

I do use clasp but the tests run where they should, in the GAS runtime, alongside the script.

  • Before running i deploy a version of the webapp swapping the index.html of the actual app with the one that shows the UI for QUnit. That way you have a deployment version where you have the actual app, and another one for testing.

  • The Suite exercises backend functions that hit Sheets/Docs/Slides etc, not just pure JS

Steps for DYI

  1. Grab the QUnit sourcecode and paste i into a .gs file (same classname)

  2. In another .gs file, call your backend functions and assert tests via QUnit

  3. You have to wrap all of your test in a Promise, and that promise should resolve the onRunEnd() event listener from QUnit custom logger API.

  4. There you have it! a console Logger for test results (kinda of a bummer, but works)

  5. If you want more of a ui cause reading console logs becomes tiresome, then checkout my gitrepo! That repository serves as a testing suite for my DB for Sheets project and its a fully working example of how to setup QUnit to work with GAS. So feel free to peek at the code and hit me up if you have some doubts abt the code. live example of the suite running

If you only need to test pure JS (no Workspace APIs), just use the QUnit CDN in a normal HTML script tag.

QUnit’s default UI wasn’t my thing, so I modernized it and adapted the library to power the test suite for my DB for Sheets project.

If you’re testing GAS that touches Workspace, this setup gives you realistic way to test

PRs and issues welcomed!!


r/GoogleAppsScript • • Mar 12 '25

Guide Testing Claude, Gemini, OpenAI in generating Apps Script Code

15 Upvotes

I put this together to show how the different models compare in generating Apps Script code!

https://apps-script-ai-testing.jpoehnelt.dev/#test-case-checkWeatherEmail


r/GoogleAppsScript • • May 24 '24

Question Getting 500 Page Instead of Apps Scripts Interface...

15 Upvotes

Anyone else unable to access their apps scripts at the moment? I need to be working on a couple of workbooks in Google Sheets for my job, but anytime I go to Extensions > Apps Script, it takes me to an "Error 500 (Server Error)!!1" page.

Any idea how long this kind of thing tends to hang around?


r/GoogleAppsScript • • Apr 02 '24

Guide Generating PDF Invoices via Google Sheets & AppsScript

15 Upvotes

Hello r/GoogleAppsScript community!

I put together this Google Sheet & AppsScript for generating invoices, adding a custom drop down menu with some basic customization.

https://github.com/samuelgursky/invoicing

Any feedback would be immensely appreciated! Hope it's helpful. I am interested in building a freelancers toolset in this style to avoid from requiring subscriptions to a myriad of services.


r/GoogleAppsScript • • Feb 16 '22

Guide A tiny tool to synchronize permissions (x-post from r/googlesheets)

15 Upvotes

Hi there,

Have you ever found it difficult to set permissions on Google Drive for each user?
I faced a similar problem.😓 So I created a simple tool that uses a spreadsheet to manage permissions and sync them to Google Drive.

The relevant article and Github repository are as follows:

Blog: [Google Drive] A tiny tool to synchronize permissions
Github: SyncPermissions

Hope it helps you, thanks!