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
Make sure you've installed the Supermetrics add-on before you connect.
- Open a new Google Sheets file.
- Navigate to Extensions → Supermetrics → Launch to open the Supermetrics sidebar.
- Click Create query.
- Under Data source, select Harvest.
- Click Start.
- Sign in with your Harvest account.
- Click Authorize application.
- Navigate to Report configuration.
- Select a query type to use in your report.
Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Google Sheets.
Make sure you've connected Supermetrics to Looker Studio before following the steps below.
- Open the Supermetrics Looker Studio data source gallery.
- Navigate to Harvest and click Start free trial.
- You'll see two buttons that read Authorize. If you're using Supermetrics for the first time, click the left-hand one and log in with the Google Account you use with Supermetrics.
- Once that's done, or if you've done it before, click the right-hand Authorize button (under "Harvest requires authorization to connect to data").
- Select a team that has access to the account you want to connect.
- Choose to make this connection shared or private.
- Click Start.
- Sign in with your Harvest account.
- Click Authorize application.
- Select a query type to use in your report.
- Scroll down to the bottom of the page. To create a report with our template, select Use report template for new reports. To create a blank report, deselect this option.
- In the pane's top right, click Connect.
- Click Create report.
- Click Add to report.
Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Looker Studio.
Make sure you've installed the Supermetrics add-on before you connect.
- Open an Excel file.
- Click Data → Show Supermetrics.
- Under Data source, select Harvest.
- Choose to make this connection shared or private.
- Click Start.
- Sign in with your Harvest account.
- Click Authorize application.
- Navigate to Report configuration.
- Select a query type to use in your report.
Learn about advanced settings, best practices, and troubleshooting tips for Supermetrics for Excel.