Can you use any image from Google on Wikipedia?

How does one use an image stored in Google Drive in a Google Sheet?

• I can't believe what a hard time I'm having trying to include an image stored in my Google Drive in a Google spreadsheet with image(URL), so I think I'm missing something simple. There are a bunch posts online offering solutions but none of them seem to work. They either use URL schemes that won't work with Google spreadsheet's image function (http://drive.google.com/uc?export=view&id=FILEID) or provide URLs that expire in a few hours (http://gdURL.com). Note that I've had to store the temp URLs in a cell then point image() to that cell as using the Google Drive temp URL directly in the image() function causes a syntax error.

• Answer:

  Google uses links that expire when serving up images in the browser for Google Drive.  I can get several images to display in a spreadsheet using resource links I find in the browser, but sadly, they stop working after a few minutes. No matter which link I use. I think Google would prefer you use Google Photos for this.  But they don't make it easy to insert an image into a cell. Instead, you get a floating image above your spreadsheet. From the menu, choose: Insert > Image > Your Albums Right-clicking and copying the URL is disabled after you image is floating in the spreadsheet.  You may be able to get it by searching the resources in the console. My personal method of choice (for building online stores) is dropping my images into a folder on my shared hosting account using an online IDE I love called https://shiftedit.net I then prepare a spreadsheet with links to all the store images in the cells wrapped in =image("http://www.mysite.com/myimage.jpg") so customers can edit the spreadsheet and I can upload a CSV into their store.  The spreadsheet is a Google doc so they can view the images related their products.