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.
1 Make a copy of the List of Links in Folder template
2 Click List of Links
3 Click Create list of links
4 The first time you use this, you'll need to authorize the attached script to run. Click continue
5 Click your email address
6 Scroll down and click Allow
7 Open up the folder in Google Drive whose files you want to list
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/
9 Paste the folder ID into the box
10 Click Generate List
11 You'll see a list of each file in the folder and a link to that file.
Here's an interactive tutorial for the visual learners
How are you using links?
Do you have other uses for links to files in Google Drive folders? Let me know in the comments below!