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.
You can access the majority of the posts from the sidebar or search using the search box.
No post found
Courses & Projects
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
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.
You can start at the Introduction – HERE
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.
- Google Apps Script: How to create a basic interactive interface with Web Apps
- Creating an embedded interactive Chain Story app with Google Apps Script and Google Sheets
- Google Apps Script: Store a Unique User Key from a User Accessing your WebApp
Links & References
Just a short list of recommended links.
- 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.
- 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.
- 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.
- 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.
- 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.
- Google Apps Script: Curated by Alexander Ivanov. It’s a solid community particularly for new peeps getting into Google Apps Script.
- 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.
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.
- 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.
- 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.
Got a more specific problem you need help with, but don’t have the time to develop the skills?
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.
*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.