Google Apps Script

Many of my Google Apps Script posts have two purposes:

As a tutorial to help you learn how to code with Google Apps Script.
As a template that can be quickly modified for your own purposes.

Posts || Courses & Projects || Links & References || Tools || Hire

Posts

You can access the majority of the posts from the sidebar or search using the search box.

Setup Google Apps Script Word Completion in Sublime Text

Code,Google Apps ScriptApps Script,clasp,Google apps script

CLASPALL – Update Multiple Apps Script Projects From a Single Source

Code,Google Apps Scriptclasp,Google apps script

Prevent consecutive clicks of a Google Sheet Image Button with Lock Service

Prevent consecutive clicks of Google Sheets Image Buttons in with Lock Service and Google Apps Script

CacheService,LockServiceGoogle apps script,Google Apps Script CacheService,Google Apps Script LockService,Google Apps Script SpreadsheetApp

Static Chart inside a Google Workspace Addon

Adding Charts to Google Workspace Add-on Sidebar Apps with Apps Script

Card Service,Charts API,Google Apps Script,UtilitiesGoogle Apps Script CardService,Google Apps Script Charts API,Google Apps Script Utilities Service

Automatically add email to adjacent cell of checkbox in Google Sheets with Apps Script

Add the Editor’s Email when they Tick the Check Box in Google Sheets with Apps Script

Code,Google Apps Script,Sheets,TriggersGoogle apps script,Google Apps Script SpreadsheetApp,Google Apps Script Triggers,JS find,onEdit

Create Webhooks for Google Chat App In Apps Script

Creating Webhooks for Google Chat App with Apps Script

Chat Apps,Code,Google Apps Script,UrlFetchAppGoogle apps script,Google Apps Script UrlFetchApp,Google Chat,Google Chat Apps,Webhooks

add date and time to a google sheets adjacent cell on edit apps script

Add the Current Date to a Sheet When Data Is Added So That The Date Does Not Change(Static) – Google Sheets (Updated July 2023)

Code,Google Apps Script,Google Sheets,Sheets,TriggersGoogle apps script,Google Sheets,javascript forEach,onEdit,Time

List all files and Folders in a Directory Tree in Google Drive with Apps Script

List all files and folders in a selected folder’s directory tree in Google Drive: Apps Script

Code,Drive API,DriveApp,Google Apps ScriptApps Script,GAS SpreadsheetApp,Google apps script,Google Drive,Google Drive API,JS console time,JS do-while,JS find,JS map,JS While

Chain Story WebApp uisng Google Apps Script and Google Sheets

Creating an embedded interactive Chain Story app with Google Apps Script and Google Sheets

Code,Google Apps Script,HtmlService,Lock Service,Sheets,Web Appflush(),Google apps script,Google Apps Script HtmlService,google.script.run,JS map,JS Trim,Lock Service,SpreadsheetApp

Creating Unique Ranges from 2D Arrays in Google Apps Script

Code,Google Apps Script,SheetsGoogle apps script,Javascript,JS filter,JS flat,JS JSON.parse,JS JSON.stringify,JS map,JS reduce,JS spread syntax,SpreadsheetApp

Add a Signature Block to A Gmail Email with Apps Script

Add the User’s Signature Block to an Automated Gmail Email with Apps Script

Code,Gmail API,Gmail App,Google Apps ScriptGmail API,gmailApp,Google apps script,JS find

Four Digits to Time in Google Sheets with Google Apps Script

Google Apps Script – How to Automatically Generate a Time From a Four Digit 24 hour Time in Google Sheets.

Code,Google Sheets,Sheets,Triggersdata validation,Google apps script,Google Sheets,onEdit

sort tabs in google sheets with apps script

Performance of Google Apps Script Text Finder Class on 2 Approaches to Searching Large Datasets

Code,Google Apps Script,SheetsApps Script,Apps Script Create Finder,Google apps script,Google Apps Script SpreadsheetApp,JS For,JS While

Find 1st Last nth value in a range with Apps Script

Find first, last & nth value in a Google Sheets range with Apps Script

Code,Google Apps Script,SheetsGoogle Apps Script Create Text Finder,Google Apps Script SpreadsheetApp,JavaScript for

Find All Values in Google Sheets with Apps Script

Code,Google Apps Script,SheetsApps Script FindAll,GAS SpreadsheetApp,Google apps script,JS map

Get the creators email of a Google Shared Drive with Apps Script

Get the Creator’s Email of a Shared Drive with Google Apps Script

Drive Activity APIGoogle Drive Activity API,Google Drive API,JavaScript Try Catch,JS JSON.stringify,JS substring

Count occurrences of a selection in a cell Apps Script

Count the Occurrence of a Selection of a Cell in Google Sheets with Apps Script

