Skip to main content

Lab Student Survey

CI Status Documentation Status Test coverage percentage

uv Ruff prek

PyPI Version Supported Python versions License


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 API in Google Cloud Platform.
  • Create a Service Account in Google Cloud Platform.
  • Download the Service Account credentials as JSON in Google Cloud Platform and save it as service-secrets.json in the working directory or set it as GDRIVE_SERVICE_ACCOUNT environment variable (via GitHub Secrets).
  • Create student-lab-survey (or any name) folder in Google Drive.
  • Add the Service Account email to the student-lab-survey folder with Editor permissions.
  • Create a Google Form for the lab student survey. The second question should be the name of the supervisor.
  • Create a Google Sheet in the student-lab-survey folder from the Google Form.
  • Create metadata.csv and metadata_group_name.csv in the working directory or student-lab-survey folder 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 Sheet ID as LAB_STUDENT_SURVEY_FILE_ID environment variable (via GitHub Secrets).
  • Set the student-lab-survey folder ID as LAB_STUDENT_SURVEY_FOLDER_ID environment variable (via GitHub Secrets). (Optional.) If not set, the parent folder ID of the Google Sheet will be used.
  • (Set the Service Account credentials as GDRIVE_SERVICE_ACCOUNT environment 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.

国内

研究室 口コミ -満載 -学べます - Search / X

海外

pi rate website phd site:www.reddit.com - Google Search

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)

Source distribution for lab-student-survey 1.0.0
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)

Table of built distributions (wheels) for lab-student-survey 1.0.0
File Interpreter ABI Platform Actions
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 log

Release 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 log

Security 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.

Select from 2 files

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 log

A 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.

Release history Release notifications | RSS feed

This release

1.0.0 This release

2 release files Full provenance

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page