The best and easy way to handle this is by using substitute formula and having two columns here is the explanation below:

    Column A5: just put google drive image shareable link e.g.
    "https://drive.google.com/open?id=1CfUnvGGdt96irA419HnU0BvRafD4F_os"

    Column B5: use the combination of two formula image and substitute like this:
    =image(substitute(A5,"open?id","uc?export=download&id"))

Explanation this will convert the google image indirect image file into direct link and give the image outcome as you want it.

**Screenshot:**


[![enter image description here][1]][1]


[![enter image description here][2]][2]


  [1]: https://i.sstatic.net/o8EDw.png
  [2]: https://i.sstatic.net/5FYRg.png