Extract links from google drive

I have a Google Drive folder with circa 1200 files saved within. Each file is names as a postcode. I want to extract the file names and the link to the file into google sheets. One column will be the file name. The other a hyperlink to the actual file.
See screenshot below of start of sheet that i did manually. You'll obviously need to automate this given quantity of files.
Post code can't have .pdf
Link to the file must save in same way as shown in screenshot