I've created a Google Sheets spreadsheet that is shared with anonymous users. All users have Edit permission because I want them to contribute data to the spreadsheet.
The problem is that some users are just plain trolls and tries to spam the sheet with useless information. I have tried using data validation, google scripts and other features to restrict them as much access as possible. However, they can still create a drawing and add a textbox or image to it.
As there are no granular Edit permission controls, I'm not sure how I can set this up properly. I could grant them Comment-only access, but some users just have no idea how to use a simple spreadsheet.
So I'm just wondering if it's possible to lock down certain functions in the spreadsheet? Or is there some sort of google script I can use that scans the spreadsheet for drawings and deletes them automatically?