Use Looping to find share links in certain Google Drive folders and Send Channel Message with links in Discord

Hello and have a nice evening,

I'm looking for a way to iterate through all of the folders in a previously identified folder. I want to make the contents of several folders available as share links on Discord in targeted channels.

I have currently achieved the following:

• The destination folder is determined.
• There are several weekly folders in the target folder, the newest of which is determined.

Here's what I imagined, but couldn't find anything to implement it:

• A loop that goes through that folder in the previously determined week folder.
  • If there is a document in the folder, the share link for the file should be determined.
  • Check on Discord if a channel with the folder name exists. If this is available, the link should be sent in it.

    • With the name for Discord it must be noted that spaces are replaced by a "-" and all letters are automatically written in lower case.

    • If possible, it should also be possible to define an optional variable for all customers in front of the discord name. As for example "testchannel-name1" in this case "testchannel" is the optional variable and is automatically inserted in the name, which should be searched for later in Discord.

I know that this is a relatively large summary, but I don't need a 1-to-1 guide, just hints how and whether you can solve this with Zapier.

Thank you for reading through and thank you in advance for the help! Regards

Kay