Google Sheets integration: I added new fields and want to reorder columns in Google Sheets without changing the Sheets URL.

  • Profile Image
    Asked on June 02, 2021 at 05:00 PM

    I have had to add fields to a published form. In our Google Sheet integration, the new fields added have been added as columns after the originally published form fields.

    How can I retain the current Google Sheet URL, but reorder the columns to reflect the new fields and where they are inserted?

    Thanks, Peter

    This is a re-post of a comment on How to Integrate Forms with Google Sheets

  • Profile Image
    Answered on June 02, 2021 at 11:24 PM

    Hi Peter,

    Unfortunately, we do not recommend making changes to the sheets and columns, as in some cases this might cause conflicts with the integration.

    We would suggest creating a new sheet instead within the same spreadsheet file, and then replicate the data to the new sheet. On the new sheet, you can order the columns to your liking.
    Please see the guide below for more details:

    Another option would be to re-integrate the integration by removing and adding it, but this way you will also lose the current sheet URL.

    Let us know if you need further assistance.