/ Advisors

Employer submitted job portal opportunities with Airtable and Zapier

If you've considered using our job portal feature to share opportunities with your job seekers, then you might know that opportunities can be saved by your advisors, either through the advisor dashboard or by using the Huntr chrome extension.

But, what if you want to give your employer partners or other parties the ability to submit opportunities without having to add them as advisors in your organization? This is were the Huntr API comes in. Our API offers a job post creation endpoint that opens up a world of integrations.

In this post we will discuss one potential integration, in which we use Airtable's form feature to create an 'Employer Job Submission Form'. We will then use Zapier to listen for new Airtable entries and send those entries to your Huntr job portal.

The end product will be an Employer facing form, through which your employer partners can submit job opportunities, which will then be published to your job seeker facing Huntr job portal. Let's get started!

Setting up your Airtable base

Screen-Shot-2021-03-05-at-1.26.31-PM

Before you start working on the Zapier integration, make sure you've setup your Airtable base, tables and forms to support the integration. We won't go into detail on how to set these up, but here is a link to our setup. You can create a copy of the setup by following the link and clicking the 'copy base' link on the top right of the page.

Our setup has two tables, one for Job Posts and another one for Employers, and includes one form to signup as an Employer and a second form to submit a job post. You don't have to follow this format, and can customize it to your liking, but we feel it offers a pretty intuitive experience for employer partner job submissions.

Publishing a job submission from Airtable to Huntr through Zapier

1) Sign up for a Zapier account

You can sign up for zapier through this link. Once you have signed up, you should see a page similar to the one below; click on the 'Make a zap' button. A zap represents an integration between two applications.

Screen-Shot-2020-06-25-at-12.46.58-PM

2) Setup Airtable as a trigger

In Zapier, a trigger is the action that will initiate the 'Zap'. In our case, our trigger is a new Airtable job post record being received.

  • After you clicked the 'Make a zap' button, enter Airtable in the 'Choose App & Event' search box, and click on the Airtable option.

  • You should now see a list of Event options, select the 'New Record' option, then click 'Continue'.

  • You should now see a 'Set up trigger' section. Select the base you created on Step 1 and the 'Job Posts' table for the table field. Click 'Continue'.

  • At this point, you should see a 'Test trigger' button. Click the button. This will pull the latest job post entry from your Airtable. If everything is working, you should see a 'We found a record!' message on the screen. If there is more than one record available, you will be able to see them through the dropdown. Once you've selected a record click Continue.

3) Setup Zapier Webhook Action

In this step we will take the data from step 2 and send it to Huntr using Zapier's Webhook POST action.

  • Find the 'Webhooks by Zapier' app in the action search box. Select it and then select the 'Post' option from the Action Event dropdown. Click continue.

  • You should now see the 'Set up action' section. Under the URL field enter https://api.huntr.co/org/job-posts. For Payload Type, select Json.

  • For the Data section, see the image below to see the Key/Value pairs to enter, your keys on the left should look exactly like the ones in the image, your values might look different if you decide to modify the structure of the Airtable tables.

Screen-Shot-2021-03-05-at-1.45.50-PM

  • For the Headers section, you only need the Authorization header, as seen in the image below. Make sure to replace the <HUNTR_API_TOKEN> part for your organization's API token, which you can find under the 'Developers' page in your advisor portal, so the final header value would look something like this: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpZCI6IjVhNzA5ZTAwYTI2NDZhZjNjM2YxMDcyNCIsImp0aSI6IjU4YTg0MGEzLWMzMTEtNDJiYS1iZTBhLWVhMjVmNDY4Njg0YyIsImlhdCI6MTYxNDkxNjE3Mn0.hKtERnezpTuc7nMxzWJtogIsw_8xBHpOf1P7NkrOP9M. Click continue.

Screen-Shot-2021-03-05-at-1.50.19-PM

  • Click Test & Continue. You should now see the job post in both the Job Posts section of your advisor portal and in the job seeker facing portal.

4) Share your Airtable job submission link with partners

Share your Airtable form link with partners and see the job opportunities flow into Huntr!

Note: Job submissions will not be sent to Huntr immediately

Zapier does not run this workflow immediately after a new Airtable submission is sent. For lower priced plans, Zapier will check for new entries every 15 minutes or so. So don't expect to see a job post in Huntr immediately after submitting a new Airtable entry.