Auto-update Google Spreadsheet integration when a new field is added to the form

I have read several posts about adding fields to a form with google sheets integration.

In testing I have found that if I add a field to the form and name a column in the sheet exactly the same as the form, it seems to work ok.

However, I have not tested this fully and want to know if the current best solution is to remove the integration and re-add or is adding a column to the spreadsheet ok?

Yes, you were right.

Re-integration creates another spreadsheet with all the submissions in it.

So in case you don't want to re-integrate the form but adding a field is necessary, you can do so but you need to also update the column headers of the integrated spreadsheet every time you add a field inside the form. Ensure that the field labels has its corresponding column in the spreadsheet.

Though we are not encouraging this method to users, doing a re-integration in case new fields are added to the form is always the safest way for this.