Collect & summarize multilingual news with NewsAPI, OpenAI & Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
Nodes used (8)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Merge
n8n-nodes-base.merge - OpenAI
@n8n/n8n-nodes-langchain.openAi - Code
n8n-nodes-base.code - Edit Fields (Set)
n8n-nodes-base.set
What it does
How it works This workflow automatically collects the latest news articles from both English and Japanese sources using NewsAPI, summarizes them with OpenAI, and appends the results into a Google Sheet. The summaries are concise (about 50 characters) in Japanese, making it easy to review news highlights at a glance. Set up steps 1. Create a Google Sheet with two tabs: - 01Input (columns: Keyword, SearchRequired) - 02Output (columns: Date, Keyword, Summary, URL) 2. Enter your own Google Sheet ID and tab names in the workflow. 3. Add your NewsAPI key in the HTTP Request nodes. 4. Connect your OpenAI account (or deactivate the summarization node if not needed). 5. Run the workflow manually or use the daily schedule trigger at 13:00. This template is ready to use with minimal changes. Sticky notes inside the workflow provide extra guidance.