Data entry management web application with user rights

I need data entry application with Realtime update like the spreadsheet model work for local connected users only.
Columns will work like when we have to fill the specific column entry only few columns entries are visible to the specific user rest details are hidden except the admin sheet will be 01 but functioning differently due to entries columns define to multiple users.
Final syncing solution can be connected to google spreadsheet api for final backup to be maintain of these record.