client onboarding: create approved freelancers Google group for the client

[andiechu]

Part of issue #45

Requirement

When account manager fill in a new client information record in this spreadsheet, create a Google group for the client using its alias. And make sure all the relevant people are in it.

Procedure

• trigger the creating function when there's a new client record (hint: can use a form to get information exporting automatically in the spreadsheet so that you can use onFormSubmit() trigger; or use spreadsheet's onChange() trigger)
• create a Google group named {client}@coderbunker.com
  • Name of the groups: {CLIENT} Coderbunker Team
  • Email address: {CLIENT}@coderbunker.com
  • Members of all co-founders (Ricky and Fred)
  • Group Settings: Setting > Basic permission > Post > Add Public
  • Add the group to [email protected]