Use a list of SKUs in a google sheet to pull their data from GOAT marketplace

Question

I am looking to pull the price data for each of the SKUs I have listed in a google sheet.

My initial try was the use a formula inside of the sheet.

=importxml("SKU Search URL", "//p/span[@data-qa='grid-cell-price']/text()")

This does not work, since the content is dynamic.

What would be the easiest method of obtaining this data?

share a copy of your sheet, url and example of desired result — player0, Jul 23 '21 at 20:09
@player0 https://www.filemail.com/d/tnqgzgurswwslzn Eveything is in that sheet. — NathanMorrison, Jul 23 '21 at 20:21

score 0 · Answer 1 · answered Jul 23 '21 at 20:23

0

Google Sheets does not support web scraping of JavaScript controlled elements. you can easily check it by disabling JS for a given site and only what's left visible can be scraped. in your case, that's nothing, unfortunately:

answered Jul 23 '21 at 20:23

player0

124,011
12
67
124

I have become aware of this. I am looking for an alternative solution to this. – NathanMorrison Jul 23 '21 at 20:30
@NathanMorrison alternative solution includes alternative source – player0 Jul 24 '21 at 00:00

Use a list of SKUs in a google sheet to pull their data from GOAT marketplace

1 Answers1