Job Listing API - Pull Job Search Data into Google Sheets [Tutorial]

How to connect a jobs API to Google Sheets

In this tutorial I’m going to show you how to connect the Remotive remote jobs API to Google Sheets using the Apipheny API integrator add-on, but the same method can be applied to any jobs API.

The example we’re going to use is Remotive, a directory for remote jobs. Remotive offers a remote jobs API that you can use to get a list of remote job opportunities from their database.

An API is just a data pipeline between two softwares. So by connecting the Remotive jobs API to the Google Sheets API, we can get a list of remote jobs sent directly to our Google Sheets.

You can connect the Remotive API to Google Sheets in 5 steps:

Install the Apipheny add-on for Google Sheets
Create your API URL
Run the API request

Step 1.) Install and open the Apipheny add-on for Google Sheets

Apipheny is an API connector for Google Sheets. You can use Apipheny to connect your Google Sheets to unlimited API data sources, make unlimited API requests, and more. There is a 30 day free trial included.

1.) Install Apipheny by opening the following link on desktop and then clicking the Install button in the Google Marketplace: https://apipheny.io/install

2.) After you’ve installed Apipheny, open a Google Sheet and then click on the Extensions dropdown in the menu at the top.

In the dropdown list you should see Apipheny. Click Apipheny then click Import API to open the Apipheny sidebar in your Google Sheet.

Tip: you can open a new Google Sheet by entering this URL in your browser: sheet.new

Step 2.) Create your API URL

After you install and open Apipheny, your next step is to enter the Remotive API URL into Apipheny.

Here’s the API URL:

https://remotive.io/api/remote-jobs

This URL uses the GET method. If you use this URL without any parameters, you’ll get a list of all of the jobs from Remotive’s system.

If you want to narrow down the results returned, you can use the following parameters:

Parameter	Description	Example
category	Get job listings for a specific category. To get a list of categories, send a request to https://remotive.io/api/remote-jobs/categories	`https://remotive.io/api/remote-jobs?category=software-dev`
tags	Get job listings for specific tags. You can query several tags at once, comma separated, e.g: php,ubuntu). To get a list of tags, send a request to https://remotive.io/api/remote-jobs/tags	`https://remotive.io/api/remote-jobs?tags=c-sharp,linux`
tag_operator	If multiple tags are used, they can be combined using this operator. You can use “or” (which is the default) or “and”	`https://remotive.io/api/remote-jobs?tags=c-sharp,linux&tag_operator=and`
company_name	Use this parameter to filter listings by company name.	`https://remotive.io/api/remote-jobs?company_name=remotive`
search	Search for job listings by title and description.	`https://remotive.io/api/remote-jobs?search=front%20end`
limit	Use this parameter to limit the number of job listings returned. The default is “all”. An integer must be provided.	`https://remotive.io/api/remote-jobs?limit=5`

Remotive Jobs API Parameters

Step 3.) Run the API request

After you create the API URL with parameters you need to get a list of remote jobs by category, or tag, etc., then your last step is to enter the API URL into the Apipheny add-on and run the API request.

Just enter the API URL into the “API URL Path” field in Apipheny and then click the Run button: