IMPORTFROMWEB is the easiest way to start scraping data from any website. Find out how you can start filling your new blank sheet
In your spreadsheet, go to Add-ons > Manage add-ons
- If IMPORTFROMWEB is displayed in the list, check that it has been added to your document by pushing Manage > Use in this document
- If IMPORTFROMWEB is not in the list, go to the menu Add-ons > Get add-ons and search for IMPORTFROMWEB
Importing data is as easy as typing
=IMPORTFROMWEB([the url you want to search], [an XPath to describe the content you want to import])
In Google Sheets menu, go to Add-ons > IMPORTFROMWEB >Build function.
It will load a sidebar on the right side giving you a lot of support to create your function and discover all the capabilities.