HumationHuman + Automation
Back to Catalog

Collect & summarize multilingual news with NewsAPI, OpenAI & Google Sheets

Supira Inc.Supira Inc.
387 views
2/3/2026
PostgreSQLJSONData TransformationETLAPI Integration
Official Page

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:
    • 01_Input (columns: Keyword, SearchRequired)
    • 02_Output (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.

Collect and Summarize Multilingual News with NewsAPI, OpenAI, and Google Sheets

This n8n workflow automates the process of fetching the latest news from NewsAPI, summarizing articles using OpenAI's GPT models, and storing the summarized content in a Google Sheet. It's designed to help you stay informed on specific topics by providing concise, AI-generated summaries of news articles, potentially across multiple languages.

What it does

This workflow performs the following key steps:

  1. Triggers on a Schedule: The workflow starts at predefined intervals (e.g., daily, hourly) to fetch the latest news.
  2. Fetches News Articles: It makes an HTTP request to the NewsAPI to retrieve news articles based on configured parameters (e.g., keywords, language, sources).
  3. Filters Articles: An 'If' node checks if any articles were returned by the NewsAPI. If no articles are found, the workflow stops.
  4. Prepares Data for OpenAI: An 'Edit Fields (Set)' node prepares the article data for summarization by OpenAI, likely extracting the article content.
  5. Summarizes Articles with OpenAI: For each article, it sends the content to OpenAI to generate a concise summary using a specified GPT model.
  6. Combines Original and Summarized Data: A 'Merge' node combines the original article data with the AI-generated summaries.
  7. Formats Data for Google Sheets: A 'Code' node likely formats the combined data into a structure suitable for insertion into a Google Sheet.
  8. Stores Data in Google Sheets: The processed and summarized news articles are appended as new rows to a designated Google Sheet.

Prerequisites/Requirements

To use this workflow, you will need:

  • n8n Instance: A running n8n instance (cloud or self-hosted).
  • NewsAPI Account & API Key: To fetch news articles.
  • OpenAI Account & API Key: To use OpenAI's GPT models for summarization.
  • Google Account: With access to Google Sheets to store the summarized news.
  • Google Sheets Credential in n8n: Configured to allow n8n to write to your Google Sheets.
  • OpenAI Credential in n8n: Configured with your OpenAI API Key.
  • HTTP Request (NewsAPI) Credential/API Key: Configured to allow n8n to make requests to NewsAPI.

Setup/Usage

  1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
  2. Configure Credentials:
    • Set up your Google Sheets credential.
    • Set up your OpenAI credential.
    • Ensure your NewsAPI key is correctly configured within the HTTP Request node (likely in the headers or query parameters).
  3. Customize NewsAPI Request:
    • In the HTTP Request node, adjust the NewsAPI URL and parameters (e.g., q for keywords, language, sources) to fetch news relevant to your interests.
  4. Configure OpenAI Summarization:
    • In the OpenAI node, you can adjust the model (gpt-3.5-turbo, gpt-4, etc.) and the prompt used for summarization if needed.
  5. Specify Google Sheet:
    • In the Google Sheets node, specify the Spreadsheet ID and Sheet Name where you want to store the news. Ensure the sheet has appropriate headers (e.g., "Title", "Summary", "URL", "Published At").
  6. Activate the Workflow: Once configured, activate the Schedule Trigger node to run the workflow automatically at the set intervals. You can also test it manually by clicking "Execute Workflow".

Related Templates

AI-powered code review with linting, red-marked corrections in Google Sheets & Slack

Advanced Code Review Automation (AI + Lint + Slack) Who’s it for For software engineers, QA teams, and tech leads who want to automate intelligent code reviews with both AI-driven suggestions and rule-based linting — all managed in Google Sheets with instant Slack summaries. How it works This workflow performs a two-layer review system: Lint Check: Runs a lightweight static analysis to find common issues (e.g., use of var, console.log, unbalanced braces). AI Review: Sends valid code to Gemini AI, which provides human-like review feedback with severity classification (Critical, Major, Minor) and visual highlights (red/orange tags). Formatter: Combines lint and AI results, calculating an overall score (0–10). Aggregator: Summarizes results for quick comparison. Google Sheets Writer: Appends results to your review log. Slack Notification: Posts a concise summary (e.g., number of issues and average score) to your team’s channel. How to set up Connect Google Sheets and Slack credentials in n8n. Replace placeholders (<YOURSPREADSHEETID>, <YOURSHEETGIDORNAME>, <YOURSLACKCHANNEL_ID>). Adjust the AI review prompt or lint rules as needed. Activate the workflow — reviews will start automatically whenever new code is added to the sheet. Requirements Google Sheets and Slack integrations enabled A configured AI node (Gemini, OpenAI, or compatible) Proper permissions to write to your target Google Sheet How to customize Add more linting rules (naming conventions, spacing, forbidden APIs) Extend the AI prompt for project-specific guidelines Customize the Slack message formatting Export analytics to a dashboard (e.g., Notion or Data Studio) Why it’s valuable This workflow brings realistic, team-oriented AI-assisted code review to n8n — combining the speed of automated linting with the nuance of human-style feedback. It saves time, improves code quality, and keeps your team’s review history transparent and centralized.

higashiyama By higashiyama
90

Auto-reply & create Linear tickets from Gmail with GPT-5, gotoHuman & human review

This workflow automatically classifies every new email from your linked mailbox, drafts a personalized reply, and creates Linear tickets for bugs or feature requests. It uses a human-in-the-loop with gotoHuman and continuously improves itself by learning from approved examples. How it works The workflow triggers on every new email from your linked mailbox. Self-learning Email Classifier: an AI model categorizes the email into defined categories (e.g., Bug Report, Feature Request, Sales Opportunity, etc.). It fetches previously approved classification examples from gotoHuman to refine decisions. Self-learning Email Writer: the AI drafts a reply to the email. It learns over time by using previously approved replies from gotoHuman, with per-classification context to tailor tone and style (e.g., different style for sales vs. bug reports). Human Review in gotoHuman: review the classification and the drafted reply. Drafts can be edited or retried. Approved values are used to train the self-learning agents. Send approved Reply: the approved response is sent as a reply to the email thread. Create ticket: if the classification is Bug or Feature Request, a ticket is created by another AI agent in Linear. Human Review in gotoHuman: How to set up Most importantly, install the gotoHuman node before importing this template! (Just add the node to a blank canvas before importing) Set up credentials for gotoHuman, OpenAI, your email provider (e.g. Gmail), and Linear. In gotoHuman, select and create the pre-built review template "Support email agent" or import the ID: 6fzuCJlFYJtlu9mGYcVT. Select this template in the gotoHuman node. In the "gotoHuman: Fetch approved examples" http nodes you need to add your formId. It is the ID of the review template that you just created/imported in gotoHuman. Requirements gotoHuman (human supervision, memory for self-learning) OpenAI (classification, drafting) Gmail or your preferred email provider (for email trigger+replies) Linear (ticketing) How to customize Expand or refine the categories used by the classifier. Update the prompt to reflect your own taxonomy. Filter fetched training data from gotoHuman by reviewer so the writer adapts to their personalized tone and preferences. Add more context to the AI email writer (calendar events, FAQs, product docs) to improve reply quality.

gotoHumanBy gotoHuman
353

Daily cash flow reports with Google Sheets, Slack & Email for finance teams

Simplify financial oversight with this automated n8n workflow. Triggered daily, it fetches cash flow and expense data from a Google Sheet, analyzes inflows and outflows, validates records, and generates a comprehensive daily report. The workflow sends multi-channel notifications via email and Slack, ensuring finance professionals stay updated with real-time financial insights. 💸📧 Key Features Daily automation keeps cash flow tracking current. Analyzes inflows and outflows for actionable insights. Multi-channel alerts enhance team visibility. Logs maintain a detailed record in Google Sheets. Workflow Process The Every Day node triggers a daily check at a set time. Get Cash Flow Data retrieves financial data from a Google Sheet. Analyze Inflows & Outflows processes the data to identify trends and totals. Validate Records ensures all entries are complete and accurate. If records are valid, it branches to: Sends Email Daily Report to finance team members. Send Slack Alert to notify the team instantly. Logs to Sheet appends the summary data to a Google Sheet for tracking. Setup Instructions Import the workflow into n8n and configure Google Sheets OAuth2 for data access. Set the daily trigger time (e.g., 9:00 AM IST) in the "Every Day" node. Test the workflow by adding sample cash flow data and verifying reports. Adjust analysis parameters as needed for specific financial metrics. Prerequisites Google Sheets OAuth2 credentials Gmail API Key for email reports Slack Bot Token (with chat:write permissions) Structured financial data in a Google Sheet Google Sheet Structure: Create a sheet with columns: Date Cash Inflow Cash Outflow Category Notes Updated At Modification Options Customize the "Analyze Inflows & Outflows" node to include custom financial ratios. Adjust the "Validate Records" filter to flag anomalies or missing data. Modify email and Slack templates with branded formatting. Integrate with accounting tools (e.g., Xero) for live data feeds. Set different trigger times to align with your financial review schedule. Discover more workflows – Get in touch with us

Oneclick AI SquadBy Oneclick AI Squad
619