Budget: 2000 UAH Deadline: 1 day
Hello!
I reviewed the code — the problem is clear.
Google Sheets stops due to the API rate limit: update_full_statistics is called with every new row and makes 20+ requests in a row. Google allows ~60 requests/minute — hence the stops.
What I will do:
1. Batching Sheets requests — accumulating rows, writing once every N seconds
2. SQLite as the main local storage (instead of CSV)
3. Sheets updates asynchronously, not blocking parsing
4. Operation 24/7 without stops
I am ready to start now.