Use Hotjar's integration with Zapier to send data from Hotjar to Google Sheets and create custom reports automatically.
You can set up this integration to add new rows or columns to a spreadsheet when one of the following actions happens:
- a new Recording is captured
- your Survey gets a new response
You can also refine this workflow to create reports based on specific Hotjar parameters, for example, Country or Device.
In this article, you'll find step-by-step instructions on how to set up the Zapier integration to automatically create new entries in Google Sheets based on Hotjar metadata related to Recordings or Surveys.
You'll need an existing Zapier account and a Gmail account to follow along with these steps
The steps below guide you through connecting Hotjar to Google Sheets using Zapier. You'll need a Zapier account and an existing Gmail account to follow along.
Create a new spreadsheet on your Google Drive.
Choose names for rows (or columns) to prepare a structure for your report.
Log in to Zapier.
Click the Create Zap button.
For the Trigger, select Hotjar.
Select New Recording or New Survey Response as the Event.
Choose which Hotjar account you'd like to use in this Zap.
Connect your Hotjar account to Zapier. For help with this, see Zapier's documentation on connecting apps to Zapier.
Click the + button, adding Filter as the next Action.
This is an optional step that allows you to narrow down the report data.
In the Filter setup & testing section, add any filtering conditions for when to create a new Google Sheet entry. For example, you can create an entry only if the user is based in a specific country:
- Select Country Name in the Choose field dropdown.
- Select (Text) Exactly matches in the Choose condition dropdown.
- Enter France in the Enter text or insert data field.
Take a look at the full list of Hotjar parameters to choose the most suitable filtering options for your report.
Click the + button, adding Google Sheets as the next Action.
Select Create Spreadsheet Column or Create Spreadsheet Row in the Event dropdown and click Continue.
Choose your Gmail account. Sign in.
Fill in the Drive, Spreadsheet, and Worksheet fields.
Match the names of your spreadsheet fields with the Hotjar parameters you want to store there. Click Continue.
Test the action and click Publish to activate the Zap.
With the Zap activated, any Hotjar event that matches the filter conditions will create an entry in a chosen spreadsheet. For further help using Zapier and setting up Zaps, you can also visit the Zapier Help Center.
Changing the names of rows or columns will interrupt this workflow
Anytime you update the names of columns or rows in the spreadsheet, make sure to update the Zap as well. Otherwise, the integration will stop working.