Google Sheets integration: Is it possible to order the columns?

  • Profile Image
    aburbatraining
    Asked on February 26, 2020 at 06:40 PM

    Hi, 


    I was able to set up the Google Sheets integration and it works beautifully. 


    I have two questions.

    1. Is there a way to get the requests to populate most recent submission first (currently it populates with oldest request first). 


    2. Am I able to add columns to the end of the sheet, so that we can add our notes? (If I don't change any of the column titles? I don't want to break the form as it works great, but it would be super if we can add columns.


    Alice

  • Profile Image
    roneet
    Answered on February 26, 2020 at 10:57 PM

    Unfortunately, it is not possible to order the data from recent to the oldest data or add columns at the end. The integration was never meant to allow for making changes to the integrated sheet.  Editing columns and such will make the integration to break. 

    The recommended solution if you need to edit the sheet would be to create a second sheet and use import range to import the data from the first:

    https://support.google.com/docs/answer/3093340?hl=en

    Screenshot 1: Sheet1 of the Google Spreadsheet integrated with your form.

    Screenshot 2: Sheet2 of the Google Spreadsheet where the IMPORTRANGE is used.

    Notice that in Sheet 2, in column B row 1 (B1). The IMPORTRANGE with range string referring to the 4th column in Sheet 1 (email field).

    Please note that when there is a submission, Sheet 2 is also automatically updated. Please give it a try and if you have any questions regarding this, please feel free to contact us again anytime and we will be glad to help you.

    Thank you.