Google Sheets automation
A hands-on solution to speed up the data entry in the work I was doing in 2025 at Öko-Job in Liestal.
At Öko-Job in Liestal I had to enter the same kinds of information into a Google Sheet over and over for the bookkeeping. Typing the same things again and again is slow, so I built a little tool that turns it into a few clicks.
It’s a small Python app that runs on my own computer and opens in the browser. You pick the type of record, then the date from the last two weeks, then add a reference if there is one and pick an option, and finally choose the target. A last page shows the whole record once more, and when I press Submit, the app adds it as a new row to the right tab of the sheet through the Google Sheets API. It signs in with Google once and remembers it.
What the buttons say isn’t in the code but in a config file: the sheet, the record types, the targets, the options and how many days back you can go. So I can change the flow without touching the code, and my private setup and login files stay out of the repository. The version on GitHub uses placeholder names instead of my real setup.
It’s built with Python and Flask and has tests for the sign-in and the entry flow. It isn’t a big system, and that was the point: a lightweight tool that makes a repetitive job faster and more consistent.