App 02

UPC Music
Scanner.

Point your phone at a barcode on a CD or record. Get artist, title, label, and format โ€” automatically logged to a Google Sheet you own. A tool for music collectors who want their physical collection catalogued without typing anything.

App starting
How it works
Scan barcode
Camera detects UPC from CD or vinyl sleeve
โ†’
MusicBrainz
Looks up artist, title, label, format, release date
โ†’
Google Sheets
Appends a row to your own spreadsheet via Apps Script
โ†’
Discogs
Optional: fetch want-list counts via Apps Script in your sheet
๐Ÿ“ฑ
Installable PWA

Add to your Android home screen for a native app feel โ€” no app store needed.

๐Ÿ”’
Your data, your sheet

Nothing goes to a server you don't control. Data lives in a Google Sheet on your own Drive.

โœ“
Fill missing data

A custom Sheets menu can backfill rows where MusicBrainz data is incomplete.

{ }
Plain JavaScript

No framework, no build step, no npm. A single HTML file, a JS file, and a CSS file.

Scanner active on a barcode Match result screen Populated spreadsheet Installed on home screen

The app runs in your browser and can be installed to your Android home screen. Before you can use it you'll need to connect it to a Google Sheet โ€” setup is being simplified and will get easier soon.

Full setup instructions โ†’
1
Create a Google Sheet

Set up a spreadsheet on Google Drive with the column headers listed in the README. This is where your scanned items will land.

2
Deploy the Apps Script

Add the provided Apps Script to your sheet via Extensions โ†’ Apps Script, deploy it as a web app, and copy your Deployment ID.

3
Open the app on your phone

Visit mediascan.chrisschumann.dev in Chrome on Android. On first run, enter your Deployment ID. Requires Chrome โ€” BarcodeDetector is not available on iOS or Firefox.

4
Add to home screen

Tap the browser menu (three dots) and select "Add to Home screen" for a native app-like experience that opens without the browser chrome.

Plain JS PWA MusicBrainz API Google Apps Script Discogs API MIT License

Uses the browser's native BarcodeDetector API โ€” no third-party scanning library. The Google Sheets integration runs via Apps Script deployed from within your spreadsheet. The optional Discogs want-list lookup is a separate Apps Script function in the same sheet โ€” it never touches the PWA itself.

Requirements
Open source