Best products from r/sheets

We found 2 comments on r/sheets discussing the most recommended products. We ran sentiment analysis on each of these comments to determine how redditors feel about different products. We found 2 products and ranked them based on the amount of positive reactions they received. Here are the top 20.

Next page

Top comments mentioning products on r/sheets:

u/6745408 · 1 pointr/sheets

no problemo. I have a 'wishlist' sheet just like the one you're making.

For mine, in H2 I paste amazon.com URLs like https://www.amazon.com/dp/B00070E8LA or ebay URLs like https://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.

u/bfcrowrench · 1 pointr/sheets

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.