OUR CUSTOM FORMULAS

Functions to Pull Amazon Data into Google Sheets

Check out our growing library list of formulas to get detailed seller central data into Google Sheets

All Amazon Marketplaces Supported

Set your main marketplace with the attributes below. If you sell in multiple marketplaces and want to get the total count of something, use “ALL” for the marketplace attribute in the formulas.

  • ALL
  • US – USA
  • CA – Canada
  • MX – Mexico
  • BR – Brazil
  • UK – UK
  • DE – Germany
  • FR – France
  • ES – Spain
  • IT – Italy
  • NL – Netherlands
  • SE – Sweden
  • PL – Poland
  • TR – Turkey
  • SA – Saudi Arabia
  • AE – Arab Emirates
  • JP – Japan
  • AU – Australia
  • SG – Singapore
  • IN – India
  • EG – Egypt

Selected list of functions

This is a short version of the types of data and how to load it in Google Sheets. To see the full extensive version with videos and more examples, go to our documentation page.

Assuming you have authenticated, installed, and activated the addon properly following the install guide.

  • 1.Start typing the formula to use the one you need. =GORILLA_ …
    • It will load the formula box to guide you build the formula
asinlist new fulfillment filter
  • 2.The formula box will highlight in green the filter or attribute you are currently entering.
    • In this example, the “marketplace” filter is bolded meaning that whatever you enter will be used to filter the Marketplace. Type in the marketplace like “EU” to get data for all EU countries EXCEPT UK.
  • 3.Type a comma or semi colon (for EU users) based on your language settings.
    • This will tell the formula to move on to the next filter.
  • 4. Not all inputs are required. Only the “required” filters must be entered.
    • “Optional” filters are used to narrow down the data instead of a broad total number.
    • You can skip the optional filters by typing a comma or semicolon to move to the next filter.
    • =GORILLA_ASINLIST( , , , “FBA”)
  • 5. Multi-Seller Agency plan users MUST enter the seller ID at the start of all formulas as all the seller accounts are separated.
Examples

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.

=GORILLA_ASINLIST()
If no attributes are entered, it will list all your current active and inactive ASIN from all marketplaces.


=GORILLA_ASINLIST( , , , "FBA")
This will list only the FBA ASINs for the default marketplace for your account as the other attributes are empty.


=GORILLA_ASINLIST( , , "INCLUDE")
This will list the entire list of ASINs in your account including all the deleted, inactive, closed, suppressed products. If no inputs are entered like GORILLA_ASINLIST(), the default value is "EXCLUDE". 


=GORILLA_ASINLIST("ALL", "B43")
Lists all ASINs from all marketplaces where the ASIN starts with "B43".


=GORILLA_ASINLIST("US" , , "INCLUDE", "FBM")
This will list all FBM ASINs for the US marketplace only. Will also show closed, inactive, deleted, suppressed ASINs. 
 

For Gorilla Multi Seller (Agency) plans, the formulas will start with the seller ID or nickname:

=GORILLA_ASINLIST("SELLER ID")

=GORILLA_ASINLIST("TOY STORE", , , "INCLUDE", "FBM") 

=GORILLA_ASINLIST("BLADERUNNER", "ALL", "B43")

=GORILLA_ASINLIST("A739JJDNJEG", "US" , , "INCLUDE", "FBA")

GORILLA_ASINLIST( ) Function

  • asinlist function box 2104 Gorilla ROI

Description:

Return a list of active and inactive ASINs from your marketplace(s).

Syntax:

GORILLA_ASINLIST([marketplace], [filter_sku], [status], [fulfillment], [sort])

for Multi Seller (Agency) users
GORILLA_ASINLIST(sellerID, [marketplace], [filter_sku], [status], [fulfillment], [sort])
  • marketplace – OPTIONAL
    • Marketplace filter. Use “ALL” for all marketplaces. If empty, it loads for the default marketplace. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.
  • filter_asin – OPTIONAL
    • Part of an ASIN to filter result. The filter will act only on the start of the ASIN like ASINPART*.
  • status – OPTIONAL
    • Valid values are ALL, ACTIVE, INACTIVE.
    • “ALL” lists both active and inactive SKUs
    • “ACTIVE” lists active SKUs only.
    • “INACTIVE” lists inactive only.
    • Default if empty is “ALL”
  • fulfillment – OPTIONAL
    • Default if empty is “ALL” to show FBA and FBM ASINs.
    • “FBA” will only display FBA ASINs. FBM will only display FBM ASINs.
  • sort – OPTIONAL
    • Default if left empty is “date_asc”.
    • “date_asc” lists ASINs in ascending order by created date.
    • “date_desc” lists ASINs in descending order by created date.
    • “asin_asc” lists ASINs in ascending alphabetical order.
    • “asin_desc” lists ASINs in descending alphabetical order.
Examples

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.

=GORILLA_ASINLIST()
If no attributes are entered, it will list all your current active and inactive ASIN from all marketplaces.


