I love using Google Drive to share student work with other classes, families, and the community as a whole. The built-in sharing features work pretty well, but sometimes I want to create a table with links to embed in Google Sites or take actions such as sharing links via a mail merge. In these cases, it’s helpful to have a spreadsheet that contains links to each item in a Google Drive folder.

Add-on

I put together an add-on template to help create such a list. To use it, make a copy of the template and follow the tutorial below.

Tutorial

Click here to open the tutorial in a new window.

11 STEPS


1 Make a copy of the List of Links in Folder template

Step 1 image

2 Click List of Links

Step 2 image

3 Click Create list of links

Step 3 image

4 The first time you use this, you'll need to authorize the attached script to run. Click continue

Step 4 image

5 Click your email address

Step 5 image

6 Scroll down and click Allow

Step 6 image

7 Open up the folder in Google Drive whose files you want to list

Step 7 image

8 Find and copy the folder ID in the URL bar on the page for the folder. It's all of the letters and numbers after drive/folders/

Step 8 image

9 Paste the folder ID into the box

Step 9 image

10 Click Generate List

Step 10 image

11 You'll see a list of each file in the folder and a link to that file.

Step 11 image

Here's an interactive tutorial for the visual learners

https://www.iorad.com/player/1571859/List-of-Links-in-Folder-Add-On

You May Also Enjoy

Illustration of a laptop with a color sort on the screen. Three dotted boxes are labeled red, yellow, and green. The red box has a red heart inside. A green leaf and yellow star are sitting outside, waiting to be sorted into their boxes.

Sliding New Activities into Google Slides

Google Slides can be used for much more than just presentations. In this tutorial, you’ll see ways to set up foolproof templates to maximize learning.