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 URL using xpath
How do I return a specific link address using IMPORTXML and XPath
I tested these formulas:
=IMPORTXML("https://ok.ru/video/334044074277","//*[contains(@class, 'video-card_n-w')]//a/@href", "en_US")
=IMPORTXML("https://ok.ru/video/334044074277","//*[contains(@class, 'video-card_n-w')]//a/title/text()", "en_US")
=IMPORTXML("https://ok.ru/video/334044074277","//*[@id='hook_Block_VideoMovieCardBlock_9556824694']/div/div[2]/a", "en_US")
Which return #
, N/A Imported content is empty.
, N/A Imported content is empty.
.
The xpaths seems correct on chrome developer tool.