This Google sheet function automatically pulls prices from products on certain websites as well as some other random sites . You will receive instructions on a Google Doc with a small piece of code and a script ID. These will be easily copied and pasted into the "Apps Script" section of your Google Sheet by following the provided instructions.

These are the sites it is currently known to work with. However, it may also work with other sites unknown to me:

target.com

samsclub.com

zoro.com

pfaltzgraff.com

entertainmentearth.com

farmandfleet.com

webstaurantstore.com

lakeside.com

hobbylobby.com

nike.com

saksfifithavenue.com

Note: Due to what I suspect are changes on Home Depot's website pulling price data from their site has become unreliable. Also, Walmart and Amazon are blocked from direct access in Google sheets (using the free method).

However, I have another tool to pull price, shipping, stock, image, lead time that works with both Walmart and Amazon and hundreds more suppliers!

https://youtu.be/THtPExY82Pw

This is an ongoing project where I will continue to test and add more websites and functionality. Please join me in this quest by purchasing this function and getting all future updates FREE FOR LIFE! Your purchase provides the support needed to cover costs and time of doing research and producing tools for sellers.

Thank you!

Mr. Mark Wed

Mark Teach

Tools, Tutorials, and Resources

for Business and Personal Management

Be sure to select “Subscribe for Newsletter and Updates” during checkout so I can send you updated versions of this system!