Google Script CV Workflow POC
Suppose you wanted to automate a chunk of your CV creation. Suppose they’d let you do it digitally via Google Docs (if not aspects of this could still work but it wouldn’t be nearly as interesting) and that you’d like to link to the “proof” files.
I am further supposing that you might be willing to think about doing this slightly differently.
Usually people build the CV/tenure document and then go back and find/link to their evidence. The path I’m suggesting would allow you to gather the evidence as you came across it and then build the index to it automatically. You’ll still want to construct the overarching narrative but this takes the grunt work of listing/linking and puts it on the computer where it belongs.1
This is the proof of concept scenario. You could make it much better depending on your needs/wants but this ought to get you started with how it could work. This script does create a spreadsheet of all your content with a variety of useful links and creates a Google document with all the files as ordered list items under their respective folder headings.2
Given one folder called CV POC . . . in that folder are your three folders of goodness . . . research, teaching, and service.
You’ve filled these folders with PDFs, Word files, images, or whatever of the proof that you are worthy of tenure/promotion/deity-status.3
Add a Google Sheet and attach the script below to it by going to Tools>Script Editor and pasting the contents in replacing everything.
You’ll save it and then hit the play button. You’ll need to approve some stuff. Once approved . . . you’ll get the output in a tidy little Google Doc with working links etc. like the one below.
Notice the script does a few things that are dependent on how the file names were written. It replaces underscores with spaces, chops off the file extension . . . stuff like that. It was more done for my own amusement and to show what might be done that for an actual logical purpose.
1 Thanks to David C. for helping me articulate that difference.
2 This currently gets made on the root of your document rather than in the POC folder. I could move it but that feels clumsy. I can’t quite remember how I’ve generated files within particular folders in the past.
3 In my case, I used PDFs I had handy from other projects. They are clearly not my works.