How to retrieve a list of shareable links


Small precision, I begin in Javascript. I have browsed a few tutorials on Youtube at most. I am also not a developer. For the following, I use Google sheet.

My problem :

My work environment is structured as follows (folders / sub-folders):


The black texts correspond to the folders and sub-folders. The texts in red correspond to the Google sheet files.

As shown in this image, the tracking file (FOLLOW_UP) is located in the RACINE folder. The ID4522, ID7852 and ID5864 folders are subfolders of the RACINE folder.

We find in the ID4522 sub-folder the following Google sheet file “Entry_Form_ID4522”, in the ID7852 sub-folder the following Google sheet file “Entry_Form_ID7852”,…

Important clarification: The number of sub-files (of the form “IDxxxx”) can vary at any time without warning.

My wish

Most likely via a macro in javascript, retrieve in the tracking file (“FOLLOW_UP”) from cell B3 and down, the list of shareable links for each of the files “Entry_Form_IDxxxx”. List of subfolders can change at any time (for example when my client adds a folder with the associated “Entry_Form_IDxxxx” file).

Thank you by advance.

Best regards.

FOLLOW_UP file should look like below :

Firstly, welcome to the forums.

While we are primarily here to help people with their Free Code Camp progress, we are open to people on other paths, too. Some of what you are asking is pretty trivial in the Free Code Camp context, so you might find that if you’re not getting the instruction and material you need in your current studies, the FCC curriculum will really help you get started. At a modest guess I’d say investing a 4-5 hours working through the curriculum here will really pay off. You can find the curriculum at

With your current questions, we don’t have enough context to know what you already know or don’t know, so it is impossible to guide you without just telling you the answer (which we won’t do).

It is pretty typical on here for people to share a codepen / / jsfiddle example of what they have tried so that anyone helping has more of an idea of what help is actually helpful.

Please provide some example of what you’ve tried and I’m sure you’ll get more help.

Happy coding :slight_smile:


Thank you for your quick feedback. As I’m a beginner I try

Best regards.