Code,Google Apps Script,SheetsGAS SpreadsheetApp,Google apps script,JS includes,onEdit

Sort data in google sheets using Google Apps Script

Sort and randomize data in Google Sheets with Apps Script

Code,Google Apps Script,Sheets,UncategorizedGoogle apps script,Google Apps Script SpreadsheetApp

Add a row below the header in Google Sheets with Apps Script

Add a Row of Data Below the Header in Google Sheets with Apps Script

Code,Google Apps Script,Sheets,UncategorizedGoogle apps script,Google Apps Script SpreadsheetApp,Google Sheets Named Range,JavaScript Find,JavaScript length

Build a Currency Converter Chat App with Google Apps Script

Develop a Google Chat App Currency Converter with Google Apps Script

Chat Apps,UrlFetchAppGoogle apps script,Google Apps Script Chat Apps,Google Apps Script UrlFe,Google Chat,Google Chat Apps,Javascript regular expressions

Google Chat Apps for Apps Script Developers

Google Chat Apps for Google Apps Script Developers (updated 2023-11-04)

Chat Apps,Code,Google Apps Script,UncategorizedApps Script,Google apps script,Google Chat Apps

Get Hidden or Visible Google Sheet Tabs with Google Apps Script

Code,Google Apps Script,SheetsGoogle apps script,Google Apps Script SpreadsheetApp,Javascript arrow functions,Javascript concat,javascript reduce

Duplicating Sheet Views in other Sheet Tabs using Google Apps Script

Duplicate Filter Views in Selected Google Sheet Tabs with Google Apps Script

Code,Google Apps Script,Sheets,Sheets Advanced ServiceGoogle apps script,Google Apps Script Sheet API,Google Apps Script SpreadsheetApp,Javascript arrow functions,Javascript Filter,javascript forEach,JavaScript Includes,Javascript map,javascript reduce

Creating Links from Custom Menus and Buttons in Google Sheets with Google Apps Script

Google Apps Script,HtmlService,UI ClassGoogle Apps Script Custom Menus,Google Apps Script HtmlService,Google Apps Script UI class,Google Sheets Buttons

Using Hyperlinks in Dialogs and Sidebars to open a URL in a new Tab with Google Apps Script

DocumentApp,FormApp,Google Apps Script,Sheets,,SlidesApp,UI Class,UncategorizedGoogle apps script,Google Apps Script Dialog,Google Apps Script getUi(),Google Apps Script Sidebar

Run Google Apps Script when setting up a new Google Sheet before revealing other tabs_v2Run Google Apps Script when setting up a new Google Sheet before revealing other tabs_v2

One Approach to Encourage Users to Run Google Sheet-Bound Apps Script When They First Make a Copy of the File

Code,SheetsGoogle apps script,Google Apps Script SpreadsheetApp

How to force subscribe a user in your domain to a Google Calendar with Google Apps Script.

Calendar API,Google Cloud,Service Accounts,Session Class,UrlFetchAppGoogle apps script,Google Apps Script Session Class,Google Apps Script UrlFetchApp,Google Calendar API,Google Service Accounts,Google Workspace Domain Wide Delegation of Authority

How to delete a Google Sheets Button once it is clicked with Google Apps Script

How to remove a Google Sheets button (drawings) or images connected to a Google Apps Script after the script has been run

Google Apps Script,SheetsGAS,Google apps script,Google Apps Script Drawings,Google Apps Script Images,Google Apps Script SpreadsheetApp,JavaScript Find

Import range values from one Google Sheet into another with Google Sheet

Copy and Paste Range Values from one Google Sheet into another with Google Apps Script

Code,Google Apps Script,Sheets,UncategorizedApps Script,Google apps script,Google Apps Script SpreadsheetApp

Append a datetime stamp to google doc elements with google apps script

Append List Items, Paragraphs and table cell items with a date-time stamp in Google Docs using Google Apps Script

Code,DocumentApp,Google Apps ScriptGoogle apps script,Google Apps Script Document App,Javascript,JavaScript computed property names,JavaScript Date,JavaScript Template Literals

my Google Apps Script developer gave me obfuscated code What to do

I hired a Google Apps Script developer and they delivered unreadable code. What’s going on?

Code,Google Apps ScriptGoogle apps script,Google Apps Script Clients,Google Apps Script Developers,Google Workspace

validate users to access a web app with Google Apps Script

How to Validate Specific Users on a Web App in Google Apps Scripts

Code,DriveApp,Google Apps Script,GroupsApp,HtmlService,Uncategorized,Web AppGoogle apps script,Google Apps Script DriveApp,Google Apps Script GroupsApp,Google Apps Script HtmlService,Google Apps Script: Web App,JS forEach,JS includes,JS map

