Skip to main content
Best answer

The Zap adds HotJar survey responses above headers in Google Sheets instead of under them

  • Jun 2, 2024 12:28 PM UTC
  • 3 replies
  • 113 views

My zap needs to take survey responses from HotJar and add them to a google sheet.

It is doing this successfully, but instead of putting the data under the headers, it adds a new first row above the headers and writes the data above them. So the headers are shifted down and remain at the bottom of the list. I can’t seem to fin an option to have it add the new row to row 2.

Best answer by Troy Tessalone

Hi @InEnsisLapis 

The GSheet needs to be structured a specific way to be used in Zaps.

  • Row 1 with headers
  • Cell A1 needs to have a Header
  • No grouped rows/columns
View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

3 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • Jun 2, 2024 10:09 PM UTC

Hi @InEnsisLapis 

The GSheet needs to be structured a specific way to be used in Zaps.

  • Row 1 with headers
  • Cell A1 needs to have a Header
  • No grouped rows/columns

  • Author
  • Beginner
  • Jun 3, 2024 11:58 AM UTC

Thanks Troy,

 

This worked - specifically I had no headers in cell A1, so moving my headers row to the left to occupy A1 fixed it. 


ken.a
Forum|alt.badge.img+6
  • Zapier Staff
  • Jun 6, 2024 7:11 AM UTC

That’s awesome @InEnsisLapis! A huge thanks to Troy for lending a hand and pointing you in the right direction!

If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