Is there any API available for Retrieve images in the cell from a google spreadsheet?

Question

I'm trying to Retrieve images in the cell from a google spreadsheet. I checked this question is already available. and I also referred to this documentation. But, these both are no longer work. Does anyone suggests me API or provides any good documentation link?

Edited:

This is my Google Sheet. I'm trying to retrieve A4 and A5. Which is I uploaded from local machine. I used this API. But It's given me the blank value. Is there any other API available for retrieving this both images?

It depends on how the images are added to the cell (e.g. via formula, uploaded from local, etc.). Can you clarify that? — Iamblichus, Jun 24 '21 at 08:30
@lamblichus I am grateful to you for replying to me. I Edit My Questions Please check. — Nikunj Chaklasiya, Jun 24 '21 at 16:07
Does this answer your question? [Transfer images between Google Sheets?](https://stackoverflow.com/questions/63264840/transfer-images-between-google-sheets) — Iamblichus, Jun 25 '21 at 08:20

score 1 · Answer 1 · answered Jun 29 '21 at 11:27

1

You will not be able to retrieve images placed using the "Upload" functionality. To retrieve via API, the image should be placed using

=IMAGE("http://your.url").

So upload your image to a content server, get the URL and insert them to the respective cells using =IMAGE formula. Now if you retrieve the grid data using Spreadsheet.get and locate this specific element in the array, you will get the cell value as =IMAGE("http://your.url"), you can parse this string to retrieve the image URL.

answered Jun 29 '21 at 11:27

Upesh M

382
1
4
9

I'm trying to do Image Retrieve Without URL like an Image Insert in cell From Local PC. and I'm trying to fetch this image using angular and other platforms. Is it Possible? – Nikunj Chaklasiya Jun 30 '21 at 04:29
I'm Successfully Retrieve the Image. If it is URL. – Nikunj Chaklasiya Jun 30 '21 at 04:30

score 0 · Answer 2 · answered Sep 21 '22 at 12:16

You can get a zip file with the sheet in html format with all the images – using Google API. I belive it will be easy to parse it and to get the image you need.

Get Your API Key, from Google developers Console
Get a File ID of a google spreadsheet with permissions set to "Anyone with the link".
Now you're ready to call the api (with curl or browser window): https://www.googleapis.com/drive/v3/files/{FILE_ID}/export?mimeType=application%2Fzip&key={YOUR API KEY}

fill in your FILE_ID and API_KEY from google.
works only with "anyone with link" permissions, otherwise you gotta authenticate first. (more here: How to send google-sheet data in an email keeping the formatting( colors) intact from python?)

Is there any API available for Retrieve images in the cell from a google spreadsheet?

2 Answers2