Google Forms is a powerful tool for creating surveys, quizzes, or forms for data collection. When linked to Google Sheets, responses are automatically organized in a spreadsheet for easy analysis.

The post mentions, “Smart Fill for Google Sheets, which detects and learns patterns between columns to intelligently autocomplete data entry”.

You can create a custom template in Google Sheets even if you do not have a Google Workspace (G Suite) subscription. Make a blank sheet with all raw information & copy-paste it.