Select an empty cell and try:
=IMPORTFROMWEB( "https://www.amazon.com/s/?keywords=iphone", "//h2//text()" )
You can also run the example by opening the builder from the menu: Add-ons > IMPORTFROMWEB > Build function
IMPORTFROMWEB(urls, xpaths, regexs, replaceBy, options)
One or a list of URLs of the pages to retrieve
One or a list of XPaths describing all the elements to retrieve in the pages
(optional) One or a list of regular expressions to extract or replace specific parts from the content returned by each XPath.
- If the next argument replaceBy is not filled or NULL, it will extract some text from the content
- Otherwise, if replaceBy has a list of values, it will replace the extracted content by the values from replaceBy.
Each regEx from the list is associated to one XPath from the list of XPaths in such way that the first regEx will extract content from the results of the first XPath, etc…
Use regexes in order to clean up your data.
Check this article for the most useful regex rules to convert numbers, dates or currencies
(optional) One or a list of texts to replace the content extracted by the regexs.
Each string of the list is associated to one regex from the list of regexs in such way that the first string will replace the content extracted by the first regex, etc…
A reference to a two-columns range. The left column containing the options names and the second column the options values.
Only list the options that you want to override.
splitResults (Boolean | Char)
When an XPath returns various entries, the results are typically split so they expand in the cells around.
- TRUE: Results expand naturally in other cells
- FALSE: All results of an XPath are compressed in one cell.
- A character: Results are concatenated in one cell and separated by this character.
- Default is TRUE.
Whether to stack the results from all the urls.
Useful in case of retrieving various pages of a search as it will create a list of results
Default to FALSE.
jsRendering (Boolean | “force”)
However this behaviour can be overridden.
- TRUE: Let the engine decides when a page needs to be
Default is TRUE.
IMPORTFROMWEB caches the results in a smart way to avoid redundant recalculations. The downside is that the data can be up to 6 hours old.
If TRUE, the function will recalculate when any change occurs to the sheet.
Default to FALSE