Recommended sites, books, and videos
Here’s a little list of some great sites, books, and videos that are related to Google Apps, Google Apps Script and EdTech in general.
Google Apps Script
This is Google’s official Apps Script site, which contains lists of Apps Script code that you’ll need for your programs. In a lot of cases, it’ll give you example chunks which you can copy and paste right into your program. Bookmark it, you’ll be using it a lot!
This is part of the above site and is where you can find the code related to spreadsheets, which I think is a good place to start learning and practising.
Got stuck? Need someone to help you with your code. This is an amazing place where you can either search for an answer to your coding problem or post a question and the community invariably will post potential solutions. I can’t express how wonderful I think the people who help on these pages are!
As you start learning GAS, you’ll see Bruce’s name pop up everywhere, whether it be one of the books listed below, part of the Google + GAS community, or on his blog. The man is a font of knowledge, and his blog contains a stack of GAS examples, which include the code so you see how he goes about it.
Google Apps Script Recommended Reading and Watching
Here are some books and videos I recommend reading and watching.
Google Sheets Programming
This is the first book I bought, and it’s a great way to start your GAS journey. Focussed on using GAS with spreadsheets, it builds up from simple short programs to more complex ones.
GAS for Beginners
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
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. Here you’ll see how the various parts of GAS come together to produce programs that carry out a complete workflow.
This book I read early on and even though it was above my then knowledge of GAS, it’s full of great examples of GAS code, which you can use and experiment with. 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 have still found this a very useful book. I’ve since gone back and reread it and it continues to be a great help.
Google Apps Script videos
I think it’s wonderful that Bruce has made videos on GAS, as there is very limited training material out there in video format. I’ve not watched this video but based on the video below, I have no doubt this would be an excellent place to start learning Apps Script.
If you already know some GAS or other programming languages, then possibly this video is for you. It covers all the main areas of GAS and jammed packed with examples and how to get the best out of Apps Script.
I also recommend joining the Google+ communities on Google Apps, Drive, and GAS. They are full of wonderful ideas and there is always someone who is willing to help you with a problem you may have using these. Here are the links:
GSuite / Google Apps
Google Apps Script
Totally unscripted – Broadcasts where the experts in the field share new things that are happening in the world of Apps Script and also usage ideas.
Follow my Google + Collection Learning Google Apps Script for tips, examples and ideas on how to use GAS with Google Apps