A library used to fill in a person's hours on a nearForm project timesheet in Google Sheets
First you must go to the Google developer console and do the following:
- Create a new project
- Enable the sheets API on the Project
- Generate service account credentials (this downloads a JSON file)
- Share the timesheet with the client_email address inside the JSON file
const spreadsheetId = 'YourSpreadSheetID'
const ProjectTimeSheet = require('untimely').ProjectTimeSheet
let config = require('credentials.json')
new ProjectTimeSheet(spreadsheetId, config, (err, sheet) => {
let opts = {
name: 'Dara Hayes',
date: '19/01/16'
}
sheet.getEmployeeDay(opts, console.log)
// {hours: 8, notes: 'Wrote a new dope library'}
opts = {
name: 'Dara Hayes',
date: '20/01/16',
hours: 8,
notes: 'Wrote some tests for new library'
}
sheet.setEmployeeDay(opts, console.log)
})