Some work is not difficult. It is just painfully repetitive.
For me, one of those tasks was monthly timesheet entry.The data was already in Excel: date, project, working hours, task, description. But our company uses Papierkram, so I still had to copy everything manually into the system.
One row was fine. Dozens of rows every month were not.
At some point, I realized I could spend close to 10 hours just moving data from Excel into Papierkram.
Not creating anything new. Just copying data from one place to another.
So instead of spending another 10 hours doing it manually, I spent that time building a small browser extension.
That became QuickSheet for Papierkram.
It started with a simple script
The first version was just a JavaScript snippet running in the browser console.
I inspected how Papierkram creates a time entry, reused the current logged-in browser session, and sent the same request programmatically.
It worked.
But a console script is fine for one developer. It is not something I wanted to explain to colleagues every month:
Open DevTools
→ paste this script
→ change this value
→ make sure you are on the correct page
→ run it
So I turned the idea into a Chrome extension.
The real problem was Excel
Different people use different column names and formats:
Date / Work Date / Datum
Project / Customer Project
Duration / Hours
Task / Activity
Description / Comment
And the project name in Excel may not be exactly the same as the project name in Papierkram.
So the workflow became:
Upload Excel
→ Map columns
→ Map projects/tasks
→ Review
→ Import
Mappings can be reused, so the first import may take a little setup, while the next one is much faster.
About 10 hours became about 3 minutes
Before:
Excel
→ manual copy/paste
→ Papierkram
~10 hours
Now:
Excel
→ QuickSheet
→ review
→ Papierkram
~3 minutes
The exact time depends on the workbook and number of entries, but the important part is that a human no longer needs to act as middleware between two systems.
Automation also needs guardrails
If I accidentally import the same timesheet twice, automation can create dozens of duplicate entries in seconds.
So QuickSheet includes validation, preview, project/task mapping, and duplicate checks before import.
The goal is not:
Upload → automatically write everything
It is:
Upload → understand → review → confirm → import
Keep the architecture simple
QuickSheet does not need a Papierkram API key and does not ask users for their Papierkram password.
Users log in to Papierkram normally, and the extension works with their current browser session and existing permissions.
The Excel file is processed locally in the browser.
That means I do not need to run a backend that receives people's working hours, project names, or timesheet comments.
Sometimes the simplest privacy feature is simply not collecting the data.
A small reminder
QuickSheet started because I did not want to spend another day copying timesheets.
But it was also a good reminder:
Before automating something complicated, look for the boring task you repeat every week or every month.
Sometimes a small tool that saves a few hours repeatedly is more useful than a much bigger project.
For this one, the result was simple:
around 10 hours of manual work became a few minutes.
QuickSheet for Papierkram is available on the Chrome Web Store:
https://chromewebstore.google.com/detail/quicksheet-for-papierkram/jmdbodibbijpgdaipcdekmfchjnaeedf
QuickSheet for Papierkram is an independent browser extension and is not affiliated with, endorsed by, sponsored by, or produced by Papierkram / odacer finanzsoftware GmbH.



Không có nhận xét nào:
Đăng nhận xét