Create daily AI news briefings from Google Sheets with Claude, Notion, and Slack
Ready for 3.0What this workflow does
This AI workflow has 14 nodes and runs on a schedule (cron 0 7 * * 1-5). Along the way it connects Google Sheets, Anthropic Chat Model, Notion and Slack.
How it runs
Trigger: On a schedule (cron 0 7 * * 1-5).
- Configure Settings (Code): runs custom JavaScript code
- Read URL List from Sheets (Google Sheets): uses Google Sheets
- Limit: keeps the first few items
- Fetch Article Content (HTTP Request): calls an HTTP API
- Prepare Article Text (Code): runs custom JavaScript code
- Claude AI Chain (Basic LLM Chain): sends a prompt to an LLM, with model: Claude Model
- Parse Claude Briefing (Code): runs custom JavaScript code
- Save to Notion (Notion): uses Notion
- Aggregate: combines items into one
- Log to Google Sheets (Google Sheets): append
…plus 2 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (10)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets - Limit
n8n-nodes-base.limit - HTTP Request
n8n-nodes-base.httpRequest - Basic LLM Chain
@n8n/n8n-nodes-langchain.chainLlm - Anthropic Chat Model
@n8n/n8n-nodes-langchain.lmChatAnthropic - Notion
n8n-nodes-base.notion - Aggregate
n8n-nodes-base.aggregate - Slack
n8n-nodes-base.slack
From the author
Quick overview This scheduled workflow pulls article URLs from Google Sheets, scrapes each page, uses Anthropic Claude to generate a structured news briefing, saves results to Notion, posts a compiled digest to Slack, and appends a processing log back to…