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 sharable 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:

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: