I have Twinmotion 2023.2 and a large library of Substance materials. Is it possible to link TM to my Substance material library?

Yes you can. Here is the official tutorial: https://www.youtube.com/watch?v=XS1ElfCunHE