Today we are going to explore Google Sheets. As some of you may not know Google Sheets, same as Google Slides are a word processor, a spreadsheet and a presentation program respectively, all part of a free, web-based software office suite offered by Google within its Google Drive service. Many people just know and like to call Google Sheets similar as Excel, but respectively laying on the internet and for free. Normally in order to setup a project and start working with Google Sheets all the users are required to have a google account. We are not going to start it from the basics, but rather focus on tricks and tips that can significantly increase the efficiency or simply save time.

Insert images into Google Spreadsheets:
This is going to be our subject in this post and we will try to explain how this feature works on google spreadsheets application.

Normally, when people try to insert image from the “menu options” or just trying to drag it from their desktop, application fails to display the image visual part. Here we are meeting very common issue, that many people struggle to solve. We will show some basic Google spreadsheets rules, that will give you a full understanding of how it works, same as you will also later have a great opportunity to try it yourself.


Google image function
Function for image display


Basic function “=IMAGE” together with valid image URL (image you would like to display) allows you to insert image inside a cell and display it visually. You can also control aspect ratio, what allows you to change size of the image in accordance to the height of the cell.


Basic Examples:
=IMAGE(“URL”) – Original image ratio fitted in the height of the cell
=IMAGE(“URL”,2) – Image is stretched to fit all edges of the cell
=IMAGE(“URL”,3) – Image retains its original ratio
=IMAGE(“URL”,4,50,50) – Including image options for manually changing ratio. You simply need to try changing 50,50 for the next preferred result.


Display of Google Spreadsheet images
Displayed images in Google Spreadsheets


For more advanced users we would like to share experience of how to also display images that are uploaded on google drive. Normally, it can be quite a headache to figure it out, but we know the way of how to help you. As far as we could experience google drive functionality together with Google spreadsheets, this function sample below is the only way to directly display images in the Google Spreadsheet cell. This URL structure is 100% reliable and fully dependable of id which is missing in the sample. ID is always unique and must be taken from the uploaded image URL on your google drive application. Once you have done it and combined it with the function example we provided you with, you must be able to see your result immidialtely in the selected cell area.



In case you are very advanced and familiar of how to setup Google Spreadsheets and Google Scripts, we also consider it mutual to have a script which can do a automated Google drive results directly in the preferred Google Spreadsheet just by simply pressing “run this script” function. See full function overview below:


Script editor example
Google Script editor example

function listFilesInFolder(folderName) {

var sheet = SpreadsheetApp.getActiveSheet();
sheet.appendRow([“Name”, “Date”, “Size”, “URL”, “Download”, “Description”, “Image”]);

var folder = DriveApp.getFolderById(“************”);
var contents = folder.getFiles();

var cnt = 0;
var file;

while (contents.hasNext()) {
var file =;

data = [
“” + file.getId(),
“=image(\”” + file.getId() +”\”)”,


This script will generate you all uploaded images on selected Google drive folder including its Name, Date, Size, URL, Download URL, Description and Image visual.


Google Script editor results
Google Script editor results in Google Spreadsheets


As normally we recommend to try it yourself for full understanding. Best way to learn is to try and see how it works.

We hope you liked our post and feel free to get in contact or write comments if you have any questions.

Kind regards,
KB Media Solutions team