How to Auto Format Google Form Responses in Google Sheets

Discover ways to mechanically protect the formatting in Google Sheet when new Google Kind responses are submitted

If you submit a Google Kind, it shops a replica of the shape response as a brand new row within the Google Sheet. The one downside right here is that Google Types won’t add any formatting or types to the brand new row that you might have utilized to the earlier rows of the sheet. Let me illustrate this with a small instance.

Right here’s a Google Sheet that’s storing Google Kind responses. I’ve modified the default font household to Droid Sans, center-aligned the Nation and Age column and in addition utilized a special date format to the Date of Beginning column.

Google Types Response Sheet

All the things seems to be good however as quickly as a brand new kind submissions is made, the brand new row appended to the Google Sheet by way of Google Types will lose all of the formatting.

The cell alignment will not be preserved, the customized date codecs are ignored and so is the default font measurement and font household. Right here’s a screenshot of the identical sheet however with a brand new row added by way of Google Types.

Google Types Auto Formatting

Additionally see: Automate Google Forms through Workflows

Auto Format New Rows in Google Sheets

Since there’s no manner for us to override this Google Types conduct, we are able to take the assistance of Google Apps Script to mechanically format new rows in Google Sheets which might be added by way of Google Types.

The thought is straightforward. We’ll create an onFormSubmit set off contained in the Google Sheet that can be executed each time a brand new kind is submitted. This set off will take no matter formatting that has been utilized to the earlier row and apply to the present row.

To get began, open the Google Sheet and format the final row with the types that you just wish to apply to incoming kind responses.

Subsequent, go to Extensions > Apps Script menu and copy-paste the Google Script under. Run the createTrigger and you’re good to go!