list all users in an organisations google workpsace account with google apps script

List All Users in an Organisation’s Google Workspace Account with Google Apps Script

AdminDirectory,Advanced Google Services,Google Apps Script,UncategorizedAdminDirectory,Google apps script,Google Apps Script Admin SDK,Google Apps Script AdminDirectory,Google Apps Script Advanced Services,Google Apps Script Intermediate,Google Workspace

Get a list of Google Shared Drives by ID and Name in Google Apps Script [updated 16 Dec 2022]

Drive API,Google Apps Script,UncategorizedGoogle apps script,Google Apps Script Drive API,Google Apps Script Shared Drives,Google Workspace Shared Drives

Google Apps Script GWAO File Picker Title

Create a Google Workspace Add-on file picker card with CardService that opens a Google Picker in an overlay window – Google Apps Script

Card Service,Code,Gmail API,Google Apps Script,Google Picker,PropertiesServiceGoogle apps script,Google Apps Script CardService,Google Apps Script PropertiesService,Google Cloud Platform (GCP),Google Picker

Find and replace text with a link in Google Apps Script using DocumentApp

How to find and replace text in a Google Doc with a link or a list of links with Google Apps Script

DocumentApp,Google Apps ScriptApps Script,DocumentApp,DocumentApp Links,Google apps script,Google Apps Script Document App

Google Apps Script custom auto email response on form submit

How to Create a Custom Email Auto-responder for a Google Forms Submission with Google Apps Script (Updated Feb 2022)

FormApp,Gmail API,MailApp,UncategorizedApps Script,FormApp,Gmail API,Google apps script,Google Forms,JS indexOf,JS substring,MailApp

Add weekly time triggers in date range in Google Apps Script

How to programmatically schedule weekly time triggers between two dates in Google Apps Script

ScriptApp,TriggersClockTriggerBuilder,GAS,Google apps script,JS Date,JS destructuring,JS forEach,JS spread syntax,ScriptApp,Time Triggers

how to change your Google Apps Script project time zone

Help! My time triggers are not in sync! : How to update your Google Apps Script project time zone.

Code,Google Apps Script,Triggers,UncategorizedClock Triggers,Google apps script,Google Apps Script Triggers

Custom Google Forms pre-fills with Google Apps Script

Create custom prefilled Google Forms links in custom emails with Google Apps Script (Updated Feb 2022)

Code,Gmail App,Google Apps Script,Sheets,UncategorizedApps Script,GAS sendMail(),gmailApp,Google apps script,JS Fill,JS forEach,JS replace,SpreadsheetApp

Automatically download google drive files on-click

Automatic download link for non-Google Workspace files in Google Drive

Apps,Google Suite,UncategorizedGoogle Drive,Google Workspace,Google Workspace tools

Custom Table of Contents in Google Sheets

Create a custom automated Table of Contents for your Google Sheets tabs with Google Apps Script (Updated Feb 2022)

Code,Google Apps Script,ScriptAppApps Script,GAS SpreadsheetApp,Google apps script,JS forEach,JS IFFE,JS includes,JS map,JS push,JS Sort

Google Sheets Recipe Template cover image

Use Google Sheets to store your Recipes to automatically change Batch Sizes and Recipe Amount by Weight

Apps,Google SheetsGoogle Sheets,Google Sheets template,Recipe

Google Apps Script Store Unique Key from users on your WebApp

Google Apps Script: Store a Unique User Key from a User Accessing your WebApp [updated Dec 2021]

Google Apps Script,HtmlService,PropertiesService,Session Class,Web AppGAS HtmlService,GAS SessionClass,GAS WebApp,Google apps script,Google Apps Script WebApp,JS Date,JS JSON.parse,JS JSON.stringify

Creating Google Sheets Proper in Javascript

Google Apps Script – Javascript: Emulate the “Proper” Google Sheets Function

Google Apps Script,JavascriptGoogle apps script,Javascript,JS map,JS slice,JS split,JS toLowerCase,JS toUpperCase

Google Apps Script: How to create a basic interactive interface with Web Apps

Google Apps Script,HtmlService,Web AppGoogle apps script,Google Apps Script: HTML Service,Google Apps Script: Web App

Add and remove editors in a Google Sheet with Google Apps Script

Google Apps Script: How to Add and Remove Editors to A Google Sheet with Code (Updated Feb 2022)

Google Apps Script,SheetsGAS,Google apps script,JS forEach,JS Join,JS push,JS template literal,JS Try...Catch,SpreadsheetApp

SPREAD_BYRANGE custom function in Google Sheets

Google Apps Script: 3 Google Sheets Custom Functions to Allocate Items from a Column and Spread Them Out into a New Column N Times (Updated Feb 2022)

