IMPORTXML from Etsy- 'Imported Content is Empty' error

0
votes

I built a spreadsheet to keep track of the daily sales in my Etsy shop and had successfully pulled the live number through an ImportXML formula. This week, the formula suddenly began to return an 'Imported content is empty' error and I can't seem to figure out how to fix it.

I'm trying to scrape the number where it says "337 Sales" at the top of this page.

Previously, I had successfully used

=IMPORTXML("https://www.etsy.com/shop/lmnoprints", "//span[@class='shop-sales hide-border no-wrap']")

But it seems that Etsy has since updated some things and that Xpath no longer exists. Now I have tried

=IMPORTXML("https://www.etsy.com/shop/lmnoprints", "//span[@class='wt-text-body-01 no-wrap']")

...but I'm still getting the same error message. Can anyone point out any dumb mistakes I'm making? Thanks for your help in advance!

2
web-scrapinggoogle-sheetsgoogle-sheets-formula

2 Answers

0
votes

I replaced the url based on this link

Use:

=IMPORTXML("https://www.etsy.com/shop/LMNOprints", "//span[@class='wt-text-body-01 no-wrap']")

Output:

enter image description here

0
votes

Received help for this through Reddit! Posting to help anyone else having this issue:

=index(importxml("https://www.etsy.com/shop/LMNOprints","//span[@class='wt-text-caption wt-no-wrap']"),1)