1 of 1 people found this helpful
This is a little off topic for this forum which relates to Tableau's APIs for connecting to R and Python so you may find more active responses on one of the more mainline forums. Automating the extract of data in .xlsx files is something that would have to come from the Hotjar side, but if they provide an API there are a few ways you could do this:
1) Explore using Tableau's Web Data Connector SDK to write a connector of your own if Vimeo provides an API Web Data Connector - Tableau
2) Write a script using the Hyper API to pull data and save it as a Hyper file to load into Tableau: Tableau Hyper API
3) Write a R or Python Script in Tableau Prep to pull data into a Prep flow with a Script node. Introducing support for custom R and Python scripts in Tableau Prep flows | Tableau Software
You could also explore using services like AWS to automate the flow of data into a database that Tableau can connect live to.
Many thanks for your response! I might need to walk the Python path, since Hotjar does not yet provide any API!
No problem! If that works for you, would you mind marking the answer correct so others can follow up?