This add-on for Google sheets makes it easy to generate a list of links to each file in a specified Google Drive folder.
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
Blog posts about this add-on
Use this Google Sheets template to create a list of links to items in a Google Drive folder.