Questions tagged [xpath]

XPath is a language for addressing parts of an XML document that can be used by some web apps like Google Sheets to import structured data.

10 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
785 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/...
1
vote
0answers
77 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 ...
0
votes
0answers
21 views

Google Sheet Importxml did not work with div shown after I click button

I tried to extract Google Map link from web site using Importxml function of Google Sheet, anyway the data will show up after I click a button as picture below ( the div will show after I click a ...
0
votes
0answers
87 views

Data Scrape to Google Sheets from MyFitnessPal.com

I would like to be able to pull the macronutrient (and more if possible) data from MyFitnessPal using what i assume would need to be an importhtml() or importxml() function directly onto a google ...
0
votes
0answers
93 views

How to separate direct sibling elements into different columns?

So basically I'm trying to import a list of values from a certain web-page into my spreadsheet and I'm stuck. I want to make a list of names with their corresponding number stages next to them, all ...
0
votes
0answers
136 views

Pull “Fair Value” from Yahoo Finance to Google Sheet using XPath?

Currently, I am using xPath to grab Ex-Div date, Dividends, etc but I cannot seem to be able to grab the Fair Value "Undervalue" rating from Yahoo Finance. I want the "Undervalue" to be specific but ...
0
votes
0answers
99 views

xPath_query from IMPORTXML in Google sheets ends up empty

So, in these covid19-infested days I want to update our digital signage with the current situation. Want to use google sheets and IMPORTXML to fetch data from a website that is frequently updated with ...
0
votes
1answer
472 views

ImportXML error: 'imported content is empty' when selecting for text within a list item

I want to scrape a text within this website in google sheets with the IMPORTXML function. Through dev tools by inspecting the text in question, I get the corresponding HTML: <li _ngcontent-udl-c4="...
-1
votes
1answer
165 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
2answers
167 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=...