Custom Functions,Google Apps ScriptGAS,Google apps script,js every,JS Fill,JS flat,JS forEach,JS isArray,JS slice,JS spread syntax,JS typeOf

Running Google Apps Script for the First Time: What’s with all the Warnings!

Code,Google Apps ScriptGoogle apps script,Google Apps Script Authentication,Google Apps Script scopes

Automated PDF Certificated Creator That Is Emailed to the Attendee Google Apps Script

Google Apps Script: Automated PDF Certificated Creator That Is Emailed to the Attendee (Updated Feb 2022)

Code,DriveApp,Gmail App,Google Apps Script,Google Slides,PropertiesService,Sheets,SlidesAppDriveApp,gmailApp,Google Sheets,Google Slides,PropertiesService,SpreadsheetApp

Google Apps Script: Create multiple versions of a document based on Google Sheet Data and a Google Doc Template (Mail Merge)

DocumentApp,DriveApp,ScriptApp,SheetsGoogle apps script,Google Docs,Google Drive,Google Sheets,Javascript Filter,Javascript Flatmap,javascript forEach,Javascript map

Extract IDs from PDFs and instert into Google Apps Scirpt

Google Apps Script: Extract Specific Data From a PDF and insert it into a Google Sheet (Updated Feb 2022)

Advanced Google Services,Code,DocumentApp,Drive API,DriveApp,Google Apps Script,SheetsDocumentApp,DriveAPI,DriveApp,Google apps script,JS map,JS match,JS regex,regular expressions,SpreasheetApp

Google Apps Script: Upload grades into a Google Classroom Coursework Assignment (Updated Feb 2022)

Classroom,Google Apps Script,SheetsGoogle Classroom,Google Classroom API,Google Sheets,JS forEach,JS map,JS Try...Catch

Get Google Doc Text Based on Reference Characters GAS Header1

Google Apps Script: Get Google Doc Text Based on Reference Characters

Code,DocumentApp,Google Apps Script,JavascriptDocument App,GAS,Google Docs,JS indexOf,JS push,JS set,JS spread syntax,JS substring

Google Apps Script: Add and remove Google Sheets columns based on search array

Google Apps Script: Add and removed Google Sheets columns based on a search array

Code,Google Apps Script,Sheets2d arrays,filter,getRange,includes,Javascript concat,Javascript Filter,Javascript map,javascript reduce,map,matrix,reduce,SpreadsheetApp,V8 engine

Google Apps Script Course – Part 4: 2D Array Data Transformation of Multiple Question Multiple Group Items Data to Total Count of Rating Choices in Google Sheets

Advanced Google Services,Google Apps Script,Javascript,Sheets2d arrays,Google apps script,Google Apps Script course,Google Sheets,Javascript,Javascript concat,Javascript Filter,Javascript map,Javascript pop,Javascript shift,Javascript slice,SpreadsheetApp

Google Apps Script Course – Part 3: 2D Array Data Transformation of Multiple Question Items Data to Total Count of Rating Choices in Google Sheets

Google Apps Script,Sheets2d arrays,code,GAS,Google apps script,Google Apps Script course,Google Sheets,Sheets,SpreadsheetApp

Google Sheets 2d count array with Google Apps Script

Google Apps Script Course – Part 2: 2D Array Data Transformation of Single Question Item Data to Total Count of Rating Choices in Google Sheets

Code,Google Apps Script,Sheets2d arrays,GAS,Google apps script,Google Apps Script course,Google Sheets,SpreadsheetApp

Google Apps Script 2d array transformation of count data in Google Sheets

Google Apps Script Course – Part 1: 2D Array Data Transformation of Single Question Item Data to Total Count of Choices in Google Sheets (Updated Feb 2022)

Google Apps Script,Sheets2d arrays,GAS,Google apps script,Google Apps Script course,SpreadsheetApp

datatransformation course header Google Sheets Google Apps Script

Google Apps Script Course – Intro: 2D Array Data Transformation for Google Sheets

Google Apps Script,Sheets2d arrays,GAS,Google apps script,Google Apps Script course,Google Sheets

expand column data to macth all rows Google Sheets

Google Apps Script: Filling out your column data to match the number of columns in a range

Code,Google Apps Script,Javascript,SheetsGAS,Google apps script,Google Apps Script Tools,map,reduce,SpreadsheetApp

Google Sheets onOpen activate next empty row

How to Automatically Navigate to the First Empty Row in a Google Sheet using Google Apps Script

Google Apps Script,PropertiesService,Sheets2d arrays,Binary Search,getLastRow,getRange,Google Sheets,iteration,PropertiesService,SpreadsheetApp

Google Form Seat Booking and Registeree list