=GORILLA_ASINLIST( , , , "FBA")
This will list only the FBA ASINs for the default marketplace for your account as the other attributes are empty.


=GORILLA_ASINLIST( , , "INCLUDE")
This will list the entire list of ASINs in your account including all the deleted, inactive, closed, suppressed products. If no inputs are entered like GORILLA_ASINLIST(), the default value is "EXCLUDE". 


=GORILLA_ASINLIST("ALL", "B43")
Lists all ASINs from all marketplaces where the ASIN starts with "B43".


=GORILLA_ASINLIST("US" , , "INCLUDE", "FBM")
This will list all FBM ASINs for the US marketplace only. Will also show closed, inactive, deleted, suppressed ASINs. 
 

For Gorilla Multi Seller (Agency) plans, the formulas will start with the seller ID or nickname:

=GORILLA_ASINLIST("SELLER ID")

=GORILLA_ASINLIST("TOY STORE", , , "INCLUDE", "FBM") 

=GORILLA_ASINLIST("BLADERUNNER", "ALL", "B43")

=GORILLA_ASINLIST("A739JJDNJEG", "US" , , "INCLUDE", "FBA")

GORILLA_ASINSTATUS( ) Function

  • Find the status of your ASIN. Returns "active" or "inactive".
    Find the status of your ASIN. Returns “active” or “inactive”.

Description:

Returns the status of the ASIN whether it is active or inactive.

Syntax:

GORILLA_ASINSTATUS([marketplace], ASIN/SKU)

for Multi Seller (Agency) users
GORILLA_ASINLIST(sellerID, [marketplace], ASIN/SKU)
  • marketplace – OPTIONAL
    • Marketplace filter. Use “ALL” for all marketplaces. If empty, it loads for the default marketplace. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.
  • ASIN/SKU – REQUIRED
    • The ASINs or SKUs to get the status of.
Examples

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.

=GORILLA_ASINSTATUS("US", A2:B100)
This will return “active” or “inactive” for all the ASINs or SKUs listed from A2 to B100 for the US marketplace. The function supports 2D arrays such as a set of values in column A and column B.


=GORILLA_ASINSTATUS( , A1:A1000)
If the marketplace is left out, it will get the listing status of the ASIN/SKUs from the default marketplace associated with your account. Use ranges in your formula to get the results in bulk.  
 

For Gorilla Multi Seller (Agency) plans, the formulas will start with the seller ID or nickname:

=GORILLA_ASINSTATUS("TOY STORY", "US", A2:B100)

=GORILLA_ASINSTATUS("SELLER ID", A1:A1000)

GORILLA_BUYBOXOFFERS( ) Function

  • buyboxoffers 1 Gorilla ROI

Description:

Get the list of all sellers and offerings on the listing and competing for the buy box. Does not pull information for SKU’s that you do not sell. Only works for SKUs and ASINs in your inventory.

Syntax:

GORILLA_BUYBOXOFFERS(sku, [marketplace], [header])

for Multi Seller (Agency) users
GORILLA_BUYBOXOFFERS(sellerID, sku, [marketplace], [header])
  • SKU (or ASIN) – REQUIRED
    • SKU or ASIN of the product. Unlike other functions, this one does NOT accept array inputs or ranges like {“SKU12345″,”ASIN12345”} or A1:A100.
  • marketplace – OPTIONAL
    • Marketplace filter. Use “ALL” for all marketplaces. If empty, it loads for the default marketplace. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.
  • header – OPTIONAL
    • Display header in the table of results
    • “TRUE” auto creates a header as the first row of results. Selected by default if no values are entered.
    • “FALSE” only shows the table of data. No headings or titles.
Examples

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.

=GORILLA_BUYBOXOFFERS("B00YD545CC", "US", "TRUE")
Returns all sellers for the listing in the US market along with details of the buy box. A header row is automatically generated.


=GORILLA_BUYBOXOFFERS("B00YD545CC", "DE", "FALSE")
Returns all sellers for the listing in the German market along with details of the buy box. A header row is not present. Only the data is displayed.

 
=GORILLA_BUYBOXOFFERS("B00YD545CC")
If only the SKU is entered, it will display data for all sellers in the default marketplace and include the header in the table. 


For Gorilla Multi Seller (Agency) plans, the formulas will start with the seller ID or nickname:

=GORILLA_BUYBOXOFFERS("SPEEDO STORE", "B00YD545CC", "US", "TRUE")

=GORILLA_BUYBOXOFFERS("SELLERID837834", "B00YD545CC", "US", "FALSE")

=GORILLA_BUYBOXOFFERS("COFFEE SELLER", "B00YD545CC")

GORILLA_BUYBOXPRICE( ) Function

  • Get amazon buy box price

Description:

Get the current buy box price of the seller winning the buy box.

Syntax:

