I just wanted to post what I ended up doing. Maybe it’ll help someone down the road. I’m not sure this is the most efficient way to do this, but it works.
I’m using a combo of Google Sheets Functions and Appsheet Automations.
My spreadsheet looks something like this:
Column D contains the following function: =REGEXREPLACE(IMPORTXML(“https://www.upcitemdb.com/upc/"&C2,"//title"),"^\d+ - +”,"")
Here I’m basically copying what I found here except I’m using https://www.upcitemdb.com which seems to be a much bigger database.
The problem with the results it that it contains extra text that I don’t want.
For example, UPC 038000070105 - Corn Flakes Kellogg’s Corn Flake Crumbs, 21 Ounce |
I only want the product name. So I ran another two functions to remove the first and last parts of the text.
Column E contains the following function:
Column F contains the following function:
I’m now left with the results I need.
The rest is done with AppSheet.
The name of my Data sheet is Items.
First create an Event. in our case, when data is added to our table.
Next create two processes. The first one copies the barcode from Column B to C
The second copies the item name (after the lookup) from Column F to B
Finally, I tied it all together with a Bot. When the Event is triggered, run both Processes.
And it works whew!
To use, simply scan a barcode and hit save. The rest runs in the background and the result is an item name and barcode.