5
  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
3

Remove the quotes on A1.

The above because referenced text values should not contain quotes.

Please bear in mind that the

  1. The image should be shared with anyone with the link.
  2. Google Drive might block the access to the image for a while if it is downloaded too many times. If your spreadsheet / image regularly have this problem you should consider to upload the image to another service like Google Sites, Google Blog, a web hosting, etc.
| improve this answer | |

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