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.
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 Technical Support for help.
Note: If creating a custom report using Report Builder, the Group by feature doesn't work if your report is exported to Excel or Google Sheets. You'll need to recreate your grouping in the external app you use.
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!