GORILLA_BUYBOXPRICE(sku, [marketplace], [condition], [returnStyle], [priceType])

for Multi Seller (Agency) users
GORILLA_BUYBOXPRICE(seller ID, sku, [marketplace], [condition], [returnStyle], [priceType])
  • SKU (or ASIN) – REQUIRED
    • SKU or ASIN of the product. Use arrays and ranges like A1:A1000 to bulk load data. See examples below. If a range of SKU is used in the formula, it will display the buy box price only.
  • marketplace – OPTIONAL
    • Marketplace filter. Use “ALL” for all marketplaces. If empty, it loads for the default marketplace. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.
  • condition – OPTIONAL
    • Filter for new or used conditions
    • “NEW” only displays the prices for products that are being sold in NEW condition.
    • “USED” only displays the prices for products that are being sold as USED condition.
  • returnStyle – OPTIONAL
    • Displays the results in a table or as a list of prices.
    • Default results show the price for the lowest price for each SKU/ASIN provided.
    • “FULL” loads all buy box data like price, fulfillment channel, offer count, listing price, suggested price, landed price.
    • “FULLWITHHEADER” shows the “full” data with a header row as the first row.
  • priceType – OPTIONAL
    • Displays the results as either the following:
    • “LandedPrice” – Displays the results based on the LandedPrice of the SKU that is entered in Seller Central
    • “ListingPrice” – Displays the results based on the ListingPrice of the SKU that is entered in Seller Central
    • “ShippingPrice” – Displays the results based on the ShippingPrice of the SKU that is entered in Seller Central
Examples

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.

=GORILLA_BUYBOXPRICE(A1:A1000, "US", "ANY", "PRICE")
Returns the lowest offered buy box prices only for all SKU’s in A1:A1000. Pulls from the US marketing for any condition.


=GORILLA_BUYBOXPRICE("B00YD545CC", "DEFAULT", "NEW", "FULL")
Returns the buy box price for the ASIN in the default marketplace. Looking up NEW condition products only. Full results are displayed with no header in the table of results.

 
=GORILLA_BUYBOXPRICE("B00YD545CC")
If only the SKU is entered, it will display the price of the buy box only.


For Gorilla Multi Seller (Agency) plans, the formulas will start with the seller ID or nickname:

=GORILLA_BUYBOXPRICE("NIKE FACTORY", A1:A1000, "US", "ANY", "PRICE")

=GORILLA_BUYBOXPRICE("SELLERID837834", "B00YD545CC", "DEFAULT", "NEW", "FULL")

=GORILLA_BUYBOXPRICE("ADIDAS DIRECT", "B00YD545CC")

GORILLA_FEESESTIMATE( ) Function

  • gorilla feesestimate

Description:

Get the estimated fees associated with the product. (Not the actual settlement product fees and charges to your accounts).

Syntax:

GORILLA_FEESESTIMATE(sku, [marketplace], [returnStyle], [fulfillment])

for Multi Seller (Agency) users
GORILLA_FEESESTIMATE(sellerID, sku, [marketplace], [returnStyle], [fulfillment])
  • SKU (or ASIN) – REQUIRED
    • SKU or ASIN of the product. Use arrays and ranges like A1:A1000 to bulk load data. See examples below.
  • marketplace – OPTIONAL
    • Marketplace filter. Use “ALL” for all marketplaces. If empty, it loads for the default marketplace. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.
  • returnStyle – OPTIONAL
    • “Full” – displays full information of each seller offering the product without header information.
    • “Fullwithheader” – autocreates a header row and displays full information of each seller offering the product.
    • “FBAFees” – Amazon’s FBA fee for your item
    • “PerItemFee” – the per item fee Amazon charges for your product
    • “ReferralFee” – the referral fee amount based on the category of your product
    • “VariableClosingFee” – the variable closing fee
  • fulfillment – OPTIONAL
    • “ALL” – lists the default SKU fees for either FBA or FBM (default)
    • “FBA” – lists the FBA fees for the SKU
    • “FBM” – lists the FBM fees for the SKU

For a deeper understanding of all fees, please refer to the Ultimate Amazon Seller Fees Guide.

Examples

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.

=GORILLA_FEESESTIMATE(D2)
Uses the ASIN or SKU entered in cell D2 and shows the total estimate fee (Fulfillment fee + referral fee) for the SKU. If Amazon does not have the price information, no estimate will be provided. 


=GORILLA_FEESESTIMATE(A2:C10)
Supports 2 dimensional ranges. Also works horizontally. Bulk return an array of values by assigning the range of the SKU. In this example the SKU or ASIN is listed in A2:C10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37. 


=GORILLA_FEESESTIMATE("738-JDUY-32F", "default", "fullwithheader")
Entering all the attributes will display the full breakdown of the fee estimate for the product."Default" refers to your main marketplace. "Fullwithheader" creates another row before the results with the table headers to make it easy to identify.
 

