Harvest2Sheet

Allows you to download time sheet data from a project within Harvest into Google sheets.

Install

To install this app you need NodeJS installed.

Install via:

npm install -g harvest2sheet

Creating login credentials

harvest2sheet has the ability to help you with setting up your credentials for harvest and google. IT will lead you through the process to create them and then generate the project.json for you that you can get started with.

To start the wizard run:

harvest2sheet login

Run

To run the program make sure you specify which month you want to target.

harvest2sheet 2020-08

harvest2sheet will then create a sheet (if it doesn't already exist) in your spreadsheet and fill it with the time entries found in harvest for that month.

The sheet name will be in the format of H|Aug'20 and have gray as a color.

Configure

harvest2sheet requires a project.json file to run its tasks off of.

The project.json format is as follows:

{
    "HARVEST_ACCESS_TOKEN": "Add your personal token here",
    "HARVEST_ACCOUNT_ID": 666,
    "GOOGLE_ID": "Add your google ID here",
    "GOOGLE_SECRET": "Add your google secret here",
    "GOOGLE_REFRESH_TOKEN": "Add your google refresh token here",
    "tasks": {
        "project1": {
            "harvestProject": 42,
            "spreadsheetID": "Add your google sheets ID here"
        },
        "project2": {
            "harvestProject": 42,
            "spreadsheetID": "Add your google sheets ID here"
        }
    },
    "output": [
        "date",
        "user",
        "client",
        "project",
        "task",
        "hours",
        "rounded_hours",
        "notes",
        "billable_rate",
        "billable_amount",
        "cost_rate",
        "cost_amount",
        "currency"
    ]
}

The login block on the top is important and can be generated by running harvest2sheet login.

The tasks object

The project name, used internally only. Can be anything.

harvestProject

The harvest project ID. Find it by navigating to the project inside the harvest web app and look at the URL.

An example might be https://yourorg.harvestapp.com/projects/1234567 in which case the harvestProject is 1234567.

spreadsheetID

This is the spreadsheet ID. Find it by navigating to your spreadsheet in the web app and look at the URL.

An example might be https://docs.google.com/spreadsheets/d/1ZZS15TTMxQRjeX2nI-u4zJMQJu0QzhlKRgOC17jLG6X/edit#gid=0 in which case the spreadsheetID is 1ZZS15TTMxQRjeX2nI-u4zJMQJu0QzhlKRgOC17jLG6X.

The output array

The output array let's you pick and sort what things you want to be added to the spreadsheet.

If you don't specify anything harvest2sheet will default to:

"output": [
    "date",
    "user",
    "client",
    "project",
    "task",
    "hours",
    "rounded_hours",
    "notes",
    "billable_rate",
    "billable_amount",
    "cost_rate",
    "cost_amount",
    "currency"
]

Choose from the below items:

Property	Description
date	Date
hours	Hours
rounded_hours	Rounded Hours
notes	Notes
locked	Locked
locked_reason	Locked Reason
closed	Closed
billed	Billed
timer_started_at	Timer Started At
started_time	Started Timer
ended_time	Ended Timer
running	Running
billable	Billable
budgeted	Budgeted
billable_rate	Billable Rate
billable_amount	Billable Amount
cost_rate	Cost Rate
cost_amount	Cost Amount
created_at	Created At
updated_at	Updated At
user	User
client	Client
currency	Currency
project	Project
project_code	Project Code
task	Task

Release History

• 1.2.2 - fixed date range for harvest
• 1.2.1 - fixed isDate detection, added version flag support
• 1.2.0 - added global dates, caught more errors
• 1.1.1 - fixed settings error handling
• 1.1.0 - added support for shaping the output
• 1.0.1 - added support for multi line time entries
• 1.0.0 - Launch

};