Python, Excel VBA, API Integration to Parsing Specific Line from API response

I am seeking a professional with strong expertise in Python, Excel VBA, and API integration. The primary task is to extract specific data from the API response, and populate it into a designated column in an Excel file.

Key Requirements:
- Experience in Python programming
- Proficiency in Excel VBA
- Demonstrable experience with API integration
- Ability to parse specific data from an API response from Google Server
- Good understanding of automating tasks in Excel

Further Details:
- The primary purpose of the project is to send API requests with image URLs listed in column A of the Excel file. Upon receiving the API response, the relevant data should be extracted and placed in column D and B/C/E to be populated.
- The setup should be easy to execute when needed by click of few buttons and automatically looping until all rows in excel are submitted by API.
- The final deliverable should be in .xlsx format.

ATTACHED:
- Partial response of JSON API shown in attached screen shot JSON-API-RESPONSE.jpg
- Format of excel file which shows how the image urls listed on column and other columns to populate.


Please submit your bid if you have a strong background in this area.