Introduction

Welcome to SellerSheet! Thank you for choosing our platform to help manage your Amazon business. We're excited to have you on board!
As a SellerSheet user, you'll receive regular updates and dedicated support to help you succeed.

This documentation will guide you through setting up and using SellerSheet effectively. We've designed it to be comprehensive yet easy to follow. While no technical knowledge is required to use SellerSheet, familiarity with Amazon Seller Central and Google Sheets will help you get the most out of our platform. If you need to learn more about Google Sheets, you can find helpful resources at Google Docs Help and Google Workspace Learning Center.

Requirements

SellerSheet is a Google Sheets add-on that connects to Amazon via the SP-API and Ads API. Before it can function, users must:

  1. Sign up via Google on sellersheetai.com.
  2. Authorize access to their Amazon Seller and Ads(Optional) accounts.
  3. Install and use the add-on in Google Sheets.

Onboarding Guide

Follow these steps to get started with SellerSheet:

  1. Sign up on the SellerSheet website using your Google account
  2. Authorize SellerSheet to access your Amazon Seller account
  3. Install the SellerSheet add-on in Google Sheets
  4. Use the add-on to sync your Amazon data to Google Sheets

For detailed instructions on each step, please refer to the sections below.

Video Tutorial

Step 1: Sign Up on SellerSheet Website

  1. Go to https://sellersheetai.com.
  2. Click Login > Continue with Google — this is the only supported sign-up method. After signing up, you can click Continue with Email and receive OTP to login in the future.
    Login with Google button and user dashboard
  3. Make sure to use the same Google account for Google Sheets and SellerSheet.
  4. After signing in, you'll be redirected to your Dashboard: https://sellersheetai.com/dashboard

Step 2: Authorize Your Amazon Seller Account(s)

Important: To avoid account linkage issues, please complete the authorization in the usual IP/network environment of your Amazon seller account. You can login sellersheetai.com with email after first signup with Google if you have issue with login with google in your usual IP/network environment.

2.1 Authorize Store

  1. In the Dashboard, click Add Store.
    2. Add Store button
  2. Fill out:
    • Store Name(e.g.,MYSTORE)
    • Region (e.g., North America, Europe)
    • Select Marketplaces(e.g., US, UK)
    Store information form
  3. Click Authorize Store. This redirects to Amazon for OAuth approval.
    4. Amazon confirmation page
  4. After success, the store appears under My Stores.
    Store list
  5. To access the specific store data, you will use the Store Name-Marketplace in the Store cell in Google sheet, like below format:
    • MYSTORE-US for the US marketplace
    • MYSTORE-UK for the UK marketplace

2.2 Authorize Ads (optional)

  1. After store authorization, click Authorize Ads. This redirects to Amazon for OAuth approval.
    2. Ads authorization
  2. After success, you'll see the ads marketplace and authorization timestamp.
    Ads authorization result

2.3 Share Store Access (Business and Enterprise plan only)

  1. Click Share to allow other users to access your authorized store.
    Store sharing
  2. You can revoke access at any time.
    Revoke access

Step 3: Install the Google Sheets Add-on

  1. Visit Google Workspace Marketplace: Install SellerSheet Add-on
  2. Click Install and complete permissions using the same Google account.
  3. Open any Google Sheet and launch the add-on in Google Sheets. Navigate: Extensions > SellerSheet > Sidebars > Open Sidebar This will initialize the settings including creating a working folder SellerSheet in your Google Drive together with other subfolders and spreadsheets.
    4. Launch add-on
  4. (Optional) Run Initialize User Settings.
  5. (Optional) Open Settings Dashboard to view SellerSheet folder and authorized stores.

Step 4: Use the Sidebar

  1. On the sidebar, select the tab matching your spreadsheet name (e.g., Sales, Ads).
  2. Each block (e.g., Orders, Products) contains actionable buttons:
    • If on the Orders sheet, go to the Sales tab → Orders block.
    • Buttons: Update Orders, Clear Records

Usage Tutorial

This section provides detailed instructions on how to use SellerSheet's various features. Each subsection below covers a specific functionality and includes step-by-step guidance.

Quick Start Guide

  1. Open your Google Sheets created by SellerSheet when you first run the add-on
  2. Navigate: Extensions > SellerSheet > Sidebars > Open Sidebar to open the sidebar
  3. Select the appropriate tab corresponding to your spreadsheet name (Sales, Ads, Inventory, etc.)
  4. Use the available buttons to perform actions

Common Features

  • Update Data: Refresh your data with the latest information from Amazon
  • Clear Records: Remove existing data before updating
  • Settings: Configure your preferences and connection settings

Best Practices

  • Regularly update your data to maintain accuracy
  • Use the clear function before large data updates
  • Check the settings dashboard periodically to ensure proper configuration
  • Keep your Google Sheet organized with clear sheet names

Sales

The Sales tab contains the following blocks:

  • Orders: View and manage your orders
  • Invoices: View and manage your invoices

Ads

The Ads tab provides access to your Amazon advertising data:

  • Campaigns: View and manage your advertising campaigns
  • Reports: Access detailed advertising performance reports

Inventory

Manage your product inventory through the Inventory tab:

  • Products: View and update product information
  • Stock Levels: Monitor inventory levels and alerts

Reports

Access comprehensive business reports:

  • Sales Reports: Detailed sales performance analytics
  • Financial Reports: Revenue and profitability analysis

Settings

Configure your SellerSheet preferences:

  • Account Settings: Manage your account and subscription
  • Integration Settings: Configure Amazon and Google Sheets connections
WhatsApp WhatsApp