Amazon is on fire for merchants these days! Whether or not merchants will love this eCommerce giant a few years from now aside, many are making money and expanding their volume dramatically through Amazon’s marketplace. As a result, we need a way to track Amazon sales, most because Amazon’s built-in reporting is un-explain-ably (is that even a word?!?) weak and deprived of any sort of analytic value (in our humble opinions).
Now, let’s look at an automated way to send your Seller Central Amazon orders to a Google Sheet. This way, you can dashboard sales or do with the data what you need. No programming skills required for this one!
Using Amazon’s API to Push Orders to Google Sheets
Step 1: Setup a Google Sheet
We begin by setting up our Google Sheet.
- Create a new Google seet
- Add the column headings which you’d like. You can change these later but we’ll start with just a few columns here: Date, Order ID, Amount, Fulfillment.
When we access the amazon API (next step), we’ll have options to grab other fields as well but for the sake of this tutorial, we’ll just use a few basic fields.
Step 2: User Zapier to Connect Amazon to Google Sheets
To connect our Amazon account to our new Google Sheet, we’re going to use a sometimes free (based on the volume you do) service called Zapier (read our review here). Zapier is free for some (lower volume), and inexpensive for the rest. The best way to learn this is with our quick video.
- Create your Zapier Account
- Create a new Zaper
- Use the Amazon Seller Central Trigger App
- Use Google Sheets as the action App
- Map your Fields
Benefits of Sending Amazon Orders to Google Sheets
As with most data, once we get it in Google Sheets we can slice and dice it any way we need. This is especially the case with Aamzon as we think their reporting is terrible (no exaggeration, we actually think they don’t want to make it easy to report on your sales).
Want to create cool charts? Great, do send your Amazon orders to Google Sheets and create charts there!
Want to create interactive data visualizations? Great connect the Google Sheet to Data Studio and display the data with filters as need!
Either way, get your data out of Amazon (in real time) and in to a format which is useful, share-able, and easy to manage.
Very helpful tutorial. I have zap all set up, but when the orders come into Google Sheets, many orders don’t have an “order amount.” This tends to be if the order is unshipped. I am afraid that these orders are never counted, and that if the status changes to “shipped,” then it won’t count this order. Have you run into this issue?