Analyze Amazon Seller Central data with Google Sheets
About Amazon Seller Central
About Google Sheets
Connect Amazon MWS to Google Sheets
It is very simple to connect Amazon Seller Central to Google sheets, it can be done in a fast and easy manner with Windsor.ai.
First Step:
You need to select Amazon Seller Central as a Data Source and Grant Access to Windsor.ai.
Second step:
Select Google Sheets as a data destination.
Third Step:
You can choose between two options:
Option 1: Advanced and for large data volumes
- Click this link to install the Google Sheets add-on
- Go to Extension – Ad Data and Analytics by Windsor.ai – Login
- Enter your API key: [your API Key] and click Login
- Start using the add-on in Google Sheets from the Add-ons menu in Extension – Ad Data and Analytics by Windsor.ai – Get Data into Sheet in Google Sheets document and select your fields
Option 2: Quickstart
- Copy the snippet below into your Google Sheet. Only works for fast queries below 60 seconds, use the add-on in case of issues.
- The URL works as an API data feed and the fields can be adjusted with the parameters in the URL.
- You can add any field that is available in the data sources you have added.
=IMPORTDATA(“https://connectors.windsor.ai/amazon_sp?api_key=
[your API Key]&date_preset=last_28d&fields=account_name,clicks,date&_renderer=googlesheets")
and replace
[your API Key]
with your API key. The list of selected fields must contain a date field. The fields which are listed after&fields=
are simply a set of standard fields which you can customise. A full list of metrics and dimensions can be found in our Amazon Seller Central Ads connector documentation. Customise the URL to your liking.
About Amazon Seller Central and Google Sheets
Let us explain what MWS is by telling you what it does. APIs allow programs to integrate with other programs, to put it simply. Different software solutions may use different formatting, and certain requests from one program cannot be performed by the other. In this case, Amazon MWS allows us to read, analyze and format data from Amazon in Google Sheets or Excel.
The internal Amazon systems aren’t immediately available to the external world, but they are made available via the Marketplace Web Service. But, the MWS isn’t a tool in the strict sense of the word, it doesn’t come with features, but it does allow you to develop your own features and make the most of your Amazon data. And we all know how essential data is when you’re selling things – looking at the data in the right way can allow you to improve your sales and become more profitable and that’s what every business strives to do, regardless of what you’re selling.
So, MWS alone can’t help you make the most of your Amazon data, but when integrated with Google Sheets it’ll sure give you a full perspective and better understanding of your sales data.
Try Windsor.ai today
Access all your data from your favorite sources in one place.
Get started for free with a 30 - day trial.
Extract MWS data to Google Sheets with Windsor.ai
See the value and return on every marketing touchpoint
Providing 50+ marketing data streams, we make sure that all the data we integrate is fresh and accessible by marketers, whenever they want.
Spend less time on manual data loading and spreadsheets. Focus on delighting your customers.