Need help with specific xpath_query for importxml (Google Sheets)

[mrblister]

The IMPORTXML formula for Google Sheets is "=IMPORTXML(Url, xpath_query)". For example webpage Amazing Spider-Man #365 Value - GoCollect, I've been trying to extract the data under "Preview Grades", specifically the FMV data per grade. I don't know what I'm doing wrong, but I can't figure out the "xpath_query" to that data. I keep getting errors like "no data" or "imported content is empty". Any help with xpath_query to the data I want would be appreciated!

 

[mrblister]

OK I figured it out. It's because the data is "dynamic", and dynamic data is (generally) not scrape-able.
You can still TRY though.

1. First, here's a guide to test if the data IS actually dynamic.
2. And if the data is dynamic, here are some ways you can still try to retrieve that data.

Note that it didn't work for me though; but hopefully it will work for you!