Distribution of Apps

[Werni]

Hello

I created an App which I wanted to distribute to various users on the following way:

• App managed centrally
• The Google Sheet used as DB should be locally stored in the various Google Drives of the End user including the upload of pictures and documents
• Some Appscripts are attached to the Google Sheet for some daily runs to load mails etc.

There are three possibilities for me:

1. Ask every end user to copy the application including the Google Sheet -> No Central App Management anymore
2. Declare all Data bases as Private tables cutting my Google Sheet in various Google Sheets one per Tab -> Central App but Appscript does not work anymore
3. Using partitions where depending the User eMail a partition is selected

What is the best way or do somebody knows a better way?

Thanks Werner