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.


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.


Click here to open the tutorial in a new window.


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


Tags: , ,



Get new posts by email: