Online queue with Streamlit, centralized Google Sheets backend and Courier notification system

This is an example of poor man's web project. Feel free to deploy it yourself or draw inspiration.

0. Setting up the project

Clone the repository, setup python venv and install the requirements:

git clone https://github.com/ViktorooReps/streamlit-queue.git
cd streamlit-queue
virtualenv venv
source venv/bin/activate
pip install -r requirements.txt

Create the directory for secrets:

mkdir .streamlit
touch .streamlit/secrets.toml

1. Setting up Google Sheets backend

Go to Google Sheets, create new spreadsheet and add 2 worksheets:

...one with accounts....

...and another with the actual queue...

The bottom of your spreadsheet should look like this:

Fill in Accounts sheet with the names of the people that will use the queue, as well as their Telegram accounts (optional).

Now go to Google Console and create new project. Then you will need to go to Service Accounts:

Create service account, and then add a new JSON key:

Next, you will need to enable Google Sheets API. Search for it in the search bar, click on it and enable it.

Finally, go to your spreadsheet and add your service account with the Share button.

2. Configuring Courier notifications

TODO

3. Deploying to streamlit

TODO