toggl entries to google sheets
Go to file
bain e173325758
group similar entries
2023-03-28 19:47:38 +02:00
README sum whole columns, not only entries 2022-08-11 23:47:35 +02:00
requirements.txt initial commit 2022-08-11 23:11:21 +02:00
toggl2sheets.py group similar entries 2023-03-28 19:47:38 +02:00

README

toggl2sheets

toggl2sheets is a script that automatically gets time entries from toggl 
and puts them into a google spreadsheet. toggl2sheets will only add *new*
entries (since it last ran), modified entries will not be updated.

A hidden spreadsheet "_toggl2sheets" will be created to keep track when
was the last execution of this script.

The script operates based on project names. It will put all entries
that are a part of project "A" into a worksheet with with the name "A".
It can create new sheets when the project worksheet does not exist, or just
ignore it.


Example sheet:
Datum      | Popis            | 30 | Hodinovka | 138 Kč
1. 1. 2022 | (no description) | 15 | 69 Kč     | 69 Kč
2. 1. 2022 | (no description) | 15 | 69 Kč     | 69 Kč

In the sheet the first row is a header and there must not be any
breaks in the entries. toggl2sheets will find first empty row and insert
the new entries before it.