Download Amazon SP-API Report to Google Sheet.

I am receiving a lot of query from Amazon Seller asking me about to write a blog on downloading Amazon Seller Central Report to Google Sheet using SP-API. I have earlier written a article on our company blog on downloading data from Amazon Seller Central using MWS API. You can check the blog on Google App Scripts + Amazon MWS — Tirnav Solutions. So, lets start.

We have been working on e-commerce API integration since past 5 years and we have worked on Amazon MWS & SP-API, Amazon Advertising API, eBay, Walmart, Google Shopping, Shopify and many other and also for Target.com, WayFair etc using Electronic Data Interchange(EDI).

I will not write the detail step as written in my previous blog since we have already published a Google Sheet add-on which is free to use. The url for the add-on: Amazon SP-API Reports — Google Workspace Marketplace. Feel free to use the add-on and share feedback/review or any new feature you would like to have in the add-on to our email: amazon-support@tirnav.com.

To use the add-on, the seller need to configure the SP-API related setting in the Amazon AWS account. You can find the related setting information from Amazon Github page: selling-partner-api-docs/SellingPartnerApiDeveloperGuide.md at main · amzn/selling-partner-api-docs (github.com)

Once, you have done setting up with SP-API configuration and generating the Refresh Token from Seller Central, Seller can download the Google Sheet add-on and start using it. Seller need to enter the configuration in the Configuration page. Please note that your credentials are store in Google User Profile.

Once, you fill out your credential, the add-on will verify the credentials by making a test API call and save it. After that, you can start using the add-on.

Now, lets make a request for a new report lets say All Listing Report. I will go through Add-ons -> Amazon SP-API Reports — Start Tracking Report.

We will select the Report from the Report Dropdown and as you can see i have selected All Listing Report, we will also select the frequency to set at what interval add-on should sync the data in the sheet and then adding the sheet name where we need to store the data. If no sheet name is provided, then by default it will take the report name as the sheet name.

Phheww, all done now. Lets save and now the add-on should download the latest data within 5 seconds and then it will automatically trigger for new data at a frequency we already configured. Let see how the data look like:

The add-on will show all the column as return by the SP-API report and on the first row it will print at what time the last time the report was synced.

You can also stop the add-on from downloading the new data by clicking on the Stop Tracking Report.

Please try out the add-on and do not forget to provide the review on Google add-on if you find the add-on helpful enough and give us the shout out on jain.jayesh@tirnav.com or amazon-support@tirnav.com for any help.

Google Add-on link: Amazon SP-API Reports — Google Workspace Marketplace

--

--

--

Founder — Tirnav Solutions. Expert: Java, Amazon SP-API,Amazon Vendor Central EDI, Amazon Advertising API, Google App Scripts & Electronic Data Interchange(EDI)

Love podcasts or audiobooks? Learn on the go with our new app.

Recommended from Medium

Add Post Processing to your Game

AmazeWoW Interview Experience and Preparation Guidelines

Layer Your Clothes: How Canadians Keep From Freezing Their Junk Off on Winter Adventures

Introducing Scoped API Keys

How Do I Link GitHub Actions with Applitools?

Coroutines in Unity!

Prototype faster than ever before with Serverless Cloud

Create a Environment using AWS CLI.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Jayesh Jain

Jayesh Jain

Founder — Tirnav Solutions. Expert: Java, Amazon SP-API,Amazon Vendor Central EDI, Amazon Advertising API, Google App Scripts & Electronic Data Interchange(EDI)

More from Medium

Explaining machine learning models to business users using BigQueryML and Google Data Studio

Stocky — Ultimate Inventory Management System with Pos Nulled

01-stocky-Presentation

Interview with Paul Okundaye: Perspectives from an MBB Consultant

A complete step by step guide-SEO(Search Engine Optimization)