Skip to content

G-Suite Google Apps Script (GAS) used with Coderbunker documents

Notifications You must be signed in to change notification settings

coderbunker/gas

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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:

About

G-Suite Google Apps Script (GAS) used with Coderbunker documents

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published