Google apps scripts tied to Google forms to automate access to Looker Sandbox enviornments
- set_up is for setting up the triggers for calling the defined functions based on a trigger from when a form is filled out by a Googler
- trial_users is the function for adding internal / prospective customers to the Looker sandbox instance and sending them an email for account verification
- email_hashing is for hashing the result of the form to prevent PII from going into the BQ
- dataset_requests is for calling the cloud function defined here, to create a new scratch schema in BQ and a service account with a shared Cloud Secret containing the JSON keys for establishing the BQ connection in Looker
- disable_users is for disbaling users after two weeks, and notifying the SE (while also sending along prefilled form for extending users or providing feedback)