Google Sheets (importHTML or importXML)



Hi, I use the importHTML function within google sheets both on websites as well as with password protected apps successfully. I have had to use the importXML in a few cases but either have pretty much worked for me almost all the time when pulling data live into a spreadsheet.

This is an example of what I have been using in the command line of the Google Sheet
But when I went into view source, it appears as if there is no Table or List within a hubspot view. Which is why this likely hasn’t worked.

Should I be using importXML instead? Can anyone tell me what the xpath query should be for a company view, to pull into a google sheet?

here is more about the Google Sheets importXML function


Did you figured out? I might also be interested by your solutions!