=GORILLA_FEESESTIMATE("738-JDUY-32F", "US", "FBAFees", "FBA")
This example will pull in the FBA fees for your product as a single value for the SKU in the US market. It will pull the fees for the FBA version of the product.


For Gorilla Multi Seller (Agency) plans, the formulas will start with the seller ID or nickname:

=GORILLA_FEESESTIMATE("CAR KEY SELLER", D2)


=GORILLA_FEESESTIMATE("HATS GALORE", A2:C10)

=GORILLA_FEESESTIMATE("CHAIRS DOMAIN", "738-JDUY-32F", "default", "fullwithheader")

=GORILLA_FEESESTIMATE("SELLERID832", "738-JDUY-32F", "US", "FBAFees", "FBA")

GORILLA_INVENTORY( ) Function

  • amazon inventory all report status
    amazon inventory all report status

Description:

Get inventory movement status of a product such as how many are in stock, transfer, or inbound.

Syntax:

GORILLA_INVENTORY(sku, [marketplace], [status])

for Multi Seller (Agency) users
GORILLA_INVENTORY(sellerID, sku, [marketplace], [status])
  • SKU (or ASIN) – REQUIRED
    • SKU or ASIN of the product. Use arrays and ranges like A1:A1000 to bulk load data. See examples below.
  • marketplace – OPTIONAL
    • Marketplace filter. Use “ALL” for all marketplaces. If empty, it loads for the default marketplace. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.
  • status – OPTIONAL
    • Supply status. Valid values are:
    • “Total”​ (or ALL) = fulfillable + inbound_working + inbound_shipped + inbound_receiving +reserved_transfer​
    • “Warehouse”
    • “Fulfillable” (or instock)
    • “Local_Stock”​ (only available for EU marketplaces)
    • “Unsellable”
    • “R​reserved” = reserved_orders + reserved_transfer + reserved_processing
    • “​​Inbound_working​”
    • “Inbound_shipped” (or “inbound”)
    • “​Inbound_receiving​​”
    • “Researching​​”
    • “Reserved_orders​”
    • “Reserved_transfer​” (or “transfer”)
    • “​Reserved_processing”

Refer to the seller central page for more details on the manage FBA inventory report.

Examples

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.

=GORILLA_INVENTORY(D2, "ALL", "warehouse")
Uses the ASIN or SKU entered in cell D2 and shows the total number of units that are currently in the Amazon warehouse.


=GORILLA_INVENTORY("B00YD545CC", "UK", "transfer")
Gets the total number of units for ASIN B00YD545CC that are in transfer status for Italy marketplace.


=GORILLA_INVENTORY(A2:A10, "ALL", "inbound")
Supports 2 dimensional ranges. Bulk return an array of values by assigning the range of the SKU. In this example the SKU or ASIN is listed in A2:A10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37. 

=GORILLA_INVENTORY(ASIN123123,"DE","fulfillable")

=GORILLA_INVENTORY(ASIN321321,"DE","inbound")

=GORILLA_INVENTORY(ASIN567856,"DE","researching")


For Gorilla Multi Seller (Agency) plans, the formulas will start with the seller ID or nickname:

=GORILLA_INVENTORY("SELLER63DJ3", D2, "ALL", "instock") 

=GORILLA_INVENTORY("SELLER63DJ3", "B00YD545CC", "UK", "transfer")

=GORILLA_INVENTORY("SELLER63DJ3", A2:A10, "ALL", "inbound")

GORILLA_PROFITLOSS( ) Function

  • Gorilla profitloss function

Description:

Gets the financial data to build a profit and loss statement for your Amazon FBA account or by SKU/ASIN. Automatically generate a pre-built table, or pull detailed profit and expense line items to build your own statements.

Syntax:

GORILLA_PROFITLOSS(period, [marketplace], [sku], [category], [details])

for Multi Seller (Agency) users
GORILLA_PROFITLOSS(sellerID, period, [marketplace], [sku], [category], [details])
  • period – REQUIRED
    • Predefined periods and any custom dates. See full list of predefined periods below.
  • Custom
  • Today
  • Yesterday
  • Same day last week
  • Same day last month
  • Same day last year
  • Last 7 Days
  • Last 14 Days
  • Last 30 Days
  • This Week
  • This Month
  • This Quarter
  • This Year
  • This Year-to-Last-Month
  • Last Week
  • Last Month
  • Last Quarter
  • Last Year
  • Last 60 Days
  • YYYY
  • Last 12 Months
  • Last 7 Days Week Ago
  • Last 7 Days Year Ago
  • Last 30 Days Month Ago
  • Last 30 Days Year Ago
  • Last Week Year Ago
  • Last Month Year Ago
  • YYYY-MM
  • YYYYQ1… YYYYQ4
  • marketplace – OPTIONAL
    • Marketplace filter. Use “ALL” for all marketplaces. If empty, it loads for the default marketplace. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.
  • SKU (or ASIN) – REQUIRED
    • SKU or ASIN of the product. Only accepts ONE SKU or ASIN input. Does not work with multiple SKUs or ranges like other formulas.
  • category – OPTIONAL
    • Specify the line item to get the total value for that single category
    • “Sales”
    • “Discounts/Promotions”
    • “Amazon Reimbursements”
    • “Shipping Income”
    • “Income-Other”
    • “Amazon Lending”
    • “COGS”
    • “Amazon Fees”
    • “Advertising”
    • “Tax”
  • details – OPTIONAL
    • Defaults to “NO”
    • “Yes” = Will list all the transactions associated with the category
    • “No” = Will only show the total value of the category
