Greenhouse Setup Guide

Follow our setup guide to connect Greenhouse to Fivetran.

---

Prerequisites

To connect Greenhouse to Fivetran, you need:

• A Greenhouse account with active subscription.
• An account with owner/admin privileges.

---

In Fivetran

1. In the top right corner of your Fivetran Dashboard, click on + Connector.

2. Select the Greenhouse connector to launch the setup form.

3. Make a note of the automatically-generated webhook URL at the bottom of the form. You will need to register this URL in Greenhouse.

   

---

In Greenhouse

Find your Greenhouse API Key

1. Go to your dashboard, like https://yoursubdomain.greenhouse.io/.

2. In the top right, click on the settings button. Select Configure.

   

3. In the left menu, select Dev Center.

   

4. Select API Credential Management.

   

5. You can either use the existing key or generate a new API key by clicking on Create New API Key. Make a note of your API Key. You will need it to fill in your Fivetran Greenhouse setup form.

   

6. Give the key access to the appropriate tables.

   

Register webhooks

All incremental updates about the entities are captured by webhooks. Fivetran can capture webhooks like candidate hired, candidate rejected, etc to record the history.

1. Return to the Dev Center.

2. Select Web Hooks.

   

3. Select the first option, Web Hooks.

   

4. Create a webhook for each event you want to capture. Paste the webhook URL you found in Fivetran in the Endpoint URL field.

   

• Note: The following events are recommended to be registered for webhooks and all events have the same endpoint:

  • APPLICATION CREATED

  • APPLICATION DELETED

  • CANDIDATE HIRED

  • CANDIDATE MERGED

  • CANDIDATE STAGE CHANGED

  • CANDIDATE UNHIRED

  • CANDIDATE REJECTED

  • CANDIDATE UNREJECTED

  • CANDIDATE DELETED

  • DEPARTMENT DELETED

  • INTERVIEW DELETED

  • JOB CREATED

  • JOB UPDATED

  • JOB DELETED

  • JOB POST DELETED

  • JOB STAGE DELETED

  • OFFER CREATED

  • OFFER UPDATED

  • OFFER DELETED

  • OFFICE DELETED

  • SCORECARD DELETED

    For some of the events, like Application created, Job created and Offer created we will create an entry in the history table but the main entity will be inserted on periodic sync and not part of the event cycle. Also, some entity level updates will not be present in the history table due to lack of information from the source API, but the updated data will be synced into the main entity.

---

In Fivetran

1. Return to the tab with your Fivetran dashboard.

2. Enter your desired destination schema name.

3. Enter the API key you found in Greenhouse.

4. Click Save & Test. Fivetran will take it from here and sync your Greenhouse data.