Google Sheets (importHTML or importXML)

[lellis]

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

[olga_rusnak]

Hi @lellis 

try Coupler.io Google Sheets add-on to pull data on an hourly basis from HubSpot to Google Sheets. You may set up a data refresh schedule to 1 hour (other options are available as well).

It would be great to if you could let me know if it worked for you!

[paul-test]

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