Store Reports
Request any Amazon SP-API report on demand from a sheet row and get the finished report in Google Drive.
The Store Reports panel requests Amazon SP-API reports on demand and downloads them to Google Drive. The reports SellerSheet syncs for you on a schedule are already in the data warehouse; use this panel for anything else, or a one-off date range.
Main steps
Fill a row
On the Store Reports sheet, from row 4: Store (e.g. myStore-US), the Report Type, and the dates for reports that take a range.
Create Reports
Click Create Reports: SellerSheet submits each request to Amazon and fills in the Report ID.
Get Reports
Amazon takes a few minutes. Click Get Reports to poll: finished reports download to Drive and are linked in their row.
On Report Lookup, Search Reports finds past Amazon reports with the row-4 filters. Clear Table empties the data rows of either sheet; headers and dropdowns stay.
Every button
| Button | 中文 | What it does | Effect |
|---|---|---|---|
| Create Reports | 创建报告 | Request Amazon reports from rows 4+ (Store, Report Type, dates); the Report ID fills in automatically. | WRITES SHEET |
| Get Reports | 获取报告 | Poll pending reports; finished ones download to Drive and link in the row. | WRITES DRIVEWRITES SHEET |
| Clear Table | 清空表格 | Clear data rows; headers and dropdowns stay. Ctrl+Z to undo. | WRITES SHEET |
| Search Reports | 搜索报告 | Search past Amazon reports using the row-4 filters. | WRITES SHEET |
| Clear Table | 清空表格 | Clear result rows; headers and filters stay. Ctrl+Z to undo. | WRITES SHEET |
Prefer to ask an agent?
reports_createReport and reports_getReport do the same over MCP; synced reports are one query_report_data call away. Guides: Download Amazon reports, Create store reports.