ScriptEditor to open a google folder link in AppSheet in Finder

[FaCe]

Hi,

i'm trying (using the help of various ChatGTP & others) to create a Script in my Mac to be opened by Appsheet.

I've saved in a column (text) the link of my Google Drive Folder and want with an Action execute the script transform the link in a local link to be opened in Finder. 

Any hints ?