Skip to main content

How to Set Up Export to Google Sheets

Learn how to set up Export to Google Sheets in Seller Assistant

Setting up export to Google Sheets

Step 1. Before you set up your export, you need to connect Google Sheets to your Seller Assistant account.
​

Step 2. Go to "Integrations" section and choose "Google Sheets".

Step 3. Click on the desired Google Sheet from the list to open the settings page.


​Step 4. Drag the desired variables right into the table cells.
​

Note

You can choose from 140 available variables for export. You can also use a filter to find specific variables.

Step 5. Once done, click the "Fill Titles" button to create the header in your sheet.
​

Step 6. Now your export to Google Sheets is configured.

You can always reconfigure the columns displayed in the table. For convenience, you can reset the values to the minimum set by clicking the "Reset to Default" button.

List of Variables

Product Info:

  • Parent ASIN

  • ASIN

  • Marketplace

  • Marketplace ID

  • Product Title

  • Brand

  • Model

  • Product Image

  • Product Image URL

  • Product URL

  • Package Quantity

  • Universal Product Code (UPC)

  • European Article Number (EAN)

  • Currency sign

  • Product Rating

  • Review Count

Custom Data:

  • Current Date

  • Cost of Goods

  • Cost of Goods incl. VAT

  • Quantity

  • Source Link

  • Notes

  • Tags

Sales Rank:

  • Category

  • TOP BSR

  • BSR

  • Average BSR (30d)

  • Average BSR (90d)

  • Average BSR (180d)

  • Sales Rank Drops from Keepa (30d)

  • Sales Rank Drops from Keepa (90d)

  • Sales Rank Drops from Keepa (180d)

Price:

  • Price

  • Currency Code

  • BuyBox Price

  • Price Dynamics, %

  • Average Price (30d)

  • Average Price (90d)

  • Average Price (180d)

  • Min FBA Price

  • Min FBM Price

Size:

  • Height, in

  • Width, in

  • Length, in

  • Weight, Lbs

  • Height, m

  • Width, m

  • Length, m

  • Weight, kg

  • Product Volume, cu ft

  • Product Volume, cu m

  • Size, in

  • Size, m

Offers:

  • Stock

  • Stock FBM Quantity

  • Stock FBA Quantity

  • Seller Name

  • FBA Offers Count

  • FBM Offers Count

  • Lowest FBA Offers

Flags & Alerts:

  • Size Type

  • Oversize Flag

  • Restricted Flag

  • Favorite Flag

  • Blacklisted Flag

  • HazMat Flag

  • Meltable Product Flag

  • Fragile Flag

  • Generic Brand

  • IP Complaints risk flag

  • Like

Logistics:

  • Third Party Logistics (FBA)

  • Third Party Logistics (FBM)

  • Inbound Shipping cost (per item + per lbs)

  • Inbound Shipping FBM cost (per item + per lbs)

  • Shipping costs/item, (FBA)

  • Shipping costs/item, (FBM)

  • Shipping costs/lbs, (FBA)

  • Shipping costs/lbs, (FBM)

  • Prepare/Labeling Cost, (FBA)

  • Prepare/Labeling Cost, (FBM)

  • Fragile/Bubble Wrapping, (FBA)

  • Fragile/Bubble Wrapping, (FBM)

  • Prep Center Name

  • Oversize Fee (FBA)

  • Oversize Fee (FBM)

  • HazMat Fee (FBA)

  • HazMat Fee (FBM)

  • Misc Fee Rate

  • Misc Fee Fixed

  • Misc Fee

Fees:

  • Referral Fee

  • TOTAL Fees, (FBA)

  • TOTAL Fees, (FBM)

  • FBA Fee

  • Inbound Placement Fee

  • Small & Light FBA Fee

  • Referral Fee Mod

  • Storage Fee

  • Variable closing Fee

  • Digital Service Fee FBA

  • Digital Service Fee FBM

  • Digital Service Fee incl. FBA Fee

Taxes:

  • Sales Tax

  • Sales Tax Rate

  • Sales Tax Flag

  • VAT on Fees Rate, %

  • VAT on Fees

ROI & Profit Margins:

  • Profit FBM

  • Profit FBA

  • Profit S&L FBA

  • ROI FBM

  • Break Even Price FBM

  • Break Even Profit FBM

  • ROI FBM 10% Price

  • ROI FBM 20% Price

  • ROI FBM 10% Profit

  • ROI FBM 20% Profit

  • ROI FBA

  • Break Even Price FBA

  • Break Even Profit FBA

  • ROI FBA 10% Price

  • ROI FBA 20% Price

  • ROI FBA 10% Profit

  • ROI FBA 20% Profit

  • Margin FBM, %

  • Margin FBA, %

Sales Estimates:

  • Total Product Sales Estimate, pcs/mo

  • Total Product Sales Estimate, $/mo

  • Your FBA Sales Estimate, pcs/mo

  • Your FBA Profit Estimate, $/mo

  • Your FBM Profit Estimate, $/mo

  • Monthly Sold

Supplier Offers:

  • Selected Supplier COG

  • Selected Supplier Name

  • Selected Supplier Product Link

  • Selected Supplier SKU

  • Selected Supplier Identifier

  • Default Supplier Offer

  • All Supplier Offers

Learn how to save data in Google sheets from extension.

Did this answer your question?

Related Articles