How to Create FBA Shipments (Send to Amazon) in Google Sheets
Run Amazon's whole Send-to-Amazon (STA) workflow from Google Sheets with the SellerSheet sidebar — set up your warehouse and products once, then create, confirm, label and track every FBA shipment in a few clicks.
Introduction
Creating FBA shipments in Seller Central means navigating multiple pages for every single shipment — entering your warehouse address, adding products one by one, filling box dimensions, choosing carriers, and downloading labels. It's repetitive, error-prone, and slow.
SellerSheet handles the entire Send-to-Amazon (STA) workflow from Google Sheets. Set up your warehouse address once, fill in your products and box configurations, then click through the sidebar buttons to initiate, confirm, and track your shipment — including FBA carton labels and FNSKU barcode labels.
This guide covers the Box First, Split Later workflow using 4 sheets: Shipment Setting, Product Info, Manage Shipments, and the STA working sheet. In four stages:
- Set up sheets — address, products, tracking.
- Fill the STA sheet — boxes, MSKUs, quantities.
- Create & confirm — initiate, options, confirm.
- Get labels — FBA + FNSKU labels.
Prerequisites
- Store connected: your Amazon store is connected to your SellerSheet account — sign in at sellersheetai.com and connect it under Settings → Stores & Marketplaces.
- Sidebar installed: the SellerSheet add-on is installed in Google Sheets. See Install & first sync.
- FBA access: your Amazon Seller Central account must have FBA (Fulfillment by Amazon) enabled.
Setting up your sheets
The problem
In Seller Central, you re-enter your warehouse address, product details, and box dimensions every time you create a shipment. There's no way to save templates or reuse configurations across plans.
SellerSheet uses an FBA spreadsheet with dedicated tabs so you configure your data once and reuse it for every shipment. The FBA spreadsheet contains 4 key tabs.
1. Shipment Setting
Fill in your warehouse or ship-from address. Each row represents a different warehouse/location identified by a unique Warehouse Code. You only need to fill this once per warehouse.
| Column | What it holds |
|---|---|
| warehouseCode | Unique ID for this warehouse (e.g. myStore-US-WH1). |
| companyName | Company name on the shipping label. |
| name / phoneNumber / email | Contact information for the ship-from address. |
| addressLine1 / addressLine2 | Street address. |
| city / stateOrProvinceCode / countryCode / postalCode | Location details. |
| unitOfDimention | Measurement unit for box dimensions (CM or IN). |
| unitOfWeight | Weight unit (KG or LB). |
2. Product Info
Fill in your product catalog with SKU, FNSKU, ASIN, box dimensions, and prep details. When you create an STA sheet, product data is pulled in automatically via VLOOKUP — so you only fill this once per product.
| Column | What it holds |
|---|---|
| store | Store ref (e.g. myStore-US). |
| msku | Your Merchant SKU. |
| fnsku | Amazon's Fulfillment Network SKU. |
| asin | Amazon Standard Identification Number. |
| qtyPerBox | Number of units per box. |
| boxDimensions | Length x Width x Height (e.g. 50x42.5x35) in the units from Shipment Setting. |
| boxWeight | Weight per box in the units from Shipment Setting. |
| labelOwner | Who labels items (SELLER or AMAZON). |
| prepOwner | Who preps items (SELLER or AMAZON). |
| prepCategory / prepTypes | Prep requirements (e.g. NONE, ITEM_NO_PREP, ITEM_LABELING — comma-separated for multiple). |
Pro tip: auto-import from FBA inventory reports
Use Store Reports to create an FBA Inventory Report — it gives you SKU, FNSKU, ASIN, and product title automatically. See the Store Reports guide for details.
3. Manage Shipments
This is your central tracking hub for all FBA shipments. Each row represents one shipment plan. You fill in the basic details here, then click Create STA SS to generate the working spreadsheet.
| Column | What it holds |
|---|---|
| store / warehouseCode | Which store and warehouse to ship from. |
| planName | Your label for this shipment plan. |
| fulfillmentSplit | Packing strategy (Box First, Split Later). |
| shipDate / deliveryWindowStartDate | Shipping schedule. |
| planFolder | Hyperlink to the STA spreadsheet (auto-generated). |
| planId / shipmentId | Amazon's plan and shipment identifiers (auto-filled). |
| fbaLabel / fbaId | FBA label PDF link and confirmation ID (auto-filled). |
| amazonReferenceId | Amazon's reference number confirming readiness (auto-filled). |
| status | Current shipment status (WORKING, SHIPPED, CLOSED). |
| carrier / tracking | Your carrier and tracking number. |
| remark | Internal notes. |
Creating your STA shipment
The problem
In Seller Central, creating an FBA shipment plan means clicking through 5+ pages of forms — entering the ship-from address, adding products one by one, filling box dimensions, selecting carriers. For each shipment. Every time.
SellerSheet's sidebar walks you through numbered steps. Each button calls the Amazon API and fills the results back into your sheet. The entire flow takes a few clicks instead of dozens of form pages. Every button of the panel is listed on FBA.
1. Create the STA spreadsheet
On the Manage Shipments sheet, fill in a row with your shipment details:
- Set Store and Warehouse Code (must match Shipment Setting).
- Enter a Plan Name (your internal label).
- Set Fulfillment Split to
Box First, Split Later. - Fill in Ship Date and Delivery Window Start Date.
- Click Create STA SS in the sidebar.
SellerSheet creates a new spreadsheet in organized Google Drive folders (Store › Country › Year › Month) and opens it. The STA sheet is pre-populated with your warehouse address from Shipment Setting and product data from Product Info via VLOOKUP.
2. Fill the STA sheet
The STA sheet has two main areas: the header section (filled from your Manage Shipments row, with a step-by-step progress stepper) and the item grid (where you fill in your products and box assignments).
Header section. Holds the shipment overview (Store, Plan Name, Fulfillment Split, Send From Address, Ship Date, Delivery Window Start Date, the box dimension and weight units, FNSKU Label Size, FBA Box Label Size), the progress stepper with the IDs Amazon returns (Packing Option, Placement Option, fees), and — once confirmed — the FBA ID, Reference ID and warehouse.
Item grid. Columns boxNo, msku, image, fnsku, title, asin, qtyPerBox, boxDimensions, boxWeight, boxes, quantity, expiration, labelOwner, prepOwner, prepCategory, prepTypes. Fill in:
- boxNo — which boxes contain this product (e.g.
1~3means boxes 1 through 3). - msku — your Merchant SKU. VLOOKUP fills fnsku, title, asin, qtyPerBox, boxDimensions, boxWeight, labelOwner, prepOwner, prepCategory, and prepTypes from Product Info.
- boxes — how many boxes for this product line (calculated from the boxNo range).
Box number format
Use 1~3 to indicate boxes 1 through 3 share the same contents. Each range or number on a separate row represents a distinct product-to-box assignment.
3. Initiate the plan
Click Initiate Plan in the sidebar. SellerSheet calls the Amazon API to:
- Create an inbound plan with your products and box configuration.
- Generate packing options.
- Confirm the packing option at once if only one exists.
The progress stepper marks steps 1a and 1b as done.
Multiple packing options?
If Amazon returns several packing options, pick one in the stepper's 1b cell, then click Confirm Pack. After packing is confirmed, click Set Box Info to send your box dimensions and weights to Amazon.
4. Generate options
Amazon returns three types of options, each fetched by its own button:
- Placement options — click Gen Placement Opts. Amazon returns which fulfillment centers to ship to, with their placement fees. Each shipment's warehouse, weight and volume land in the STA-Options sheet. Pick a placement in the stepper's 2 cell.
- Transportation options — click Gen Trans. Opts. Shipping methods (Amazon Partnered Carrier vs. Use Your Own Carrier), with cost and mode, land in the STA-Options Transportation dropdowns — pick one per shipment there.
- Delivery windows — own-carrier shipments only: click Gen Delivery Window to fill the STA-Options Delivery Window dropdowns, then pick a slot per shipment.
When Amazon splits items to different warehouses, STA-Options holds one row per shipment, each with its own dropdowns. See Handling multiple shipments below.
| Transportation option | What it means |
|---|---|
AMAZON_PARTNERED_CARRIER | Amazon handles pickup and delivery. No delivery window selection needed — Amazon manages the scheduling. |
USE_YOUR_OWN_CARRIER | You arrange your own shipping. Click Gen Delivery Window to get available delivery slots, then select one. |
5. Confirm the shipment
Once you've selected your options, click Confirm Shipment. SellerSheet performs the full confirmation sequence:
- Confirms the placement option picked in the stepper.
- Confirms each shipment's transportation option (carrier selection).
- Confirms each shipment's delivery window (if using your own carrier).
After confirmation:
- The FBA ID, Reference ID and warehouse appear in the STA header and in STA-Options; the FBA ID becomes the link to the label PDF once Amazon has it.
- Status updates to
WORKING. - The Manage Shipments sheet is updated with the confirmed shipment row.
Pro tip: multiple shipments confirmed in one click
When Amazon splits your plan into multiple shipments, Confirm Shipment processes all shipments for the selected placement option at once. Each gets its own FBA label PDF and row in Manage Shipments.
6. Get the Reference ID
Click Get Ref. ID to check whether Amazon has assigned a Reference ID to your shipment. If ready, the Reference ID is filled in (and mirrored to Manage Shipments) and the status may update. If not ready yet, wait 5–10 minutes and try again.
Pro tip: Reference ID timing
The Reference ID confirms Amazon is ready to receive your shipment. It typically takes 5–10 minutes to generate after confirmation. Don't worry if it shows "Not Ready" immediately.
Getting labels
The problem
Downloading FBA carton labels from Seller Central means finding the right shipment, navigating to the labels page, and downloading one PDF at a time. For FNSKU labels, you need a separate barcode generator tool.
FBA carton labels
Set FBA Box Label Size in the STA header, then click Get FBA Box Labels in the sidebar. SellerSheet downloads the FBA carton label PDF to your Google Drive in the plan folder. The FBA ID cell becomes a clickable hyperlink to the PDF.
This also works from the Manage Shipments sheet — select the row and download the labels for any shipment.
FNSKU item labels
To generate FNSKU barcode labels for individual items:
- Set FNSKU Label Size in the STA sheet header (e.g.
30x50 mm,4x6 inch). - Click Get FNSKU Labels in the sidebar.
SellerSheet generates a barcode label for every unit across all boxes (qtyPerBox × boxes) and opens them in a print dialog. Labels are grouped by FNSKU with a summary page showing the box breakdown and total label count — ready for printing.
Handling multiple shipments
The problem
Amazon often splits your inbound plan into multiple shipments going to different fulfillment centers. In Seller Central, you have to manage each split separately — different carriers, different delivery windows, different labels. Tracking everything across multiple shipment IDs gets overwhelming.
When Amazon splits your items, SellerSheet fills the STA-Options sheet with one row per shipment per placement option. Each row has its own:
- Shipment ID — unique identifier for each split.
- Transportation Option ID — chosen independently per shipment (e.g. Amazon Partnered for one warehouse, your own carrier for another).
- Delivery Window Option ID — delivery slot per shipment (only needed for
USE_YOUR_OWN_CARRIER). - Reference ID / Status — tracked per shipment after confirmation.
How it works:
- After Gen Placement Opts. and Gen Trans. Opts., review the STA-Options rows.
- Select the Placement Option in the stepper's 2 cell on the main STA sheet (options show the fulfillment centers and fee).
- For each shipment row in STA-Options, select your preferred Transportation Option and Delivery Window Option. Match Carriers copies shipment 1's carrier to the other shipments of the same placement.
- Click Confirm Shipment — all shipments for the selected placement are confirmed in one click.
- Each shipment gets its own FBA label PDF and its own row in Manage Shipments.
An Inbound PL (Packing List) sheet is also created showing the detailed item breakdown per shipment — which products go to which fulfillment center.
Compare placement fees
Different placement options may have different fees. Check the fee of each placement option before confirming — choose the option that balances cost and delivery speed for your needs.
Track & manage shipments
The Manage Shipments sheet is your central dashboard for all FBA shipments. After confirming, each shipment appears as a row with its data filled in:
- Plan Folder — clickable link back to the STA spreadsheet.
- FBA Label — direct link to the carton label PDF.
- Status — tracks the lifecycle:
WORKING→SHIPPED→CLOSED. - Carrier / Tracking — fill in your carrier name and tracking number after shipping.
Click Refresh Shipment in the sidebar to refresh the status of every open shipment on the sheet from Amazon at any time.
Pro tip: cancel if needed
Made a mistake? Click Cancel Plan in the sidebar before shipping to cancel the entire inbound plan. Every step of the stepper and the Status cell become CANCELLED.
Quick reference
| What you need | Action | Sheet |
|---|---|---|
| Set up warehouse address | Fill once, reuse for all shipments | Shipment Setting |
| Prepare product catalog | Fill SKU / FNSKU / ASIN / box details | Product Info |
| Create a new shipment | Fill row → Create STA SS | Manage Shipments → STA |
| Walk through the STA workflow | Initiate Plan → Gen Placement Opts. → Gen Trans. Opts. → Confirm Shipment → Get Ref. ID | STA |
| Print carton labels | Get FBA Box Labels | STA |
| Print item barcodes | Get FNSKU Labels | STA |
| Track all shipments | View status, labels, tracking; Refresh Shipment | Manage Shipments |
Maximizing efficiency
- Reuse Product Info: fill your product catalog once. Every new STA sheet fills product data via VLOOKUP — no re-entering box dimensions or prep details.
- Auto-import with FBA inventory reports: use Store Reports to create FBA Inventory Reports and get SKU, FNSKU, ASIN, and title imported automatically.
- Batch shipments: create multiple rows in Manage Shipments and generate STA spreadsheets for each — work on them in parallel across different tabs.
- Multiple warehouses: set up multiple warehouse codes in Shipment Setting for different ship-from locations. Select the right one per shipment.
- After shipment: for listing management (updating prices, titles, or adding ASINs), see the Create Listings guide.