Google Sheets: New submission is inserted to row 1 when the first column is hidden on the integrated sheet

  • Profile Image
    dominosteve
    Asked on April 16, 2019 at 10:31 PM

    I set up an integration to a Google spreadsheet and it was working fine.   New entries were showing up at the bottom of Sheet1.  After an edit of the form the entries started getting inserted into Row 1 above the headers.  I removed integration and re-integrated it to a new spreadsheet and the issue persists.

    I do not know if I changed a setting by accident.

     

  • Profile Image
    jherwin
    Answered on April 16, 2019 at 11:39 PM

    I tested google spreadsheet integration on my end and it's working fine. Could you please show us a screenshot or share us the public link of the integrated sheet so we can look at it?

    Also, please tell us the form to which this issue is related to.

    We'll wait for your response.

  • Profile Image
    dominosteve
    Answered on April 17, 2019 at 02:01 AM

    I figured out the problem.  I had hidden the first column of the spreadsheet and that caused the issue.  I had hidden other columns before but I guess it requires the first column to not be hidden.  You might want to submit this for a fix but this 'feature' could be used by someone who would like to have new entries show up top (would have to be ok with no column heading since they get pushed down with each entry)

  • Profile Image
    Kiran
    Answered on April 17, 2019 at 03:10 AM

    Glad to see that you were able to figure out the issue and resolve it. Generally, we do not recommend to make any changes to the integrated Google sheet that shall break the integration. I am able to replicate the issue at my end by hiding the first column of the Google Sheet. Let me forward this thread to our backend team to look into. If there is any update in this regard, we'll let you know.

    Thank you!

  • Profile Image
    Denis
    Answered on April 17, 2019 at 08:16 AM

    Hello,

    Sorry for the inconveniences caused. Google Integration relies on the header row. Any type of edit will break the integration.

    Regards.