3
  1. I've an image in my Drive URL = "https://drive.google.com/open?id=0B7Qr0kRr6yOOLXB1OE5lUUxBRjQ"

  2. I converted it to "https://drive.google.com/uc?export=download&id=0B7Qr0kRr6yOOLXB1OE5lUUxBRjQ"

Replaced "open?id" with "uc?export=download&id"

  1. The modified URL from step 2 above is in Sheet1!A1.

At Sheet1!A5 when I use =Image(A1,1) it doesn't work but when I use:

=Image("https://drive.google.com/uc?export=download&id=0B7Qr0kRr6yOOLXB1OE5lUUxBRjQ",2)

it works. This shows up image.

What's the reason that when I use direct URL with IMAGE Function it works but when I give cell reference of containing URL it won't?

  • 1
    The image require permission to be accessed but it should public to be used by IMAGE. Create a demo spreadsheet shared with anyone with the link showing both cases. – Rubén Nov 7 '17 at 14:14
  • Just tried Google Sheets image() function. It doesn't work at all. 👎🏻 – Jonny Apr 21 '18 at 3:52
1

Remove the quotes on A1.

The above because referenced text values should not contain quotes.

  • 2
    Hello there Ruben, Thanks for replying. I tried it without quotes also. It won't work! – user8890001 Nov 6 '17 at 10:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.