Greenhouse Recruiting includes a variety of reports to provide insight into your hiring process, help you tell stories, and drive strategic decisions. Greenhouse Report Connector takes your reporting a step further by combining the power and customization of a spreadsheet with a simple and seamless Google Sheets add-on.
With Report Connector, you can easily import Greenhouse Recruiting reports to Google Sheets and refresh your reports in real time directly from your workbook. Use this integration to build and manipulate dashboards, custom charts and graphs, and combine reports to perform complex analyses.
Note: Click here to copy the Greenhouse Recruiting Reports Dashboard.
Report Connector overview
As you start to build out your own reporting resources, be sure you understand navigating data and pivot tables in Google Sheets. Check out these resources:
With Greenhouse Report Connector, you'll import one report from Greenhouse Recruiting to a single sheet on Google Sheets. You can then import additional reports onto additional sheets. From there, you can use pivot tables or other means to combine and manipulate data onto additional sheets in your workbook.
Note: When you refresh an imported report, it will replace any data you've added to the sheet. For this reason, be sure to use pivots or formulas to manipulate data on separate sheets.
Enable Report Connector
Check out the following article for instructions: Integrate Greenhouse Report Connector with Google Sheets.
Beginner Report Connector templates
We've created a few templates to use as a starting point for you to build much more complex reports based on your needs. Each of the reports linked below has one or two focus metrics that leverage an imported report from Greenhouse Recruiting. Check them out:
- Hires by source / offer acceptance rate template
- Jobs closed by quarter / job age template
- Hiring speed template
- Interviews conducted over time template
Note: Click Make a copy to copy the template to your Google Drive.
Advanced Report Connector templates
Feeling confident? Check out these in-depth templates for more ways to leverage Report Connector:
- Company recruiting leaderboard: Who is providing the most referrals, doing the most interviews, and having the best interview adherence?
- Start date predictor: How likely are we to make our hire on time?
- Quarterly exec metrics and presentation: How is our recruiting function performing each quarter, and what is our plan for next quarter?
- Click the Presentation link above to view a Google Slides template showing how an organization performed in the previous quarter against five recruitment KPIs.
- Cost per hire worksheet: How much are we spending per hire? How much are we spending overall? What are the opportunities for improvement?
Note: Click Make a copy to copy the template to your Google Drive.
Troubleshoot Report Connector
Note: In order to access a report in Report Connector, you must have permission to view the report in Greenhouse Recruiting.
If you receive an error message using the Report Connector, we recommend you take these initial troubleshooting steps:
1. In Google Sheets, select Extensions > Greenhouse Report Connector > Sign Out.
Next, sign back into the Report Connector by clicking Extensions > Greenhouse Report Connector > Sign In. Follow the on-screen instructions to give Google Sheets access to your Greenhouse Recruiting account.
2. Ensure your web browser is updated to the latest version. See how to update:
3. Refresh the report in Greenhouse Recruiting by navigating to the report, then copy / paste the report URL into the Google Sheets Connector using Import Report to check if the report populates.
If these troubleshooting steps don't resolve your issue, contact Greenhouse Support for help.
Additional resources
- Which report should I use? If you're unsure which report has the data you need, use this tool to figure it out!