Daily deals digest in Slack from a Google Sheets watchlist

By General Input

Every morning at 8am, post a curated digest of the best current Google Shopping deals across your team's watchlist categories, with prices, stores, and product images, straight into Slack.

Integrations

  • Real-Time Product Search
  • Google Sheets
  • Slack Bot

Type

Agentic Task

Categories

  • Marketing
  • Operations

Build me an agent workflow that posts a curated daily deals digest to Slack every morning at 8am. The trigger is a cron schedule (08:00 in my workspace timezone, every day).

At each run, the agent should:

1) Read a configured Google Sheets watchlist using Google Sheets Get Values. The sheet has one row per tracked category with three columns: query (e.g. "noise canceling headphones", "ergonomic office chair", "gaming GPU"), min_discount_pct (integer, e.g. 20), and channel (the Slack channel ID or name to post results in, e.g. #deals-tech). The spreadsheet ID, tab name, and header row should be inputs the user configures when they connect the workflow.

2) For every row, call Real-Time Product Search Search Deals with the row's query to pull current Google Shopping deals. Filter the returned deals down to those whose discount percent is at or above the row's min_discount_pct. If nothing in a row clears the floor, skip that row silently — do not post an empty section.

3) For the most promising hits across all rows (top candidates by discount size and apparent value), optionally call Real-Time Product Search Get Product Details to flesh out the title, image URL, rating, and seller before deciding what to include.

4) Use editorial judgement to pick the 5 to 8 most compelling deals across all categories for today. Dedupe near-identical listings (same product across multiple queries, or the same SKU from multiple sellers — keep the best offer). For each selected deal, write a one to two sentence blurb covering the price, the store, the discount percent, and why it stands out (price relative to typical, seller reputation, strong ratings, etc.).

5) Group the selected deals by the target Slack channel from the watchlist row they came from. For each channel that has at least one deal, call Slack Bot Send a Message to post a single digest message to that channel. Use Slack mrkdwn formatting (`*bold*`, `<url|text>`). Each deal in the digest should include: product title (linked to the buy URL), price + original price + discount percent, store name, a one-liner blurb, and the product image URL on its own line so Slack unfurls it. Lead the message with a short header like "*Today's deals* — DATE".

Inputs the user should configure when they connect the workflow: the Google Sheets spreadsheet ID and tab name for the watchlist, the timezone for the 8am cron, and optional editorial preferences (e.g. "prefer new condition only", "cap price at $X", "skip Amazon resellers").

Connections required: Google Sheets (read), Slack Bot (chat:write, plus chat:write.public if the bot won't be a member of every target channel), and Real-Time Product Search (RapidAPI key).

Related prompts

Explore more prompts
Call overdue Xero customers with an AI collections agentLocal listing health board for every location you manageLet support send one-off Loops emails without an engineerA brand asset library your marketing team actually searchesTurn Mailjet email clicks into ranked HubSpot follow-upsClean out the Looker dashboards and Looks nobody opensStop cold emails to anyone with a live deal in PipedriveLiveKit live operations console for room moderationWake up dormant Keap leads with a researched reasoniMessage campaign console with pre-flight checks and delivery board