I need help somehow associating file names from a list with images from their FileID from Google Drive in Sheets.
Hello, a while ago, I requested some help automating the images from my Google Drive in this post. After some help, and a lot of work, I now have all the images in my Google Drive, I can easily get all of them, extract the names, and File IDs, and quickly load the images with a toggle, and used cached versions of the images. Then, I can take those, and using the =WRAPROWS function, make them all visible in a grid in a different page with the way I want them. It all works great.
Now, however, I want to associate the list of file names with the list of images. Is there a way through AppScript, or formulas, that I can do this? Possibly adding two blank rows between each row of images, so one can have the file names on it?
This is what the images looks like currently.
This is kind of what I would like it to look like, but I am open to other suggestions or ideas. The point is that I want to be able to easily associate all the images with the correct file name somehow.
Any suggestions or help are appreciated. I feel like it is possible to combine the two lists, and split them, but maybe that is the wrong way to go about it, and I don't know what else to do. Ideally though, I'd like to use my list of them, and not have to manually change or update them, as there are a lot, and more get added regularly.
Thanks in advance!