Book Creator | Extra Suite - Awesome Add-Ons, Extensions & 3rd Party Products to boost your G Suite experience

Buy Rangathetrainer a Coffee. ko-fi.com/rangathetrainer

Introduction

In my first E-Book, Too Suite, I offered up a range of top tips on G Suite tools for Distance Learning. If you haven't checked it our already you can find it here at bit.ly/TooSuite.

I was blown away by the reception it got and how widely it was appreciated so decided to follow up with this collection of great add-ons, extensions and 3rd parties that I recommend.

I dedicate this book to my wife Claire and my daughter Deryn for putting up with me and my "google friends" on late night video calls.

If you enjoy this book all I ask is that you share it with colleagues, and if you feel inclined, buy me a coffee using the link above. Thank you.

Daren - @Rangathetrainer (part of @GlobalGEG)

CONTENTS

4. Add-Ons
5. Autocrat ( for Sheets with Docs & Slides)
6. FormMule (for Sheets)
7. FormRanger (for Forms & Sheets)
8. FormLimiter (for Forms)
9. Automagical Forms (for Docs, PDFS & Forms)
10. Unsplash (for Slides)
11. Slide Toolbox (for Slides)

12. Extensions
13. Eyedropper
13. Page Marker
14. Dualless
15. Grid View (for Meet)
15. Nod (for Meet)
16. Mute Tab (for Meet)
16. Meet Attendance (for Meet
17. Slides Reveal (for Slides)
18. Talk & Comment (for verbal notes & feedback)
19. Mote (for verbal notes and feedback)

20. 3rd Party Products
21. Bookcreator (for e-books)
22. Screencastify (for recording video & basic editing)
23. WeVideo (for recording & editing video)
24. Flipgrid (for student voice promotion & video)
25. StreamYard (for Live streaming to Youtube or Socials)
26. Wakelet (for collating your resources and more)

What is an Add-on?

Add-ons are extensions developed to improve G Suite productivity in apps such as Gmail, Google Sheets, and Google Forms.

Add-ons add new capabilities to the G Suite applications they work with, help to automate tasks and improve workflow, or make third-party services or information available in G Suite.

Add-ons are built using Apps Script—a development platform based on JavaScript that allows users to create business and productivity applications quickly and easily.

To install Add-ons you head to the tool bar and 'Get Add-Ons'. In some domains, Add-Ons can be restricted.

Autocrat - for Sheets with Docs & Slides

Autocrat is a merge add-on in Google Sheets that works brilliantly for mail merge and general creating of documents in Docs or Slides.

Jobs are created based on column headers and <<tags>> in the destination template and can be automated on the submission of a Form or on a time trigger.

The generated document can be an editable Doc or Slide or a PDF.
Perfect for certificates!!
Watch how here >>>>>>>>

FormMule for Forms and Sheets

FormMule comes from the same stable as Autocrat and is perfect for generating emails and alerts from a Google Sheet.

I use FormMule all the time
to generate alerts and notifications
for work flows and it's super easy.

Like Autocrat, it works from your Sheets column headers, matching the headers to tags.

You can set your job to run on certain conditions based on cell values.

Another bonus is that you can easily send from a no reply email address. Just set up your template using the tags pulled through by the Add-on.

Like Autocrat the send can be triggered by submission or setting a time.

Get FormMule here

FormRanger for Forms & Sheets

Form Ranger is a great tool for pulling data into Google Forms for drop-down or multiple choice questions. Also from New Visions Cloud Lab it enables you to import a range of data from a Sheet column. What's more, it updates live.

Unlike its sibling Add-ons, Form Ranger adds to the form, not the sheet. Just select the question and the source for Form Ranger to do its magic.

To populate, you choose your source sheet, tab and column. Then sit back and watch Form Ranger pull in your class or year roster, staff list or any other range of data that you may want people to select.

Form Ranger is a huge time saver for teachers and admin staff as many Forms can be populated from the same sheet and range. Update in one place, update in all!

FormLimiter for Forms

FormLimiter automatically tells Google Forms to stop accepting responses after a determined numberofresponses, at a specific date and time, or when a cell in Sheets contains a specified value.

This Add-on is perfect for club sign-ups, arranging meetings or places on school visits.

You can set a custom message that users will see when trying to submit a form after the limit has been reached.

Again, another great time and work saver from New Visions Cloud Lab.