Get google drive file ID from its URL

Hi,

Simple question: how to get google drive file ID from its URL?

I tried to extract this by “search for files/folders” module but failed in providing URL address as a search key.

Pretty simple; just use the Split function and get the last value or the file id value as per the URL structure.

Do share your file URL and I will show you how to do it.

1 Like

Blockquote
https://drive.google.com/file/d/1R55D8zdWy1mOP8AT_5cZCdZhGloJKuGM/view?usp=share_link

Use this formula;

{{get(split(https://drive.google.com/file/d/1R55D8zdWy1mOP8AT_5cZCdZhGloJKuGM/view?usp=share_link; “/”); 5)}}

Replace the bold part with your URL.

1 Like

Hi Manish,

Thanks for replay! Could you check why it didn’t work?

Scenario URL: https://eu1.make.com/95498/scenarios/1082287/edit

Just remove the “” from /

It was just in the display when I pasted the formula but not required in the formula.

1 Like