Google-sheets – Restrict or prevent drawing functionality

google sheetsgoogle-apps-script

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?

Best Answer

Unfortunately, this is not possible to achieve in Google Sheets (eg. to lock down certain functions like "inserting of drawings" etc.)