Weekly Amazon Competitor Intelligence Brief, Auto-Sent to Slack

Build me an agent workflow that produces a weekly Amazon competitor intelligence brief. It should run on a cron trigger every Monday at 8am in my local time zone.

Inputs the workflow needs (make these configurable on the workflow, do not hardcode in agent instructions): a list of ASINs to monitor (a mix of my own products and the top competitors in my category), the Amazon marketplace country code (default US), the Slack channel to post the short summary to, and an optional Google Drive folder ID for where to file the brief.

On each run, for every ASIN in the watchlist, call Real-Time Amazon Data three times: Get Product Details (for title, price, rating, review count, and the Best Sellers Rank value at product_information["Best Sellers Rank"]), Get Product Offers (for third-party offers and which seller currently holds the buy box), and Get Top Product Reviews (for the 8 publicly visible top reviews — no cookie needed). Pass the configured country on every call. Batch ASINs (up to 10 per call) where the operation supports it to stay efficient.

Before writing this week's brief, find the most recent prior brief this workflow created (search Google Drive for the document title prefix, e.g. "Amazon Competitor Brief — ") and read it back so you can do a real week-over-week comparison. If there is no prior brief, note that this is the baseline run and skip the comparison sections.

Synthesize a written intelligence brief. The brief MUST lead with a "What changed this week" section at the top — do not start with a static product dump. The What Changed section should call out, across all tracked ASINs:

• Price movements week over week (current vs prior, absolute and percent change, flag anything moving more than ~5%). • Star rating shifts and review-count deltas. • Best Sellers Rank shifts (smaller is better — call out big jumps up or down, name the category). • New third-party offers and any buy-box flips (new seller name, condition, price). • Three to five themes from the recent top reviews per product (group similar feedback; quote a representative phrase).

After the What Changed section, include a per-ASIN section for each product with the current snapshot (title, price, rating, review count, BSR, top offers, review themes) so the brief is also a standalone reference.

Write the brief into a new Google Doc. Use Create Document with a title of the form "Amazon Competitor Brief — YYYY-MM-DD" (use today's date in my local time zone), then use Batch Update Document to insert the formatted brief content (headings, bullets, bold for movement callouts).

Finally, post a short message to Slack using Send a Message (Slack Bot integration) to the configured channel. The message should contain only the top three takeaways for the week as bullets and a link to the new Google Doc — keep it scannable. Use Slack mrkdwn formatting (single asterisks for bold) and format the link as <doc_url|This week's brief>.

Tone and rules to bake into the agent: lead with what changed, not a product dump; quantify every claim ("price up $2.10, +4.8% WoW", "BSR fell from #1,420 to #2,180 in Kitchen & Dining"); attribute observations to the underlying source ("per Get Product Offers"); when nothing material changed for an ASIN, say so in one line rather than padding the section; do not invent data — if a field is missing, note that the source did not return it.

Additional information

What does this prompt do?

Pulls fresh product details, third-party offers, and recent top reviews for every ASIN on your watchlist, including your own products and your competitors.
Writes a full intelligence brief into a new Google Doc titled with the date, leading with what actually changed since last week.
Calls out price moves, rating and review-count shifts, Best Sellers Rank changes, new offers, buy-box flips, and three to five themes from recent reviews.
Posts the top three takeaways to a Slack channel with a link to the full Doc so your team actually reads it.

What do I need to use this?

A Real-Time Amazon Data account (a RapidAPI subscription) to pull product, offer, and review data.
A Google account with permission to create Google Docs.
A Slack workspace where a bot can post a short weekly summary in your chosen channel.
A list of ASINs you want to track — typically your own products plus your top category competitors.

How can I customize it?

Move the schedule to the day and time your team actually reviews the category, or run it more often than weekly.
Edit the ASIN watchlist whenever you launch a new product or your competitive set changes.
Pick the Slack channel (a category-specific channel usually works best) and tweak the format of the short summary.
Switch the Amazon marketplace if you sell outside the US (UK, Germany, Japan, and more are supported).

Frequently asked questions

Can I track competitors in a non-US Amazon marketplace?

Yes. Tell the workflow which Amazon country you sell in, including UK, Germany, Japan, Canada, and more, and it will pull data from that marketplace.

How many ASINs can I track?

Plenty. The workflow loops through your list, so you can start with a handful of your own products plus a handful of competitors and grow the watchlist over time.

How does the brief know what changed since last week?

The agent compares this week's data to the prior brief it wrote in Google Docs, so the top of the document calls out movement instead of repeating a static product dump.

Will the Slack post be a giant wall of text?

No. Slack only gets the top three takeaways for the week and a link to the full Google Doc. The long-form analysis stays in the Doc.

Can I run it more or less often than weekly?

Yes. The schedule is a single setting. You can move it to daily, twice a week, or any cadence that fits how fast your category moves.

Does this work for products I do not sell myself?

Yes. The watchlist is just a list of ASINs, so you can mix your own products with pure competitor ASINs to get a category-wide view.