kanshi | Dynamic display configuration | Video Utils library

Thanks to the posts suggested by @Tanaike, the solution I've come up with is as follows. It is very dirty and not well written but it works.

Workflow...

1. Get spreadsheet ID and folder ID;
2. Open a copy of the spreadsheet;
3. Export as XLSX;
4. Change filetype to zip;
5. Unzip into a blob;
6. Create object to hold xlsx worksheet ids/sheet names, image locations and filenames and Drive image ids for newly created images;
7. Iterate through each blob in the blob;
8. Find the xl/workbook.xml file and retrieve sheet id and names;
9. Find each xl/drawings/drawing#.xml files and retrieve sheet, location and image filename;
10. Find all images, save to drive and retrieve and map drive ids to filenames;
11. Go through each sheet in the Google sheet;
12. Iterate through each cell;
13. When you find a cell starting with 'com' which ISN'T a formula, generate the image id from the sheet id, row and column, find the corresponding image name and then the corresponding google drive image id.
14. Clear the cell contents and reinsert as an =IMAGE() formula;
15. Add a note to the cell with the image name.