Automatically create sharing link, password, expiring date for folders and save values in list

Dear Community,
I’m brand new here and a little helpless.

I have to create a lot of folders every day, and set a sharing link, an expiration date and a password. I copy these 3 values ​​into an excel sheet.
That will cost me around 1 hour a day.

Is there a possibility to create the links and passwords for all folders in one step and to copy the links and passwords in a list?
That would save me an infinite amount of time and reduce the susceptibility to errors. I want to dig into the topic but have no idea where to start and whether such automation is even possible.

many thanks and best regards
slowturtle