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 - ...