This demo is running as me, so you don't need to authorise the script. In your own organisation, you should probably choose to let the script run as the user accessing, which is the best for logging purposes, but that also requires you assign your users proper admin rights.
Searching for a device by serial number or email address does a query in a previously created Google Sheets file.
Normally you would have either a time triggered Apps Script or a scheduled GAM to keep the Sheets file updated. As this is a demo, the file is static.
You can always find my tools over on Github, linked top-right, but on these pages I also demo some of them.
My tools are usually completely free, but if you feel they have helped or improved your workflow in any way, you are welcome to PayPal me any amount you deem appropriate.