Google Sheets script that retrieves data from an API

Job ID: 36614455

Budget: €8 – €30 EUR

I am searching for a developer who can create a Google Sheets script that retrieves data from an API. When I input the request data into the Google sheet, I expect it to fetch data from the API. The desired data that I would like to be returned is highlighted in green, while the data that I would like to include in the API request is highlighted in yellow (https://docs.google.com/spreadsheets/d/1VERzy5Fb7j6DWbVoZZ8q_JFN5GvGeDE33zved1yLxUg/edit?usp=sharing.)

Details on the API: Rentalizer Summary API (https://apidocs.airdna.co/#fbf43c02-bf99-d08d-a27b-ec5231aea87a)

I am searching for someone who specialises in Google Sheets scripting and is capable of delivering high-quality work in a timely manner. After rewarding the project I can give the API key and hope it to be delivered in 1 or 2 days.

Thank you for considering this project.
Related categories: JavaScript Google Sheets Google Apps Scripts