Advice on QR Code Chore Auto Log System

I help run a nonprofit hostel, where guests are asked to pitch in by doing a nightly chore to help keep the place clean. I’ve been working on a system that assigns chores using a QR code. The idea is that when the QR code is scanned, it randomly selects a chore from a weighted list (so some chores show up more often than others). Once a chore is assigned, it's removed from the list for the rest of the day to avoid duplicate scans.

Each time the QR code is scanned, I want the system to automatically log the date, time, and selected chore into a Google Sheet. Additionally, the list of available chores should reset every day at 4 PM.

I’ve been using GitHub and Google Sheets to try to build this system. I got close to making it all work, but I ran into issues mostly with the automatic logging to the spreadsheet. I tried using Grok, but the autofill part didn’t quite work consistently.

To summarize:
-QR code that guests scan to receive their assigned chore, randomly assigned with weights added.
- No duplicate chores once scanned. (this was a issue I was running into, if scanned through the same device it would climate the chore but if another device was scanned it let that device pick all the options).
- Log each scan automatically to a Google Sheet, recording:
Date
Time
Assigned chore
- Reset the list of available chores daily at 4 PM, so all chores become available again.

-Must work without requiring guests to log in or have a Google account when scanning the QR code.

Let me know if this is something you can provide us advice on.