How to Auto Format Google Form Responses in Google Sheets
When you submit a Google Form, it stores a copy of the form response as a new row in the Google Sheet. The only problem here is that Google Forms will not add any formatting or styles to the new row that you may have applied to the previous rows of the sheet. Let me illustrate this with a small example. Here’s a Google Sheet that is storing Google Form responses. I’ve changed the default font family to Droid Sans , center-aligned the Country and Age column and also applied a different date format to the Date of Birth column. Everything looks good but as soon as a new form submissions is made, the new row appended to the Google Sheet via Google Forms will lose all the formatting. The cell alignment is not preserved, the custom date formats are ignored and so is the default font size and font family. Here’s a screenshot of the same sheet but with a new row added through Google Forms. Also see: Automate Google Forms through Workflows Auto Format New Rows in Google Sheets Sin...