Create a seat booking form with Google Forms, Google Sheets and Google Apps Script

FormApp,Google Apps Script,Google Forms,Google Sheets,Google Sheets Basics,SheetsCOUNTA,filter,GAS,Google apps script,Google Forms,Google Sheets,IFERROR,REGEXMATCH,UNIQUE

force change calendar subscriptions for Google Group members in Google Apps Script

Google Apps Script: How to force subscribe Google Group Members to a Google Calendar for G Suite [Update 06 Apr 2022]

Advanced Google Services,Calendar API,Google Apps ScriptAdminDirectory,Calendar API,G Suite,G Suite Admins,GAS,Google apps script,Google Calendar,GroupsApp

Google Standard Color Palette Picker for Sidebar and Prompt

Google Apps Script: Google Standard Color Palette Picker for Sidebar and Dialog Boxes in Google Sheets, Google Docs and Google Slides (Updated Feb 2022)

Code,Google Apps Script,HtmlService,,UI ClassGAS,Google apps script,Google Apps Script Tools,Google Docs,Google Sheets,Google Slides,onOpen

Google Apps Script: Hexadecimal Color Codes for Google Docs, Sheets and Slides Standard Palette

Code,Google Apps ScriptGoogle apps script,Google Docs,Google Sheets,Google Sheets Colors,Google Slides

Google Apps Script: Create a Select All Checkbox to Tick Checkboxes in Any Desired Range in Google Sheets

Google Apps Script,Sheets,Triggersfilter,GAS,Google apps script,Google Sheets,isChecked,map,onEdit,SpreadsheetApp

Google Apps Script: How to check if there is a Tick Box (Check Box) in a cell or range

Code,Google Apps Script,SheetsGAS,Google apps script,Google Sheets,isChecked

Google Apps Script – URL Fetch JSON data from an API and add it to a Google Sheet – Ripple API example

Google Apps Script,Google Sheets,Google Suite,Sheets,Triggers,UrlFetchAppGAS,Google apps script,Ripple API,SpreadsheetApp,Time Triggers,UrlFetchApp,XRP

Delete rows based on a cell value in Google Sheets with Google Apps Script

Google Apps Script: Delete Rows Based on a Column’s Cell Value in Google Sheet

Code,Google Apps Script,Sheetsfilter,GAS,Google apps script,Google Sheets,iteration

Create a time trigger to run reminder notices in google apps script

Google Apps Scripts: Create Time Triggers to automatically send email task reminders from a Google Sheets check list

Code,Google Apps Script,HtmlService,MailApp,ScriptApp,Triggers,UI Class,UrlFetchAppClockTriggerBuilder,GAS,Google apps script,Google Sheets,ScriptApp,Time Triggers,Triggers

Google Apps Script email remind from Google Sheet The Badger 2

Google Apps Script: Create an HTML email reminder service from Google Sheet data.

Google Apps Script,HtmlService,MailApp,UI Class,UrlFetchApp,UtilitiesGoogle apps script,Google Sheets,HTML Emails,HtmlService,MailApp,onOpen,UrlFetchApp,Utilities

Google Sheets get last row with hidden formulas and checkboxes with GAS

Google Apps Script: Get the last row of a data range when other columns have content like hidden formulas and check boxes [updated Mar 2022]

Code,Google Apps Script,SheetsGAS,getDataRangesheetApp,getLastRow,Google apps script,Google Sheets,SpreadsheetApp

Send Emails and Edit permission from Google Sheet Uniques list with Google Apps Script

Google Apps Script: Send Bulk Emails and Share a Google Sheet with One Button Click

Code,Gmail App,Google Apps Script,Google Sheets,Google Suite,Sheets,UI ClassGAS,gmail,gmailApp,Google apps script,Google Sheets,SpreadsheetApp

Google Apps Script: Basic Beginners Guide to Using Strings in Code

Code,Google Apps Script,JavascriptGAS,Google apps script,Javascript,strings

Reduce selected columns in Google Sheets by unique values in Google Apps Script

Google Apps Script: Getting Selected Google Sheets Columns and Reducing them to a Unique Value Based on a Key Column

Code,Google Apps Script,Sheets3D array,GAS,Google apps script,Google Sheets,SpreadsheetApp

Google Apps Script to Visual Studio Code with Clasp

Working with Google Apps Script in Visual Studio Code using clasp

Code,Google Apps Scriptclasp,GAS,Google apps script,Visual Studio Code

Maintaining Row height in copy and paste in Google Sheets with Google Apps Script

Google Apps Script: Maintain Row Heights When Copying and Pasting Data in Google Sheets

Code,Google Apps Script,SheetsCopying Data,GAS,Google apps script,Google Sheets

