I’m thinking of using QR codes as barcodes. My main question is how can I have the scan of a code communicate with the spreadsheet? Ideally with no hardware other than a phone and no added apps.
You can open scans with zxing links on a webpage but you'll likely want an app - cause the performance will be better.