Examples

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.

=GORILLA_PROFITLOSS("2020")
Will automatically generate a condensed and summarized profit and loss table in the form of: 

Sales – $xxx
Discounts/Promotions – $xxx
Amazon Reimbursements – $xxx
Shipping Income – $xxx
Income-Other – $xxx
Amazon Lending – $xxx
COGS – $xxx
Amazon Fees – $xxx
AdvertisingTax – $xxx 
 

=GORILLA_PROFITLOSS("THIS YEAR", "US")
Will generate a table like the example above for the US marketplace profit and loss only. 


=GORILLA_PROFITLOSS(A2,B2,"MYSKU")
Using cells A1 and B2 to point to the period and the marketplace. Creates the P&L based on the SKU "mysku". When a SKU is entered, not all transactions are available like storage costs as it is applied to your account and not the SKU. 


=GORILLA_PROFITLOSS("THIS YEAR", "US", , "Income-Other")
Returns the total value only for the line item "Income-Other". You can specify a category to get single values rather than generate the full table each time.


=GORILLA_PROFITLOSS("LAST 30 DAYS", "FR", ,"Amazon fees", "YES")
List all the transactions that make up the category you specify. In this example, it will list all the expenses that are rolled up inside "Amazon Fees".

To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period.

2020Q1, 2019Q4 etc 

To get monthly data, use the format YYYY-MM as the preset period. 2020-04, 2021-07 etc


For Gorilla Multi Seller (Agency) plans, the formulas will start with the seller ID or nickname:

=GORILLA_PROFITLOSS("MY STORE", "2020") 

=GORILLA_PROFITLOSS("BEAUTY STORE", "THIS YEAR", "US")

=GORILLA_PROFITLOSS("A73984JDUYL", A2,B2,"MYSKU")

=GORILLA_PROFITLOSS(sellerID, "THIS YEAR", "US", , "Income-Other")

=GORILLA_PROFITLOSS("WALMART", "LAST 30 DAYS", "FR", ,"Amazon fees", "YES")

GORILLA_PROFITLOSS( ) Function

  • Gorilla profitloss function

Description:

Gets the financial data to build a profit and loss statement for your Amazon FBA account or by SKU/ASIN. Automatically generate a pre-built table, or pull detailed profit and expense line items to build your own statements.

Syntax:

GORILLA_PROFITLOSS(period, [marketplace], [sku], [category], [details])

for Multi Seller (Agency) users
GORILLA_PROFITLOSS(sellerID, period, [marketplace], [sku], [category], [details])
  • period – REQUIRED
    • Predefined periods and any custom dates. See full list of predefined periods below.
  • Custom
  • Today
  • Yesterday
  • Same day last week
  • Same day last month
  • Same day last year
  • Last 7 Days
  • Last 14 Days
  • Last 30 Days
  • This Week
  • This Month
  • This Quarter
  • This Year
  • This Year-to-Last-Month
  • Last Week
  • Last Month
  • Last Quarter
  • Last Year
  • Last 60 Days
  • YYYY
  • Last 12 Months
  • Last 7 Days Week Ago
  • Last 7 Days Year Ago
  • Last 30 Days Month Ago
  • Last 30 Days Year Ago
  • Last Week Year Ago
  • Last Month Year Ago
  • YYYY-MM
  • YYYYQ1… YYYYQ4
  • marketplace – OPTIONAL
    • Marketplace filter. Use “ALL” for all marketplaces. If empty, it loads for the default marketplace. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.
  • SKU (or ASIN) – REQUIRED
    • SKU or ASIN of the product. Only accepts ONE SKU or ASIN input. Does not work with multiple SKUs or ranges like other formulas.
  • category – OPTIONAL
    • Specify the line item to get the total value for that single category
    • “Sales”
    • “Discounts/Promotions”
    • “Amazon Reimbursements”
    • “Shipping Income”
    • “Income-Other”
    • “Amazon Lending”
    • “COGS”
    • “Amazon Fees”
    • “Advertising”
    • “Tax”
  • details – OPTIONAL
    • Defaults to “NO”
    • “Yes” = Will list all the transactions associated with the category
    • “No” = Will only show the total value of the category
Examples

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.

=GORILLA_PROFITLOSS("2020")
Will automatically generate a condensed and summarized profit and loss table in the form of: 

