Amazon API to Google Sheets

I need to have a Google Sheets spreadsheet connected to the Amazon Product API, so that I can have the first 3 columns contain all of the following data. The goal is then to retrieve from one of these three identifiers data about product name, price, image, product description. Usually we provide the EAN. So first thing to do is to automatically lookup for the other 2 identifieres. Column A - EAN Column B - ASIN Column C - Product Name and via the API's mentioned above have the further Columns automatically populate with the following data: Column D - Product Name Column E - Product Description Column F - Buyer Box Price Column G - Image link Column H - ...