Create daily AI news LinkedIn posts using OpenAI, NewsAPI, Gmail and Google Sheets
Ready for 3.0What this workflow does
This AI workflow has 24 nodes and runs on a schedule (every day at 20:00). Along the way it connects OpenAI, LinkedIn, Google Sheets and Gmail. It also calls newsapi.org over HTTP.
How it runs
Trigger: On a schedule (every day at 20:00).
- Fetch AI News from NewsAPI (HTTP Request): calls newsapi.org
- Extract Articles Array (Edit Fields (Set)): sets 1 field: articles
- Split Articles (Split Out): splits a list into separate items
- Limit: keeps the first few items
- Loop Over Articles (Loop Over Items (Split in Batches)): loops over the items in batches
- Aggregate Summaries (Code): runs custom JavaScript code
- Summarize Article with GPT-4o-mini (OpenAI): uses OpenAI
- AI Article Selector (OpenAI): uses OpenAI
- Add Summary to Article (Edit Fields (Set)): sets 3 fields: summary, title, url
- Create LinkedIn Post (OpenAI): uses OpenAI
…plus 13 more steps. See the full node list below.
Services it uses
HTTP calls to: newsapi.org
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 (13)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - HTTP Request
n8n-nodes-base.httpRequest - Edit Fields (Set)
n8n-nodes-base.set - Split Out
n8n-nodes-base.splitOut - Limit
n8n-nodes-base.limit - Code
n8n-nodes-base.code - OpenAI
@n8n/n8n-nodes-langchain.openAi - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - If
n8n-nodes-base.if - LinkedIn
n8n-nodes-base.linkedIn - Google Sheets
n8n-nodes-base.googleSheets - Gmail
n8n-nodes-base.gmail - Merge
n8n-nodes-base.merge
From the author
Quick overview This workflow runs nightly, pulls AI news from NewsAPI, uses OpenAI to summarize and select a top story, generates a LinkedIn post and image, and emails you for approval before publishing to LinkedIn and logging the result to Google Sheets. How…