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
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...
No comments:
Post a Comment