Help

extracting google docs id from url

Topic Labels: Formulas
483 1
cancel
Showing results for 
Search instead for 
Did you mean: 
pedroarango11
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all! I'm trying to extract the ID from a google drives doc link, any ideas on how to do this? Knowing the ID of the file is the one after the /d/?

1 Reply 1
preshetin
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi @pedroarango11 - You can use a formula like this:

 

MID({URL}, FIND("/d/", {URL}) + 3, FIND("/edit", {URL}) - FIND("/d/", {URL}) - 3)

 

In this formula, replace {URL} with the field name or variable containing the URL string.

Here is how this formula works in action:

preshetin_0-1704977086973.png

Hope this helps!

P.S. Kudos to Chat GPT whom I asked this question!