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


Do you have other uses for links to files in Google Drive folders? Let me know in the comments below!