I have a .csv that I import into Google Sheets. This contains data for multiple clients. Right now, I have to manually split this sheet into different workbooks/files and share each individual file with each different client. Each client then receives a file with only their data in it.
I would like to reduce my workload and set up filters with restricted permissions so that I can just share one file with all of my clients. They can then only use the filter I have shared with them and there is only one file to manage.
Is this plan completely foolproof? (hold the laughter)