Maintains a dynamic Google Form on form submission. Spreadsheet automatically updates with new form submissions, and automatically restructures both the sheet and the form questions to show the most recent submissions. In the style of a battle royale, if you submit an animal fighter, they will either be added to the roster of winners, or burnt to a crisp. These updates are visible instantly upon hitting "Submit". Entirely uses the Google Drive API, so I don't need to interfere at all. Since this is open to the public, I can ban certain entries if they're rude, all without deleting them from the response list.
Live demo runs here. Spreadsheet publically visible here.
https://www.googleapis.com/auth/forms
https://www.googleapis.com/auth/spreadsheets
https://www.googleapis.com/auth/script.container.ui
The script is connected to the Response Sheet, which is generated from the Form. Connecting the script to the sheet allows us to use the "on Form Submit" trigger, automatically running the script when the form is submitted. The form and sheet ID are hard-coded in, and can be changed. Certain values, like data columns and rows, will need to be modified if you are using this for your own sheet. The example.gs file shows the original project from a 2020 project. The code.gs file and Demo show a modern adaptation.