Google Sheets Functions

  1. Home
  2. Docs
  3. Google Sheets Functions
  4. Marketplace and Country Codes

Marketplace and Country Codes

We support all global Amazon seller marketplaces.

For each formula, you can define the marketplace you want to pull the data for.

  • ALL – Default option if you don’t specify in the formula.
  • 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
  • AE – Arab Emirates
  • JP – Japan
  • AU – Australia
  • SG – Singapore
  • IN – India

Special Country Codes

We have 2 special country codes that is not part of Amazon.

  • EURO
  • EU

EURO: combines all data for countries where the EURO currency is used. DE, FR, IT, ES, NL.

Countries like UK, SE, TR are not included as they may be part of “Europe” but they do not use EURO.

This is to make it easy to find the total value of the EURO sales.

EU: combines data for all European countries regardless of currency. UK, DE, FR, IT, ES, NL, SE, TR

UK is still included as we did not split it yet after brexit.

Sample Usage

In the formula syntax, it will say [marketplace].

Anything inside square brackets are optional. It can be left empty to use the default settings.

GORILLA_BUYBOXWINNER(sku, [marketplace])

GORILLA_BUYBOXWINNER(“BANANA332”)

This will load the data for the sku BANANA332 in the default seller marketplace. If the seller is US based, it will auto default to US. If the seller main marketplace is FR, it will auto default to France.

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

GORILLA_SALESTOTAL(“this year”, “EURO”)

This will load the total sales for this year for the countries that use the EURO currency.

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?