Follow our setup guide to connect Greenhouse to Fivetran.
To connect Greenhouse to Fivetran, you need:
- A Greenhouse account with an active subscription.
- An account with owner/admin privileges.
IMPORTANT: Only use an HTTPS URL with TLS version 1.2 or above.
Find webhook URLlink
In the connector setup form, find the automatically-generated webhook URL and make a note of it. You will need to register the URL in Greenhouse.
Find API Keylink
Log in to your Greenhouse account.
Click the Settings option.
Click Dev Center and then click API Credential Management.
Click Create New API Key.
You can also use an existing Harvest API key. Click Copy to make a note of it. Skip to Step 3.
In the Create new credential window, enter a Description for the API key.
In the Type drop-down menu, select Harvest, and then click Create.
NOTE: Fivetran only supports the Harvest API.
Make a note of your API Key. You will need it to configure Fivetran.
Give the key access to the Candidates table.
NOTE: You must have access to the Candidates object.
Give the key access to the tables you want to sync and then click Update.
NOTE: If you change the API key permissions after configuring the connector, then reload the schema from your connector dashboard. You may observe sync errors or data integrity problems if you don’t reload the schema.
Finish Fivetran configuration link
In the connector setup form, enter the Destination schema name of your choice.
Enter the API key you found Step 2.
Click Save & Test.
Return to the Dev Center.
Click Web Hooks and then click Web Hooks.
In the Create a new Webhook window, enter a name for your webhook.
In the When drop-down menu, select the event type you want to capture.
Enter the Endpoint URL from Step 1.
Enter the Secret key from Step 2.
Click Create Web hook.
Use the above steps to create the following event webhooks (with the same endpoint URL and secret key):
- 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
Fivetran will take it from here and sync your Greenhouse data.