We live in a world that’s full data driven. Every decision that we make should rely on data which is available at our finger tips. Almost always the data is available within the countable infinite of web pages out there! Even more so, our data should be well organized and easily accessible! It’s not enough to simply Web Scrape a website, you will also need to get that data in a place where you can easily study and manipulate it – you got it, we’re talking about a Spreadsheet! KPIBees is different than the other Web Scraper out there, as it delivers the data exactly where you need it – in a Spreadsheet! KPIBees is a Google Sheet Add-on that makes it easier to pull data from various tool/data formats/websites to Google Sheets. You don’t need a chrome extension to web scrape, or an expensive tool like UIPath, a simple spreadsheet add-on that gets the data where you want it will do just fine! The tool can help you periodically web scrape certain values/texts from a web page or even assist in web scrapping the data that you need for your project.
One easy way to import JSON to Google Sheets is with the Google Sheets Add-on KPIBees. With just a few clicks, JSONs can be imported into Google Sheets.
Open KPIBees Gsuite Marketplace listing and install the Google Sheets Add-on.
STEP 2
You will need to provide standard add-on access to KPIBees – don’t worry, we are 100% GDPR compliant. We don’t access/use/resell any of the data.
STEP 3
Open any spreadsheet and go the Add-ons toolbar. Find KPIBees add-on and click on Launch.
STEP 4
Click on the Web Scraper Google Sheets connector to create your first query!
STEP 5
Let’s say we want to webscrape the view count of Ed Sheeran’s youtube video.
We need the get the video link and also the XPath that identifies the view count html element.
This is how you can easily retrieve the XPath using Chrome – also check the video for this web scraping example.
STEP 6
Add the url and the XPath. In this example, we are using the “Get Text Content” retrieval strategy which matches our desired use case.
STEP 7
Click on create query to pull the data to the selected spreadsheet cell! You can also automate web scrapping by adding triggered refreshing to your spreadsheet.
Let’s say you want to web scrape an html table from a website and bring the contents of that table to the spreadsheet. For example, we want to bring the first table in order of occurrence from the Oldest People wikipedia page.
Select the web scraper connector, and the website url, and set the table index that should should be parsed to google sheets. In the Advanced section you can set a lot of others details, such as login parameters, how much time to wait until the page is loaded before beginning to web scrape the content etc. Then click on “Create Query”.
After the query is created, the content is pulled to the selected spreadsheet cell. If you to select another table from page, simply select the order in which it occurs in “Which table to retrieve” and run the query again!
In terms of Web Scraping a website, there are several strategies to pull the data that KPIBees offers:
Google Spreadsheets
