To obtain very specific bits of that HTML, Google Sheets uses a structured data format called XML and a related query language called XPath. Such a formula in Google Sheets is built up as follows ...

How to use Google Sheets to create, work with, and collaborate on spreadsheets — and how Gemini, Google’s AI assistant, can give you a head start.