This article outlines how to leverage CodeSignal’s webhooks functionality to feed CodeSignal Certify assessment results into Airtable via Zapier.
Visit this support article you want to send CodeSignal Test results to Airtable via Zapier.
This integration will be useful to you if you are using Airtable as your applicant tracking system (ATS) and are already tracking candidate contact information in Airtable. By integrating CodeSignal with Airtable using Zapier, your candidates' Certify assessment results will be automatically added to Airtable.
Prerequisites
- You must have a paid Zapier account that provides access to Premium apps.
- You must have an Airtable account.
- You must have Admin permissions in your company’s CodeSignal account.
- You must have access to CodeSignal APIs & Webhooks through your plan.
Steps
Prep
1. Set up a table in Airtable to use for your integration. At a minimum, the table needs to include the following 2 columns:
- Candidate email address: To find the record that you want to match the certification results to. This column should already be populated with the email addresses of your candidates.
- Certification Results: To record the certification data you get from the Webhook. This column will be empty, and will be populated by data from the Webhook.
2. (Optional) Add columns to your table that parse out Coding Score and Coding Results from the CodeSignal Certification Results. The formulas below show how to parse out this information into new columns.
3. Complete the steps for setting up a Webhook from CodeSignal to Zapier detailed in this Knowledge Base article: Connect CodeSignal with Another Application Using Zapier
Find the candidate in Airtable
Writing CodeSignal certification results to an Airtable table that already includes the email addresses of your candidates requires 2 steps in your zap.
- You need to find the candidate from the Webhook data in Airtable - using candidate email address, for example.
- Then, you need to write the certification data from the Webhook to that candidate's record in Airtable.
4. After you have set up a Webhook from CodeSignal to Zapier, Zapier will prompt you to select an App & Event for the second part of the zap setup. Select Airtable in the Choose App field.
5. In the Choose Action Event field, choose Find Record from the drop-down menu. Click the CONTINUE button.
6. If you have already connected your Airtable account to your Zapier, you should see your Airtable account as an option in the drop-down menu. Click CONTINUE.
If you are connecting your Airtable account to Zapier for the first time, read this guide for instructions.
7. After connecting your Airtable account to Zapier, Zapier will prompt you to Customize Record. Select values for the following fields:
- Base: Select the Airtable Base that you set up in for this integration in step 1 of "Prep."
- Table: Select the Airtable Table that you set up in for this integration in step 1 of "Prep."
- Search By Field: Select email
- Search Value: Select Payload Candidate Email. This will match the candidate email from the Webhook data to the corresponding record in your Airtable table.
At the bottom of the window, check the box for Create Airtable Record if it doesn't exist yet? Choose the appropriate values for each field to populate from the webhook payload.
Click the CONTINUE button, and then TEST & CONTINUE.
Write the data to Airtable
8. Click the + button to add another step to your Zap. For the app, choose Filter by Zapier. Under Filter Setup & Testing, choose values for the following fields:
- Choose field...: Select Zap Data Was Found (in the Find or Create Record in Airtable drop-down)
- Choose condition...: Select (Boolean) Is True
Then, click Continue
9. Click the + button again to add another step to your Zap. For the app, choose Airtable. Under Choose App & Event, select Update Record from the drop-down menu. Then, under Choose Account, select your Airtable account.
10. Zapier will again prompt you to Customize Record. Select values for the following fields:
- Base: Select the Airtable Base that you used in the previous step of the zap.
- Table: Select the Airtable Table that you used in the previous step of the zap.
- Record: Select ID
- Certification Results: Select Payload Shared Test Sessions. This will allow Zapier to populate the Certification Results column in your Airtable table with CodeSignal certification results pulled from the Webhook.
11. Test your zap, and you're done!
Add any other desired steps in your zap to complete the set-up.
Questions? Reach out to us at support@codesignal.com