routine-generator

• routine-generator
  • Overview
  • Prerequisites
  • Installation
  • used packages
  • Screenshots

Overview

A simple routine generator for NCPSC Discipline Team.

As a member of the discipline team monitor, we have to generate our duty schedule each week. Hence I created this script to automate this process. We have a spreadsheet containing all the members' data.

At first, It fetches the Members list from the google sheet and saves that locally. then generate 5 day (6 members each day) routine and update that routine into the google sheet. then I just made some slight changes if I had to. lastly It fetches the updated routine and places this name into a template routine image

Prerequisites

• nodejs >= 16.15.1

Installation

1. clone this repository or simply download

   git clone git@github.com:realDarkCode/routine-generator.git

2. navigate to project folder

   cd routine-generator

3. Install dependencies

   npm i

4. Setup authentication

   1. Create a A Google Cloud Platform project with the API enabled.
   2. Setup Authentication with OAuth 2
   3. Download OAuth 2.0 Client IDs as JSON
   4. Move that file into project root and rename as credentials.json

5. Run script

   npm start

used packages

• googleapis - for reading and updating data into google sheets.
• @google-cloud/local-auth - for authenticating with google.
• jimp - for writing text into image
• prompt-sync - taking input from console

Screenshots