How to connect a remote 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.

Remotive is 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:

  1. Install the Apipheny add-on for Google Sheets
  2. Create your API URL
  3. Run the API request

Step 1.) Install Apipheny

To pull data from the Remotive API to Google Sheets easily and without writing any code, first install and open the Apipheny Google Sheets add-on.

Apipheny is a no-code API integrator for Google Sheets that you can use to make unlimited API requests, connect to unlimited APIs (including the Remotive API), save API requests, schedule API requests, and more. Click here if you want to learn more about Apipheny.

Install Apipheny by clicking the Install button on this page.

After you install Apipheny, open a Google Sheet and in the menu at the top, click “Add-ons” > “Apipheny” > “Import API” to open the Apipheny add-on.

Open Apipheny
Open Apipheny

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:

ParameterDescriptionExample
categoryGet job listings for a specific category. To get a list of categories, send a request to https://remotive.io/api/remote-jobs/categorieshttps://remotive.io/api/remote-jobs?category=software-dev
tagsGet 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/tagshttps://remotive.io/api/remote-jobs?tags=c-sharp,linux
tag_operatorIf 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_nameUse this parameter to filter listings by company name.https://remotive.io/api/remote-jobs?company_name=remotive
searchSearch for job listings by title and description.https://remotive.io/api/remote-jobs?search=front%20end
limitUse 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:

Remote Jobs API data in Google Sheets
Remote Jobs API data in Google Sheets

Congratulations! You’ve now imported data on remote job opportunities into your Google Sheets.

Once you have the info you need, you can create reports or alerts with the data.

You can also try using the other features of the Apipheny add-on, such as saving and scheduling your API request.

You can even combine the remote jobs API data with data from a different API to create custom blends of data that no other software can provide.

Related articles:

Related Posts

Leave a Comment