Continue with Google SellerSheet Documentation
Seamlessly synchronize Amazon Seller Central data with Google Sheets.
SellerSheet connects directly to Amazon's SP-API and Ads API, enabling automated data retrieval, analysis, and management within the familiar Google Sheets interface.
Dashboard Authorization
Use the SellerSheet Dashboard to securely authorize your Amazon Stores. This is where you connect your Seller Central account so SellerSheet can fetch your data.
Sidebar Installation
Install the SellerSheet Sidebar from the Workspace Marketplace. This adds the SellerSheet sidebar to your spreadsheets.
This documentation outlines the setup process, authentication workflows, and module-specific functionalities.
Sidebar Path
Open the sidebar in Google Sheets and click buttons to sync data. Best for daily operations — no coding required.
How the sidebar works →AI Agents (MCP)
Connect Claude, Cursor, Coze, Codex, OpenClaw, or any MCP-compatible AI tool. Type in plain language — the agent handles multi-step tasks and writes results directly to your sheets.
Set up AI agents →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.
1. Account Creation
Access the SellerSheet Portal to create your account.
- New Users: Click Continue with Google to create your account.
- Returning Users: Can also use Continue with Email to login via OTP.
- Use the same Google Account you use for Google Sheets.
- You will be redirected to the Dashboard upon success.
2. Store Authentication
2.1 Authorize Amazon Store
- Navigate to the Dashboard.
- Click the Add Store button.
- Enter a friendly Store Name (e.g., "MyStore").
- Select the Region. Important: Ensure the region matches your Amazon Seller Central account.
- Click Authorize Store to be redirected to Amazon for approval.
How your Store Name is used in sheets
SellerSheet identifies your store using a Store Identifier that combines your store name with the country code of your marketplace:
StoreName-CountryCode
For example, if you named your store "Bam-Bam-Shop" and selected Canada (CA), your store identifier is Bam-Bam-Shop-CA.
Sheets that connect to Amazon (such as Create Listings and Draft Listings) require you to type this identifier exactly into a designated cell (e.g. cell A2 or B1). If it doesn't match, you'll see a "Store not found" error. See how sheets use the store identifier →
[ Placeholder: Store name → sheet identifier diagram ]
Replace with: ./assets/images/guide/store-identifier-explainer.png
2.2 Authorize Advertising
- Once the store is listed, click Authorize Ads.
- Click Confirm to be redirected to Amazon Ads.
- Click Allow on the Amazon page.
- You will be redirected back. The ADS AUTH column will show the authorization date.
2.3 Team Access
- Click the Share button.
- Input the email address and click Share Store.
- Current Access lists existing users; Shared to confirms the new addition.
3. Sidebar Installation
- Go to the Google Workspace Marketplace Listing.
- Click Install (or "Admin Install" for Workspace domains).
- Follow the prompts to grant permission to your Google Account.
- Open a new Google Sheet (or type
sheet.new). - Go to Extensions → SellerSheet → Open Sidebar.
- The add-on will initialize and create the "SellerSheet" folder structure in your Drive.
4. Sync Orders
Verify your setup by retrieving your first batch of data.
- In the Sidebar, expand the Sales tab.
- Click the Sync Orders button.
- The Orders sheet in the "SellerSheet Sales" spreadsheet will populate with your recent 30 days of orders.
How SellerSheet Sidebar works
SellerSheet works through a sidebar inside Google Sheets. Each tab in the sidebar is divided into three clearly labeled sections. Understanding these sections tells you exactly what to do before clicking any button.
1 Resources — Jump Straight to Your Files
At the top of each tab you'll find Resources — quick-access links to the spreadsheet and Drive folder for that feature. Click the green button to open the spreadsheet, or the blue button to open the Drive folder.
For example, the Sales tab shows links to the Sales spreadsheet (which contains the Orders, Invoices, and Fees sheet tabs) and the Invoices Drive folder. The Resources section is hidden when no files are configured yet.
2 Global Buttons — Works From Any Sheet
Below Resources you'll find Global Buttons. These run across the entire spreadsheet, so you can click them from any sheet tab — no need to navigate first.
3 Sheet-Specific Buttons — Go to the Matching Sheet First
The bottom section groups buttons inside named dropdowns. Each dropdown maps to one sheet tab in the spreadsheet — the dropdown name is the sheet name. You must be on that sheet before clicking.
Sheet missing? If the expected sheet tab doesn't exist in your spreadsheet, open the sidebar and click Re-Initiate Resources in the Home tab — it recreates any missing template sheets automatically.
4 Fill In the Colored Columns
Every sheet uses color-coded column headers so you always know what to fill in and what to leave alone:
| Header Color | Meaning | What You Do |
|---|---|---|
| Yellow | Required | You must fill this column — the action won't run without it. |
| Light Yellow | Optional | Leave it empty or fill it in for more specific results. |
| Gray | Auto-Filled | Don't touch — SellerSheet fills these automatically after you run an action. |
Quick Tip: Hover over any column header to see a tooltip explaining what it expects.
5 Entering Your Store Identifier
Sheets that connect to Amazon — such as Create Listings and Draft Listings — require you to enter your Store Identifier in a designated cell (typically A2 or B1) before running any action.
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:
Example
Store Name in Dashboard: Bam-Bam-Shop
Marketplace: Canada (CA)
→ Type into cell A2: 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 → Sheet cell A2 ]
Replace with: ./assets/images/guide/general/store-identifier-in-sheet.png
Putting It All Together
Want to create invoices? Here's the pattern:
- 1In the sidebar Sales tab, click the Resources → Sales link to open the spreadsheet.
- 2Switch to the Invoices sheet tab at the bottom of the spreadsheet.
- 3Fill in the Yellow (Required) columns.
- 4Back in the sidebar, open the Invoices dropdown and click Create Invoices.
This same pattern applies to every SellerSheet feature — Resources to open files, Global for whole-spreadsheet actions, Sheet-Specific for per-tab actions.
Home Tab
The Home Tab is your central base in the sidebar. It hosts your essential tools and provides quick access to everything SellerSheet has created for you.
Documentation
Click this to open this guide. Useful for new users to get started quickly.
Mini Dashboard
Your cockpit for account management. Opening the Mini Dashboard allows you to monitor:
- Subscription: Check your current plan and expiry.
- API Quotas: Real-time tracking of your SP-API and Ads API usage.
- Stores: Secondary view of your owned and shared stores.
Home Tab Main Overview
My Resources
The My Resources panel in the Home tab shows everything SellerSheet has created for you — folders, spreadsheets, and connected stores. It's also your safety net: if anything goes missing, this is where you fix it.
What SellerSheet Creates
When you first open the sidebar, SellerSheet builds a SellerSheet folder in your Google Drive containing:
- Folders: Organized storage for Invoices, Reports, Images, etc.
- Spreadsheets: Pre-built templates for Sales, Catalog, Store Reports, FBA, A+, etc. Each spreadsheet contains multiple sheets (tabs) for sub-features.
- My Stores: Stores you authorized on the SellerSheet Dashboard.
- Shared With Me: Stores other team members have shared with you.
How SellerSheet Tracks Resources
SellerSheet remembers each folder and spreadsheet by its ID. If the resource still exists, SellerSheet keeps using it. If it's been deleted or can't be found, SellerSheet creates a new one and remembers the new ID going forward.
This means you can safely delete, rename, or reorganize — SellerSheet always adapts.
Recovery & Starting Fresh
My Resources doubles as a self-repair tool. Click any item's link or use Re-Initiate Resources at the bottom — SellerSheet checks every folder, spreadsheet, and sheet tab by name. If the exact name is missing, it creates a fresh template. Resources that already exist are left untouched.
Deleted something by accident?
Click the missing item's name in My Resources, or click Re-Initiate Resources. SellerSheet creates a new resource and remembers it automatically.
Want a clean sheet template?
Rename the existing sheet tab (e.g.,
Invoices→Invoices - Backup), then click Re-Initiate Resources. SellerSheet sees the original name as missing and creates a fresh template alongside your renamed copy.Want to keep a full backup?
Use File → Make a copy to duplicate the entire spreadsheet or folder first. Then clear the data in the original. SellerSheet continues using the original because the ID hasn't changed — your backup is safely separate.
Important
Recreated sheets are empty templates — your previous data is not restored. Always make a copy first if you need to preserve existing data.
Important Rule
You can only run actions for stores that appear in your "Store" column. Always ensure the sheet tab you are on matches the dropdown menu you use in the sidebar.
Folders & Spreadsheets
Store Management
Sales
Sync orders, fees, refunds, and invoices from Amazon into your spreadsheet.
- Open the Sales spreadsheet from the sidebar Resources section.
- Navigate to the Orders sheet tab.
- In the sidebar, click Sync Orders — fetches all recent orders from Amazon and distributes them across Orders, Fees, and Refund sheets.
- For invoices, go to the Invoices sheet, fill in your store identifier, and click Get Invoices.
Store identifier: Each sheet that pulls Amazon data requires your store identifier in a designated cell (e.g. A2). Use the exact name shown in the sidebar — e.g. MyStore-AE.
Advertising (PPC)
Manage campaigns and analyze performance metrics across Sponsored Products, Brands, and Display.
Available Actions
- Campaign Manager: View and adjust bids/budgets.
- Performance Reports: Download search term reports and placement data.
Inventory Management
Monitor stock levels across FBA and FBM fulfillment channels.
Catalogs
View live listings, check selling eligibility, draft new listings, and submit listing updates to Amazon.
- Open the Catalogs spreadsheet from the sidebar Resources section.
- Go to the Live Listings sheet, enter your store identifier in A2, and click Sync Listings to pull your current catalog.
- To check selling eligibility for an ASIN, go to the Listing Restrictions sheet, enter the ASIN, and click Check Restrictions.
- To create or update listings in bulk, fill in the Draft Listings sheet and click Submit Listings. Monitor results in the Submission Log sheet.
FBA Fulfillment
Create FBA shipments, generate box labels, and track shipment status — all from Google Sheets.
- Open the FBA spreadsheet from the sidebar Resources section.
- Go to the Shipment Setting sheet and fill in your store, destination, and shipment name.
- Go to the Product Info sheet. Enter SKUs and quantities for the items in this shipment.
- Click Create Shipment in the sidebar. Once created, click Get FBA Labels to download box labels.
- After shipping, click Sync Shipment Status to track processing at the Amazon warehouse.
STA Shipments: For Small Parcel Delivery shipments, use the STA sheet to upload tracking numbers after the carrier picks up.
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
Store Reports
Request any of Amazon's 100+ SP-API reports on demand and download them directly to Google Drive.
- Go to the Store Reports sheet. Enter your Store and the Report Name (copy from the Store Report Type sheet).
- Optionally set Data Start Time and Data End Time for date-range reports.
- Click Create Reports — SellerSheet submits the request to Amazon and fills in the Report ID.
- Wait for Amazon to process (usually 1–5 minutes), then click Get Reports. When ready, a clickable Sheet URL appears in the row.
| Column | Required? | What to put |
|---|---|---|
| Store | Yes | Your store identifier, e.g. MyStore-AE |
| Report Name | Yes | Exact name from the Store Report Type sheet |
| Data Start Time | Optional | Start date for reports that require a date range |
| Data End Time | Optional | End date for reports that require a date range |
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.
AI Agents (MCP)
Manage your Amazon business by talking to an AI — Claude, Cursor, Coze, Codex, OpenClaw, and more.
What is MCP?
Instead of clicking buttons in the sidebar, you connect an AI tool and describe what you want in plain language. The AI calls Amazon on your behalf, processes the data, and writes structured results directly into your Google Sheet — across multiple steps in one go. SellerSheet supports any MCP-compatible AI agent.
Example: "Pull my FBA inventory for SS-AE, find SKUs below 30 units, and write a reorder list to my Reorder sheet with current stock and days remaining." — One prompt. The AI calls Amazon, processes the data, and writes the sheet automatically.
Connect Your AI Tool
Add https://sellersheetai.com/mcp as a remote MCP server in your AI tool. The first time you run a SellerSheet command, a browser tab opens for one-click Google authorization — no API key to copy manually.
Claude Code
claude mcp add --transport http sellersheet https://sellersheetai.com/mcp Full setup guide →Codex & OpenClaw
Add https://sellersheetai.com/mcp as a remote MCP server in settings
What AI Can Do
| Domain | Example multi-step task | Writes to your sheet |
|---|---|---|
| Sales analysis | Compare last 30 days vs previous 30 days by ASIN, flag declining products | Dashboard sheet — ASIN, revenue, units, % change |
| Inventory | Find all FBA SKUs below reorder threshold, estimate days of stock remaining | Reorder sheet — SKU, ASIN, current stock, days remaining |
| Ads | Pull all SP campaigns, calculate ACOS per campaign, flag anything above 30% | Ads Analysis sheet — campaign, spend, sales, ACOS, flag |
| Listings | Sync live listings, find any missing bullet points or fewer than 3 images | Fix Needed sheet — ASIN, title, missing fields |
| Reports | Download last week's All Orders report, extract and rank revenue by ASIN | Sales Summary sheet — top 10 ASINs by revenue |
Example Prompts
Copy these prompts directly into your AI tool. Replace SS-AE with your store identifier.
Inventory reorder analysis
Check FBA inventory for SS-AE. Find all SKUs where stock is below 30 units. Write them to the Reorder sheet with columns: SKU, ASIN, Current Stock, Days Remaining.
Writes to: Reorder sheet — SKU, ASIN, Current Stock, Days Remaining
Sales comparison (30-day vs prior 30-day)
For SS-AE, compare sales for the last 30 days vs the 30 days before that. Break it down by ASIN. Write a summary table to the Dashboard sheet with columns: ASIN, Title, Last 30 Days Revenue, Previous 30 Days Revenue, Change %.
Writes to: Dashboard sheet — ASIN, Title, revenue comparison, % change
Ads efficiency audit
Pull all active Sponsored Products campaigns for SS-AE. Calculate ACOS for each campaign. Flag any campaign where ACOS is above 30%. Write the full list to the Ads Analysis sheet sorted by ACOS descending.
Writes to: Ads Analysis sheet — Campaign, Spend, Sales, ACOS, Flag
Listing health check
Sync live listings for SS-AE. Find any listings missing bullet points or with fewer than 3 images. Write them to the Fix Needed sheet with columns: ASIN, Title, Missing Fields.
Writes to: Fix Needed sheet — ASIN, Title, Missing Fields
