Weekly Amazon Seller performance recap in Notion

Every Monday at 8am in my local time, generate a weekly Amazon Seller performance recap and publish it to Notion so I can read the past week of my store like an executive summary instead of digging through Seller Central. Use a cron trigger.

Data collection from Amazon Seller Partner:

1) Call Search Orders for my marketplace covering the last 7 full days (the most recently completed Mon to Sun window) and capture order count, unit count, and revenue. Then call Search Orders again for the prior 7 days as a baseline for week over week comparisons.

2) Call Create Report to request a sales and traffic report for the same last 7 day window so we get unit, session, page view and conversion context. Also request a returns report (or equivalent) covering the same window. Create Report is asynchronous, so for each reportId returned, poll Get Report with a short backoff loop (start at 5 seconds, double up to 60 seconds, cap total wait around 5 minutes) and keep polling until processingStatus is DONE. If a report fails or is cancelled, note it in the recap and continue instead of crashing the workflow.

3) Once a report is DONE, call Get Report Document to get the pre-signed URL (it expires after 5 minutes, so fetch the data immediately) and download the report contents for use in the analysis.

Analysis the agent should do in-memory before writing to Notion:

- Top 5 SKUs by revenue for the week, with units sold and revenue. Tie-break by units.

- Week over week change in total revenue and total units versus the prior 7 days, expressed as both absolute and percent.

- Refund and cancellation observations, including any SKUs whose refund rate looks unusually high versus the prior week.

- 2 to 3 concrete, specific recommendations grounded in the data, for example 'restock SKU X before it stocks out at current sell-through' or 'investigate the refund spike on SKU Y this week'. No vague advice.

Publishing to Notion:

4) Call Notion Create a Page as a child of my database titled 'Amazon Weekly Reports'. Use the report date (the Monday of the new week, ISO format) as the page title.

5) Call Append Block Children to fill the new page with: a one paragraph executive summary at the top (what happened this week and why it matters), a heading 'Top SKUs' followed by a numbered list or simple table of the top 5 SKUs by revenue, a heading 'Week over week' with the revenue and unit deltas, a heading 'Refunds and cancellations' with the notable observations, and a heading 'Recommendations' with the 2 to 3 action items as a bulleted list.

Tone and formatting rules:

- Executive and skimmable. Short sentences. Numbers up front.

- No em dashes anywhere in the output.

- Format currency with the marketplace's currency symbol and round to whole units.

- If a number is flat (within 2 percent) call it flat instead of inventing a trend.

Make the marketplace (default US), the Notion database name (default 'Amazon Weekly Reports'), and the run time (default Monday 8am) easy to change without rewriting the workflow.

Additional information

What does this prompt do?

Pulls last week's orders, units, refunds and traffic from your Amazon Seller account and compares them to the prior week.
Surfaces the top 5 SKUs by revenue, the biggest movers, and any refund or cancellation spikes worth a second look.
Writes a Monday morning recap to Notion with a short narrative, a SKU leaderboard, and 2 to 3 concrete recommendations.
Reads like an executive summary, not a Seller Central screenshot, so you can skim it with coffee.

What do I need to use this?

An Amazon Seller Central account connected to General Input.
A Notion workspace with a database called Amazon Weekly Reports shared with General Input.
A clear sense of which marketplace you want the recap to cover, for example US, UK or Germany.

How can I customize it?

Change the day and time, for example switch from Monday 8am to Friday 5pm, or run it daily instead of weekly.
Swap the comparison window from week over week to month over month, or compare to the same week last year.
Add or remove sections in the Notion page, such as a returns deep dive, a buy box recap, or an ad spend block.
Point the recap at a different Notion database or send a copy to Slack alongside the Notion page.

Frequently asked questions

Do I need a developer to set this up?

No. You connect your Amazon Seller and Notion accounts in General Input, point the workflow at the Notion database you want the recap to land in, and the agent handles the rest.

Will this work for more than one marketplace?

Yes. You can tell the workflow which marketplace to use, for example US, UK, Germany or Japan. If you sell in several, duplicate the workflow once per marketplace or ask the agent to roll them all into a single page.

What does the Notion page actually look like?

A new page is created each week with the report date as the title. Inside you get a short written summary, a leaderboard of the top SKUs by revenue, a week over week comparison, and 2 to 3 concrete recommendations.

Can I change which Notion database the recap lands in?

Yes. The database name and location are inputs to the workflow, so you can move it to any database that has been shared with General Input.

How fresh is the data?

The recap covers the last 7 full days. Amazon's sales and traffic reports can take a few minutes to generate, which the workflow waits for before writing to Notion.