---
title: "Harvest connection guide"
slug: "harvest-connection-guide"
description: "Connect your Harvest data to Supermetrics with our guide on permissions, query types, and connection instructions for seamless data integration."
updated: 2026-05-06T11:47:17Z
published: 2026-05-06T13:26:01Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://docs.supermetrics.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Harvest connection guide

This guide contains all permissions and requirements for connecting your Harvest data to Supermetrics.

You can connect to data sources from the [Data sources page on the Supermetrics Hub](https://hub.supermetrics.com/token-management). On the Hub, you can also [share an authentication link](/v1/docs/how-to-connect-to-data-sources-from-supermetrics-hub#share-authentication-link) to connect to a data source you don't have direct access to.

After you connect to the data source on the Hub, you can use the data source connection in [all available destinations](/v1/docs/harvest-connection-guide#connection-instructions).

## Required permissions

The Harvest API mirrors your account permissions. For this reason, you'll need access to an **Administrator**account to access your data. [Learn more in Harvest's documentation](https://support.getharvest.com/hc/en-us/articles/360048180732-The-Harvest-API).

## Query types

Query types define what sort of metrics and dimensions are available. Each Harvest query type pulls time and billing data by the dimension in its name (for example, the Projects report pulls data by client or project). You need to select one of the following query types when pulling data:

Note that Project, Client, Task, and Team reports allow only reporting with monthly granularity.

- Projects report
- Clients report
- Tasks report
- Team report
- Time entries (not available in Data Studio)

Harvest's API allows a maximum of 100 requests every 15 minutes. If you find any of your Harvest queries timing out, wait 15 minutes and try again.

## Connection instructions

When connecting to Harvest, you need to log in to Harvest and select the query type when prompted.

1. Select the Harvest data source [on the Supermetrics Hub](https://hub.supermetrics.com/token-management) or in the data destination.
2. If prompted, choose to make this connection [shared or private](/v1/docs/about-shared-and-private-connections).
3. Click **Start**.
4. Sign in with your Harvest account.
5. Click **Authorize application**.
6. In your data destination, select the query type to use.

See detailed instructions on [how to connect to a data source from the Supermetrics Hub.](/v1/docs/how-to-connect-to-data-sources-from-supermetrics-hub)

You can also connect to Harvest from these destinations:

- Google Sheets: [How to log in to a Supermetrics data source in Google Sheets](/v1/docs/how-to-connect-to-a-supermetrics-data-source-in-google-sheets)
- Data Studio: [How to connect data sources to Looker Studio](/v1/docs/how-to-connect-data-sources-to-looker-studio-formerly-data-studio)
- Excel: [How to connect data sources to Excel with Supermetrics](/v1/docs/how-to-connect-data-sources-to-excel-with-supermetrics)
- Power BI: [How to create your first Supermetrics query for Power BI](/v1/docs/how-to-create-your-first-supermetrics-query-for-power-bi)
- The Supermetrics API: [How to use the Query Manager](/v1/docs/how-to-use-the-query-manager)
- Data warehouse and cloud storage (Hub): [How to create a transfer](/v1/docs/how-to-create-a-transfer)
- BigQuery (marketplace): [How to create a BigQuery (marketplace) transfer](/v1/docs/how-to-create-a-bigquery-marketplace-transfer)

## More resources

- [How to reauthenticate a data source in Google Sheets, Looker Studio, Excel, or Power BI](/v1/docs/how-to-reauthenticate-a-data-source-connection-in-google-sheets-looker-studio-excel-power-bi-and-supermetrics-hub)
- [How to reauthenticate a data source in data warehouse, API, or cloud storage platform](/v1/docs/how-to-reauthenticate-a-data-source-connection-in-data-warehouse-destinations-or-the-supermetrics-api)
- [How to manage data source connections on the Supermetrics Hub](/v1/docs/how-to-manage-data-source-connections-on-supermetrics-hub)