| Faculty ↕ | Lab website | Tags |
|---|
Setup instructions — connect your Google Sheet
- Open your Google Sheet. Go to File → Share → Publish to web.
- Under "Link", select your sheet tab, then choose Comma-separated values (.csv).
- Click Publish and copy the URL provided.
- Open this HTML file in a text editor. Find the line near the top of the
<script>section that reads:
const SHEET_CSV_URL = "";
and replace the empty string with your copied URL. - Save the file and reload it in your browser. The table will populate from the sheet.
Your Google Sheet must have these column headers in row 1 (exact spelling, case-insensitive):
Tags are matched against the lists defined in the TAG_CATS variable in the script. Only recognised tags are shown — unrecognised values are silently ignored. Matching strips trailing parentheticals, so a sheet entry of Molecular Neuroscience (e.g., ABC) matches the tag Molecular Neuroscience.