SellerSheet Documentation

Prerequisites

• Active Amazon Professional Seller Account
• Google Account (Workspace or Personal)
• Chrome Browser (Recommended)

Quick Start Guide

SellerSheet seamlessly synchronizes your Amazon Seller Central data with Google Sheets. Features include automated order syncing, comprehensive business reports, multi-store support, and simple team sharing.

How SellerSheet Sidebar works

SellerSheet works through a sidebar inside Google Sheets. The sidebar is organized as three workspaces — Sellers, Vendors, and Ads — with an icon rail of feature areas down the left side. Pick a workspace, pick a feature, and its panel shows everything that feature can do. Five ideas explain the whole sidebar.

The Store Reports panel in the Sellers workspace. Left to right: the template sheet with ✎ input columns and auto-filled status columns, the icon rail, the panel with Resources links and its sheet-specific action groups.

1 Pick a Workspace, Then a Feature

The tabs at the top switch between three workspaces: Sellers (Sales, Catalogs, FBA, Shipments, Store Reports, A+ Content, Data Kiosk), Vendors (Vendor Orders), and Ads (Sponsored Products, Sponsored Brands, Sponsored Display, Ads Reports). The icon rail down the left side lists the feature areas of the active workspace — click one to open its panel.

Each panel shows an action count (e.g. ⚡ 5 actions) so you can see at a glance how much it does. Star any action to pin it to your favorites. The bar at the bottom of the sidebar holds Settings, Dashboard, Notifications, and Documentation.

2 Resources — Jump Straight to Your Files

At the top of each panel, Resources gives quick-access links to that feature's files: the green button opens its spreadsheet, the blue button opens its Drive folder.

For example, the Store Reports panel links to the Store Reports spreadsheet and the StoreReports Drive folder where downloaded reports land. The Resources section is hidden when no files are configured yet.

3 Two Kinds of Actions — Read the Section Label

Actions are grouped under two labels. "Global · works on any sheet" actions run from anywhere — no need to navigate first (e.g. Sync Orders fetches the latest orders and distributes them across all relevant sheets). "Sheet-specific · active tab must match" groups are named after sheet tabs in the spreadsheet — you must be on that sheet tab before clicking.

Rule of thumb: the group name is the sheet name. See a group called "Store Reports" with Create Reports inside? Switch to the Store Reports sheet tab at the bottom of the spreadsheet first, then click. Groups collapse and expand, so panels stay short.

Sheet missing? If the expected sheet tab doesn't exist in your spreadsheet, click Re-Initiate Resources in the sidebar — it recreates any missing template sheets automatically.

4 Reading a Template Sheet — Fill the ✎ Columns

Every template sheet follows the same anatomy: a green title band (e.g. SellerSheet · Store Reports), a dark header row, and one row per request. The header marks tell you exactly what's yours to fill:

Header Mark	Meaning	What You Do
✎ pencil	Your input	Fill it in — e.g. Store ✎, Report Name ✎. Many input cells offer a dropdown of valid values; hover the header for a note explaining what it expects.
no mark	Auto-filled	Don't touch — SellerSheet writes these after you run an action: Request Time, Report ID, Processing Status, Sheet URL, Folder URL.

Quick Tip: watch the Processing Status column — it updates in place (e.g. DONE), and the result links land in the URL columns of the same row.

5 Entering Your Store Identifier

Every action that talks to Amazon needs to know which store to use. On most templates the first column is Store ✎ — type your Store Identifier there on each row (different rows can even target different stores). A few older sheets take it in a designated cell such as A2 instead.

The Store Identifier is formed by combining the Store Name you chose in the Dashboard with the country code of your marketplace, separated by a hyphen:

StoreName + - + CountryCode = StoreName-CountryCode

Example

Store Name in Dashboard: Bam-Bam-Shop

Marketplace: Canada (CA)

→ Type into the Store ✎ column: Bam-Bam-Shop-CA

Getting a "Store not found" error? The identifier in the cell doesn't match any store in your account. Check the exact spelling and country code in your Dashboard. Country codes: US, CA, GB, DE, FR, IT, ES, JP, AU, AE, IN, MX, BR, SG, NL, SE, PL, TR, BE, EG, SA, ZA.

[ Placeholder: Dashboard store name → Store ✎ column ]

Replace with: ./assets/images/guide/general/store-identifier-in-sheet.png

Putting It All Together

Want an Amazon report? Here's the pattern:

• 1
  In the Sellers workspace, click Store Reports on the icon rail, then the green Resources link to open its spreadsheet.
• 2
  Switch to the Store Reports sheet tab — the action group with the same name needs it active.
• 3
  Fill the ✎ columns on a row: Store (e.g. SS-AE), Report Name, and any optional dates via the dropdowns.
• 4
  In the sidebar, click Create Reports — Request Time, Report ID and Status fill themselves. When Status shows DONE, click Get Reports and the result links land in the same row.

The same pattern runs every feature — pick the workspace and panel, open Resources, match the sheet tab, fill the ✎ columns, click the action, and read the auto-filled status on your row.

1. Open the Sales spreadsheet from the sidebar Resources section.
2. Navigate to the Orders sheet tab.
3. In the sidebar, click Sync Orders — fetches all recent orders from Amazon and distributes them across Orders, Fees, and Refund sheets.
4. For invoices, go to the Invoices sheet, fill in your store identifier, and click Get Invoices.

Advertising (PPC)