Google Apps Script: How to Connect a Button to a Function in Google Sheets [Updated 08 Apr 2022]

Code,Google Apps Script,Sheets,UI Classalert,Google apps script,Google Sheets,ui

Google Apps Script – Why isn’t my add-on showing up in the add-on menu when I test it? (Updated Feb 2022)

Apps,Code,Google Apps Script,Triggersalert,AuthMode,GAS,Google apps script,onOpen

Google Apps Script – When I add a value to a cell in a selected column, I want it to move to another Google Sheet [update Feb 2022]

Google Apps Script,Google Sheets,Sheets,TriggersCopying Data,copyTo,GAS,Google apps script,Google Sheets,onEdit

Google Apps Script – Create Custom Unique IDs in Google Sheets [Update December 2021]

Code,Google Apps Script,Sheets,TriggersGAS,Google apps script,Google Sheets,onEdit,unique ID

Google Apps Script – Adding a Unique ID in a Cell on Edit of an Adjacent Cell Using Time

Google Apps Script,Javascript,Sheets,TriggersGoogle apps script,Google Sheets,Javascript,JS Date,onEdit

Get Sheet Names and Spreadsheet Names: Google Apps Script

Google Apps Script – How to Get the Sheet Name and Spreadsheet Name and add to a Cell on Google Sheets with a Custom Function (Updated Feb 2022)

Code,Custom Functions,Google Apps Script,Google Sheets,SheetsCustom Functions,GAS,Google apps script,Google Sheets

Google Apps Script – Copy Selected Columns in One Sheet and Add Them To The Bottom of Different Selected Columns in Another [updated Feb 2022]

Code,Google Apps Script,SheetsCopying Data,GAS,Google apps script,Google Sheets

Google Apps Script – How to Change the File Name of Non-Native Files like MS Word Docs, PDF’s and Excel files.

Code,DriveApp,Google Apps ScriptDriveApp,file editing,GAS,Google apps script

Google Apps Script: Get File By Name – With Optional Parent Folder Crosscheck

Code,DriveApp,Google Apps ScriptDriveApp,GAS,Google apps script

Google Apps Script – How to make a Custom Function to Use in Google Sheets

Custom Functions,Google Apps Script,Google SheetsCustom Functions,GAS,Google apps script,Spreadsheets

Google Sheets – Random Alphabetic, Random Alphanumeric and Random Alphanumeric + Character Custom Functions (Updated January 2022)

Code,Custom Functions,Google Apps Script,Google Sheets,SheetsCustom Functions,GAS,Google apps script,Spreadsheets

Google Apps Script – How to Find the Folder ID of a Non-Unique Folder Using File Path Names

Code,DriveApp,Google Apps ScriptDriveApp,GAS,Google apps script

Google Apps Script – How to Create Folders in Directories with DriveApp

Code,DriveApp,Google Apps ScriptGAS,Google apps script

Google Apps Script – Getting Input Data From a Dialog Box in Google Sheets (Updated January 2022)

Code,Google Apps Script,HtmlService,Sheets,Triggersdialogs,Google apps script,Google Sheets,HtmlService,onEdit

How to Hide a Row based on a Cell Value in Google Sheets with Filter or Google Apps Script.

Code,Google Apps Script,Google Sheets,Sheets,Triggerscode,GAS,Google Sheets,onEdit,Spreadsheets

Sections to Sheets – Free Google Add-on That Separates Column Sections Into Individual Sheets for Page-by-Page Export or Printing

Apps,Google Apps Script,Google Sheets,GWAOw!Editor Add-ons,Google Sheets,GWAOw,GWAOw Sheets,Spreadsheets

Google Apps Script – Copy and Paste Cells While Retaining Column Width in Google Sheets.

Code,Google Apps Script,Sheetscode,Copying Data,GAS,Google apps script,Google Sheets,Spreadsheets

Google Apps Script – Disable Enable Submit Button in Sidebar

Code,Docs,Google Apps Script,HtmlService,Sheets,Google apps script,Google Docs,Google Sheets,HtmlService,sidebar

Google Apps Script – How to create Javascript and CSS files for a Sidebar Project in Google Apps Script

Code,Docs,Google Apps Script,HtmlService,SheetsGAS,Google apps script,HtmlService,SpreadsheetApp,Spreadsheets

Google Apps Script – How to Alternate Colors in an Ordered List by Column Category.

Code,Google Apps Script,Sheetscode,GAS,Google apps script,Google Sheets,ranges,Spreadsheets

Google Apps Script – Get the Start Row and Length of Each Category in an Ordered Column in Google Sheets

Google Apps Script,SheetsGAS,Google apps script,Google Sheets,ranges,SpreadsheetApp

