Mass Attachments from Sharepoint Online

I am trying to figure out if there is a way to create attachments from Sharepoint URLs in mass. I have thousands of files saved on Sharepoint that have a standardized URL path and naming convention that is derived from values in my Smartsheet table. For example, I have 3 fields:

Name State Year

Test1 GA 2020

Test2 FL 2020

The file path would be something like sharepoint.com/test1_GA_2020.pdf; i.e. the only thing changing is the file name that is created based on fields in the Smartsheet table. Is there a way for me to dynamically create links to thousands of URLs at a time based on logic?

Thanks!

Answers