Connect Google Sheets to Amazon Seller API's
Budget: $250 – $750 USD
We're a seller on Amazon with about 5,000 SKU's. We're looking for a developer to bring the following data into Google Sheets:
- Our current selling price of the ASIN/SKU
- Number of our sales in the past 7 and 30 days of the ASIN/SKU
- Current BuyBox Price of ASIN/SKU
- Current Lowest Price of ASIN/SKU (include shipping fees if it’s FBM and not free shipping)
- Does the ASIN have a BuyBox or Not of ASIN/SKU
- Current FBA fees of ASIN/SKU
- Number of FBA sellers within 3% of BuyBox price of ASIN/SKU
- Current BSR of ASIN/SKU
- 90 Day Average BSR of ASIN/SKU
- Is Amazon listed as a seller of the ASIN/SKU
- Amount of inventory that is Inbound of the ASIN/SKU
- Amount of inventory that’s checked in and available at Amazon of ASIN/SKU
- Amount of inventory that’s moving between warehouses at Amazon of ASIN/SKU
We have a couple Google Sheets that references some or all of this information. Currently this data is brought in through manual imports of exported spreadsheets from other third party platforms that we'd like to circumvent.
We currently use Google Sheets scripts to do calculations on this data.
The data should be as real time as possible with regular scheduled refreshes and/or on demand.
The design should be independent to us, not requiring on-going developer resources (id's, cloud accounts, etc.) other than continued support and future improvement projects.
- Our current selling price of the ASIN/SKU
- Number of our sales in the past 7 and 30 days of the ASIN/SKU
- Current BuyBox Price of ASIN/SKU
- Current Lowest Price of ASIN/SKU (include shipping fees if it’s FBM and not free shipping)
- Does the ASIN have a BuyBox or Not of ASIN/SKU
- Current FBA fees of ASIN/SKU
- Number of FBA sellers within 3% of BuyBox price of ASIN/SKU
- Current BSR of ASIN/SKU
- 90 Day Average BSR of ASIN/SKU
- Is Amazon listed as a seller of the ASIN/SKU
- Amount of inventory that is Inbound of the ASIN/SKU
- Amount of inventory that’s checked in and available at Amazon of ASIN/SKU
- Amount of inventory that’s moving between warehouses at Amazon of ASIN/SKU
We have a couple Google Sheets that references some or all of this information. Currently this data is brought in through manual imports of exported spreadsheets from other third party platforms that we'd like to circumvent.
We currently use Google Sheets scripts to do calculations on this data.
The data should be as real time as possible with regular scheduled refreshes and/or on demand.
The design should be independent to us, not requiring on-going developer resources (id's, cloud accounts, etc.) other than continued support and future improvement projects.