Verify all permissions granted in a Google Sheet script

The following Google Apps Script code is designed to check that a user has approved all required permissions/scopes before trying to run some of your code bound to a Google Sheet file. This is somewhat in response to Google rolling out Granular OAuth consent which creates confusion for end users and additional work for developers.

You tell the function which scopes are required in order for the tool to run effectively and it will verify that the user has accepted all of them before then running the rest of your code.

Screenshot of popup informing user they are missing some permission

Bulk assign Google AI licences without the Admin Console

The following Google Apps Script is designed to automate the assigning of a Google AI licence e.g. "Google AI Pro for Education" in the Google Admin Console, for individual accounts/users via a Google Sheet. The code also adds them to a particular Google Group which was used in this context to control access to Google AI Studio.

You can refer to the Google product and SKU IDs webpage if you need to assign a different licence type. There is no initial checking to see if they have an existing licence or are already in the Group, instead a try/catch is used to collate any failed users.

Snippet of code for bulk assigning AI licences

Append Sheet data to a Doc with varying Table sizes

The following Google Apps Script is a slight variation of my post on bulk creating Google Docs from Google Sheet data.

This time I was looking to work with Sheet data where students would get a mark for each module they completed, but not all students completed the same number of modules. I wanted to translate this information into a table in a Doc, one row per module, and avoid empty rows.

So I ultimately went from a table with a header row and one more row for the first module mark (because everybody completed at least one), to having the Apps Script check for any further module results and then appending a new table row to add them.

Granular OAuth consent in Google Workspace Add-ons

At the beginning of 2026 Google started to roll out granular OAuth consent for Workspace Add-ons with the view that it would improve the choice for end users when selecting permissions to run automated script. Unfortunately as end users are not typically aware of the inner workings of Google Apps Script (why would they?) the result is that sometimes they do not select all of the necessary permissions for an Add-on to function correctly when installing.

This leads to additional work for developers to handle enquiries and provide resources/instruction to overcome the issue. It can also result in reduced installations of an Add-on or negative feedback about it not working.

Google Form - cleanse question titles

The following Google Apps Script provides a way to help clean data submitted by a Google Form (via an 'onFormSubmit' trigger), specifically the question titles. We typically use the question titles in our Apps Script code to extract the specific values we want e.g. email address, name, etc. Doing so locks us into ensuring we copy the relevant question title explicitly as it is written in the Form, such as any upper/lower case characters and trailing whitespace. Any deviation from this and the automation will no longer work.

This specific piece of Apps Script has been created so that it can be easily dropped into the beginning of your existing code, to set the Form question titles all to lowercase and to remove any whitespace around them.

Google Form - cleanse question titles sample code

Publish a Google Form to your domain

The following Google Apps Script is designed to publish a Google Form to your domain only, for completion.

Screenshot of code for publishing a Google Form

Get Google Form file upload links into a Google Doc

The following Google Apps Script aims to provide one way to solve the difficulty of passing Google Form data into a Google Doc, after the Form has been submitted, where you have a file upload question and you want a nice accessible link putting in the Google Doc rather than the long (unclickable) URL.

I have a specific blog post which focusses more upon the process of creating Google Docs from a Form submission.

Google Doc with Form data and accessible file links

Collate and organise a large Sheet of data

The following Google Apps Script is designed to organise a large Google Sheet of data into a specific category and then populate a Google Sheet template file with it. In this example our main data consists of these columns:

• URLs
• Last Update Time
• Creator Email
• Owner Email
• Incompatibility Reason

We want to organise the jumbled data so that we gather together all the rows of the same Owner Email address and pop these into a separate Google Sheet, which is then shared ('edit' access). Repeating this process for the next unique Owner Email address.

Collate and organise a Sheet of data by Owner Email