Google sheets text link

How To
1

Hello,

I’m tryng to set up a simple automation that “watch files in a folder” on Google Drive and if a new file is detected it will add a new row to a google sheet adding to column A the file name and to column B the sharing link

The problem I’m having is that the sharing link looks something like this

https://drive.google.com/file/d/***FILE ID***/view?usp=sharing

and I need to transform it in a Hyperlink using only the FILE ID as a text that will be linked to https://drive.google.com/file/d/***FILE ID***/view?usp=sharing

I apologize for the poor explanation, I hope it’s clear, thanks

2

Welcome to the Make community!

=HYPERLINK("https://drive.google.com/file/d/***FILE ID***/view?usp=sharing")

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.