Avi's Script-Enabled Google Templates

Code Repositories

If you want to know more about how each tool works "under the hood", you can view the code here.
This page contains scriptless versions of the Google Sheets/Slides templates. To enable them, you will need to create the file(s) in the Apps Script editor and paste the associated code. You can access the editor in the Extensions menu in Sheets or Slides.

Click on the image to make your own copy of Wordle in Google Sheets (without the script).

Wordle in Google Sheets v2.0: w/categories, by Avi Megiddo & ChatGPT

Wordle in Google Sheets

After making your copy of the Sheet template, you have only the UI and the word lists, but not the code. To enable your copy of the sheet with the Wordle in Google Sheets script, you will need to paste the code from Wordle in Google Sheets v2.0 Code.gs into your Apps Script Editor (click on the 'Extensions' menu to find the Apps Script editor).
Click on the floppy disk icon button(💾 ) to save your script.
Give your project a name, something like "My copy of Avi Megiddo's Wordle in Google Sheets".
Go back to the sheet, and click refresh. You should now see the menu item 'Wordle' appear in the toolbar.
Give Permissions: A window will pop up saying "Google hasn't verified this app." This is expected.
- Click on Advanced.
- Click on Go to EMF Converter (unsafe).
  Note: It's marked unsafe only because it's a custom script and not officially verified by Google. It's safe to proceed.
- Choose your Google account and click Allow to give the necessary permissions. This only has to be done once.
After this, you should be able to run the functions from the 'Wordle' menu bar item that appears.

Student Comment Generator by Avi Megiddo code.gs

Student Comment Generator

To enable the Sheet, you will need to create two files in the app script editor:

Code.gs

After making your own copy of the Sheet template, create the files above in your Apps Script Editor.

Scriptless 3.0 Make Random Orders, Partners, and Groups TEMPLATE by Avi Megiddo

Scriptless Random Orders &
Groups Maker

Version 3.0 Make Random Orders, Partners, Groups + Bad Pairings Code.gs

3.0 Random Orders, Partners, Groups Code.gs

Version 3.0 Make Random Orders, Partners, Groups + EditBadPairsDialog.html

3.0 Make Random Orders, Partners, Groups EditBadPairsDialog.html

Make Random Orders, Partners, Groups

To enable the Sheet, you will need to create two files in the app script editor:

After making your own copy of the Sheet template, create the files above in your Apps Script Editor.

Insert images from Drive Folder

Note: This tool works on a blank Google Slides presentation.

Insert Images from Folder by Avi Megiddo - Code.gs

Insert Images
Code.gs

Insert Images by Avi Megiddo Sidebar.html

Insert Images
Sidebar.html

Insert Images from Drive: auto-center, auto-left, insert/remove text box.

To enable the Slides, you will need to create 2 files in the app script editor:

After making your own copy of the Slides template, create the files above in your Apps Script Editor.

Scriptless Word Search Maker TEMPLATE by Avi Megiddo

Scriptless Word Search Maker Template

Word Search Generator TEMPLATE by Avi Megiddo - Code.gs

Create word-search puzzles
Code.gs

Word Search Maker

To enable the Sheets, you will need to create a file in the app script editor:

Code.gs

After making your own copy of the Sheet template, create the file above in your Apps Script Editor.

Scriptless Single & Double Elimination Brackets - interactive TEMPLATE by Avi Megiddo

Scriptless Tournament Brackets Manager

Single & Double Elimination Brackets TEMPLATE code.gs by Avi Megiddo

Tournament Brackets Manager Code.gs

Tournament Bracket Manager

To enable the Sheets, you will need to create a file in the app script editor:

Tournament Brackets Code.gs

Copy and paste the code from the file(s) below.

Scriptless Aquarium of Appreciation TEMPLATE by Avi Megiddo

Scriptless Aquarium of Appreciation a.k.a. Box of Thanks

Aquarium of Appreciation
Code Walkthrough

Aquarium of Appreciation / Box of Thanks - Code Overview

Aquarium of Appreciation (a.k.a. Box of Thanks)

To enable the Sheet, you will need to create 3 files in the app script editor:

After making your own copy of the Sheet template, create the files above in your Apps Script Editor.

Aquarium of Appreciation a.k.a. Box of Thanks - Code.gs

Aquarium of Appreciation
Code.gs

Aquarium of Appreciation - message.html

Aquarium of Appreciation
Message.html

Aquarium of Appreciation- UI.html

Aquarium of Appreciation
UI.html

Or if you prefer, the original Box of Thanks look and feel, with buttons:

Scriptless Box of Thanks: Thank someone, or read about past kind acts.

Box of Thanks - Code.gs

Box of Thanks
Code.gs

Box of Thanks - message.html

Box of Thanks
Message.html

Box of Thanks - UI.html

Box of Thanks
UI.html

Scriptless Suggestion Box Template by Avi Megiddo

Suggestion Box:

To enable the Sheet, you will need to create 2 files in the app script editor:

After making your own copy of the Sheet template, create the files above in your Apps Script Editor.

Suggestion Box

Code walkthrough

Aquarium of Appreciation - message.html

Suggestion Box
Code.gs

Aquarium of Appreciation - message.html

Suggestion Box
SuggestionForm.html

Interactive Mood Meter:

To enable the Sheet, you will need to create a file in the app script editor:

Code.gs

Copy and paste the code from the file(s) below.

Scriptless Mood Meter - Multiple Classes

Mood Meter Google Sheets Template - Code Overview

Mood Meter - Multiple Classes, Data Tracking Code.gs file

_________:

To enable the Slides, you will need to create a file in the app script editor:

Code.gs

After making your own copy of the Sheet template, create the file above in your Apps Script Editor.

Page updated

Google Sites

Report abuse