Set the Paper Size and Orientation in a Doc Using Google Apps Script

Docs,Google Apps Script,SheetsDocumentApp,GAS,Google apps script,Google Docs

How to Get Something from Google Sheets and Display it in the Sidebar in Google Apps Script (Updated January 2022)

Code,Google Apps Script,Google Sheets,HtmlService,Sheets,code,Google apps script,Google Sheets,HtmlService,Spreadsheets

Google Apps Script – Iterating Through Ranges in Sheets the Right and Wrong Way

Code,Google Apps Script,Sheetscode,getDataRange,getLastRow,getRange,Google apps script,Google Sheets,SpreadsheetApp

Spacer – Free Google Add-On That Spaces Rows by Column Category (Updated January 2022)

Apps,Google Apps Script,Google SheetsGoogle Sheets

Can I modify Google Sheets with code? [updated January 2022]

Code,Google Apps Scriptcode,Google apps script,Google Sheets,SpreadsheetApp

No post found

Back to Top

Courses & Projects

Beginner

Building a Data Log in Google Sheets with Google Apps Script – FREE

A beginner Google Apps Script series that progressively develops a data log:
– 1st, we start off with a basic input field to get the hang of appending rows in Google Sheets with Google Apps Script.
– 2nd, We then build a vertical form inside Google Sheets that’s easily readable with by editors.
– 3rd, Next, we move our Google sheet form to the sidebar.

In this series we will walk through:
– appending data.
– validating data.
– creating submit buttons.
– handling deleted formatting and data validation with Apps Script
– Creating a basic sidebar app in Google Sheets
– data validation in Apps Script
– data validation in the Sidebar

https://www.youtube.com/playlist?list=PLSDEbLgMgqvrwnVekQKlrx1Zyi1tUFsyY

