Here’s a list of apps script resources, sites, people, communities, books and videos I’ve found useful whilst learning Google Apps Script. For the latest on what is happening with Apps Script and for getting ideas on how to use it, I would definitely recommend following the people in the People section below.
developers.google.com
https://developers.google.com/apps-script/
This is Google’s official Apps Script site, with information on how to use Apps Script along with examples. Plus, it is where you can find a complete reference, which explains how the services, classes and methods work, including chunks of code you can copy and paste. It also includes more advanced areas, like creating your own Workspace Add-on and using the APIs.
https://developers.google.com/apps-script/reference
Direct link to the reference section. On the left you will finds the links to the different Google Workspace services, such as the Spreadsheet one.
People
A list of some of the best people out there to learn all about Google Workspace and Apps Script.
- Specialises in Google Sheets and Apps Script
- A wealth of information on Google Sheets and Apps Script
- Video courses as well as blog posts (see Videos section)
- Loads of practical Apps Script tutorials which go into great detail
- Plus, there are Google Sheet tutorials
Amit Agarwal
- Site full of Apps Script and Google Sheet tutorials
- He’s also the creator of some wonderful Workspace add-ons
- Regularly shares Apps Script posts
- Posts mainly in Spanish, but if don’t speak Spanish, don’t let that put you off, there’s a goldmine of knowledge here
- A whole host of Apps Script posts covering a range of topics
- Also, set up the workspacedevs.com site – see further down
- Regularly blogs on Google Workspace and Apps Script
- Founder of “Saperis” through which she offers online courses and video tutorials
Aryan Irani
www.youtube.com/channel/UCUFg_uOw6t61eu5TSV7txaQ
- Lots of practical videos and posts on Google Workspace and Apps Script
Mozart
www.youtube.com/channel/UCZUOyadcadiZ1KseDCNc-Cg
- Lots of videos on how to use Apps Script
- In Spanish – but non-speakers I would still check them out, just change the subtitles to English π
Phil Bainbridge
- Site full of practical Apps Script tutorials
Bruce McPherson
www.youtube.com/c/BruceMcpherson
- A massive amount of Apps Script posts here
- One of the legends in the Apps Script community
Alice Keeler
alicekeeler.com/scripts/apps-script-tutorials
- Loads of posts on both Apps Script and Google Workspace focusing on their use in education
Laura Taylor
- Regularly blogs on Workspace and Apps Script
Andrea Leardini
- Blog on Google Workspace and Apps Script
- In Italian – But just translate the page if you don’t speak Italian
Alexander Ivanov
- Apps Script and Google Sheet posts (in Russian)
Nick Young
- Posts on Apps Script
- Check out his Apps Script repositories on GitHub
Communities
The Google Apps Script community have set up a Google Group. Here, youβll be able to share news, ask questions, etc.
AppsScriptInfo
- Wonderful curated collection of Apps Script posts and resources
- Subscribe so you get the latest info straight to your inbox
Developers
- A great list of Google Workspace developers created by Sourabh
- Great to see a wide-range of experience and backgrounds on the list
Totally unscripted
sites.google.com/view/totallyunscripted/home
Broadcasts where the experts in the field share new things that are happening in the world of Apps Script and new ways to use it.
Books
There aren’t many books on the topic of Google Apps Script (apart from my own π ) but here are some I used when first learning Apps Script.
Google Apps Script for Beginners β Serge Gabet
This starts from the basics and covers various uses of GAS, including with Sheets, Forms, Emails, Docs, and some web applications improving the UI.
Learning Google Apps Script β Ramalingam Ganapathy
Personally, I think this is a better book than the GAS for beginners and it takes you further. It covers areas like creating elements, emails, forms, calendar, RSS feeds, workflows, Add-ons.
The idea of the book is for those coming from a VBA background, but I donβt think that does the book justice, as I donβt know anything about VBA and still found this a very useful book.
Note, the above book links are affiliate links, meaning I receive a few pennies if you decide to buy them after clicking on the links.
Videos
There aren’t a massive amount of video courses out there for Apps Script, but here’s a selection of the best ones.
Ben Collins
Ben currently offers two:
- Free introductory course
- Paid course which focusses on automating Google Sheets and connecting it to other services like Google Calendar, Docs and Mail. It also takes you into the wonderful world of APIs.
Learn Google Spreadsheets
www.youtube.com/c/LearnGoogleSpreadsheets/videos
- Excellent videos on using Apps Script as well as Google Sheet ones
Laurence Svekis
Laurence has produced numerous videos on Udemy on Google Apps Script and on Javascript. A great place to start your learning and even if you already know some Apps Script.
Here are a selection of the courses he has on Udemy:
Google Apps Script Complete Course β Beginner to Advanced
Google Script Create Google Docs on the fly from templates
Form Submission Application using Google Suite Google Script
Get Google Sheets as JSON data for web applications
Quick JavaScript Core learning Course JavaScript Essentials
Bruce McPherson
Two excellent video courses:
Google Apps Script for Beginners
Google Apps Script for Developers
JavaScript, HTML, CSS
w3schools
A great place to learn JavaScript, JTML, and CSS. Easy to follow information and which gives you a chance to try code out.
stackoverflow
Got stuck? Chances are someone has already posted a similar question on this site. If not, you can post one and more often than not someone will answer it for you.
codecademy
https://www.codecademy.com/learn/learn-javascript
This site allows you to learn various programming languages by doing. A good place to learn Javascript, HTML, and CSS, and maybe a bit of JQuery.
Want to learn quickly? Check out my short video tips here.
Want to learn more about Google Workspace and Apps Script? The books below are available on Amazon. Just click on a book! (Affiliate links).
a
