Tag Info

New answers tagged

0

For extracting the price, you could use this formula. Formula A1 = "http://www.walmart.com/ip/Dell-Pre-Owned-Refurbished-Silver-745-Desktop-PC-with-Intel-Core-2-Duo-Processor-4GB-Memory-750-Hard-Drive-and-Windows-7-Professional-Monitor-Not/21907344" =IF( ISNUMBER( INDEX(SPLIT(IMPORTHTML(A1, "table", 2), "Online, $, Quantity"),1,2) ), ...


0

Ultimately, I can't do it with Google's functions. As a result, I decided to write a custom function. Go to Tools -> Script Editor. Click "Spreadsheet" on the left hand side to create a new document. Scroll down and paste the following code in: function getWalmartPrice(url) { var html = UrlFetchApp.fetch(url).getContentText(); //Can't create document ...



Top 50 recent answers are included