With the world taking a frog leap into the eCommerce world, more and more people start selling their products on Amazon. However, once you start hitting the mass scale and you have orders coming every minute, it can be hard to get a grasp of all the data. The basic Amazon dashboards are limited, and you will soon find yourself using proprietary tools charging hefty monthly subscriptions. In this video, I will show you how easy it is to integrate Amazon MWS API with Google Sheets and collect data of your orders daily. We will use the Python programming language with some 3rd party libraries.

https://youtu.be/cV_sRu9A23A

.env example

MWS_ACCESS_KEY="XXXXJJVN6XXNSP3XXXX"
MWS_SECRET_KEY="XXXXwQuqXXTshxEsQYmXXXX92eb6ZsNzjMmvXXXX"
MWS_SELLER_ID="XXXXJ965EXXXX"

GOOGLE_SHEET_KEY=XXXNDDjLr42RKWeqzmY_XXXX7d4yF_nuZKwHXXXX

pipenv install
pipenv shell

python script.py