How to link data points from multiple websites

Alex Fite

What I'm trying to do is make a spreadsheet that consists of my competitors current price on multiple website like Amazon, Walmart, and Ebay. What i've tried so far is a couple of apps that link data but some won't connect with smartsheets and others don't provide the data I want. Does anyone know how I can pull the price for a single items listing and update it constantly or daily as their price changes into a smartsheet.

Paul Newcome

Have you looked into using a data scrape type solution in Excel or Google Sheets and then using Data Shuttle to pull the data into Smartsheet?

Alex Fite

The main problem I have been having with scraping is all the programs I've seen so far make you download the data you scrape from a single page and I have hundreds of pages I would need to scrape meaning I get hundreds of Excel documents any time I want to update the data. Another Problem I had with it is I sell many similar products but they are sold at different prices so I'm trying to get the data received in a organized format so I don't need to check which exact size or color it is.

Paul Newcome

There are ways to scrape in both excel and google sheets that do not require special programs or anything. They are built directly into the core product.

https://www.groovypost.com/howto/how-web-scraping-in-excel-works-import-data-from-the-web/

https://support.google.com/docs/answer/3093339?hl=en

Alex Fite

Unfortunately Excel did a update a couple years back making it so you can only import information from websites that is in a table. Google sheets works for some sites but sites like Amazon aren't compatible. But I did find a solution with the desktop version of Microsoft Power Automate. It has a paid cloud based option but also a free desktop version that acts as complex macros letting pull info from the web and import into Excel then copy and paste into Smartsheets. It also lets me do it in a organized format letting me pull any words or number then paste into a exact cell in Excel making it super easy to copy and paste into a template in Smartsheets.