Amazon SP API (orders) to Google Sheets with Python

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 SP API (old Amazon MWS) with Google Sheets and collect data of your orders daily. We will use the Python programming language with some 3rd party libraries.

Watch full tutorial here

https://youtu.be/bHBFElmWRNg

Create .env and get client_secret.json from GCP

.env example

REFRESH_TOKEN=Atzr|IwEBINTLp**********
LWA_APP_ID=amzn1.application-oa2-client.8c42******
CLIENT_SECRET=3483932*************************
AWS_ACCESS_KEY=AKIA***********
AWS_SECRET_KEY=M9aYP********************
ROLE_ARN=arn:aws:iam::957*******:role/******

GOOGLE_SHEETS_EMAIL=***********.iam.gserviceaccount.com
GOOGLE_SHEETS_ID=1bSoTWrE*******************
GOOGLE_WORKSHEET_NAME=*********

Setup Python Virtual Environment

pipenv install
pipenv shell

Running Script

python script.py