How can I write the XPath to pull back underlying text not on the webpage?
I am trying to use =importXML in Google Sheets to pull back text circled in blue. Notice this information does not actually appear on the webpage, but is in the underlying code. Below is the image, full XPath of what I’d like to pull back. How can I make the importXML XPath Query Dynamic so I can pull back information for various URLs I have?
Generating Xpath to get attribute value via IMPORTXML
I’m accessing this website: https://workspace.google.com/marketplace/search/mail%20merge