All Questions
Tagged with google-sheets xpath
626 questions
0
votes
0
answers
35
views
How to get YouTube Video's Highlighted Comment in Google Sheet with REGEXEXTRACT or IMPORTXML
I want to get the author and text of a YT video's "highlighted comment" into a Google Sheet.
I did some research and found plenty of help for other metrics, but not this specific feature, ...
0
votes
2
answers
99
views
IMPORTXML Google Sheets Formula not working
I am trying to use =IMPORTXML() in Google Spreadsheets, but I get "Imported content is empty." even with the right xpath_query argument. I've used a xPath Generator tool here.
I get this ...
0
votes
0
answers
28
views
How to fetch data from the site that updates in real time as you enter it using IMPORTXML? [duplicate]
I want to import data from https://demonlist.org using this xpath: //a[@href='/classic/1']/descendant::p[1] to a google spreadsheet but it returns that theres no data to import.
I checked the sites ...
0
votes
1
answer
44
views
How to parse XML in Google Sheet?
This URL
https://export.arxiv.org/api/query?id_list=2308.05734 contains the xml below.
<?xml version="1.0" encoding="UTF-8"?>
<feed xmlns="http://www.w3.org/2005/Atom&...
- 20.2k
1
vote
1
answer
96
views
Google sheets IMPORTXML and XPath href and title not returned
I need to extract some URLS and their respective titles using Google Sheets ImportXML with Xpath.
I found these previous answers and tested them but they don't seem to be working for my case:
Extract ...
- 759
0
votes
0
answers
123
views
How to get Updated Consumer price index (CPI) from a website in google sheets?
Need to get India's CPI and update all the prices in my sheet every year based on it.
I tried using IMPORTXML (“url”,”xpath”), but that doesn’t seem to work, i am getting "N/A" error.
I used ...
- 1
0
votes
1
answer
236
views
Google sheets and Bank Of Canada Valet API - how to import data monthly for USD/CAD
I managed to play around with the BoC Valet API in Google sheets to obtain daily USDCAD rate for a specific period.
=importxml("https://www.bankofcanada.ca/valet/observations/FXCADUSD/xml?...
0
votes
3
answers
1k
views
How to get YouTube's channel subscriber count in Google Sheet with IMPORTXML
I want to get the number of subscribers of a YouTube Channel into a Google Sheet without using the YouTube API.
I did some research and found some examples but I'm still stuck.
The input is a url like ...
- 23
1
vote
1
answer
37
views
Returning xpath value based on decendent criteria within IMPORTXML
I am trying to return the Time and Name of movies from a list, however I seem to get so far and end up going around in circles!
This is the HTML I am using:
<li>
<a href="XXXXXX" ...
- 147
0
votes
0
answers
26
views
How to use Google Sheets IMPORTXML function to get Sector and Industry values from Fidelity website [duplicate]
I am trying to use the IMPORTXML function in Google Sheets to retrieve the "Sector" and "Industry" values under "Company Profile" for Fidelity's website here:
https://...
- 455
0
votes
0
answers
78
views
What is the XML query to put this weather data into a Google Sheet
I am trying to put weather data from this website into a google sheet and I have been unable to find an XPATH query that will work. Can you help me?
https://tsvweather.brownrice.com/dailysnow.php
I ...
- 1
-1
votes
1
answer
32
views
How do I import the data on this Website using Importxml on Google Sheets?
I'm currently trying to import via importxml on GoogleSheets the entire Table on a website but it dosen't return the data. The formula I'm using is =IMPORTXML("https://dinem.magyp.gob.ar/...
0
votes
1
answer
109
views
I can import just first ten items with importxml in google sheet
I'm trying to import titles from a website with IMPORTXML function in google sheet but it is import just the first 10 from list, but what i need is to import all titles list
this is my formula:
=...
- 23
0
votes
0
answers
20
views
Google Sheets Error - Resource at URL not found [duplicate]
When i try to get Yahoo Finance stock price importxml return error. Anyone know solve for this problem?
B2 = ASTOR.IS
P2 = "https://finance.yahoo.com/quote/"&B2&"/key-...
1
vote
1
answer
86
views
How importxml google sheets Can use * in class substring value [@class='myClassValue--&"*"']? Forexfactory
I'm trying to import all at once the values from a class split in 3 subclasses.
The class was subdivided into 3 'subclasses' substrings values appended "--low", "--medium", "--...
- 759