Download monthly reports from toggl.
- python
Create venv and activate:
python -m venv venv/
source venv/bin/activate
Install requirements:
pip install -r requirements.txt
First, set constant variables at the top of the file:
-
USERNAME (required): your toggle username
-
PASSWORD (required): your toggle password
-
WORKSPACE_ID (required): id of the toggl workspace your want generate report of. You can get it by going to https://track.toggl.com/timer, choosing Report from the sidebar and copying the number from the url:
-
HANDLE: your nickname, appearing in the filename eg. ak
-
COMPANY: company name, appearing in the filename eg. QED
-
SPREADSHEET_ID: id of the google spreadsheet with the invoice. You can get it from URL address of the sheet. Leave blank if you don't want to download it.
python toggl.py
will generate the following reports for the previous month:
- summary pdf report
- summary csv report
- detailed csv report
- [optionally] download google sheet invoice
Please note that it does not fill in the invoice with total hours, you need to do it yourself before running the script. It only downloads the sheet and saves it under a correct name in the reports folder.
It will also perform a series of checks:
- check if there are any entries without description
- check if there aren't any suspiciously long entries (>8h)
- check if there aren't any overlapping entries
Not passing a check will display a warning but continue with report generation.
python toggl.py 1 2020 will generate 3 reports for January 2020.
Mind that script always takes the latest available version of gsheet invoice.