Sales – $xxx
Discounts/Promotions – $xxx
Amazon Reimbursements – $xxx
Shipping Income – $xxx
Income-Other – $xxx
Amazon Lending – $xxx
COGS – $xxx
Amazon Fees – $xxx
AdvertisingTax – $xxx 
 

=GORILLA_PROFITLOSS("THIS YEAR", "US")
Will generate a table like the example above for the US marketplace profit and loss only. 


=GORILLA_PROFITLOSS(A2,B2,"MYSKU")
Using cells A1 and B2 to point to the period and the marketplace. Creates the P&L based on the SKU "mysku". When a SKU is entered, not all transactions are available like storage costs as it is applied to your account and not the SKU. 


=GORILLA_PROFITLOSS("THIS YEAR", "US", , "Income-Other")
Returns the total value only for the line item "Income-Other". You can specify a category to get single values rather than generate the full table each time.


=GORILLA_PROFITLOSS("LAST 30 DAYS", "FR", ,"Amazon fees", "YES")
List all the transactions that make up the category you specify. In this example, it will list all the expenses that are rolled up inside "Amazon Fees".

To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period.

2020Q1, 2019Q4 etc 

To get monthly data, use the format YYYY-MM as the preset period. 2020-04, 2021-07 etc


For Gorilla Multi Seller (Agency) plans, the formulas will start with the seller ID or nickname:

=GORILLA_PROFITLOSS("MY STORE", "2020") 

=GORILLA_PROFITLOSS("BEAUTY STORE", "THIS YEAR", "US")

=GORILLA_PROFITLOSS("A73984JDUYL", A2,B2,"MYSKU")

=GORILLA_PROFITLOSS(sellerID, "THIS YEAR", "US", , "Income-Other")

=GORILLA_PROFITLOSS("WALMART", "LAST 30 DAYS", "FR", ,"Amazon fees", "YES")

GORILLA_RANKING( ) Function

  • gorilla ranking 2 Gorilla ROI

Description:

Get Best Sellers Rank (BSR) for the broadest top-level category or deepest child category. Only works for single marketplaces at a time.

Syntax:

GORILLA_RANKING(sku, [marketplace], [queryType], [returnStyle])

for Multi Seller (Agency) users
GORILLA_RANKING(sellerID, sku, [marketplace], [queryType], [returnStyle])
  • SKU (or ASIN) – REQUIRED
    • SKU or ASIN of the product. Use arrays and ranges like A1:A1000 to bulk load data. See examples below.
  • marketplace – OPTIONAL
    • Marketplace filter. Use “ALL” for all marketplaces. If empty, it loads for the default marketplace. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.
  • queryType – OPTIONAL
    • Defaults to “top” if empty.
    • “TOP” = Top Level category.
    • “ALL” = All categories (only 1 SKU/ASIN allowed).
    • “CHILD” = Child category.
  • returnStyle – OPTIONAL
    • Return style (defaults to “rank”):
    • “rank” = Rank Only.
    • “r_cat” = Rank + Category (accepts array input).
    • “r_full” = Rank + Full Category Path (accepts array input).
Examples

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.

=GORILLA_RANKING("B00YD545CC", "US", "top", "r_cat")
Returns BSR of the top category as well as the category name for unit B00YD545CC for the US marketplace.


=GORILLA_RANKING("A2:A10", , "top", "rank")
Supports array inputs. Bulk return an array of values by assigning the range of the SKU or ASIN. In this example the SKU or ASIN is listed in A2:A10 and returns all values at once. Default marketplace is used as it is not set.


For Gorilla Multi Seller (Agency) plans, the formulas will start with the seller ID or nickname:

=GORILLA_RANKING("MICHAEL STORE", "B00YD545CC", "US", "top", "r_cat")


=GORILLA_RANKING("SELLERA73J42", "A2:A10", , "top", "r_full")

GORILLA_REIMBURSEDETAILS( ) Function

  • gorilla reimbursements details function
    gorilla reimbursements details function

Description:

Dump the reimbursement report showing all details of the reimbursement.

Syntax:

GORILLA_REIMBURSEDETAILS(period, [filter], [reason], [start_date], [end_date])

