Executing Functions with the Asinzen Insight Google Sheets Add-on: A How-To Guide

Modified on Mon, 11 Nov at 6:01 AM

The Asinzen Insight Google Sheets Add-on is a powerful tool that allows you to perform various functions directly within your Google Sheets. This guide will walk you through two methods to execute functions using the add-on.

Method 1: Using Cell Functions

The first method involves writing functions directly into the cells of your Google Sheet. One of the functions you can use is GETMY_FBA_FEES, which calculates the FBA fees for a given marketplace, ASIN, and selling price.

Steps:

Open your Google Sheet where you have the Asinzen Insight add-on installed.
Enter the function in a cell using the following format: =GETMY_FBA_FEES(marketplace, asin, sell price)

Example:

=GETMY_FBA_FEES("US", "ABC01234567", 39.99)

Alternatively, you can reference cells that contain the ASIN and selling price: =GETMY_FBA_FEES("US", A2, B2). Here, A2 contains the ASIN and B2 contains the selling price.

Method 2: Using the Function Builder

The second method involves using the Function Builder, which provides a more interactive way to run functions.

Steps:

Open your Google Sheet and ensure the Asinzen Insight add-on is active.
Click on the Add-ons menu at the top of the Google Sheets interface.
Select Asinzen Insight from the dropdown menu.
Click on Functions to open the sidebar panel.
Search for the function you want to use (e.g., GETMY_FBA_FEES).
Select the range of cells that you want to apply the function to.
Click on the function name in the sidebar to execute it.

By following these steps, you can easily run functions using the Asinzen Insight Google Sheets Add-on, whether you prefer typing them directly into cells or using the interactive Function Builder.