Or do an investigation check of the room and collect everything based on that roll? Would make it easy. Obv i can see people not being too happy if they roll a 1, RIP.
Yes, that "Room Investigation" would be good, and it could be arranged so that incremental amounts of stuff is revealed, depending on your die roll. For example:
No Investigation: Nothing
01-05 Gold in 2 chests
06-10 Above plus secret panel revealed
11-20 Above plus mysterious paperwork