for Multi Seller (Agency) users
GORILLA_REIMBURSEDETAILS(sellerID, period, [filter], [reason], [start_date], [end_date])
  • period – REQUIRED
    • Predefined periods and any custom dates. See full list of predefined periods below.
  • Custom
  • Today
  • Yesterday
  • Same day last week
  • Same day last month
  • Same day last year
  • Last 7 Days
  • Last 14 Days
  • Last 30 Days
  • This Week
  • This Month
  • This Quarter
  • This Year
  • This Year-to-Last-Month
  • Last Week
  • Last Month
  • Last Quarter
  • Last Year
  • Last 60 Days
  • YYYY
  • Last 12 Months
  • Last 7 Days Week Ago
  • Last 7 Days Year Ago
  • Last 30 Days Month Ago
  • Last 30 Days Year Ago
  • Last Week Year Ago
  • Last Month Year Ago
  • YYYY-MM
  • YYYYQ1… YYYYQ4
  • filter – OPTIONAL
    • OPTIONAL – SKU, ASIN or FNSKU to filter the results. Can be a range of values like A1:A100 where A1 to A100 consists of values like SKU111, SKU222, SKU333 or ASIN123.
  • reason – OPTIONAL
    • Reason for adjustment. Valid values are:
    • “ALL” (default)
    • “CustomerReturn”
    • “Damaged_Warehouse”
    • “CustomerServiceIssue”
    • “Lost_Warehouse”
    • “Lost_Inbound”
    • “Reimbursement_Reversal”
    • “FeeCorrection”
    • “Lost_Outbound”
    • “ReturnAdjustment”
    • “Damaged_Inbound”
    • “Damaged_Outbound”
  • start_date – OPTIONAL
    • Starting date for when period is custom. To use custom dates, specify the period as “CUSTOM”.
  • end_date – OPTIONAL
    • Ending date for when period is custom. To use custom dates, specify the period as “CUSTOM”.
Examples

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.

=GORILLA_REIMBURSEDETAILS("LAST 7 DAYS")
Returns a details list of all reimbursed transactions and SKU over the last 7 days.  No SKUs are specified which will show all transactions across the entire account.


=GORILLA_REIMBURSEDETAILS("THIS YEAR", A2:A10)
Supports 2 dimensional ranges. Bulk return the reimbursement details of the SKUs listed in A2:A10. Other SKUs will not be loaded. 


=GORILLA_REIMBURSEDETAILS("CUSTOM", , "WAREHOUSE_DAMAGED", "2022-01-01", "2022-01-15")
Returns all warehouse damaged related reimbursements for all the SKUs in the account. Data is loaded for the custom date period.


=GORILLA_REIMBURSEDETAILS("2022", B7:B27, "LOST_INBOUND")
Returns data for Lost Inbound SKUs listed in B7:B27 for 2022.


For Gorilla Multi Seller (Agency) plans, the formulas will start with the seller ID or nickname:

=GORILLA_REIMBURSEDETAILS("MEGAMART", "LAST 7 DAYS")

=GORILLA_REIMBURSEDETAILS("ELECTRICMART", "THIS YEAR", A2:A10)

=GORILLA_REIMBURSEDETAILS("SELLERID38", "CUSTOM", , "WAREHOUSE_DAMAGED", "2022-01-01", "2022-01-15")

=GORILLA_REIMBURSEDETAILS("BESTBUY", "2022", B7:B27, "LOST_INBOUND")

GORILLA_REVIEW( ) Function

  • gorilla review Gorilla ROI

Description:

Get the full reviews and details of a product based on SKU or ASIN. Only works for single marketplaces at a time.

Syntax:

GORILLA_REVIEW(sku, [marketplace], [count])

for Multi Seller (Agency) users
GORILLA_REVIEW(sellerID, sku, [marketplace], [count])
  • SKU (or ASIN) – REQUIRED
    • SKU or ASIN of the product. Only one accepted.
  • marketplace – OPTIONAL
    • Marketplace filter. Use “ALL” for all marketplaces. If empty, it loads for the default marketplace. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.
  • count – OPTIONAL
    • Number of reviews to retrieve (default value is 5) or “ALL” to retrieve all reviews.
Examples

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.

=GORILLA_REVIEW("B00YD545CC", "US", 5)
Returns the latest 5 reviews, title, name, link and rating for ASIN B00YD545CC selling in the USA marketplace.


For Gorilla Multi Seller (Agency) plans, the formulas will start with the seller ID or nickname:

=GORILLA_REVIEW("SAMSUNG", "B00YD545CC", "US", 5)

=GORILLA_REVIEW("SELLER832", A2:A10, ,)

GORILLA_SALESCOUNT( ) Function

  • gorilla salescount 1 Gorilla ROI

Description:

Gets total number of units sold for a product between any time period. Only period is required. Other attributes are optional.

Syntax:

GORILLA_SALESCOUNT(period, [marketplace], [sku], [status], [mcf], [start_date], [end_date])