Building a Data Log in Google Sheets with Google Apps Script (https://www.youtube.com/playlist?list=PLSDEbLgMgqvrwnVekQKlrx1Zyi1tUFsyY)

2D Array Data Transformation for Google Sheets – FREE

This FREE 4-part course is designed for you to learn how to transform 2-dimensional arrays in Google Apps Script. You will start off with building a Google Apps Script that takes in Google Form response data from a spreadsheet and takes the count of each choice from a question item. It then returns the count data of each choice back to the Google Sheets.

This course then builds of your original code first, modifying the code for a set of rating data and then expands the code to take in multiple question choices and finally multiple groups of respondents.

You will learn how to create new code and then modify and enhance the original code for a new project. You will also get a taste of how to plan your project in a readable and reusable manner.

This course only requires the barest of understanding Javascript and Google Apps Script.

You can start at the Introduction – HERE

Back to Top

Upper Beginner

Webapps basics – FREE

Learn how to create your very own WebApp in Google Apps Script. You will build and modify a number of WebApps as you follow this free tutorial series.

You’ll need a basic understanding of Javascript and Google Apps Script for this course.

Back to Top

Links & References

Websites || Communities || Social

Just a short list of recommended links.

Websites

Google Apps Script Overview: The main overview page for Google Apps Script. It has useful links to courses and how to get started.
Google Apps Script Documentation: Want to know how I learned how to code in Google Apps Script? I set a project and then read the documentation. Google makes its docs really easy to follow. Make sure you bookmark this one.
AppsScriptPulse: An excellent aggregate site pooling together all the great Google Apps Script coding tutorials and guides across the internet. Created by Google Developer Expert, Martin Hawskey.
Ben Collins: A site similar to this one with a tonne of tutorials on Google Apps Script. Ben also provides some exceptional courses FREE and paid. He’s a great guy. Go and show him some love!
Baz Roberts: Another prolific Google Suite and Google Apps Script blogger. Baz has an amazing collection of project-based tutorials that are well worth getting your teeth into. He is also a popular author writing some excellent books on Google Apps Script.
Alice Keeler: Has a number of solid Gooogle Apps Script tutorials with an educator and Google Classroom focus.
Labnol: By the ever-popular Amit Agarwal. An excellent resource for Google Apps Script along with some neat Google Add-ons.
script.gs: A dedicated Google Apps Script fan, Sourabh Choraria’s love for coding in his tutorials is evident and almost equals his passion for lowercase 😄. Get some great perspectives on tying in other APIs with Google Apps Script here too.
MDN Javascript Reference: Google Apps Script is based on Javascript 1.6 along with bits for 1.7 and 1.8 sprinkled in. This means that you can use much of the Javascript documentation to help you to figure out your coding problem. The MDN Javascript Reference is my preferred option for this.
WorkspaceDevs: Google Workspace Developer is a directory of workspace developers who offer to provide support for people working in Google Workspace including Google Sheets, Google Slides, Gmail and Apps Script help. This is another great resource from Sourabh Choraria.

Back to Top of Links

Community

Google Apps Script Community: By far my favourite community to see what people are up to, what issues they are facing and generally feel involved. This community is primarily directed towards Google Apps Script developers. The community discusses Google Apps Script issues and helps each other out on various script integration and best practices. Please don’t try and get “free” code from this group.
Stackoverflow: How did we learn to code before Stackoverflow? I use this site to look up questions already asked to see if I figure out my own problem from there. I really don’t use this site to ask questions and my contributions are limited here.
Git Hub: Git Hub can be a nice place to explore some good examples of other developers working in Google Apps Script. I like to give it a glance once in a while to pick up some style tips and see how different devs tackle a similar problem.

Back to Top of Links

🐐You can support me for free by using this Amazon affiliate link in your next tech purchase :Computers & Stuff! 🐐

Social

You can follow me on: Twitter or Facebook

Twitter: a lot of Google’s lovely people working on Google Apps Script and GSuite product frequent Twitter along with all the Google educators and Google Developer Experts you could ever dream of. The community is strong here and, quite frankly, the nicest bunch of humans on Twitter. Try #GoogleAppsScript, #GSuiteDevs and #Gsuite to search the site.
- GSuite: Google’s GSuite page has some great tips and updates on all things GSuite including some regular Google Sheet tips and gif videos showing new functionality or boosting productivity.
- Google Devs: A little beyond Google Apps Script but Google Devs is the spot to get updates on all Google-related dev stuff.
Youtube
- Yagisanatode: Google Apps Script: This is my Google Apps Script playlist for a few things that are better left to video for explanation.
- Learn Google Spreadsheets: two years and over 50 videos on Google Sheets from this fella. His videos are top quality and his pacing is top-notch.
- Jordan Rhea: A very broad range of Google Apps Script tutorials. Lots of good stuff here. Jordan is easy to follow and has some unique code snippets.
- Totally Unscripted: Google’s regular GSuite developers series. It’s a great way to keep up with what’s happening in the Google dev space.
Facebook
- Google Apps Script: Curated by Alexander Ivanov. It’s a solid community particularly for new peeps getting into Google Apps Script.
Reddit
- Google Apps Script: I confess. I don’t frequent this group. However, it does seem to be an active community with some pretty good support for people troubleshoot their own Google Apps Script issues.

Is there something I missed? Send me a message via my contact form or on Twitter!

Back to Top

Tools

As we mentioned above, many of the tutorials are designed to quickly be incorporated into your own projects. Below is a number of tools I have created or recommend.

Create a Google Workspace Add-on file picker card with CardService that opens a Google Picker in an overlay window – Google Apps Script: There is no out of the box file picker for Google Apps Script’s card services. This is my attempt to solve this problem using googlers Picker API.
Change Colour Theme of the editor: There is just something about having a dark theme that gets me going. When I am working on small projects, I generally just use the Google Apps Script editor. Thank you Jean-Rémi Delteil for creating a Chrome web-app just for that very purpose.

Google Apps Script Editor Color Change

Work on Google Apps Script with your Visual Studio Code editor with CLASP: CLASP allows you to take your Google Apps Script code and run in in your favourite editor. You will be able to update and save your data to your script file from the terminal.
Google Standard Color Palette Picker for Sidebar and Dialog Boxes in Google Sheets, Google Docs and Google Slides: If you are working in the sidebar or a dialogue box and want to be able to access the standard colour array that Google Sheets uses then this is for you.

Google Color array picker

Hexadecimal Color Codes for Google Docs, Sheets and Slides Standard Palette: A quick reference of all the colours in the standard colour array in Google Sheets.
Filling out your column data to match the number of columns in a range in Google Sheet: When you paste into Google Sheets, Google Apps Script requires all rows to be of equal length. This means that we sometimes need to add extra blank columns. to a row. This script will do this for you at the end of your code to ensure that your rows have a consistent length of columns.
Paper size and orientation in Google Apps Script: Set the paper size and orientation in a doc using Google Apps Script.

Back to Top

Hire

Got a more specific problem you need help with, but don’t have the time to develop the skills?

Hire me:

I am occasionally available for projects usually over the June-July-August period. You can contact me: HIRE ME.

Hire A Google Apps Script Legend:

Many of my busy readers have a lot of success hiring freelancers for Google Apps Script projects from Fiverr.

Fiverr’s your best bet to find a skilled Google Apps Script professional to solve your problem quickly and cheaply. *

*The above affiliate links have been carefully researched to get you to what you specifically need. If you decide to click on one of these links it will cost you just the same as going to the site. If you decide to sign up, I just get a little pocket money to help pay for the costs of running this website.

Back to Top