I was wondering how can I scrape random websites article titles and links at the same time. For example i want to scrape article titles and their links from this website to my google sheets document: https://jamesclear.com/articles I used importXML function but unfortunately, I cant do it and I'm pretty sure I don't know how to do it.

Thank you

CodePudding user response：

Try

=importxml("https://jamesclear.com/articles","//div[@class='all-articles__list']//li")