A minimal experimental Google Sheets, Flask, and Heroku based salary slip generation and delivery system.
The following need to be pip installed and added to the requirements.txt for Heroku:
gunicorn flask flask-wtf gspread pandas premailer numpy oauth2client flask-login
Working with gspread requires a service token through a new project created on the Google Developers Console. The gspread setup can be followed in the link below:
https://gspread.readthedocs.io/en/latest/
Two spreadsheet databases need to be set-up for the salary slip generation system to work. The format is shown in the below example sheets:
Salary Slip Database: https://docs.google.com/spreadsheets/d/120NOykXIUyKvrM5SSPKK6CzPSOYSk1sv0eREajwfZyU/edit#gid=1285578064 Employee Database: https://docs.google.com/spreadsheets/d/1YYaaDksBX7zwtH17mPudKnoX4yg-K4-ROiigadGQe0s/edit#gid=0
The system delivers salary slips to the employees listed in the database via HTML formatted email by adding the required information in the Flask form.