Automate your Amazon orders data with SP API, Google Sheets and Python (new method 2023)

We just launched our first Amazon SP-API course!
Link to the course: https://courses.deltologic.com/
---
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.

Github Code: https://github.com/jakobowsky/amazon-...

Need help?
Feel free to reach out and book a free consulting session - we will examine your business and find the best solution to your problem.

Send us an email: [email protected]

Our website: https://deltologic.com/

Time Stamps:
0:00 - SP API vs. MWS and Google Sheets
1:33 - Selling Partner API Documentation & Setup
5:00 - Roles
6:13 - Registering an application
7:15 - Authorizing an application
8:15 - Installing Python Virtual Environment
8:48 - Connecting to SP API
10:13 - Connecting to Google Sheets
12:50 - Developing the Python script
15:10 - Recap, Running the script, and Results