In this episode of Google Workspace Add On Walkthroughs (GWAOw!), we take a look at ImportFromWeb by NoDataNoBusiness.
ImportFromWeb is a powerful web scraping tool for Google Sheets that allows you to grab data from any website. The creators call it IMPORTXML on steroids.
You can use ImportFromWeb as a Google Sheets function or use one of their incredible templates.
This tool is ideal for Google Workspace businesses that need to find and store live data from websites. Whether you are scouring the web for new client prospects or keeping an eye on your competition, this might be the tool for you.
In this walkthrough, we really just scratched the surface on ImportFromWeb’s capabilities. We walk through three practical examples covering retrieving a list of books from a web store, listing the first page of Google Workspace jobs on Indeed.com and then getting the latest Tweets for Google Workspace on Twitter. I’ve added the formulas below from the video for you to try out once you installed the add on.
I also managed to score us a 40% discount when you purchase ImportFromWeb after your trial, use the code YAGISANATODE40 at check out to get the discount or use this link:
Check it out on the Google Workspace Marketplace: ImportFromWeb
Example 1 – Book List (xpath)
URL: https://www.booktopia.com.au/search.ep?keywords=Terry+Pratchett&productType=917504
Selector: //*[@id="product-results-p1"]/li
Example 2 – Job List (css selectors)
URL: https://www.indeed.com/jobs?q=%22Apps%20Script%22&vjk=4b000129055a847f
CSS Selector: .jobTitle
CSS Selector URL: .jcs-JobTitle/href
Example 3 – Twitter (jsRendering) – Playground
URL: https://twitter.com/search?q=%23GoogleWorkspace&src=typed_query&f=top
Selector: article
Check out more Episodes of GWAOw! here!