Here’s a little list of some great sites to visit that are related to Google Apps, Google Apps Script and EdTech in general.
Alice posts about a whole range of topics relating to the classroom, but in particular, has some great posts about Google Apps and Google Apps Script use.
A wonderful site full of lots of EdTech ideas. A lot of Eric’s posts focus on how you can use the various tools to make enjoyable and interesting classes.
Ben’s site focuses mainly on Google Sheets and Google Apps Script, and is full of really useful ways these can be used to make things a lot easier and better.
GSuite Updates Blog
Keep up-to-date with the latest changes and improvements to the GSuite.
Some great posts on how Google Apps can be used. I recommend subscribing to their newsletter.
I particularly like this post on how Google Apps can transform your classroom.
Blog full of ideas on using Google Apps.
Blog focussing on Google Sheets with ideas of how to use it better.
This site is full of really detailed Excel tips, which in many cases, can be transferred to Google Sheets. It also has a section on Google Sheets Add-ons.
Google Apps Script
Google Apps Script site
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!
GAS Reference – Spreadsheet
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!
Desktop Liberation – Bruce McPherson
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
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.
This starts from the basics and covers various uses of GAS, including with Sheets, Forms, Emails, Docs, and some web applications improving the UI.
Personally, I think this is a better book than the one above and is 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.
I’ve only read parts of this one but it seems to be a stage higher than the previous two books. It’s rammed with information and example code.
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 didn’t know anything about VBA and have still found this a very useful book, which I think I will go back and read!
I’ve not watched these, but I think it’s wonderful that Bruce has made videos on GAS, as there is very limited training material out there in video format. Looking at the content, the first one is clearly the one you should start with, or if you already know some GAS or other programming languages, then possibly the second is for you.
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. Interesting, even though sometimes it’s way above what I’m capable of doing with GAS at the moment.