🔥 Google Sheets integration is live! Learn more

How to Import Job Listings into Airtable with No-Code

Aug 17, 2022Rosie Threlfall

In this guide, we'll run through how to import job listings into Airtable using the Adzuna API and the free Data Fetcher add-on.

Adzuna is a job search engine and its handy API allows you to import job listing data for various applications. You'll need to sign up to Adzuna here and find your API key here.

This tutorial is 100% no code.

Install Data Fetcher

First, install Data Fetcher to your base by accessing the Airtable marketplace. This free extension enables you to import different types of data into Airtable by using API integration.

Either create a free Data Fetcher account or sign in to your existing account using the 'Have an account?' button on the bottom left of the screen.

Alternatively, sign-up to Data Fetcher with your Google account by selecting 'Continue with Google'. 

Data Fetcher Sign Up

Create Request to Import Job Listings into Airtable

Data Fetcher requests are used to import and export data. You can create multiple requests within one installation of Data Fetcher in an Airtable base.

To start, click on 'Create your first request' from the Data Fetcher home screen.

Create your first request in Data Fetcher

On the create request screen, select 'custom' for Application.

job-listings1.png

For Method, select 'Get' and copy and paste this URL:

https://api.adzuna.com/v1/api/jobs/us/search/1?app_id=YOUR_APP_ID&app_key=YOUR_APP_KEY&what=html&where=new york

Enter your Application ID and API Key which can both be found here.

For what enter the type of jobs you want to find jobs for, e.g. 'Design'.

For where enter the location you wish to search for jobs in, e.g. 'New York'.

Add another parameter called 'permanent' and add '1' as the value in order to only import permanent job roles.

You can find further info about the different parameters you can import here.

Give your request a name such as 'Import Job Roles'.

Click 'Save & Run'.

job-listings-settings.png

The Response field mapping modal will now open. This is where you choose which fields to import from Adzuna and how they map to your output table. 

For each imported field, you can either map it to an existing field in your output table or create a new one. You are also able to choose a field type for any new fields.

Click filter all to remove any pre-selected fields, then use the Find field search bar to easily locate the fields you want to import.

For this example, we are going to import the following fields:

Results contract time map to the existing 'Name' field in your output table.
Results redirect url map to a new field called 'URL'.
Results description map to a new field called 'Description'.
Results created map to a new field called 'Date'.
Results location display name map to a new field called 'Location'
Results category label map to a new field 'Category' and choose the type 'single select field'.

Click 'Save & Run'.

job-listings-response.png

Click 'Save & Run'.

job-listings-output.png

Your output table will now be populated with the jobs that meet the search criteria defined by the parameters set in the Data Fetcher request.

Being able to import job listing data into Airtable could be useful for many reasons. By using a tool like Softr, you could easily create a job board and incorporate this into a website to show live job listings. You can read more about integrating Softr and Airtable to create a job board here.

Schedule Job Listings to import into Airtable Automatically

Currently, you'd need to manually click 'Run' in Data Fetcher to import any updates to the job listings or import any new listings matching your search criteria.

By using Data Fetcher's (paid) scheduling feature, you can run your request automatically at regular intervals so Data Fetcher will periodically check for new or updated job listings.

As this is a paid Data Fetcher feature, you will need to upgrade your account. In Data Fetcher, scroll to Schedule and click 'Upgrade'.

schedule-requests.png

Choose a plan from the different options depending on your needs and enter your payment details.

data fetcher upgrade options

Back in Data Fetcher, click 'I've done this'.

schedule-upgrade.png

Click 'Add API key' and copy and paste your Airtable API key. You can find your Airtable API key here.

Group 11(1).png

Enter your Airtable API key and click 'Save'.

save-airtable-api-key.png

Toggle Schedule this request to on.

schedule-data-fetcher-request.png

Select a schedule based on intervals of 'Minutes', 'Hours', 'Days' or 'Months'. Click 'Save', and any new job listing data will automatically import into your Airtable base on your chosen schedule.

schedule-a-sequence-intervals.png

Other Recent Posts

How to Import Google Calendar Events to Airtable

How to Import Google Calendar Events to Airtable

Sep 26, 2022

Rosie Threlfall

Google Calendar
The Journey Bootstrapping a SaaS to $10k MRR

The Journey Bootstrapping a SaaS to $10k MRR

Sep 12, 2022

Andy Cloke

BootstrappingData Fetcher
How to Import Zoho CRM Data to Airtable

How to Import Zoho CRM Data to Airtable

Sep 8, 2022

Rosie Threlfall