Permissions: Job Admin and above

Product tier: Available for Advanced and Expert subscription tiers

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 this Google Sheets add-on, you can: 

  • Easily import Greenhouse Recruiting reports to Google
  • Refresh your reports in real-time directly from your workbook
  • Build and manipulate dashboards, charts, and graphs
  • Create custom charts
  • Combine reports and perform complex analysis

In this article:

Note: Click here to view the Greenhouse Recruiting Reports Dashboard.

Enable the Greenhouse Report Connector add-on

See the following article for written instructions: Enable Greenhouse Report Connector.

Beginner Greenhouse Report Connector templates

Each of the sample reports linked below has one or two focus metrics that leverage an imported report from Greenhouse Recruiting. Use these as a jump-off point; you can build out much more complex reports based on your needs!

Google Sheets resources

As you start to build out your own resources, be sure you understand navigating data and pivot tables in Google Sheets. Here are some resources to leverage: 

Advanced Greenhouse Report Connector templates

Feeling confident? Check out these in-depth templates for more ways to leverage Greenhouse 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?

Troubleshoot Greenhouse Report Connector add-on

If you receive an error message on Google Sheets using the Greenhouse Report Connector, we recommend you take these initial troubleshooting steps:

1. In Google Sheets, select Extensions > Greenhouse Report Connector > Sign Out.

Greenhouse_report_connector___Sign_out.png

Next, sign back into the Greenhouse 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: Google Chrome, Apple Safari, Mozilla Firefox, Microsoft Edge.

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.

Note: In order to access a report in Greenhouse Report Connector, you must have permission to view the report in Greenhouse Recruiting.

If the above troubleshooting steps do not resolve your issue, contact Greenhouse Support for help. 

Additional resources

Check out these additional resources to explore Greenhouse Report Connector further: