Get google drive file ID from its URL

[hubehe]

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.

[ManishMandot]

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.

[hubehe]

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

[ManishMandot]

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.

[hubehe]

Hi Manish,

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

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

[ManishMandot]

Just remove the “” from /

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