Harvest

Harvest is a time tracking and invoicing tool used by teams to log hours, manage projects, and bill clients. Connecting it to Coupler.io lets you pull your time entries, expenses, invoices, and project data into the tools you already use — automatically, on a schedule, with no code.

Why connect Harvest to Coupler.io?

• Automate your reporting — stop manually exporting CSVs every week and let Coupler.io refresh your data on a schedule

• Combine multiple entities — use Join or Append transformations to merge Time entries with Projects, Clients, or Users into a single dataset

• Send data anywhere — destinations include Google Sheets, Excel, BigQuery, Looker Studio, and AI tools like ChatGPT, Claude, Gemini, Cursor, Perplexity, and OpenClaw

• Filter before you load — reduce dataset size by filtering on date range, project ID, or update time so you only pull what you need

Prerequisites

• An active Harvest account (any plan)

• Admin or Manager access in Harvest if you need to pull data across all users and projects (Members can only see their own data)

Quick start

Start with the Time report or Time entries entity — these are the most commonly used and give you the clearest picture of where hours are going across your team.

How to connect

1

Create a new data flow. Log in to Coupler.io and click Add data flow. Search for Harvest and select it as your source.

2

Authorize your Harvest account. Click Sign in with Harvest and complete the OAuth flow. You'll be asked to choose which Harvest account to connect — select the correct one and approve access. Once authorized, you'll be returned to Coupler.io.

3

Select an entity. Choose the data you want to pull — for example, Time entries, Report: Time report, Invoices, or any of the other available entities. If your entity supports a date range (like the Time report or Expense report), set the From and To dates using the date picker.

4

Choose a destination. Select where you want your data to go — Google Sheets, Excel, BigQuery, Looker Studio, or an AI destination. Follow the prompts to authorize and configure your destination.

5

Run your data flow. Click Run to execute a manual import. Once it completes successfully, your data will appear in the destination you chose.

Available entities

Entity	What it contains
Report: Time report	Aggregated time data by user, project, task, or client
Report: Expense report	Aggregated expense data by user, project, or client
Report: Uninvoiced report	Billable time and expenses not yet invoiced
Report: Project budget report	Budget vs. actual hours/costs per project
Time entries	Raw time log entries with hours, dates, and notes
Expenses	Individual expense records
Expense categories	Expense category definitions
Invoices	Invoice headers
Invoices with line items	Invoices including itemized line detail
Invoice item categories	Invoice line item category definitions
Estimates	Estimate headers
Estimates with line items	Estimates including itemized line detail
Estimate item categories	Estimate line item category definitions
Projects	Project list with budget and billing settings
Project task assignments	Tasks assigned to each project
Project user assignments	Users assigned to each project
Clients	Client list
Client contacts	Contacts associated with clients
Company	Your Harvest company/account settings
Users	Team member list and profile details
Roles	User role definitions
Tasks	Task list