Integrate 3rd Party API on Google Sheet

We want to integrate Daily Diesel Rate API on the Google Sheet and enable alerts on our email whenever the Diesel Prices in India increase by 5% or more from the mentioned diesel prices in the Google Sheet.

We will explain more about this in detail.

First, is it possible to integrate the API into the Google Sheet?