Open navigation

Harvest connection guide

Use this guide to connect Harvest to Supermetrics and start seamlessly pulling your time-tracking data into your reporting.


If you need to connect this data source to one of our data warehouse or cloud storage destinations, explore our data warehouse and cloud storage setup guides.


Before you begin

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

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).


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.


Instructions

Google Sheets Looker StudioExcel

Make sure you've installed the Supermetrics add-on before you connect.

  1. Open a new Google Sheets file.
  2. Navigate to ExtensionsSupermetricsLaunch to open the Supermetrics sidebar.
  3. Click Create query.
  4. Under Data source, select Harvest.
  5. Click Start.
  6. Sign in with your Harvest account.
  7. Click Authorize application.
  8. Navigate to Report configuration.
  9. Select a query type to use in your report.

Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Google Sheets.

More resources

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.