for Multi Seller (Agency) users
GORILLA_SALESCOUNT(sellerID, period, [marketplace], [sku], [status], [mcf], [start_date], [end_date])
  • period – REQUIRED
    • Predefined periods and any custom dates. See full list of predefined periods below.
  • Custom
  • Today
  • Yesterday
  • Same day last week
  • Same day last month
  • Same day last year
  • Last 7 Days
  • Last 14 Days
  • Last 30 Days
  • This Week
  • This Month
  • This Quarter
  • This Year
  • This Year-to-Last-Month
  • Last Week
  • Last Month
  • Last Quarter
  • Last Year
  • Last 60 Days
  • YYYY
  • Last 12 Months
  • Last 7 Days Week Ago
  • Last 7 Days Year Ago
  • Last 30 Days Month Ago
  • Last 30 Days Year Ago
  • Last Week Year Ago
  • Last Month Year Ago
  • YYYY-MM
  • YYYYQ1… YYYYQ4
  • marketplace – OPTIONAL
    • Marketplace filter. Use “ALL” for all marketplaces. If empty, it loads for the default marketplace. Other valid values are country codes US, IT, etc. or Amazon Marketplace ID like ATVPDKIKX0DER.
  • SKU (or ASIN) – OPTIONAL
    • SKU or ASIN of the product.
  • status – OPTIONAL
    • Order Status. Valid values are:
    • AllButCanceled(default)
    • All
    • PendingAvailability (JP only)
    • Pending
    • Unshipped
    • PartiallyShipped
    • Shipped
    • InvoiceUnconfirmed
    • Canceled
    • Unfulfillable
  • mcf – OPTIONAL
    • Whether to display, include or exclude MultiChannel Fulfillment orders.
    • “Exclude” (default option is not specified)
    • “Include”
    • “Only” (only displays data for MCF orders. Does not show data for FBA.)
  • start_date – OPTIONAL
    • Starting date for when period is custom. To use custom dates, specify the period as “CUSTOM”.
  • end_date – OPTIONAL
    • Ending date for when period is custom. To use custom dates, specify the period as “CUSTOM”.
Examples

Use closed ranges (e.g.A2:A100) in your formula wherever possible for quicker results and to prevent Google from blocking your account for 24 hrs due to overloading their resources.

=GORILLA_SALESCOUNT("Custom", "US", "B00YD545CC", "Shipped", "Exclude", "2018-01-01", "2018-01-21")
Gets total number of units sold for B00YD545CC that has been shipped in the US marketplace between Jan 1, 2018 and Jan 21, 2018. Excludes MCF orders.


=GORILLA_SALESCOUNT("This Week","ALL",A2:A10,"ALL")
Supports 2 dimensional ranges. Bulk return an array of values by assigning the range of the SKU or ASIN. In this example the SKU or ASIN is listed in A2:A10 and returns all values at once. Can also work for rows and ranges like A1:Z1 or D3:G37.


=GORILLA_SALESCOUNT("2019Q1", "US", "B00YD545CC", "All")

=GORILLA_SALESCOUNT("2019-05", "US", "B00YD545CC", "All")
To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period. 
To get monthly data, use the format YYYY-MM as the preset period.


=GORILLA_SALESCOUNT("This Month", "ALL", "IPHN3724", "Canceled")
Gets the total number of units for SKU IPHN3724 from all marketplaces that were canceled this month.


=GORILLA_SALESCOUNT("Same Day Last Month", "ALL", "IPHN3724", "ALL")
Gets the total number of units for SKU IPHN3724 from all marketplaces that are sold and pending.


=GORILLA_SALESCOUNT("This Year")
Gets the total number of units sold for all products, account across all marketplaces.


=GORILLA_SALESCOUNT("2019Q1", "US", "B00YD545CC", "All")

=GORILLA_SALESCOUNT("2019-05", "US", "B00YD545CC", "All")
To get quarterly data use the format YYYYQ1, YYYYQ2, YYYYQ3, YYYYQ4 as the preset period.
To get monthly data, use the format YYYY-MM as the preset period.


For Gorilla Multi Seller (Agency) plans, the formulas will start with the seller ID or nickname:

=GORILLA_SALESCOUNT("TOYSRUS", "Custom", "US", "B00YD545CC", "Include", "Shipped", "2018-01-01", "2018-01-21")

=GORILLA_SALESCOUNT("BABYSRUS", "This Week","ALL",A2:A10,"ALL")

=GORILLA_SALESCOUNT("CORNER GROCERY", "2019Q1", "US", "B00YD545CC", "All")

=GORILLA_SALESCOUNT("SELLER37432", "2019-05", "US", "B00YD545CC", "All") 

=GORILLA_SALESCOUNT("SELLER37432", "This Month", "ALL", "IPHN3724", "Canceled")

=GORILLA_SALESCOUNT("SELLER37432", "Same Day Last Month", "ALL", "IPHN3724", "ALL")

=GORILLA_SALESCOUNT("SELLER37432", "This Year")

=GORILLA_SALESCOUNT("SELLER37432", "2019Q1", "US", "B00YD545CC", "All")

=GORILLA_SALESCOUNT("SELLER37432", "2019-05", "US", "B00YD545CC", "All")
See all functions, examples, videos

How Gorilla ROI Works

1
Connect your Amazon account with Gorilla ROI and start importing
2
Install the Google Sheets add-on to your account and activate
3
Load data inside Sheets with a formula like =GORILLA_ASINLIST()
GET DATA IN SHEETS TODAY