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:


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

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

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