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 https://support.google.com/docs/answer/3093342?hl=en&ref_topic=3105411