google sheet product list creation using barcode scanning

Description

Requirements
Implement a barcode scanner using Google Sheets.
Scanning a barcode should retrieve item details from a master sheet containing all inventory data.
Automatically generate a shopping list from scanned items.
Employees should be able to access and manage the shopping list via a web app built using Google Scripts.
Enable functionality to email the generated shopping list.