Creates Google Docs for each row on a Google Sheet. Useful for deliberating between candidates who sign up or apply using Google Forms. Each row contains the applicant's name and application information. The script converts the row into a separate Google Doc that can be the candidate's interview profile, the ideal place to take interview notes and centralize all info on the candidate.
Requirements:
- The top row of the Google Sheets file must contain column headers.
- The file's first column must have some unique Name information (or some form of candidate ID). This will be used when naming the file made for that candidate.
- The root drive must have enough capacity for an additional folder and room for as many Google Docs as there are names in the spreadsheet.
Instructions:
- Create or import a Sheets file.
- In Sheets, go under `Tools` and select `Script Editor...`. Alternatively, search up `Script Editor` in the search bar and select the first result.
- Paste the code from this script over the entire boilerplate/template code.
- Hit `Run`.
- Accept permissions. This script will create and remove certain files and make directories in your Google Drive.
- In the page containing the spreadsheet, a dialog box will open, asking for details regarding the interviews being conducted. The information entered here will be used to build a folder with an appropriate name. (The folder will be named "Interviews " + whatever details you describe).
- Check the Google Drive root (**My Drive**) to see the new folder created. All files will be in that folder and will be named using the applicants' names.
ANova is a student-run volunteering organization through which dedicated mentors get to teach CS to high schoolers and middle schoolers in the Bay Area with a focus on assisting under-resourced education programs, emphasizing the value of diversity in tech, and preparing historically underrepresented students for post-secondary education.
Learn more at: https://berkeleyanova.org