View Categories

Google Session Spreadsheet Conversion

< 1 min read

If you have made session spreadsheets for upcoming sessions you will need to do this for each of those spreadsheets and your master template.

Please make the following changes to convert your session spreadsheets to use the new volunteer examiner data:

  1. Open your session spreadsheet.
  2. Click on Extension > App Scripts
  3. Click the + next to Files and select Script
  4. Paste the contents of the json_import.gs file.
  5. Click the floppy disk icon to save the script and name it something like json_import without the extension.
  6. You can close the Apps Script editor.
  7. In your session spreadsheet click View > Hidden Sheets > Train/List Import
  8. Click on that sheet at the bottom.
  9. Click on A1 and paste the following in place of what is currently there.
=ImportJSON("https://plexus.dev.glaarg.org/api/v1/googleSessionSpreadsheet", "/data", "")
  1. Hit enter to save and a few seconds later you should see the rest of the fields self populate.

That is all you need to do to use the new volunteer examiner data.