Continue with Google Introduction
Amazon Seller Central offers dozens of report types — inventory, orders, settlement, FBA, and more. But getting them into a spreadsheet where you can actually analyze the data? That's where the frustration begins: logging into Seller Central, navigating through menus, waiting for reports to generate, downloading CSV files, importing them manually — and doing it all over again tomorrow.
SellerSheet's Store Reports feature eliminates this entirely. It provides three distinct workflows, each designed to solve a specific seller pain point:
- Create & Download Reports — Need a specific report right now? Request it directly from Google Sheets and download the results in one click.
- Search & Download Existing Reports — Need a settlement report that Amazon auto-generates? Search for it by date range and download it without ever opening Seller Central.
- Schedule Automated Reports — Need your data refreshed daily? Set it once and SellerSheet updates your reports every day automatically.
Prerequisites
- Store Authorization: Ensure you have authorized your Amazon store on the SellerSheet Dashboard.
- Sidebar Installed: You need the SellerSheet Google Sheets sidebar installed. If not, follow the Onboarding Guide.
How the Sidebar Works
Before diving into Store Reports, it helps to understand how SellerSheet works in general. Every feature follows the same three-step pattern:
Go to the right sheet
Each feature has its own spreadsheet and sheet tabs. Navigate to the correct one first.
Fill in the colored columns
Yellow = required, Light Yellow = optional, Gray = auto-filled.
Click the sidebar button
Buttons inside a named dropdown only work when you're on that matching sheet tab.
Button Types
- Sheet-Specific (inside a dropdown): Only work when you are on the matching sheet. Example: buttons inside the "Store Reports" dropdown require you to be on the
Store Reportssheet. - Global (standalone, not inside any dropdown): Work from any sheet in the spreadsheet.
For the full guide — including color coding details and tooltips — see the How SellerSheet Sidebar Works section in the documentation.
Getting Started
If this is your first time, SellerSheet will create a Store Reports spreadsheet in your SellerSheet Google Drive folder. This spreadsheet contains three sheet tabs — Store Reports, Search Store Reports, and Report Scheduler — one for each workflow.
Opening the Store Reports Spreadsheet
There are two ways to get to your Store Reports spreadsheet:
A From Google Drive
Open your SellerSheet folder in Google Drive, then open the Store Reports spreadsheet. Launch the sidebar from Extensions → SellerSheet and navigate to the Store Reports tab.
B From My Resources
Open the sidebar in any Google Sheet, go to the Home tab, and click the Store Reports link under My Resources. This opens the spreadsheet directly — then reopen the sidebar from Extensions.
Screenshot: SellerSheet sidebar with Store Reports tab
Starting Fresh or Recovering Deleted Resources
SellerSheet remembers each spreadsheet and folder by its ID. As long as the resource exists, it keeps using it. If a resource is deleted or can't be found, SellerSheet creates a new one and remembers the new ID going forward.
How Re-Initiate Resources Works
Click Re-Initiate Resources at the bottom of My Resources in the Home tab. SellerSheet checks every folder, spreadsheet, and sheet tab by name — if the exact name is missing, it recreates it with a fresh template. Resources that already exist are left untouched.
- Want a clean sheet? Rename the existing sheet tab (e.g.,
Store Reports→Store Reports - 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 first. Then clear the data in the original. SellerSheet continues using the original because the ID hasn't changed.
- Deleted something by accident? Click the missing item's name in My Resources or run Re-Initiate. SellerSheet creates a new resource and remembers it automatically.
For the full guide on My Resources and resource recovery, see the documentation.
Workflow 1: Create & Download Reports
The Problem
You need a specific report — inventory health, order data, FBA fees — but getting it means logging into Seller Central, navigating to the Reports section, requesting the report, waiting for it to process, downloading the CSV, and then importing it into your spreadsheet. For multiple reports or multiple stores, this process takes hours.
With SellerSheet, you can request any Amazon report and download it directly into a Google Sheet — all from the Store Reports sheet. Here's how:
1. Configure Your Report Rows
In the Store Reports sheet, fill in the required columns:
- Report Name: Switch to the Store Report Type sheet to see all available report types. Copy the exact report name you want (e.g.,
FBA Inventory Report). - Store: Enter your store identifier — the store name you set on the dashboard plus the country code (e.g.,
MyStore-US). - Time Frame (Optional): Some reports require a date range. Fill in Data Start Time and Data End Time if needed.
Column Color Guide
| Yellow | Required | Must be filled (Report Name, Store). |
| Light Yellow | Optional | Optional fields (Data Start/End Time). |
| Gray | Auto-Filled | System-managed (Report ID, Status). Do not edit. |
2. Create the Report
Click Create Reports in the sidebar. SellerSheet sends the request to Amazon via SP-API. On success, the Request Time and Report ID columns fill in automatically. Rows that already have a Report ID are skipped — no duplicates.
3. Download the Report
After a moment for Amazon to process the report, click Get Reports in the sidebar. SellerSheet checks the status of each Report ID with Amazon:
Status Meanings
- IN_QUEUE / IN_PROGRESS: Amazon is still preparing the report. Try again in a minute.
- DONE: Report is ready. SellerSheet downloads it to
SellerSheet/StoreReports/{Report Name}in your Drive. - CANCELLED: Report had no data — Amazon cancelled it.
- FATAL: Error in request (wrong report name or missing required time frame).
When the status is DONE, the Sheet URL and Folder URL columns populate with clickable links to your downloaded report.
Screenshot: Store Reports sheet with configured rows and downloaded results
Pro Tip: Bulk Requests
Fill out multiple rows at once — different reports, different stores, different date ranges. SellerSheet processes all valid rows in the active sheet when you click Create Reports or Get Reports. Request 20 reports in one click instead of one at a time.
Workflow 2: Search & Download Existing Reports
The Problem
Some of the most critical reports — like settlement reports — are automatically generated by Amazon on a regular schedule. You can't request them yourself. To get a Flat File V2 Settlement Report, you have to navigate to Seller Central's Payments section, find the right settlement period, download the file, and manually import it. If you manage multiple stores or need historical settlement data, this becomes a massive time sink.
The Search Store Reports sheet solves this by letting you search Amazon for reports that already exist — find them by type and date range, then download them directly into Google Sheets.
1. Set Your Search Criteria
Navigate to the Search Store Reports sheet and fill in Row 2 with your search parameters:
- Store: Your store identifier (e.g.,
MyStore-US). - Report Name: The report type to search for (e.g.,
Flat File V2 Settlement Report). - Created Since (Optional): Only show reports created after this date.
- Created Until (Optional): Only show reports created before this date.
2. Search for Reports
In the sidebar, expand the Search Store Reports dropdown under the Store Reports tab, then click Search Reports. SellerSheet queries Amazon for all completed reports matching your criteria.
3. View Results & Download
Results appear in Row 4 onward, showing each report's ID, type, status, and creation date. To download a specific report:
- Copy the Report ID from the search results.
- Go to the Store Reports sheet and paste the Report ID into a new row (along with the Store name).
- Click Get Reports in the sidebar to download it to your Drive.
Screenshot: Search Store Reports sheet with settlement report search results
Search Sheet Structure
- Row 1: Technical headers (column identifiers).
- Row 2: Your search parameters (Store, Report Name, date filters).
- Row 3: Result column headers.
- Rows 4+: Search results (Report ID, type, status, created time).
Pro Tip: Settlement Period Filtering
Amazon generates settlement reports every 14 days. Use the Created Since and Created Until date filters to narrow down to the exact settlement period you need — no more scrolling through dozens of reports in Seller Central.
Workflow 3: Schedule Automated Reports
The Problem
You need up-to-date data every day — active listings, inventory levels, FBA status — but manually requesting the same reports each morning is unsustainable. Data goes stale, decisions are made on yesterday's numbers, and the repetitive work adds up. You need a "set it and forget it" solution.
The Report Scheduler automates the entire create-poll-download cycle. Configure it once, and SellerSheet keeps your reports updated daily — no manual intervention.
1. Configure the Report Scheduler
Navigate to the Report Scheduler sheet within your Store Reports spreadsheet. If it doesn't exist yet, SellerSheet creates it automatically on first run. In Row 3 onward, fill in:
- Store: Your store identifier (e.g.,
AmazonStore1-US). - Report Name: The report type to schedule (must be a snapshot-only report — no date range required).
2. Run the Scheduler
Click Schedule Reports in the sidebar. SellerSheet handles everything automatically:
- Creates a report request for each row via Amazon SP-API.
- Polls report status every 30 seconds until complete.
- When a report is DONE, downloads the data and saves it to a Google Sheet.
- Updates the Sheet URL and Folder URL columns with clickable links.
The next day, the scheduler creates a fresh report and updates the same spreadsheet in place — so any formulas, pivot tables, or dashboards you've built on top of the data stay connected and always reflect the latest values.
Screenshot: Report Scheduler sheet with scheduled reports and status
Scheduler Column Reference
- Store + Report Name: You fill these in (required).
- Last Request Time: Auto-filled when the report is requested.
- Report ID: Auto-filled with the Amazon report ID.
- Processing Status: Auto-updated (IN_QUEUE, IN_PROGRESS, DONE, CANCELLED, FATAL).
- Last Error: Shows any error messages.
- Sheet URL: Hyperlink to the downloaded report spreadsheet.
- Folder URL: Hyperlink to the Google Drive folder containing the report.
Pro Tip: True Daily Automation
The scheduler includes a once-per-day guard — new reports are only created once daily, even if triggered multiple times. Combined with SellerSheet's automatic triggers, your reports refresh every day without any manual intervention.
Important: Snapshot Reports Only
The Report Scheduler only supports snapshot reports — reports that don't require a date range (like active listings, inventory, FBA status). For reports that need a custom date range, use Workflow 1: Create & Download instead.
Which Workflow Should You Use?
Each workflow is designed for a different need. Use this table to choose the right one:
| What You Need | Workflow | Sheet | Best For |
|---|---|---|---|
| A specific report right now | Create & Download | Store Reports | Inventory, orders, FBA reports with custom date ranges |
| Amazon-generated reports | Search & Download | Search Store Reports | Settlement reports, reimbursement reports |
| Daily automated refresh | Schedule | Report Scheduler | Active listings, inventory levels — always up to date |
Maximizing Efficiency with Google Sheets
The real power of SellerSheet Store Reports is that your data lands directly in Google Sheets — the most flexible analysis tool for Amazon sellers. Here's how to get the most out of it:
- Bulk requests across stores: Fill multiple rows with different reports and different store identifiers. SellerSheet processes them all in one click — perfect for multi-marketplace sellers.
- Smart duplicate prevention: Rows with an existing Report ID are skipped by "Create Reports". Rows already marked DONE are skipped by "Get Reports". No accidental double-downloads.
- Organized Drive storage: Reports are auto-saved to
SellerSheet/StoreReports/{Report Name}folders in your Google Drive, keeping everything neatly categorized. - Settlement analysis workflow: Use Search Reports to find settlement data, download it, then leverage Google Sheets formulas and pivot tables to analyze fees, refunds, and net proceeds — all in one place.
- Live dashboards with scheduled data: Combine the Report Scheduler with
IMPORTRANGEorVLOOKUPto build dashboards that automatically reflect the latest inventory, listing, or FBA data every day.
