Gorilla ROI Spreadsheet Formula Tour

In a couple of minutes, you’ll know how to use the formulas to get Amazon or ecom data into Google Sheets.

End of Tour

You can restart the tour or enter the list of formulas into the online demo to see it in action again.

The formulas and more examples will be displayed when you close this window.

Gorilla ROI

Gorilla ROI

Gorilla ROI

Gorilla ROI

  • Products
  • Why us?
  • Templates
  • Pricing
  • Reviews
Docs
Sign in
Start Today

Formula Examples to Try

First, load the ASINs
Make sure the ASIN list is showing before applying any other formula.
=GORILLA_ASINLIST("TESTSELLER2")
Get the Title of the products from B6:B20 =GORILLA_PRODUCT(B1, B6:B20, "TITLE")
Show the inbound units for the ASIN shown in B20
=GORILLA_INVENTORY("TESTSELLER2", B20, "ALL", "INBOUND")
Get last 30 days units sold for each ASIN =GORILLA_SALESCOUNT(B1, "Last 30 days", "US", B6:B20)
Get units sold for all ASINs. Exclude MCF units. Between Jan 1 and Jan 21. =GORILLA_SALESCOUNT("TESTSELLER2", "Custom", "US", B6:B20, "Shipped", "Exclude", "2024-01-01", "2024-01-21")
Convert ASIN to FNSKU =GORILLA_PRODIDCONV(B1, B6:B20, "ASIN2FNSKU")