IMPORTFROMWEB is a new add-on for Google Sheets that retrieves any content from webpages into a sheet.
IMPORTFROMWEB creates a new function IMPORTFROMWEB() that takes as main parameters a range of web urls and a range of xpaths. It returns the results of the xpaths for each url.
- High volume of requests per sheet
Use the function hundreds of times per spreadsheet
- Scrapes pages loaded with JS
- Caches results so it doesn’t recalculate at any change
Unlike IMPORTXML, it doesn’t update the cells at any change in the spreadsheet. Instead it uses a smart and customizable cache system
- Regex manipulations
Uses the power of regexs in order to extract or replace specific parts of texts
- Stack results of multiple search pages in one list
IMPORTFROMWEB() is an evolution of the native Google Sheets function IMPORTXML(). Unless the latter, it is much more powerful and reliable.
| buggy when it is called more than a dozen of times in a spreadsheet. ||Works flawless with hundreds of formulas per sheet|
|The more formulas, the slower it gets||It’s lightning quick!|
|Refreshes at any change in the spreadsheet||Caches the data on demand, so it doesn’t recalculate all the formulas at any change|
|Very basic. No option!||Many options available for powerful scraping.|
For instance, it gives options to extract or replace parts of the results with regexs
Check out the documentation