• Extract open data from API

    The web is a fantastic place full of valuable, public information just waiting to be analyzed – if you know where to find it. Luckily, we know exactly where this data is and how it can be extracted from open APIs to be manipulated and analyzed. And we want to pass this skill on to […]

    Read full article
  • How to monitor prices on Amazon?

    Existing solutions for Amazon price tracking There are several solutions out there that allow you to track Amazon item price history: Keepa is an Amazon product finder & tracker that allows you to select, filter products using a visually nice looking UI. However since the data that you are getting for the products is mostly […]

    Read full article
  • Track Your investments within Google Sheets

    Retail trading is easier than ever, with thousands of amateur day traders investing as either a hobby or to boost their income. However, stocks open early every day and trade quickly. Keeping an eye on your investments and investment opportunities can be extremely challenging, and, unless you have the right tools, time-consuming. Fortunately, there are […]

    Read full article
  • A user-friendly alternative to IMPORTXML

    The IMPORTXML function is native to Google Sheets and can be used to scrape data from some websites and get them directly into your spreadsheet. However, there are some known limitations and issues that can make it a frustrating experience – particularly if you’re not comfortable navigating websites’ source code.  This article will help you […]

    Read full article
  • How to scrape Google Maps data?

    Approaches for Google Maps scraping There are multiple approaches to scraping Google Maps data and the best approach will depend on your needs, your skills and the resources that you have allocated for the task. For example if you have some coding skills, you might choose to create your own scraping tool, but if you […]

    Read full article
  • How to scrape Amazon product details

    Amazon sells more than 12 million products online. If you add to that the Marketplace Sellers products, that number increases to more than 350 millions unique products! With this huge offering, it’s understandable why it has become “the Google” for online shopping. It is one of the first places that customers visit in order to […]

    Read full article
  • How to convert JSON data into a table

    JSON is a powerful file format based on Javascript object syntax that can store a wealth of complex information that’s waiting to be extracted. Luckily, our ImportJSON tool makes this intricate process much simpler, giving you access to an abundance of API data that may otherwise go untapped.  One of the main difficulties of working […]

    Read full article