Top products from r/sheets
We found 2 product mentions on r/sheets. We ranked the 2 resulting products by number of redditors who mentioned them. Here are the top 20.
1. Star Wars: Dawn of the Jedi, Into the Void (Star Wars: Dawn of the Jedi - Legends)
Sentiment score: 0
Number of reviews: 1
Star Wars: Dawn of the Jedi, Into the Voidthis book dates back before the movies and the video game KOTORFast pace, and easy to readA must for all Star Wars fans
2. OSTER Classic 76 Universal Motor Clipper 76076010
Sentiment score: 1
Number of reviews: 1
Powerful, single speed universal motor for heavy-duty useDetachable blades - sizes 000 and 1Includes blade guard, lubricating oil, clipper grease and cleaning brushUltra-durable, break-resistant housing9 foot power cord; Designed with ultra-durable, break-resistant housingRenowned for its lasting du...
no problemo. I have a 'wishlist' sheet just like the one you're making.
For mine, in
H2
I paste amazon.com URLs likehttps://www.amazon.com/dp/B00070E8LA
or ebay URLs likehttps://www.ebay.com/b/Motorcycle-Coats-Jackets-for-Men-Members-Only/57988/bn_14802713
Then in my pricing column I use
=IF(ISBLANK(H2),,IF(RegExMatch(H2,"amazon"),IFERROR(IMPORTXML("https://camelcamelcamel.com/product/"&INDEX(SPLIT(H2,"/"),4),"//*[@class='green']")),(AVERAGE(IFERROR(IMPORTXML(H2,"//*[@class='s-item__price']"))))))
This either pulls from camel or averages the list price from ebay. The ebay pricing isn't perfect, but it at least gives me rough idea of where things are sitting.
On my
DATA
tab I use=IF(ISBLANK(WISHLIST!H2),,IFERROR(IF(CLEAN(INDEX(IMPORTHTML("https://camelcamelcamel.com/product/"&INDEX(SPLIT(WISHLIST!H2,"/"),4),"table",1),0,1))="Price Type",CLEAN(INDEX(IMPORTXML("https://camelcamelcamel.com/product/"&INDEX(SPLIT(WISHLIST!H2,"/"),4),"//*[@id='tracks']"),0,2)),CLEAN(INDEX(IMPORTHTML("https://camelcamelcamel.com/product/"&INDEX(SPLIT(WISHLIST!H2,"/"),4),"table",1),0,1)))))
to pull a the full title, then on my main I am using=IFERROR(ARRAYFORMULA(INDEX(SPLIT(DATA!E2:E,",-",TRUE,TRUE),0,1)))
to clean up that long, bloated title.Probably overkill.
I don't know if this is any improvement over what you've got now, but you could try
=importHTML("https://camelcamelcamel.com/Star-Wars-Dawn-Jedi-Legends/product/0345541936?context=search"&AB4, "table", 1)
to get even more of the table.I noticed that if, for example, the product is not available on Amazon, ImportXML returns 2 values instead of 3. Without labels, i would assume this could get confusing.
I know what you mean about it getting messy and I agree. I'm bummed we couldn't get the query that you were after.