GORILLA_IMAGES() – Get image URLs of the product and listing

Sample Usage =GORILLA_IMAGES(“TOY STORE”, “IPHONE7382”, “US”, “PT01”, “MEDIUM”) =IMAGE(GORILLA_IMAGES(“TOY STORE”, “IPHONE7382”, “US”, , “MAIN”)) =GORILLA_IMAGES(“TOY STORE”, A10:A30, “US”, “PT08”, “MEDIUM”) Syntax Description Description: Get product and listing image URLs. Syntax: GORILLA_IMAGES(sellerId, sku, [marketplace], [variant], [size], [fulfillment]) Seller ID – REQUIREDEnter the Seller ID or Nickname you entered in your Gorilla account. SKU – REQUIREDSKU or ASIN…

GORILLA_FEESESTIMATE() – Get estimated fees for product

Sample Usage =GORILLA_FEESESTIMATE(“TOY STORE”, D2) =GORILLA_FEESESTIMATE(“TOY STORE”, A2:C10) =GORILLA_FEESESTIMATE(“TOY STORE”, “738-JDUY-32F”, “default”, “fullwithheader”) Syntax Description Description: Get the estimated fees associated with the product. (Not the actual settlement product fees and charges to your accounts). Syntax: GORILLA_FEESESTIMATE(Seller ID, sku, [marketplace], [returnStyle], [fulfillment]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your…

GORILLA_FEETOTAL() – Get financials breakdown of all fees related to sale of product

THIS FUNCTION IS NOW REPLACED WITH FINANCES() Sample Usage =GORILLA_FEETOTAL(“This Month”) or =GORILLA_FEETOTAL(“2019-04”) =GORILLA_FEETOTAL(“This Year”,“Default”, “shipment”) =GORILLA_FEETOTAL(“2019Q2”,“US”,“B038434K3”, “refund”) =GORILLA_FEETOTAL(“Last 30 Days”,“US”,“servicefee”) =GORILLA_FEETOTAL(“last year”,“US”,“other”) Sample Spreadsheet PREVIEW LINK: PREVIEW LINK HERE DOWNLOAD LINK: SPREADSHEET LINK HERE Syntax Description Description: Get the financials breakdown of all fees related to the sale of a product. Supports getting the…

GORILLA_COSTCURRENT() – Get the current or latest product costs for any date

Sample Usage =GORILLA_COSTCURRENT(“TOY STORE”) =GORILLA_COSTCURRENT(“TOY STORE”, “2023-01”) =GORILLA_COSTCURRENT(“TOY STORE”, , A1:A100) =GORILLA_COSTCURRENT(“TOY STORE”, , A1:A100, “VALUES”) Syntax Description Description: Pull your latest product costs into Google Sheets Syntax: GORILLA_COSTCURRENT(Seller ID, [period], [sku], [output], [marketplace], [count], [sort], [date]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. PERIOD – OPTIONALPredefined…

GORILLA_COSTDUMP() – Get the AVG, MIN, MAX, FIRST, LAST product costs for any period

Sample Usage =GORILLA_COSTDUMP(“TOY STORE”, “2023”) =GORILLA_COSTDUMP(“TOY STORE”, “2023”, A1:A100) =GORILLA_COSTDUMP(“TOY STORE”, “2023”, A1:A100, “AVG”) Example output screenshot Syntax Description Description: Get a dump of results as a changelog for the changes made to the product costs in Gorilla App Syntax: GORILLA_COSTDUMP(Seller ID, period, [sku], [aggregate], [marketplace], [count], [sort], [start_date], [end_date]) Seller ID – REQUIREDEnter the…

GORILLA_CHARGETOTAL() – Get financials breakdown of sales & charges related to sale of product

THIS FUNCTION IS NOW REPLACED WITH FINANCES() Sample Usage =GORILLA_CHARGETOTAL(“This Month”) or =GORILLA_CHARGETOTAL(“2019-04”) =GORILLA_CHARGETOTAL(“Last 30 Days”,“ALL”, ,“ShippingTax”, “shipment”) or =GORILLA_CHARGETOTAL(“Last 30 Days”,“ALL”, ,“ShippingTax”) =GORILLA_CHARGETOTAL(“This Year”,“default”, , , “shipment”) =GORILLA_CHARGETOTAL(“2019Q2”,“US”,“B038434K3”, , “refund”) =GORILLA_CHARGETOTAL(“Last 30 Days”,“ALL”, , , “ADJUSTMENT”) =GORILLA_CHARGETOTAL(“2109Q1”,“DE”, , , “OTHER”) Empty variables are accepted if you want to skip over the optional ones. =GORILLA_CHARGETOTAL(“2019Q1”,…

GORILLA_CATEGORY() – Get categories product is listed under

Sample Usage =GORILLA_CATEGORY(“TOY STORE”, “B00YD545CC”, “US”, “all”, “full”) =GORILLA_CATEGORY(“TOY STORE”, “B00YD545CC”, “US”, “all”, “inner”) =GORILLA_CATEGORY(“TOY STORE”, “B00YD545CC”, “US”, “top”, “full”) Syntax Description Description: Get the categories a product is listed under. Only works for single marketplaces at a time. Not “ALL”. Syntax: GORILLA_CATEGORY(Seller ID, sku, [marketplace], [queryType], [returnStyle]) Seller ID – REQUIREDEnter the seller ID…

GORILLA_BUYBOXSELLERS() – Show the number of sellers competing for buybox for a given product.

Sample Usage =GORILLA_BUYBOXSELLERS(“TOY STORE”, A1:A1000, “US”) =GORILLA_BUYBOXSELLERS(“TOY STORE”, “B00YD545CC”) =GORILLA_BUYBOXSELLERS(“TOY STORE”, A1:A1000, “FR”) Syntax description Description: Show the number of sellers competing for buybox for a given product. Syntax: GORILLA_BUYBOXSELLERS(Seller ID, sku, [marketplace]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. sku – REQUIREDSKU or ASIN of the…

GORILLA_BUYBOXWINNERFULL() – Show the Buy Box winner details for the selected products.

Sample Usage =GORILLA_BUYBOXWINNERFULL(“TOY STORE”, A1:A1000, “US”) =GORILLA_BUYBOXWINNERFULL(“TOY STORE”, “B00YD545CC”) =GORILLA_BUYBOXWINNERFULL(“TOY STORE”, A1:A1000) Syntax description Description: Show the Buy Box winner details for the selected products. Syntax: GORILLA_BUYBOXWINNER(Seller ID, sku, [marketplace], [header], [transpose]) Seller ID – REQUIREDEnter the seller ID or nickname you entered in your Gorilla account. sku – REQUIREDSKU or ASIN of the product….