Coderbunker GSuite App Scripts

Introduction

Source of truth for Coderbunker is stored on Google G-Suite Apps.

We use these scripts to Extract, Transform, Load the data.

Usage

Use clasp to pull, push and deploy:

https://developers.google.com/apps-script/guides/clasp

Layout

One subfolder per ScriptId (set of source files).

Each ScriptId can both act as an add-on and as a GET / POST endpoint

Configuration of profiles (Google Slides)

Need the following File > Project Properties > User Properties set:

• ORG_NAME: Coderbunker
• NATURAL_LANGUAGE_API_KEY: (API key from Developers Console)
• OAUTH_CLIENT_SECRET: (Client Secret from OAuth Developers console)
• OAUTH_CLIENT_ID: (Client ID from OAuth Developers console)
• TARGET_FOLDER_NAME: Coderbunker Freelancers Profiles

Configuration of timesheet (Google Spreadsheet)

• ORG_NAME: Coderbunker
• CHANGE_ENDPOINT: onEdit events endpoint
• SNAPSHOT_ENDPOINT: full data snapshot data post endpoint

More information

See:

• Google Developers Docs
• Coderbunker Systems presentation