Map a Folder Full of Images to Google Spreadsheet

Imagine you have a large folder of images in Google Drive. I don’t have to imagine this as I do thanks to an IFTTT recipe.1 Google tends to be kind of stingy with the kinds of filtering/interactions you can have with files in their folders and we know that if you get stuff in Google Sheets then a world of other possibilities opens up. I’ve been thinking about what options there are with Google file storage because VCU is a GAFE school and we have unlimited Drive storage. That might open some media storage options with heavy load projects like our Field Botany site or our more recent work with the East End Cemetery. So . . . I wrote a quick script to take a large G Drive folder full of images and write the content to a spreadsheet while embedding an image preview. The script is below. I ended up revamping both enough that I felt it was worth reposting. For the record, the script ran through about 4,500 images but it may have timed out so keep that in mind if you’re dealing with lots of images. 1 I figure if I have enough backups to my online backups then I can pretend I’m safe.

Google Forms to Exhibit Example (POC)

So, I’ve managed to create two quick websites for work that are driven by Google’s new form option for getting data into spreadsheets. I’ve put a quick example of a log here. Feel free to enter data etc. It’s up there to play around with and hopefully is simple enough to help people figure out how to do it. One thing I don’t like about the form option. I don’t like that changes I make to the submission form alter my spreadsheet. I might want the form to read “Your name here” while my spreadsheet says {name:text}. I don’t believe there’s any way to do that and it would be much nicer when using this with Exhibit. Instead I have to add another sheet and I use a formula to reference the data in. It’s just =sheet1!A2 in case anyone needs it. Then if I get my mouse in just the right place it turns into cross hairs and I can drag that formula dynamically so that it pastes as =sheet1!A3 and A4 etc. then I can drag it across to create =sheet1B2 etc. That is much better than typing all that in. In a perfect world I’d also be able to apply some css to it but that’s getting a little picky. So the key steps. create spreadsheet and […]