More

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 Keeler

alicekeeler.com

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.

Eric Curts

www.controlaltachieve.com/

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 Collins

www.benlcollins.com

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

gsuiteupdates.googleblog.com/

Keep up-to-date with the latest changes and improvements to the GSuite.

BetterCloud

www.bettercloud.com/monitor/g-suite/

Some great posts on how Google Apps can be used. I recommend subscribing to their newsletter.

Academiaapps

www.academiaapps.com/google-apps-classroom/

I particularly like this post on how Google Apps can transform your classroom.

Prolific Oaktree

www.prolificoaktree.com

Blog full of ideas on using Google Apps.

Sheets Help

sheetshelp.com

Blog focussing on Google Sheets with ideas of how to use it better.

Ablebits

Ablebits.com

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

Here’s a list of sites, books and videos I’ve found useful whilst learning Google Apps Script and also Javascript.

Google Apps Script site

developers.google.com/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!

GAS Reference – Spreadsheet

developers.google.com/apps-script/reference/spreadsheet/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.

Stackoverflow

stackoverflow.com

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

http://ramblings.mcpher.com/Home/excelquirks/gassnips

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.

W3Schools

http://www.w3schools.com/js/

When I first started learning GAS, I discovered that it uses Javascript, and to learn GAS well you really need to have a sound knowledge of the Javascript basics. The W3Schools site covers all sorts of programming languages, but I highly recommend taking the time to read through the Javascript entries and try out the challenges it sets, to get a good idea of how it works. It’s then useful in the future as a reference, as most parts contain example code so you know who to use it.

Codecademy

https://www.codecademy.com/learn/learn-javascript

This site allows you to learn various programming languages by doing. Each part there is a challenge where you have to write or edit code, to be able to pass on to the next section. Bit by bit this builds up your Javascript knowledge.

Google Apps Script Recommended Reading and Watching

Google Sheets Programming with Google Apps Script – Michael Maguire

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.

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 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.

Google Apps Script – James Ferreira

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.

Going GAS – Bruce McPherson

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!

Google Apps Script for Beginners – Video – Bruce McPherson

Google Apps Script for Developers – Video – Bruce McPherson

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.


Google+ Communities

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

GSuite for Education

Google for Education

Google Docs and Drive

Google Docs Tips

Google Apps Script

Google Apps Script

Apps Scripts for Education – Builders and Users

Apps Scripts for Education – Beginning builders

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.