BarcodeLookup™ DB
Pull data through an API from BarcodeLookup.com and return product data for scanned barcodes
BarcodeLookup™ DB uses the test API key and make provision for user to enter their own API key since there is a paid tier provides better access.
Using the Barcode as the unique ID, the search return the query-able data and enter it into the corresponding column in the Google Sheet
There's a monitor on the account page that shows the number of lookups per minute and month
The 2 last columns show the last run time and status
Try it out and let me know what kind of upgrade/features it need to make it work better for you.