PreferenceSorter allows users to "upvote" or "downvote" different rows so you can sort by preference. PreferenceSorter is an add-on for sheets that allows users to cast votes for different options. Each row in the spreadsheet should be an option, and Column C should hold the rankings. Each user, when signed in, has one vote per option, and can use the arrows in the sidebar to either "upvote"or "downvote" each options. You can then sort the spreadsheet by the ranking columns to get a sense of how your group feels. This way, each user gets anonymous input and can indicate exactly how they feel.
Reviews of PreferenceSorter - Google Sheets add-on platform_app