Automated Hotjar Weekly Insights Export
Every Monday, WebRun opens Hotjar, pulls last week's heatmap click data and feedback poll responses for your tracked pages, exports them into a dedicated tab in a Google Sheet, and emails the product team the link with a short summary.
How do I get my weekly Hotjar heatmap and feedback data into a spreadsheet?
WebRun pulls last week's Hotjar heatmap clicks and feedback poll responses every Monday, exports them into a dedicated tab in a Google Sheet, and emails the product team the link with a short summary of what stood out. It turns raw session data into a standing weekly record without anyone touching Hotjar directly.
- Heatmap and feedback data lands in a sheet automatically every week
- Past weeks stay intact in their own tab for easy trend comparisons
- The team gets a short summary instead of digging through Hotjar
Built for product teams · UX researchers · growth teams · marketing teams
What does WebRun do on every run?
The exact actions WebRun takes, in order - in plain language, so you can adjust anything.
-
WebRun signs in and gets to work
Opens
insights.hotjar.comin a real browser with your saved login - no setup, no API keys. -
1
Hotjar - pull heatmap and feedback data
hotjar.com
WebRun opens Hotjar to pull heatmap and feedback data. - Open Hotjar and pull last week's heatmap click data for tracked pages
- Pull feedback poll and survey responses for the same period
- Note any page with a notable change in click patterns
Done when Every tracked page's heatmap and feedback data has been pulled.
-
2
Google Sheets - export the insights
google.com
WebRun opens Google Sheets to export the insights. - Export the click data and feedback responses into the weekly insights sheet
- Add a new tab for the week so history stays intact
Done when This week's insights are exported to the sheet.
-
3
Gmail - email the link
gmail.com
WebRun uses Gmail to email the link. - Email the product team the link to this week's insights sheet
- Note anything that stood out in a short summary line
Done when The team has this week's sheet link in their inbox.
How is each run configured?
Secure by default
Connect once, stays signed in
WebRun signs in once and keeps each session in a persistent environment, so every run picks up right where it left off.
Every action is checked against this policy before it runs.
Questions, answered
Does it change anything on the site based on what it finds?
No. WebRun only exports the data it finds. Acting on a heatmap finding, like changing a page layout, is left to your team.
What counts as a notable change?
It compares each page's click pattern to prior weeks and flags a page in the summary when the pattern shifts noticeably, so the email highlights what's worth a look.
Do I lose past weeks' data?
No. Each week gets its own tab in the sheet, so history stays intact and you can compare trends over time.
Related templates
Put this on autopilot.
Turn it on in minutes - or have our team set it up for you.