Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. GORILLA_LOWESTOFFER() – Get the lowest offered listing price from any seller

GORILLA_LOWESTOFFER() – Get the lowest offered listing price from any seller

Sample Usage

=GORILLA_LOWESTOFFER(D2)
=GORILLA_LOWESTOFFER(A2:C10)
=GORILLA_LOWESTOFFER

Syntax Description

Get the lowest offered listing price from any seller

GORILLA_LOWESTOFFER(sku,[marketplace], [returnStyle], [priceType])

Gorilla Agency, the syntax is

GORILLA_LOWESTOFFER(sellerID,sku,[marketplace], [returnStyle], [priceType])

Examples

=GORILLA_LOWESTOFFER(D2)

Uses the ASIN or SKU entered in cell D2 and shows the lowest price being offered for the SKU. The single lowest price is returned after comparing against all sellers.

=GORILLA_LOWESTOFFER(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_LOWESTOFFER

Entering all the attributes will display the full list of all offers on the listing. If there are multiple sellers for the SKU, this formula will create a row for each seller and display the full stats of each seller.

“Default” refers to your main marketplace. “Fullwithheader” creates another row before the results with the table headers to make it easy to identify.

For Gorilla Agency, the formulas will start with the seller ID:

=GORILLA_CATEGORY("SELLER ID", "B00YD545CC", "US", "all", "full")
=GORILLA_CATEGORY("SELLER ID", "B00YD545CC", "US", "all", "inner")
=GORILLA_CATEGORY("SELLER ID", "B00YD545CC", "US", "top", "full")

GORILLA_LOWESTOFFER Attributes

returnStyle Attributes:

  • Full – displays full information of each seller offering the product without header information
  • Fullwithheader – autocreates a header row and displays fulls information of each seller offering the product

priceType Attributes:

  • LandedPrice
  • ListingPrice
  • ShippingPrice
  • RegularPrice

 

What is Gorilla ROI?

Gorilla ROI automatically pulls Amazon data into Google sheets for you to make sense of the data without the inconvenience of manually downloading, sorting and updating spreadsheets.

Learn how you can centralize your data and use it to increase your ROI.

How can we help?