Insert image into Google Sheets cell using Google Sheets API

javascript google-sheets google-sheets-api
dedles picture dedles · Apr 27, 2017 · Viewed 8.8k times · Source

In google apps Script you can insert an image into Google Spreadsheets using the insertImage function (https://developers.google.com/apps-script/reference/spreadsheet/sheet#insertimageblob-column-row).

But I'm not using appscript. I'm using the Google Sheets API (https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets) and I can't seem to find a way to do this. Is there any possible implementation?

Answer

Sam Berlin picture Sam Berlin · Apr 27, 2017

The V4 API doesn't have the ability to insert an image blob like Apps Script does (where the image is an overlay on the sheet, not associated with any cell). You may be able to workaround this using the =IMAGE function. We know of the gap in functionality and are looking into adding support for image blobs.

Related questions

Import google spreadsheet data into google forms with app script

I searched the internet and I can't find a response to this nor the documentation for it. I need to dynamically generate Google forms questions with data from a Google spreadsheet using app script, but I don't know how to …

Read More
Ajax calls made from Google Spreadsheet Custom Function

Has anyone ever tried to write a script inside a Google Spreadsheet to make an ajax call to a website? I want to make it so that the spreadsheet updates itself from the website. But after just putting this short …

Read More
Count the cells with same color in google spreadsheet

I'm trying count the number of cells with the same background color and put the result in other cell with a script in google apps script, but I can't do it. I have the next script but not work and …

Read More