Post a daily multi-topic news digest to Slack and Google Sheets with Webz.io and GPT-4.1-mini

Description

Quick overview This workflow runs daily at 08:00 to search Webz.io news for multiple topics, uses OpenAI GPT-4.1-mini to curate a structured digest, posts the digest to Slack, and archives each selected story to Google Sheets. How it works Runs every morning at 08:00 based on the workflow timezone. Reads the digest configuration (topics list, lookback days, article count, and Slack channel) and splits it into one item per topic. For each topic, uses OpenAI GPT-4.1-mini to call the Webz.io news search tool and select up to five significant articles, returning structured fields (headline, publisher, why it matters, URL). Merges all topic results, removes duplicate URLs across topics, and formats a single Slack-ready digest message while building a per-story archive dataset. If there are no stories across all topics, the workflow stops without posting or archiving anything. If there are stories, posts the digest to the configured Slack channel and appends one row per story to Google Sheets. Setup Add an OpenAI credential to the OpenAI Chat Model node (or replace the model with another tool-calling chat model). Create a Bearer Auth credential with your Webz.io API token and attach it to the Webz.io news search node. Add a Slack credential with chat:write and channels:read, invite the bot to your target channel, and set the channel name in Digest settings. Add a Google Sheets OAuth credential, select the target spreadsheet and sheet, and ensure it has headers: date, topic, headline, publisher, why_it_matters, url. Update Digest settings with your comma-separated topics, lookback window, and article count, and set Workflow Settings → Timezone so the 08:00 schedule matches your local time. An n8n automation workflow template by Webz.io.

Community Metrics

Categories

• Automation
• AI

Tags

• n8n
• workflow
• google-sheets
• slack
• code
• ai-agent
• openai-chat-model
• structured-output-parser
• mcp-client-tool

Capabilities

• 7 nodes

Information