Manage Sponsored Products, Brands, and Display from dedicated sheets: SP Campaigns, SP Ad Groups, SP Keywords, SP Targets, SP Product Ads, SP Negatives, SP Camp Negatives, Portfolios, SB Campaigns, SD Campaigns. Every sheet follows the same pattern.

How every ads sheet works

• Setup Sheet creates or resets the header block — filters in row 4, results from row 6. Hover any header for bilingual guidance.
• List fetches entities using the row-4 filters. By default only active (enabled + paused) entities load — set State to ALL or ARCHIVED to see archived ones. Old rows are cleared on every refresh.
• Create sends rows that have the required fields and an empty ID column; new Amazon IDs are written back into the row automatically.
• Edit Selected / Archive Selected act only on rows whose Select checkbox (column A) is ticked — you can never mass-edit by accident. Archiving is permanent on Amazon.
• Status column records the per-row outcome (SUCCESS / ERROR / ARCHIVED) of your last action.

Targeting expressions — bulk-sheet syntax

The SP Targets sheet reads and writes the same expression syntax as Amazon bulk files: close-match, loose-match, substitutes, complements, asin="B0XXXXXXXX", category="12345678", price<20, rating=4-5 — refinements combine on one line. No JSON required.

Inventory Management

Monitor stock levels across FBA and FBM fulfillment channels.

1. Open the Catalogs spreadsheet from the sidebar Resources section.
2. Go to the Live Listings sheet, enter your store identifier in A2, and click Sync Listings to pull your current catalog.
3. To check selling eligibility for an ASIN, go to the Listing Restrictions sheet, enter the ASIN, and click Check Restrictions.
4. To create or update listings in bulk, fill in the Draft Listings sheet and click Submit Listings. Monitor results in the Submission Log sheet.

1. Maintain your warehouse address book in Shipment Setting and per-SKU box specs (Qty/Box, dimensions, weight, prep) in Product Info.
2. Add a row in Manage Shipments (store, warehouse code, plan name, SKUs), click a cell in it and use Create STA SS — SellerSheet generates a dedicated STA spreadsheet for that plan.
3. Run the numbered buttons in order. Box First (you know your boxes): Initiate Plan → Confirm Pack → Set Box Info → Gen Placement Opts. → pick a placement → Gen Trans. Opts. → pick carriers → Confirm Shipment. Split First (Amazon splits first): Initiate Plan → Confirm Placement (STA-Pack is generated) → fill boxes per shipment → Set Box Info → Gen Trans. Opts. → Gen Delivery Window (own-carrier only) → Confirm Shipment.
4. Download FBA Box Labels and FNSKU Labels, then track progress with Sync Shipment Status on Manage Shipments.
5. Browse historical plans (status, created / updated, ship-from) on the Search Inbound Plans sheet.

Inventory Health Dashboard

A live, filterable view of every FBA SKU across all your stores — quantities, inbound pipeline, inventory age buckets, sell-through, weeks of cover, Amazon's recommended actions and estimated long-term storage fees, with product thumbnails. Sync FBA Data refreshes a hidden _raw_fba_data layer straight from the SellerSheet data warehouse (no Amazon API wait), and Setup Inventory Dashboard builds the Inventory Health tab: type into the filter row (store, SKU, ASIN, product name, min/max available, recommended action) and the =SQL() table re-queries instantly, with summary tiles recalculating above. Open the sidebar once in the FBA workbook to activate the SQL() function.

B2B Shipments

Manage packing lists (PL) and carton labels for B2B or direct orders.

• Upload Packing Lists via CSV
• Generate FBA/AMZ Carton Labels
• Track Shipment Status

A+ Content

Build, preview and publish A+ (Enhanced Brand Content) straight from the Create A+ sheet — one module per row, in display order.

1. Fill the config row: store, locale (e.g. en-US), A+ name, content type (EBC standard / EMC premium) and optionally an image folder name.
2. Pick a Module Type per row from row 5 down. The row's cell colors then show exactly what that module needs — green = required, yellow = optional, gray = unused.
3. Add images by URL, or click Load Images (Drive) to place them automatically from your Drive folder (see naming below).
4. Preview A+ renders the document locally before anything is sent.
5. Enter the ASINs to attach, then Create & Submit — SellerSheet uploads every image to Amazon's media library, creates the document, applies the ASINs and submits for approval. Each step's result lands in the sheet.

Image file naming

Name files in your Drive folder <module>-<moduleSeq>-<imageSlot>[-anything].jpg and Load Images (Drive) places each one in exactly the right cell:

• IMAGE_TEXT_OVERLAY-1-1.jpg → the 1st overlay module's image
• three-image-text-1-2-left.png → 1st three-image module, image 2
• FOUR_IMAGE_TEXT-2-3.jpg → 2nd four-image module, image 3

List A+ fetches every document in your store (details fill 25 rows per click); Manage A+ ASINs replaces the full ASIN set on an existing document and resubmits it for approval.

1. Go to the Store Reports sheet. Enter your Store and the Report Name (copy from the Store Report Type sheet).
2. Optionally set Data Start Time and Data End Time for date-range reports.
3. Click Create Reports — SellerSheet submits the request to Amazon and fills in the Report ID.
4. Wait for Amazon to process (usually 1–5 minutes), then click Get Reports. When ready, a clickable Sheet URL appears in the row.

Report ID, Processing Status, Sheet URL, and Folder URL are filled in automatically. Find all available report names in the Store Report Type sheet.

System Settings

Configuration for global preferences and account management.

• Workspace: Define Google Drive folder paths.
• Subscription: Manage billing and plan tiers.
• System Status: Check API connectivity health.