How to Create Store Reports in Google Sheets

Request, track, and download Amazon reports directly into your spreadsheet

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.

Using Claude Code + SellerSheet MCP

The Problem

Opening Seller Central, navigating menus, waiting for reports, downloading files, and then importing them into a spreadsheet — every time, for every report. Even with the sidebar, you're still clicking through steps manually. What if you could just ask: "Get me the orders report for last week and save it to my Drive"?

With SellerSheet MCP connected to Claude Code, you describe what you want in plain language. Claude handles the entire create → poll → download → analyze cycle for you — no sidebar clicking required.

Claude Code — paste this prompt

Get me the Flat File All Orders report for SS-AE from March 1–7, 2026.
Save it to my Drive and write the link to my Store Reports tracking sheet.

Claude calls three MCP tools in sequence:

  • sp_api_create_report Submits the report request to Amazon SP-API and writes the reportId to your tracking sheet immediately.
  • sp_api_get_report Polls until DONE (1–15 min depending on type), then auto-downloads the TSV to a Google Spreadsheet in your Drive folder.
  • sp_api_search_reports Check Amazon for existing reports before creating a new one — saves time on duplicate requests.
Claude Code creating a Store Report via SellerSheet MCP
Claude Code handling the full create → poll → download cycle via SellerSheet MCP

Works with any MCP client

SellerSheet MCP works with Claude Code, Feishu + OpenClaw, Cursor, and any MCP-compatible tool. Connect once at sellersheetai.com/dashboard and use the same tools across all your AI workflows.

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:

1

Go to the right sheet

Each feature has its own spreadsheet and sheet tabs. Navigate to the correct one first.

2

Fill in the colored columns

Yellow = required, Light Yellow = optional, Gray = auto-filled.

3

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 Reports sheet.
  • 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 four sheet tabs — Store Reports, Report Lookup, Snapshot Report Scheduler, and Date 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

The Store Reports tab in the SellerSheet sidebar

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:

  1. 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).
  2. Store: Enter your store identifier — the store name you set on the dashboard plus the country code (e.g., MyStore-US).
  3. Time Frame (Optional): Some reports require a date range. Fill in Data Start Time and Data End Time if needed.

Column Color Guide

YellowRequiredMust be filled (Report Name, Store).
Light YellowOptionalOptional fields (Data Start/End Time).
GrayAuto-FilledSystem-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

The Store Reports sheet showing report requests with auto-filled Report IDs and download links

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 Report Lookup 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 Report Lookup 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

Make sure the Report Lookup sheet is your active sheet, then open the sidebar and go to the Store Reports tab. Click the Report Lookup section header to expand it, then click Search Reports. SellerSheet queries Amazon for all completed reports matching your criteria.

3. View Results & Download

Results appear starting at Row 3, showing each report's ID, type, status, and creation date. To download a specific report:

  1. Copy the Report ID from the search results.
  2. Go to the Store Reports sheet and paste the Report ID into a new row (along with the Store name).
  3. Click Get Reports in the sidebar to download it to your Drive.

Screenshot: Report Lookup sheet with settlement report search results

Searching for Flat File V2 Settlement Reports — results show Report IDs ready to download

Report Lookup Sheet Structure

  • Row 1: Technical headers (column machine keys — don't edit).
  • Row 2: Your search parameters (Store, Report Name, Created Since, Created Until).
  • Row 3+: Search results written here — Report ID, report type, processing 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.

SellerSheet provides two schedulers — one for snapshot reports (no date range) and one for date-range reports that appends new data on every run.

Snapshot Report Scheduler

Use this for reports that reflect the current state of your account — inventory, active listings, FBA status. No date range needed.

Where to find the scheduler sheet: The Snapshot Report Scheduler sheet lives in your SellerSheet Store Reports spreadsheet — a dedicated spreadsheet SellerSheet creates for you, separate from your main workbook. Open that spreadsheet, go to the Snapshot Report Scheduler tab, then open the sidebar there.

  1. Open the Snapshot Report Scheduler sheet in your SellerSheet Store Reports spreadsheet. Fill in Store and Report Name for each report you want automated.
  2. Click Schedule Reports in the sidebar.
  3. SellerSheet creates each report, polls Amazon until DONE, and replaces the spreadsheet content in place — dashboards built on top stay connected.

Multiple stores? Google Apps Script has a 6-minute execution limit. If you have many stores configured, the first run creates all report requests and saves progress automatically. Click Schedule Reports again and it resumes from where it left off — no setup needed. Usually 2–3 runs clears the full queue.

Snapshot Scheduler — Column Reference

  • Store + Report Name: You fill these in (required).
  • Request Time / Report ID / Processing Status: Auto-managed per run.
  • Sheet URL / Folder URL: Clickable hyperlinks auto-written when DONE.

Date Report Scheduler

Use this for reports that require a date range — orders, analytics, FBA financials. Each run appends new rows to a cumulative history spreadsheet and auto-advances the date window so the next run picks up exactly where this one ended.

Where to find the scheduler sheet: The Date Report Scheduler sheet lives in the same SellerSheet Store Reports spreadsheet as the Snapshot Scheduler — a dedicated spreadsheet separate from your main workbook. Open that spreadsheet, go to the Date Report Scheduler tab, then open the sidebar there.

  1. Open the Date Report Scheduler sheet in your SellerSheet Store Reports spreadsheet. Fill in Store, Report Name, Data Start Time, and Data End Time for your initial date range.
  2. Click Date Report Schedulers in the sidebar under the Store Reports tab.
  3. SellerSheet creates the report, polls until DONE, and appends the data rows to your cumulative history spreadsheet.
  4. The scheduler then advances the date window automatically: the old Data End Time becomes the new Data Start Time, today becomes the new Data End Time, and Report ID is cleared — ready for the next run.

Date Scheduler — Column Reference

  • Store + Report Name + Data Start Time + Data End Time: You fill these in (required). After each successful run, dates auto-advance.
  • Request Time / Report ID / Processing Status / Rows Added: Auto-managed. Report ID is cleared after each completed run.
  • Sheet URL / Folder URL: Clickable hyperlinks to the cumulative history spreadsheet.
  • Last Error: Any error message from the last run.

Pro Tip: Growing Order History

The Date Report Scheduler is ideal for building a cumulative order history. Each scheduled run appends the next period's orders to the same spreadsheet. Combined with Google Sheets pivot tables, you get a self-updating sales dashboard that grows automatically.

Which Workflow Should You Use?

Each workflow is designed for a different need. Use this table to choose the right one:

What You NeedWorkflowSheetBest For
Any report, described in plain languageClaude Code / MCPsp_api_create_report + sp_api_get_reportDevelopers, power users, AI workflows — full automation
A specific report right nowCreate & Download (Sidebar)Store Reports sheetInventory, orders, FBA reports with custom date ranges
Amazon-generated reportsSearch & Download (Sidebar)Report Lookup sheetSettlement reports, reimbursement reports
Daily snapshot refresh (no date range)Snapshot Report SchedulerSnapshot Report Scheduler sheetActive listings, inventory levels — replaces in place daily
Growing history (orders, analytics)Date Report SchedulerDate Report Scheduler sheetOrders, brand analytics — appends new period on each run

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 Snapshot Report Scheduler with IMPORTRANGE or VLOOKUP to build dashboards that automatically reflect the latest inventory, listing, or FBA data every day.
WhatsApp WhatsApp