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?
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!