Useful Add-ons

Hi [accessally_user_firstname],

An ‘add-on’ is a little snippet of code that run inside Google Documents, Sheets or Forms. They add functionality in order to perform a certain task. There is a huge (and growing) variety of Add-ons to choose from that perform all sorts of useful functions.

This list has been carefully curated using the following categories:

  • The type of Google document it is used in: Documents, Sheets, or Forms.
  • The audience it is intended for: Office Staff, ICT Leaders, School Leaders, Class Teachers
  • A quick description.
  • Alternatively, you can search for something which will filter the entire list.

Add ons have to be installed and activated before they can work. You can find these useful tools inside the ‘Add Ons Store’ from inside a Doc, Sheet or Form.

To learn more watch this movie or check this presentation on

Clicking any of these icons will launch that item in the Chrome web store for you – make sure you read the description of what it does before installing it.

CategoryFiltercsvFiltercsvFilterCardsContentStringFilter RemindersSet up and organize email reminders from a Spreadsheet Staff, School LeadersEasy calendar reminders Rows and ColumnsAdds multiple rows and columns to your spreadsheet quickly. Staff, School Leaders, ICT LeadersManaging spreadsheets easily Find and ReplaceSearch in values, formulas, notes, hyperlinks in all sheets at once. Staff, School LeadersQuickly finding and replacing data in Sheets. merge in the cloud. Quite powerful and a little more advanced. Staff, School LeadersMail merge. for Google SheetsVERY powerful tool for pulling data from the web and much, much more. Staff, School Leaders, ICT LeadersManaging data import into Sheets. Sheet ManagerAllows you to delete, protect and lock sheets in one go. Staff, School Leaders, ICT LeadersLocking Sheets Event ImporterImports data from one or more Google Calendars into Sheets. Staff, School LeadersImporting calendar data into Sheets. CaseMake changes to the case of text in block selections: uppercase, lowercase, first letter capitals, invert, sentence and title case. Staff, School Leaders, ICT Leaders, Teachers, StudentsFormatting text to FormLimiter - great for signing up for time slots or having students choose topics without doubling up. Staff, School LeadersManaging workshops SheetAllows you to instantly crop the sheet to the data, or the selected region. Staff, School LeadersCrop your Sheets by getting rid of unwanted rows or columns EverywhereVery interesting tool which allows you to connect an Excel spreadsheet to a Google Sheet, so that if you edit either - it synchronises! Staff, School LeadersSynchronising Excel files with Google Sheets. ToolsA set of single-click tools to change case, highlight text, sort tables and lists, change numbers to text, and more. Big time saver! Staff, School Leaders, ICT Leaders, TeachersChanging the case of text in Docs and many more features. AccentsAllows writing in different languages, Māori macrons! Tumeke! Staff, School LeadersWriting using macrons and other symbols - awesome! Notifications for FormsAllows you to send customized email notifications to form respondents. Staff, School LeadersNotifying form respondents RangeAllows you to take a snippet from a spreadsheet and email it to someone. Staff, School LeadersEmailing a snippet from a Sheet to someone ManagerThe all-in-one add-on to manage registrations to multiple events Staff, School LeadersManaging registrations for events. Cabinet by Awesome TableQuickly list all the files of a Google Drive folder in a spreadsheet, and automatically display it in a table view. Staff, School LeadersDisplaying files inside a Drive folder easily Owner ChangeHandy if you wish to change ownership of folders, subfolders and files en masse. ConsoleOffice Staff, School Leaders, ICT LeadersChanging ownership of folders en masse. off a Google Form after a maximum number of responses, at a date and time, or when a spreadsheet cell equals a value. Staff, School Leaders, ICT Leaders, TeachersLimiting sign ups in a Google Form Sheets to CalendarBrilliant for creating mass events in a calendar. Staff, School LeadersSetting up calendar events en masse. permission slips (3 free). Staff, School LeadersOnline signing of permission SheetsMap address or GPS related data and places it onto a Google Map. Staff, School LeadersInstantly mapping location of geographic data ValuesJoins two values together (e.g first and last name). Staff, School LeadersJoining values in different columns together ToolsVery handy add-on which does a whole range of quick clean-up type tasks in spreadsheets (eg. lower/upper case, split cells, text to columns, etc.). Staff, School LeadersQuickly cleaning up data in Sheets (lots of features) PlanningGANTT charts and project planning. Staff, School LeadersProject management DuplicatesQuickly find duplicates in one sheet or in two columns. Move, delete, or highlight the results. Has a number of useful tools. Make your Google Sheets duplicate-free in a flash. Staff, School LeadersRemoving duplicates of data SantaHelps you organize a blind gift distribution among your family, your mates or even your work team. Staff, School LeadersOrganising a fun activity for the team Send for FormsAllows you to send the form results to specified email addresses, with the option to merge with a template. Staff, School LeadersSending form results by email NamesQuickly split full names to several columns with first, middle, last names, titles, and/or post-nominal letters. Staff, School LeadersSplitting values in a Sheet cell some pre-set options which will appeal to some users. Staff, School LeadersQuickly applying a style to a Sheet SheetsGenerates and helps you solve sudoku problems. Staff, School LeadersGenerating sudoku sheets MonkeyAllows you to view your Survey Monkey data in a spreadsheet! Staff, School LeadersViewing Survey Monkey data inside a Sheet Styles for Google SheetsAllows you to set up table styles for sheets. Staff, School LeadersQuickly applying a style to a Sheet your Google calendar as a timesheet. Staff, School LeadersSetting up a timesheet Another Mail MergeWrite your template as a draft in Gmail and insert {{markers}} to reuse data from your spreadsheet and send personalized emails. Staff, School LeadersMail merge. SpreadsheetConvert and email Google Spreadsheets as PDF, Excel or CSV to multiple people. Staff, School LeadersConverting and emailing Google spreadsheets manually or on a recurring schedule. for DocsBrilliant add-on for Docs which allows you to get notifications of changes to documents (or folders) that you specify. Totally brilliant. Staff, School Leaders, ICT Leaders, Teachers, StudentsBeing notified of changes to files or folders. enables you to easily lock a cell or range of cells in a Google Sheet. This is a brilliant tool that gives you a lot more flexibility in how you protect information inside a Google Sheet. Watch the tutorial here Staff, School Leaders, ICT Leaders, TeachersProtect cells immediately after they've been edited. Prevents users editing each other's cells in collaborative sheets. allows you to manage your G Suite domain, 25+ tools and reports to speed up your admin daily work. Achieve most common google apps admin tasks right from Spreadsheet. No need to go on the admin console, just from spreadsheet you can create a users, move user to an OU, create reports to list all groups, all users of an OU, all resources, all Google Sites, etc... ConsoleICT LeadersManaging G Suite administration tasks from a Google Sheet InventoryThis script is for super-admins, to be used on G Suite domains with Chrome Device Management Console licenses -- used to manage Chromebooks. This script allows you to both export and update your Chromebook inventory via a Google Sheet. It enables download and update of the metadata and Organisational Units of enrolled Chrome devices direct from a Google Sheet. ConsoleICT LeadersManaging ChromeBooks using a Google Sheet. you missing the ability to show invisibles in Google Docs? Not any more! Staff, School Leaders, ICT Leaders, Teachers, StudentsShowing invisible characters in Google Docs DeckAmazing formative assessment tool for Google Slides. Turns your slideshows into interactive assessment tools! This add-on allows you to add the magic of formative assessments and interactive questions to your presentations right from Google Slides. Has a range of types of questions you can use: multi-choice, open-ended, drag/drop, tickbox and more! Leaders, Teachers, StudentsInclude formative assessment inside Slideshows! PublisherExcellent tool for creating Docs, Sheets, Slides & PDF from form submissions. Even does approval workflows! Free version creates 100 files/month ( Staff, School Leaders, ICT Leaders, Teachers, StudentsCreate documents, PDF, Sheets & Slides from form submissions. RangerFlexible add-on which allows you to dynamically populate form question choices from a column in a Google Sheet. Supports populate multiple choice, list, checkbox, and grid style question options. Staff, School Leaders, ICT Leaders, Teachers, StudentsAuto-populating Form fields - very useful for RSVPs. ManagerManage RSVPs to events using a sheet, form and provide calendar invites to registrants! Staff, School Leaders, ICT LeadersManaging RSVPs for multiple events using a Google Sheet.

There is something for everyone on this list. If you come across others, you can also submit these to the list for the benefit of other members.

If you find one that will benefit the community that isn’t listed, please submit it here…

Social Sharing General

[accessally_user_firstname], If you’re enjoying, please share it with your friends!

Skip to toolbar