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. On the Hub, you can also share an 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.
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.
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 Looker 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.
- Select the Harvest data source on the Supermetrics Hub or in the data destination.
- If prompted, choose to make this connection shared or private.
- Click Start.
- Sign in with your Harvest account.
- Click Authorize application.
- 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.
You can also connect to Harvest from these destinations:
- Google Sheets: How to log in to a Supermetrics data source in Google Sheets
- Looker Studio: How to connect data sources to Looker Studio
- Excel: How to connect data sources to Excel with Supermetrics
- Power BI: How to create your first Supermetrics query for Power BI
- The Supermetrics API: How to use the Query Manager
- Data warehouse and cloud storage (Hub): How to create a transfer
- BigQuery (marketplace): How to create a BigQuery (marketplace) transfer