How to get Amazon orders to Google Sheets using Python and SP-API (2024 update)

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 on your orders daily.
Also, Amazon's SP-API no longer requires AWS IAM and Signature Version 4! Previously a challenge, SP-API requests are now streamlined with exclusive authorization through Login with Amazon (LWA). This update makes accessing vital data simpler and bypasses previous complexities.

GitHub Code: https://github.com/jakobowsky/new-ama...

Need help with development?
Visit our website, book a call and let's explore what we can build together!

Send us an email: [email protected]
Our website: https://deltologic.com/

Time Stamps:
0:00 - Intro to video on how to get Amazon orders to Google Sheets
1:24 - Information about structure of the video
1:56 - Setup new Amazon SP-API App in Seller Central
3:03 - Setup coding environment for connecting to Amazon SP-API
4:38 - How to get orders from Amazon SP-API
7:52 - Configure Google Sheets API
9:16 - Get credentials from Google Cloud
10:58 - Put Amazon orders to Google Sheeets
15:42 - If you need help with building a custom software tool for Amazon, contact Deltologic