Collect & Summarize Multilingual News with NewsAPI, OpenAI & Google Sheets
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 Create a Google Sheet with two tabs: 01_Input (columns: Keyword, SearchRequired) 02_Output (columns: Date, Keyword, Summary, URL) Enter your own Google Sheet ID and tab names in the workflow. Add your NewsAPI key in the HTTP Request nodes. Connect your OpenAI account (or deactivate the summarization node if not needed). 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.
Related Templates
AI SEO Readability Audit: Check Website Friendliness for LLMs
Who is this for? This workflow is designed for SEO specialists, content creators, marketers, and website developers who ...
Task Deadline Reminders with Google Sheets, ChatGPT, and Gmail
Intro This template is for project managers, team leads, or anyone who wants to automatically remind teammates of tasks ...
🤖 Build Resilient AI Workflows with Automatic GPT and Gemini Failover Chain
This workflow contains community nodes that are only compatible with the self-hosted version of n8n. How it works This...
🔒 Please log in to import templates to n8n and favorite templates
Workflow Visualization
Loading...
Preparing workflow renderer
Comments (0)
Login to post comments