A tool to generate a Gatekeeper report according to the interview's values. This script just working with the Spreadsheet called [GReportGenerator]

1. Clone the Spreadsheet [GReportGenerator].

2. Please if you don't have access make a request for them.

3. Use it and fill it in your interview

4. Create the fetch script by doing click in the main menu option GK Tools > Generate fetch script

   

5. Copy the fetch script code by doing click to the button Copy script to Clipboard. Also, you can click in Download the sumary PDF button and download the file to upload it to Glow platform later.

   

6. Open DevTools on the Glow platform tab (or window) you have open

7. Paste the code and execute it in DevTools console (See below notes)

8. You should get a message with the text Interview information was saved!

   

You need to save a draft in Glow Platform BEFORE use the generated fetch script in the DevTools console.

This tools was made with Google App Script by using Google Clasp.

1. Clone the repo

   git clone https://github

2. Create a new branch

   git checkout -b branch-name

3. Install dependencies by using npm

   npm i

4. Make a copy to [GReportGenerator] spreadsheet. If you want to modify the [Summary PDF template] you should do a copy of that file as well. Please put those copied files into the folder [OnDev] located in the same path of the templates.

5. Get the scriptId from the spreadsheet you copy and update the scriptId on .clasp.json file.

   • In the spreadsheet Tools → Script Editor
   • In the Script editor → File → Project Properties

6. Login using Google Credentials with clasp

   npm run login

7. Enable Google Apps Script API

   

8. Push the code to the current clasp scriptId

   npm run push

9. Push the Code and watch for changes

   npm run push:watch

• Access Google Cloud Resource Manager
• Select your Project and click the three dots to access settings
• Get Project ID from there
• Enable the API you need with npm run enable <api from list>

• Best Practices
• Logging console

This repository is based on [Report Generator].