Get URL of inserted cell image from google sheet

Question

I have a spreadsheet with 5000 images in one cell and I would like to get in another cell the image hyperlink. Like the following:

My struggle is I am unsure where the image is saved, cause I cannot extract a hyperlink from the image.

Find below my example:

https://docs.google.com/spreadsheets/d/1gmPHXn8avgiOTN-GoASw7410FzBmXhpClDh6rjq9_Ds/edit?usp=sharing

Answer 1

The OP has 5,000 images so a manual process is not particularly helpful. But for anyone who wants to try the manual process...

• open the spreadsheet
• select a cell containing an image
• right click on the cell, a popup menu will appear
• select "Show edit history" (about half way down the menu)
• if the history is "Added 'image'", then you can access a copy of the image
  • right click the word 'Image'
  • select "Save link as" OR "Open Link in new tab"
  • save the image

---

Show edit history

---

Edit History

Answer 2

I'm writing this answer as a community wiki, since the issue was resolved from the comments section, in order to provide a proper response to the question.

Based on the images in the sample sheet you shared and to answer your question "My struggle is I am unsure where the image is saved" it seems that images were manually added Insert > Image > Insert image in cell. Unfortunately, currently there isn't a method to get the images inserted in a cell, if you use the method spreadsheets.get it doesn't return the data.

In addition to the Google Issue Tracker shared above, you can also check this one.

If you are looking to download the images in the sheet, looking for alternatives I found this thread and tested Pattern 1 from that answer and it exports images to your Google Drive.