No description, website, or topics provided.
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Failed to load latest commit information.

Automatic Setup of Development Environment

You have two options: Use default spreadsheets or copy default spreadsheets into your drive. Setup changes according to your choice. For quick setup enter Y when asked. Be aware that login won't work in this instance.

  1. Create a project in Google Cloud Console:
  2. Install following packages if missing:
  • git
  • python
  • pip
  • virtualenv
  • curl
  • node
  • npm
  1. run and provide the following info:
  1. run app-pipelines.yaml to start local development server at https://localhost:8080 4.1 If you chose N in step 3 visit https://localhost:8080/sheets/setup enter clientID and clientSecret (created in step 3.1) to copy sheets. 4.1.1 Put config docid you got in step 4.1 into config.yaml to finish setup.
  2. run to deploy to your project
  3. visit to test deployment

Manual Setup

Spreadsheets and App Script

  • Duplicate all of the spreadsheets and app script
  • Put docids into the settings spreadsheet


For service account credentials:[your-project-name]

  • Create new service account
  • Download JSON and copy/paste values into config.yaml
  • Share all of the spreadsheets with service account Email address

Create config.yaml:

  config_docid: "config-spreadsheet-docid"
  private_key_id: "values-from-google-developer-service-account"
  private_key: "values-from-google-developer-service-account"
  client_email: "values-from-google-developer-service-account"
  client_id: "values-from-google-developer-service-account"
  type: "service_account"


Install pip and virtualenv. For example, on MacOSX:

sudo easy_install pip
sudo pip install virtualenv

Clone full version of IGE to ige directory.

Install Node.js and then IGE deps via NPM:

cd ige/server
npm install



Google APIs

Enable the following APIs:

To see the list of the enabled Google APIs:[your-project-name]

OAuth 2.0

For OAuth2 2.0 credentials:[your-project-name]

  • Create new OAuth client ID
  • Application type: Web application
  • Authorized JavaScript origins: Deployment or development URL
  • Authorized redirect URIs: Deployment or development URL Download JSON and copy/paste values into config spreadsheet

App Script

  • Go to Resources -> Developers Console Project... and enter your project number
  • Go to Publish -> Deploy as API Executable select a version select Anyone and hit Update.
  • Go to Publish -> Deploy as API Executable and copy Current API ID and paste it into appsScriptID property of the settings sheet

Important Settings

Consider updating:

  • editorGroupEmail
  • loginGroupEmail
  • driveFolderID
  • all of the spreadsheet and app script docids

Deploy via Bitbucket Pipelines

Create an api key

Create a service account

Set 'Environment variables' in!/variables

  • CLOUDSDK_CORE_PROJECT = [your-project-name]
  • CONFIG_DOCID = [your-main-config-sheet]
  • GOOGLE_API_KEY = [your-api-key]
  • GOOGLE_CLIENT_SECRET = [your-downloaded-json-file-contents]

From now on new pushed commits to the bitbucket repository will trigger an automatic deployment.

If you want a manual deployment:

Running e2e Test

You will need to have the Java Development Kit (JDK) ( installed to run the standalone Selenium Server. Check this by running java -version from the command line.

Use npm to install Protractor globally with:

npm install -g protractor

This will install two command line tools, protractor and webdriver-manager. Try running protractor --version to make sure it's working.

The webdriver-manager is a helper tool to easily get an instance of a Selenium Server running. Use it to download the necessary binaries with:

webdriver-manager update

Now start up a server with:

webdriver-manager start

This will start up a Selenium Server and will output a bunch of info logs. Your Protractor test will send requests to this server to control a local browser. Leave this server running throughout the test. You can see information about the status of the server at http://localhost:4444/wd/hub.

Open a new command line or terminal window and run the following code in the root folder of the project (replace with url to test):

protractor protractor-conf.js --baseUrl <url>

Helper Routes

  • /config/scan -> Lists files containing config keys if found.
  • /config/scan/<config_key> -> Lists file containing this key if found.
  • /cache/flush -> Removes caches for all items.
  • /cache/flush/<cache_id> -> Removes cache for the given id. List of ids: config assets earnings goalsdata goalstasks goalssettings catalog