Hi Francis,

The way I would approach this is two columns one with the name you want to appear as the link text and the other column with the Google Drive filename links. To setup the email draft see the note here further up this thread https://mashe.hawksey.info/2020/04/a-bulk-email-mail-merge-with-gmail-and-google-sheets-solution-evolution-using-v8/#comment-187502

In terms of getting Drive links and file names you’ll have to find another script solution or add-on to help you do that.

Hope that helps
Martin