Articles in this section

Send CodeSignal Assessment Results to Airtable Using Zapier

Avatar
Team CodeSignal
Updated

This article outlines how to leverage CodeSignal’s webhooks functionality to feed CodeSignal assessment results into Airtable via Zapier.

Visit this support article you want to send CodeSignal assessment 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 test-taker contact information in Airtable. By integrating CodeSignal with Airtable using Zapier, your test-takers' 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:

  • Test-taker 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 test-takers.
  • 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.

airtable1_copy.png

 

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.

airtable2.png

airtable3.png

 

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 test-taker in Airtable

Writing CodeSignal certification results to an Airtable table that already includes the email addresses of your test-takers requires 2 steps in your zap.

  • You need to find the test-taker from the Webhook data in Airtable - using test-taker email address, for example.
  • Then, you need to write the certification data from the Webhook to that test-taker'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.

airtable4.png


5. In the Choose Action Event field, choose Find Record from the drop-down menu. Click the CONTINUE button.

airtable5.png

 

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 test-taker 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.

airtable6_copy.png

 

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

zap_filter.png

 

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.

airtable7.png

 

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.

 

airtable8_border_copy.png

 

11. Test your zap, and you're done!

 

Add any other desired steps in your zap to complete the set-up. 

Related articles