Skip to main content
Answer

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

  • June 2, 2024
  • 3 replies
  • 45 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
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
  • June 2, 2024

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
  • June 3, 2024

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
  • June 6, 2024

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