Questions tagged [importxml]
For questions specifically about the Google Sheets function: IMPORTXML()
26
questions with no upvoted or accepted answers
2
votes
0
answers
1k
views
My ImportXML with XPath doesn't work
I've got a problem. I'm trying to import data in my google sheet document using =ImportXML with XPath from this page : https://www.boursorama.com/bourse/produits-de-bourse/cours/warrants/...
- 21
2
votes
2
answers
2k
views
Using Google Sheets to bulk collect the number of Google Search results for given keywords
I would like to create a Google Sheets that will allow me to paste in a list of 25 or so keywords in column A and would then return the number of search results for each of those terms in column B.
...
Jake Havenridge
1
vote
1
answer
228
views
Importing data from Investors.com, getting #N/A (google sheets)
I am attempting to pull from https://research.investors.com/stock-quotes/nasdaq-apple-inc-aapl.htm
I want to get the EPS Rating which is the 305th list item, which I found using
var i = 1; [].forEach....
- 11
1
vote
0
answers
275
views
Google Sheets' IMPORTXML pulling from the wrong region
I'm using IMPORTXML to get the price of an electronics component from Mouser:
If the prices are refreshed as a result of me editing the spreadsheet, it requests from my computer, and results in the ...
- 111
1
vote
1
answer
706
views
Import Price from Gamestop Into Google Sheets
I'm trying to obtain a price from a given Gamestop.com URL and have it imported into a Google Sheets document, but I can't seem to make it work. I've tried to use the importXML formula but don't seem ...
- 11
1
vote
0
answers
80
views
Function always parses column in first row but would like it to repeat
I am trying to make a function that repeats in each row of a column that fetches the URL in the first column, does an xpath query and gets an image.
Currently its all working other than the fact it ...
- 111
1
vote
0
answers
3k
views
How can I decrease IMPORTXML refresh interval to 10 mins?
I have a couple of IMPORTXML’s fetching the prices for products, and I want the sheet to update the prices every 10 mins. I tried now() and a functions script but to no avail. What is the best way to ...
- 51
1
vote
0
answers
33
views
Ensure results stay in redesignated column and don't migrate back to original column
Before updating my spreadsheet to fetch new information from the provided scripts, I insert a new column in between the input column (A) and the results column (B). I want my new results to be next to ...
- 105
0
votes
1
answer
24
views
Google Sheets: Splitting siblings by different @class attributes into columns using IMPORTXML formula
Good day, everyone! ^^
I am still a beginner in Google Sheets formulas and still don't understand many things, but I am trying to scrape sample sentences from an online Japanese dictionary using ...
- 55
0
votes
0
answers
69
views
help with importxml
can someone tell me why this isnt working?
=IMPORTXML("https://wax.alcor.exchange/markets" ; "/html/body/div[1]/div/div/div[5]/div/table/div/div[1]/div[21]/div/div[3]/span")
I try ...
- 9
0
votes
0
answers
20
views
Serch for multiple strings in importxml
=query( importxml("http://centegix.com", "//@href"), "where Col1 contains 'twitter' ", 0 )
How to make this formula to return just "Twitter" if it contains a ...
- 3
0
votes
0
answers
37
views
Get Ask and Bid Option Prices from Fidelity's Website Using Google Sheets
I was able to get ask/bid option prices for a particular option from Fidelity Brokerage's web site using Google Sheets and importXML - but no longer. I think the site changed.
The website to access ...
- 1
0
votes
0
answers
3k
views
Extracting the price from an external page using IMPORTXML on Google Sheets?
I am running a Google Sheet and I want to extract the price of Bitcoin from a site called CoinMarketCap. The site is quite simple as is mainly a listing, and have a table full of different ...
0
votes
1
answer
1k
views
Google Sheets: word count for a webpage content (url) for SEO
For SEO analysis, I am using Google Sheets to extract basic data from my own webpages.
I am able to access page title, description, <h1> tags, or number of characters via LEN():
=IMPORTXML(A3, ...
- 101
-1
votes
1
answer
5k
views
Google Sheets ImportXML //div[@class= is not working
I am trying to scrape the div "tech-name" from this website
https://www.whatruns.com/website/bestbuy.com
with the following formula
=index(importxml("https://www.whatruns.com/website/bestbuy.com","/...
- 1
-1
votes
1
answer
324
views
Web App get url not working from IMPORTXML
My goal is to get data into my spreadsheet from my script that mimicks the way IMPORTXML works. I want to return html from my script and consume it with IMPORTXML.
It's disabled now, but at the time ...
- 289
-1
votes
1
answer
341
views
Scraping currency conversion rate from Oanda.com
A currency conversation formula for example:
=GOOGLEFINANCE("CURRENCY:"&C$2, "price", A3,)
Will display the closing price by default under "price". There is no option for the Average price. ...
-1
votes
2
answers
284
views
Get translation using Google Sheets and IMPORTXML
I want to scrap the phonetic guide for a translation in Google Translator using Google Sheets.
For instance, if you enter the page:
https://translate.google.com/#view=home&op=translate&sl=...
-1
votes
1
answer
131
views
Trying to fetch data from shopback.com.au with ImportXML function in google sheet
I am trying to fetch store name and cashback percentage from this website using google sheet's importxml function.
Put following commands with no success. Please help
=importxml("https://www....
- 11
-1
votes
1
answer
145
views
IMPORTHTML - Can't find specific table on WNBA.com
https://www.wnba.com/stats/team-stats-advanced/#?Season=2018
Is the web page. I can't seem to find the table for advanced team rates or opponent.
-1
votes
2
answers
843
views
Retrieve fund price from Vanguard website using importxml in Google Sheets
This was working in Google Sheets but now I get #N/A message:
Imported Content is Empty
A1: https://institutional.vanguard.com/web/c1/product-details/fund/1680
A2: //*[@id='dailyNavValue']
A3: ...
-1
votes
1
answer
635
views
IMPORTXML error - empty table
I am trying to import a table from the lower part of the following website to Google Sheets:
https://vistacapital.com.br/
I used the formula:
=IMPORTXML("https://vistacapital.com.br";"//*[@id='sos-...
- 1
-1
votes
1
answer
196
views
Importxml convert content only
I am getting the price value from the website. I would like to make the value as static(remove formulas) to prevent auto refresh in sheet due to that the price values will change-- I don't want it. ...
-1
votes
2
answers
8k
views
I got this "Error: Imported content is empty"
I am trying to create a google sheet to combine some information. I want the sheet to pull information h index of my friend
this is the code
=IMPORTXML("https://www.scopus.com/authid/detail.uri?...
-1
votes
1
answer
874
views
How to quote formula result?
I have a function which returns a URL from hyperlink as a first parameter to IMPORTXML function.
For the function to work I need to put the output of that function in quotes, how do I do it?
- 19
-1
votes
1
answer
685
views
index(split(ImportXML formula works in a spreadsheet of mine, not in another?
=index(split(ImportXML("http://finance.google.com/finance?q=" & V9, "//td[@data-snapfield='latest_dividend-dividend_yield']/following-sibling::*"), "/"),1,2) / 100
This formula works in a ...