Lab Student Survey
Documentation: https://lab-student-survey.readthedocs.io
Source Code: https://github.com/34j/lab-student-survey
Python package for lab student survey. A single command fetches the spreadsheet generated from Google Forms and uploads the analysis results to Google Drive.
Usage
- Create
student-lab-survey(or any name) project in Google Cloud Platform. - Enable
Google Drive APIin Google Cloud Platform. - Create a
Service Accountin Google Cloud Platform. - Download the
Service Accountcredentials as JSON in Google Cloud Platform and save it asservice-secrets.jsonin the working directory or set it asGDRIVE_SERVICE_ACCOUNTenvironment variable (via GitHub Secrets). - Create
student-lab-survey(or any name) folder in Google Drive. - Add the
Service Accountemail to thestudent-lab-surveyfolder withEditorpermissions. - Create a
Google Formfor the lab student survey. The second question should be the name of the supervisor. - Create a
Google Sheetin thestudent-lab-surveyfolder from theGoogle Form. - Create
metadata.csvandmetadata_group_name.csvin the working directory orstudent-lab-surveyfolder in Google Drive to specify the question groups. The former will be automatically generated in the working directory if it does not exist. The latter is optional.
Environment Variables
- Set the
Google SheetID asLAB_STUDENT_SURVEY_FILE_IDenvironment variable (via GitHub Secrets). - Set the
student-lab-surveyfolder ID asLAB_STUDENT_SURVEY_FOLDER_IDenvironment variable (via GitHub Secrets). (Optional.) If not set, the parent folder ID of theGoogle Sheetwill be used. - (Set the
Service Accountcredentials asGDRIVE_SERVICE_ACCOUNTenvironment variable (via GitHub Secrets).)
Running commands
lss
Github Actions
name: Run lab-student-survey
on:
schedule:
# every day at 00:00 UTC
- cron: "0 0 * * *"
workflow_dispatch:
jobs:
run:
runs-on: ubuntu-latest
steps:
- uses: actions/checkout@v3
- name: Install wkhtmltopdf
run: sudo apt-get install -y wkhtmltopdf
- name: Install and run lab-student-survey
run: pipx run lab-student-survey
env:
LAB_STUDENT_SURVEY_FILE_URL: ${{ secrets.LAB_STUDENT_SURVEY_FILE_URL }}
LAB_STUDENT_SURVEY_FOLDER_URL: ${{ secrets.LAB_STUDENT_SURVEY_FOLDER_URL }}
GDRIVE_SERVICE_SECRETS: ${{ secrets.GDRIVE_SERVICE_SECRETS }}
Installation
Install this via pip or pipx (or your favourite package manager):
pipx install lab-student-survey
Alternatives
As far as I could find, there is no repository on GitHub for this particular topic. Instead, you may want to check out the following alternative websites. However, as there are too few people in a lab, with the effect of diminishing anonymity, most of these websites do not seem to attract many reviews.
国内
- 理系研究室のクチコミサイト|OpenLab: 募集停止中, 投稿するとAmazonギフト券(100円)がもらえる, ほとんど情報なし(100程度?)
- LabBase 研究室サーチ: 入力方法不明, 上よりも情報なし
- 研究室ナビ: リンク切れ Forms
研究室 口コミ -満載 -学べます - Search / X
海外
- PI Review: 231 reviews (2021/09/21)
- GradPI: 329 reviews (2023/09/21), Must have a .edu or .ac.uk domain email address to even view the site.
- RMGA: 3 reviews? (2021/09/21)
- ratemypi.com, qcist.com: リンク切れ
- 한국에너지공과대학교 에너지공학부 구근호 - 김박사넷: かなり多い(1000以上?)
Metadata
Release files for lab-student-survey 1.0.0
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | Actions |
|---|---|---|---|---|
| lab_student_survey-1.0.0.tar.gz | 16.1 kB | With provenance | Details for lab_student_survey-1.0.0.tar.gz |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Actions Reset |
|---|---|---|---|---|
| lab_student_survey-1.0.0-py3-none-any.whl | Python 3 | none | any | Details for lab_student_survey-1.0.0-py3-none-any.whl |
Total release size: 29.6 kB
Release files / lab_student_survey-1.0.0.tar.gz
| Download URL | lab_student_survey-1.0.0.tar.gz |
|---|---|
| Size | 16.1 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
242b115dc97d690907487c25e3ceea01fac839a9968e8018989d3063589544b2
|
|
BLAKE2b-256 checksum How to use checksums |
a98bb74d9274991261daf2914f3295becc35478fce33249511c6c139e93888c1
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/6.1.0 CPython/3.13.13
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Nov 7, 2026.
Transparency logRelease files / lab_student_survey-1.0.0-py3-none-any.whl
| Download URL | lab_student_survey-1.0.0-py3-none-any.whl |
|---|---|
| Size | 13.5 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
2f2922a6714df5cd9375205d8c40ae3e7600a9955588e52b57cf405faa0371e7
|
|
BLAKE2b-256 checksum How to use checksums |
5ef7e74a58195b8f971765cfe4caf19801e6d9e4de734e3e5a735ed6d6fe2bfc
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/6.1.0 CPython/3.13.13
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Nov 7, 2026.
Transparency logSecurity for lab-student-survey 1.0.0
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
Full provenance
Both files in this release have been uploaded with provenance metadata.
Attestation for lab_student_survey-1.0.0.tar.gz
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Nov 7, 2026.
Transparency logA note on package security
PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.
To learn more about protecting yourself from malicious actors, visit our package security documentation.