So how do you display images on your Google Drive using the =image() function in Google Spreadsheets? You'll need to make your images Public then reformat the link from Google Drive to make this work...
Assuming you already have a folder full of images in Google Drive, here's what you need to do:
1) Make your Google Drive Folder Public (a-d):
a) Navigate to the folder containing your images, open the dropdown & select "Share"
b) Click on the "Anyone with the link can view ▾" dropdown for next menu...
c) Select "More..." from the dropdown...
d) Select the "On-Public on the Web" radio button, then the blue "Save" button
Notice the dropdown now displays "Anyone on the internet can find and view".
Now the images in this folder are ready for your spreadsheet.
2) Right-Click on an image & "Get Link"...
3) ctrl-c copy this link to your clipboard...
4) Reformat the url...
Here's the url I got from the example above:
Ⓐ https://drive.google.com/open?id=0B9biAW_mGiSpQ1ZjWTNxLTE2RDQ&authuser=0
Here's what it needs to look like:
Ⓑ http://drive.google.com/uc?export=view&id=0B9biAW_mGiSpQ1ZjWTNxLTE2RDQ
Here's a Google Sheet with an image from Google Drive displayed using formula Ⓑ above:
(Be sure to remove the 's' from "https://" in Ⓐ to the correct "http://" form when reconstructing formula Ⓑ)
Hope this is helpful to someone. ❧ Peace...
