Automate news discovery & publishing with GPT-4, Google Search API & Slack
Ready for 3.0What this workflow does
This AI workflow has 12 nodes and runs on a schedule (every day at 07:00). Along the way it connects OpenAI, Slack, Google Sheets and OpenAI Chat Model. It also calls googleapis.com over HTTP.
How it runs
Trigger: On a schedule (every day at 07:00).
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; 1 tool (Get row(s) in sheet in Google Sheets)
- Search Recent Articles (HTTP Request): calls googleapis.com
- Extract Best Article (Code): runs custom JavaScript code
- Skip problems (Code): runs custom JavaScript code
- Generate Original Article (OpenAI): uses OpenAI
- Prepare Publishing Data (Code): runs custom JavaScript code
- Publish to CMS (HTTP Request): calls an HTTP API (POST)
- Log to Google Sheets (Google Sheets): append
- Send Slack Notification (Slack): uses Slack
Services it uses
HTTP calls to: googleapis.com
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 (9)
- Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest - Schedule Trigger
n8n-nodes-base.scheduleTrigger - OpenAI
@n8n/n8n-nodes-langchain.openAi - Slack
n8n-nodes-base.slack - Google Sheets
n8n-nodes-base.googleSheets - AI Agent
@n8n/n8n-nodes-langchain.agent - Google Sheets Tool
n8n-nodes-base.googleSheetsTool - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
From the author
🚀 Automate News Discovery & Publishing with GPT-4, Google Search API & Slack 🎯 Overview Automated content publishing system that discovers industry news, transforms it into original articles using GPT-4, and publishes across multiple channels with SEO…