extracting google docs id from url

Topic Labels: Formulas
762 1
Showing results for 
Search instead for 
Did you mean: 
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
6 - Interface Innovator
6 - Interface Innovator

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:


Hope this helps!

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