Creating Reports for multiple clients off of one sheet

Devon Eddy
Devon Eddy โœญโœญ

Here's the scenario. I have a lead generation company that generates all it's combined leads into one sheet. I then need a way to share this lead information on a monthly basis with ~100 clients.


What I would really like to do, is create reports for each individual client that pull from the same universal sheet. The issue I'm running into, is that the clients reports won't actually work unless they have access to the underlying sheet (which I obviously can't share because of all the other client's information there).

The other option is to make the combined sheet public, but this also makes me nervous because it can be accessed by anyone? Is there any way that URL becomes public or is there any way to restrict access to a public sheet?


Not sure what would be the best route to take here, but having this sort of functionality would be very beneficial for several different use cases.

Thanks -Devon

Answers