Google Sheets (importHTML or importXML)

companies

#1

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
=importHTML(“https://app.hubspot.com/sales/2224609/companies/list/view/787903?","Table”,3)
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


#2

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