Illustration of a green folder with lines representing text

Google Drive List Links in Folder
Google Sheets Add-on

This add-on for Google sheets makes it easy to generate a list of links to each file in a specified Google Drive folder.


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

Blog posts about this add-on