Daily news digest from your topic tracking sheet to Slack

By General Input

Every weekday at 8am, scan the last 24 hours of web news for every topic in your Google Sheet and post one tidy Slack digest with snippets.

Integrations

  • Google Sheets
  • Octen AI
  • Slack

Type

Deterministic Code

Categories

  • Marketing
  • Operations

Every weekday at 8am in my timezone, run a topic-tracking news digest. The trigger is a cron schedule.

Inputs the workflow needs (collect as workflow variables): the Google Sheets spreadsheet ID and sheet/tab name for the tracking list, and the Slack channel ID where the digest should be posted.

Step 1. Use Google Sheets Get Values to read the tracking sheet. Treat the sheet as configuration: column A holds a topic or query string, and column B holds an optional domain filter (e.g. techcrunch.com). One row per topic. Skip the header row and skip any row where column A is empty.

Step 2. For each row, call Octen AI Search with the topic from column A as the query. Apply a 24-hour time filter so results are from the last day only. If column B has a value, apply it as a domain filter so results are limited to that site. Request 5 results per topic and enable highlights so each result returns a short snippet.

Step 3. Format the combined results as a single Slack mrkdwn message. Put the run date at the top (e.g. *Topic digest — Jun 18*, but without em dashes, use a colon or period). Then for each topic that returned results, render the topic as a bold section header followed by up to 5 bullet items. Each bullet should be the result title rendered as a Slack hyperlink to the source URL, with the Octen highlight snippet on the next line underneath. Skip any topic that returned zero results so the digest stays tight.

Step 4. Use Slack Send a Message to post the digest to the configured channel.

If every topic returns zero results, post a short message saying there is no fresh news today rather than skipping the post entirely.

Services to use: Google Sheets for the tracking list read, Octen AI for the per-topic web search with time and domain filters, Slack for the digest message. Workflow type is code with discrete deterministic nodes (sheet read, per-row Octen search loop, format, slack post). No branching agent reasoning required. Do not use em dashes anywhere in the message text.

Related prompts

Explore more prompts
Call overdue Xero customers with an AI collections agentLocal listing health board for every location you manageWin back LiveChat visitors whose chats went unansweredLet support send one-off Loops emails without an engineerStop cold emails to anyone with a live deal in PipedriveiMessage campaign console with pre-flight checks and delivery boardChat quality review board for LiveChat support leadsLinkedIn Ads budget pacing dashboard for every client accountFront desk appointment confirmation board for the next 3 daysGive your team Looker numbers without buying more seats