README.md

---

📍How to install:

This project aims to provide automation for sorting and formatting data in a Google Sheets spreadsheet using the Google Sheets API. It includes functionality to sort data based on a specific column and update the spreadsheet with the sorted data. Additionally, it supports formatting cells, such as aligning cell contents horizontally to the center.

⚙️SET UP Google Sheets API:

If this step has already been completed, you can skip it.

An article from Google about setting up

Or use this video tutorial.

Check if it's enabled:

Google Sheets

Google Drive

Create credentials.json > service account > KEYS > ADD KEY JSON

Put credentials.json into Google_Sheets_API folder

Share "Your Table" with your service account email

🐍SET UP Project:

Insert this command into cmd/terminal (in .env file set correct values):

cd backend/
echo "Creating .env file..."
cat <<EOL > .env
# Get form url https://docs.google.com/spreadsheets/d/__HERE_IS_SHEET_ID__/edit#gid=0
SHEET_ID="..."
EOL
cd ..

Create a virtual environment

python3 -m venv venv

Activate it:

source venv/bin/activate

Install libraries:

pip install -r requirements.txt

Run:

python main.py