Linking Web Scraper with Google Sheets

I am trying to scrape a website and pull one piece of information based on searches it would preform from a name column in a google sheet.
For example, a google sheet that had the columns of product name and price. I am hoping I could set up the scraper to run a search based on the column name and then yield the price listed from that search. Not sure if this is possible or if that made sense, but hoping to see if that could work!

@grace Hi, are you able to share the targeted website?