How to Scrape TCGPlayer Prices into a Google Sheet

Here is the formula for scraping TCGPlayer pricing into a google sheet. Change the URL to whichever item you would like. You can try other xpath data points but I found this most reliable.
=importxml("www.tcgplayer....","/html/body/div[2]/div/div/section[2]/section/div[2]/div[2]/section[3]/div/span/span/div/div[1]/div[1]/div/div/div/div[2]")

[@Badbr1gggsy]

the man himself

[@dogbert9rocks]

Incredible useful, thanks!

[@Kitchenfire0]

Its cut off for me, too. Not sure why.

[@KetchumAllCollectibles]

Yt shorts on mobile cuts them I guess. If you watch on desktop it's not

[@DaanMat]

can you paste that command into the comments here since its hard for us to type all that out from a short thanks!

[@KetchumAllCollectibles]

It's in the description

[@ckakka2]

@@KetchumAllCollectibles The command is cut-off in the description.

[@ckakka2]

=importxml("URL","/html/body/div[2]/div/div/section[2]/section/div[2]/div[2]/section[3]/div/span/span/div/div[1]/div[1]/div/div/div/div[2]")

[@KetchumAllCollectibles]

@ckakka2 I'm looking at it right now... It's literally not lol. "You can lead a horse to water"

[@Kitchenfire0]

@@KetchumAllCollectibles I had the same issue. KZbin cuts it off when you are viewing it from the "short" viewer (or whatever its called). When I watched the short from KZbin's "long-form" viewer and view the description, it shows the entire command. I had to save the video to a playlist to view it in this way.