Skip to content

YouTube Tutorial Project - Amazon SP API / Orders API / Google Sheets API / Automation

Notifications You must be signed in to change notification settings

jakobowsky/amazon-sp-api-orders-to-google-sheets

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

miniatura7_Obszar roboczy 1-min

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

About

YouTube Tutorial Project - Amazon SP API / Orders API / Google Sheets API / Automation

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published