Sheets Archives | The Efficient Teacher

Automatically authorise the Importrange function

Learn how to use Google Apps Script to automate allowing permission for the IMPORTRANGE function in Google Sheets.

Learn how to generate personalised student reports using mail merge in Word and then automate sending them home to parents using Apps Script

A full script example to show sharing a list of YouTube channels (e.g. vetted subject-specific ones) and automating subscribing to each.

Write data from your script to a range of cells on a sheet.

Read data from a range of cells on a sheet, ready for your script to process.

Add your own menu to Sheets (or Docs, Slides or Forms) to run functions in your script.