Weekly Amazon competitor brief in Google Docs and 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.