On January 19, 2022, 2 classes of
CellImage have been added to the Spreadsheet Service.
- CellImageBuilder: https://developers.google.com/apps-script/reference/spreadsheet/cell-image-builder
- CellImage: https://developers.google.com/apps-script/reference/spreadsheet/cell-image
Unfortunately, in the current stage, it seems that the image manually put to a cell without using the URL cannot still be retrieved.
- When an image is manually put from URL and Google Drive to a cell, this image cannot be retrieved.
- When an image is put using
setSourceUrlmethod with a script, this image and URL cannot be retrieved.
I would like to expect to resolve these in the future update.
Also, I reported this to the Google issue tracker. https://issuetracker.google.com/issues/215575446