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.

This method of using Google Forms with Google Sheets was ostensibly designed to gather and analyze survey data, but with a few tweaks it works just as well to record your financial transactions ...

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