Automated Payroll Distributor

I developed this application to solve a specific bottleneck in a logistics company's billing cycle. It automates the distribution of weekly driver statements by mapping PDF files to a local database and sending them via the Gmail API using secure OAuth2 authentication.

Setup & Google Cloud Configuration:

To use this application, you must set up a project in the Google Cloud Console:

1. Create a project named StatementSender at Google Cloud Console.
2. Enable the Gmail API.
3. Configure the OAuth Consent Screen (Internal/Desktop app).
4. Create an OAuth 2.0 Client ID and download the credentials.json.
5. Place credentials.json into the Token/ folder of this project.

Built with:

Python, SQLAlchemy (SQL), Gmail API (OAuth2), and CustomTkinter.

How to use:

1. Install dependencies: pip install -r requirements.txt
2. Add your driver PDFs to Data/Statements/ formatted like "[unit number] Statement".
3. Launch the app: python GUI.py.
4. Use the "Email" tab to link Unit Numbers to Email Addresses.
5. Click "Login" to authorize via your browser, then "Send" to distribute statements.