Hi,
These questions are not all related to AppSheet... I am looking for further information or links or guides/reading on setting up Google WorkSpace at my company and the only reason I am looking at this is because AppSheet is now part of WorkSpace.
Some background, at my company we have around 10 different apps that I have built and around 70 users. We use AppSheet Core. The authenticator that I use is Microsoft, though all our data is stored on a Google Drive.
We have an issue with backing up our day-to-day data. Currently, we have 70+TB of data 'stored' on various hard drives but I need to get this to another location. OneDrive will cost too much and our IT department has quoted us ยฃ18,000 to get 2 NAS's setup at 2 locations. As AppSheet is now part of WorkSpace, I can set up 70 accounts, giving me 140TB of pooled storage which is more than enough to archive/store all our data off-site, with a minimal price increase each year compared to just paying for AppSheet. I am not looking at using all other Google services such as Gmail, meet, sheets for the day-today operations of our business, we will be staying with Microsoft for this.
I have only just started exploring this and my early thoughts and questions are:
- I am assuming that all users would then need to be authenticated with Google, rather than Microsoft and this would mean they would get a new email address from Google WorkSpace
- Could this email address be something similar to first.last name@ my company name AS.com - I am thinking of putting AS at the end for AppSheet as this account won't be used for anything other than logging into this and it makes it easier for people to remember.
- There should be no issue if I added another column to all my Apps similar to [Company Email] and use this in automation instead of useremail() so everything gets emailed to the users Outlook account
- WorkSpace business standard is currently ยฃ10/month/user if I sign up for 12 months, or ยฃ12 if billed monthly. If I start with monthly billing can I then move onto the ยฃ10 option.
- Are WorkSpace user accounts pooled, so if I am paying for 70 accounts for 12 months, and 5 people leave, but then 5 people join can I simply delete and add new users without paying for additional accounts
- If I am paying for 70 accounts for 12 months but then 3 months later I need to add another 5 accounts, are these billed at the yearly rate for the next 9 months, are we tied in with a new 12 month subscription for these accounts or are they stuck on ยฃ12/month until the yearly billing cycle renews
- Are there any differences between paying for AppSheet core directly and getting this through WorkSpace
- Apart from the hassle of moving the existing Apps and data to a new account is there anything else that I should be wary of
- Would Google not look kindly at me using WorkSpace as basically an online dump of data and not using any of their other WorkSpace services
- Are there any other secure, reputable and cheap online backup/data dump services that I should look at instead? I will only be using the service as a backup and will only need to download the files again if a local hard drive fails, so I don't need synchronisation options and a fast connection is not necessary.
If anyone can point me towards more reading for the advantages/disadvantages of WorkSpace and guides on setting it up and what is involved, that'd be great