Connect Amazon Marketplace to Google Sheets and get real-time sales, orders and other data from your Amazon Marketplace to Google Sheets. You can also pull other data such as listings–current as well as historical– from Amazon Seller Central into Google Sheets.
You can do all this with ease using a data connector called Amigo which you can install as an extension in Google Sheets. Using this add-on, we can retrieve data from various sources into Google Sheets. And not only export but auto-update the reports so that fresh data are served to us routinely.
So, let us learn how to connect Amazon Marketplace to Google Sheets and load data from Amazon Seller Central to Google Sheets.
Sections of the article:
How to connect Amazon Marketplace to Google Sheets
Install the Amigo Add-on
But before you proceed, install the Amigo add-on using one of the methods mentioned below. It will be used in all the subsequent steps to create an Amazon Seller Central and Google Sheets integration and export Seller Central data to Google Sheets.
Get it from the Google Workspace Marketplace by clicking the link provided below.
Alternatively, you can get it from within Google Sheets itself.
- Open a Google Sheets document
- Go to Extensions→Add-ons→Get add-ons
- Search for Amigo and install
Once the installation is complete, the Amigo add-on should appear in your Google Sheets Extensions list.
Connect Amazon Marketplace to Google Sheets
To connect Amazon Seller Central account to Google Sheets, open Google Sheets and launch Amigo by clicking Extensions→Amigo: Data Exports and Reports→Connect.
From the list of available sources to connect select Amazon Marketplace.
Name the connection and click Authorize to connect Amazon Seller Central to Google Sheets.
You’ll be redirected to Amazon Seller Central sign-in page. Enter the account credentials and complete Seller Central and Google Sheets connection.
After successfully integrating Amazon Seller Central with Google Sheets, we’ll be able to export data from Amazon Marketplace to Google Sheets.
Export Seller Central data to Google Sheets
Launch Amigo from Google Sheets and select the Amazon Seller Central and Google Sheets connection you’ve created.
From the report creation dashboard that appears, select the marketplace from which to retrieve data. And specify the date range and select the type of Amazon data export to Google Sheets–orders, sales, listing, etc. Then click the PREVIEW button to see a preview of the data.
Give a name to the report and click the IMPORT button to pull your Amazon Seller Central data to Google Sheets.
A moment later, the spreadsheet will be populated with the requested data from Amazon.
You can likewise export sales reports, listings reports–open and detailed–from Seller Central to Google Sheets in a matter of seconds, literally. What’s more, we can set a refresh schedule to pull the data automatically at regular intervals–hourly, daily, weekly or on certain days–so that we need not spend an additional second retrieving data. Click here to set a refresh schedule in Amigo and receive the updated report in your inbox or Slack channel.
With Amigo you can export data from various other sources such as Shopify, Woocommerce, Facebook Ads, Google Ads, and Redshift to name just a few. Creating reports, analysing reports and collaborating with team and clients has never been easier. Try Amigo today. For more information, visit https://tryamigo.com
Some recommended articles:
How to Connect Shopify to Google Sheets
How to Connect Woocommerce to Google Sheets