Introducing AMZFunctions!


AMZFunctions are custom functions that you can use to easily retrieve ASIN data from Amazon such as product title, dimensions, weight, and image/product-page URL.


Enable AMZFunctions

1. Open any Google sheet and go to Add-ons > Amzpecty for Sheets > AMZFunctions > Use in this spreadsheet


How to Use

Input function. E.g. =AMZTITLE(A2) then press Enter.


Result


AMZFunctions Reference


1. Function to get the ASIN product title.

=AMZTITLE([ASIN], [DOMAIN])


2. Function to get the ASIN product page URL.

=AMZLINK([ASIN], [DOMAIN])


3. Function to get the ASIN image URL.

=AMZIMAGEURL([ASIN], [DOMAIN])


4. Function to get the ASIN product dimension.

=AMZDIMENSION([ASIN], [DOMAIN], [DIM])


5. Function to get the ASIN product weight.

=AMZWEIGHT([ASIN], [DOMAIN], [NOUNIT])


Function Parameters Guide:

[ASIN]
(required) the ASIN value or cell.
[DOMAIN]
(optional) the Amazon Marketplace domain value or cell. If unspecified, default is 'AMAZON.COM'.
Valid values are:
'AMAZON.COM'
'AMAZON.CO.UK'
'AMAZON.CO.JP'
'AMAZON.CA'
'AMAZON.IN'
'AMAZON.DE'
'AMAZON.FR'
'AMAZON.IT'
'AMAZON.ES'
'AMAZON.COM.AU'
'AMAZON.COM.BR'
'AMAZON.COM.MX'
[DIM]
(optional) the specific dimension to get in numeric value, without the unit. Valid values are 'LENGTH', 'WIDTH', and 'HEIGHT'.
[NOUNIT]
(optional) if 'TRUE', will only display the weight numeric value, without the unit.


Limitations: 

Up to 100 ASINs per day only. 

Max 30 seconds per execution of function.