How to write an XPath query for Google Sheets?

Question

XPath

I first encountered XPath, read the documentation, but I can’t figure out how to display links from a pop-up window on the page https://zen.yandex.ru/top/cars specific topic Example: Sostaritsy https://zen.yandex.ru/top/ collect links https://zen.yandex.ru/top/ cars , etc. - I can’t make a query in the Google Sheets formula in order for channel links for each topic to be transferred to the table. In this example, I collected links to 1 topic by hand https://docs.google.com/spreadsheets/d/11iX2r2T0GT...






I understood how to pull out the Audience and Subscribers, but I wanted to fully automate the parsing

Answer 1

Offhand: there the entire interface, including the popup, is rendered by js. Therefore, a simple xpath from Google tables cannot pick them up. js needs to be rendered.