Amazon Seller Central + Google Sheets Integrations

Amazon Seller Central and Google Sheets are two software systems that enable businesses to efficiently manage their data.

What is Amazon Seller Central?

Amazon Seller Central is a business management platform created by Amazon.com for online sellers. Amazon Seller Central was launched in September 2015.Amazon Seller Central gives users the ability to organize and manage inventory, sales, and customer information. It also allows Amazon sellers to connect their other business software systems, including Quickbooks, MailChimp, and Google Drive.

What is Google Sheets?

Google Sheets is an online spreadsheet program that allows users to create, edit, save, and share spreadsheets online. It also enables users to create charts and graphs.Google Sheets can be integrated with other applications and services such as Google Drive, Slack, Trello, Twitter, and Dropbox.C. Integration of Amazon Seller Central and Google Sheets

By integrating Amazon Seller Central and Google Sheets, users can more easily manage data across both platforms.Integrating these two platforms can make managing data simpler for both businesses and individuals. Businesses no longer have to spend time transferring data between platforms. Instead, they can simply transfer a file from one platform to another.Individuals using both Amazon Seller Central and Google Sheets can benefit from integration as well. They can use a single platform to track their data across multiple accounts. They also no longer have to worry about losing data if one platform becomes unavailable for some reason.

Integration of Amazon Seller Central and Google Sheets

Amazon Seller Central and Google Sheets can be integrated by following these steps:First, connect the Amazon Seller Central app to your Google Drive account. This can be done by going to the "Apps" tab on the left-hand side of your Amazon Seller Central screen. Then click on "Connect" next to "Google Drive." Once you have connected your Amazon Seller Central account to your Google Drive account, you will be able to copy and paste files between the two platforms.After connecting your accounts, you will need to download the Google Sheets app. You can do so by visiting this link https://drive.google.com/open?id=1bSX8j8fh0Zcg6XwT31lMF_VpSF-hMe7K . Downloading Google Sheets will allow you to access the app from any device with an internet connection.Once you have downloaded the app, you will need to import your Amazon Seller Central order data into Google Sheets. To do so, follow these steps:Go to https://docs.google.com/spreadsheets/d/1QxW4Rv8y2o20s-BXbSOEcU9nZuNxFttPXg5qPZrVk5KA/edit#gid=0 . In the text box next to "File," type in "https://docs.google.com/spreadsheets/d/1QxW4Rv8y2o20s-BXbSOEcU9nZuNxFttPXg5qPZrVk5KA/edit?usp=sharing". You will now see a list of spreadsheets titled "Sheet 1," "Sheet 2," etcetera. Select "Sheet 1." The spreadsheet will open in a new window. On the left-hand side of the screen, click on the tab labeled "From Web." Go to https://sellercentral-eu.amazon.com/gp/aw/merchant/home , then click on the "Orders" button at the top of the screen. Click on "Export Order Data" in the green box near the top right-hand corner of the screen. A new window will appear with a list of options for exporting your data from this page. Click on "CSV (Comma Separated Values." Your CSV file will then download onto your computer's desktop or downloads folder under a file name like "Amazon_Order_Data_export_7882709492865291855_csv." Open up a blank spreadsheet in Google Sheets (see Section II. Go to File > Import... > Upload . Find your CSV file on your computer's desktop or downloads folder and select it, then click upload . Your data will now be uploaded into a spreadsheet within Google Sheets . Open up the spreadsheet where you imported your order data in Google Sheets (see Section II above. The spreadsheet's title will be something like "Sheet 1." On the left-hand side of the screen, click on "Go to Data View." This will open up a new window with your imported data . On the left-hand side of this new window, click on the tab labeled "From Web." Scroll down until you see a section labeled "Important Note About These Data Files." Underneath this heading you will see an option labeled "Access API Reference." Click on this option . This will open up a new window with a list of links for each of Google's APIs . Click on the link labeled "Google Sheets API" . Underneath this heading you will find an option labeled "Explore the API." Click on this option . This will open up a new window with instructions on how to use the API . The first line of instructions states that in order to use the API, you must have an active developer account with Google . To sign up for a developer account with Google go here. https://console.developers.google.com/projectselector Once you have signed up for a developer account with Google , come back to this website . Click on the link labeled "Google Sheets API" within the new window . You will now see a list of options for using the API . In order to integrate Amazon Seller Central and Google Sheets , you will need to utilize the API's "SpreadsheetFeed" feature . To do so, click on the link labeled "SpreadsheetFeed." This will take you to a page with instructions on how to use this feature . You will now see an option labeled "Create client ID." Click on this option . You will now see another option labeled "Select permissions." Click on this option . You will now be asked which permissions you want your client ID to have . For this tutorial we will only need read only access , so select "Read only" from the drop-down menu next to authorization type then click on "Create Client ID" . Your client ID will now be displayed in a new window . Copy this ID and store it somewhere safe (like Notepad. because you are going to need it later . Now we are going back to our original spreadsheet (see Section I. Underneath this heading you will see an option labeled "Authorize access." Click on this option . This will open up a new window with instructions on how to authorize access to your spreadsheet . On this new screen go all the way down until you see an option labeled "OAuth 2.'0' Application Type." Underneath this heading click on the button labeled "Configure Consent Screen." This will open up another new window with instructions on how to set up your consent screen . It is important that you fill out all of these fields just as they are instructed in order for integration between Amazon Seller Central and Google Sheets to work properly . Note that some fields are required while others are optional . Once you have filled out all of these fields , click on "Save" , then go back to the first screen where you selected OAuth 2.'0' Application Type and click on "Save" again . This will take you back to your consent screen where you originally entered in your information . Copy everything inside of this field , including the quotation marks , then paste it into a blank text document (like Notepad. Save this document with a name like amazon_client_secret.txt because you are going to need it later along with your client ID (see Section II. Now we are going back to our original spreadsheet (see Section I. Beneath this heading you will see an option labeled "View Credentials." Click on this option . You will now be taken to a new webpage that lists your credentials for accessing your spreadsheet through Google's API . Scroll down until you see an option labeled "Bearer Token." Underneath this heading copy everything inside of quotation marks including the preceding periods like so.  "Bearer  xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx" (where x represents whatever random character appears after your client ID. Then paste this string into Notepad and save it as amazon_access_token.txt because you are going to need it later along with your client ID and client secret (see Section II. Now

The process to integrate Amazon Seller Central and Google Sheets may seem complicated and intimidating. This is why Appy Pie Connect has come up with a simple, affordable, and quick solution to help you automate your workflows. Click on the button below to begin.