How to Import Job Listings into Airtable with No-Code

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'. 

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.

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

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'.

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'.

Click 'Save & Run'.

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.

Use Pagination to Import More Jobs Listings

By default, Adzuna will import 10 job listings. We can import more than this by setting up pagination. In the URL, change the 1 to {page} . So that the full URL looks like:

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

Then, click 'Advanced settings' at the bottom of the screen. Scroll down to Pagination and change the type from 'None' to 'Path'.

For Path parameter, enter 'page'. For Page size parameter, enter 'results_per_page'. For Page size, enter '10'.

Change the Number of pages to the number of pages you want to fetch, or select Fetch all pages. Be careful when fetching all pages, as Adzuna may give you hundreds or thousands of results.

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'.

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

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

Under Schedule click '+ Authorize'.

A window will open and prompt you to authorize the Airtable bases that Data Fetcher will be able to access.

By selecting 'All current and future bases in all current and future workspaces' this will avoid any issues with unauthorized bases in the future.

Click 'Grant access'.

You'll now see Schedule this request has been toggled to on.

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.