HumationHuman + Automation
Back to Catalog

Automatically collect & process Google News articles to Google Sheets

SuSSuS
1412 views
2/3/2026
Data FilteringMergeTransformationFormstackCode
Official Page

Overview

This workflow automatically collects the latest articles from Google News RSS feeds, cleans and deduplicates them, and stores them neatly in a Google Sheet. It runs on a set schedule (every Monday at 09:00 by default) and helps you build a fresh pool of content ideas for newsletters, blogs, or social media.

What you can do with it

  • 🔎 Research faster – pull in fresh articles from multiple RSS sources without manual searching.
  • 🧼 Clean & normalize – extract the real article URL (instead of Google redirects), keep only the title, summary, and date.
  • 🗑 No duplicates – filter out empty or repeated entries before they ever reach your sheet.
  • 📊 Central storage – append all new, unique links into a Google Sheet for review or further automation.

How it works

  1. Trigger – Cron starts the flow every Monday at 09:00 (you can change the schedule).
  2. RSS Read – Fetches articles from multiple Google News queries (e.g., “AI”, “AI Automation”).
  3. Merge – Combines all feed results into one list.
  4. Set (Clean URL) – Extracts the real URL, title, summary, and publication date.
  5. Filter – Ensures only items with a valid title and URL continue.
  6. Unique by URL – Removes duplicate articles across feeds.
  7. Google Sheets Append – Saves new links into your chosen Sheet for review and later use.

Setup Instructions

  1. Import workflow into your n8n instance.
  2. Update RSS feeds:
    • Replace the example Google News RSS URLs (AI, AI Automation) with your own queries.
    • Format: 
      https://news.google.com/rss/search?q=YOUR_QUERY&hl=de&gl=DE&ceid=DE:de
  3. Connect Google Sheets:
    • Add your Google Sheets credentials.
    • Select the documentId (the spreadsheet) and sheetName (the tab) in the Append new Links node.
    • Recommended columns: date, title, url, summary.
  4. Adjust schedule:
    • In the Trigger: Montag 09:00 node, change the cron expression to daily or multiple times per day if you want.
  5. Run test:
    • Execute once manually.
    • Check your sheet for the first rows.

Tips & Extensions

  • ✅ Add more RSS Read nodes for additional sources (blogs, media outlets, niche topics).
  • ✅ Chain this workflow with an AI node (OpenAI/GPT) to automatically generate post ideas from the collected articles.
  • ✅ Notify yourself in Slack/Telegram when new articles are added.
  • ✅ Use a status column (Draft, Approved, Posted) to manage a simple content pipeline directly from the sheet.

👉 With this template you’ll never run out of content ideas – everything flows into one place, ready to inspire your next posts, newsletters, or campaigns.

Automatically Collect & Process Google News Articles to Google Sheets

This n8n workflow automates the process of collecting news articles from an RSS feed (like Google News), filtering them, and then preparing the data for storage or further processing. While the workflow currently focuses on data preparation, it lays the groundwork for easily integrating with services like Google Sheets to store the collected articles.

What it does

This workflow performs the following key steps:

  1. Triggers on a Schedule: The workflow starts automatically at predefined intervals.
  2. Reads RSS Feed: It fetches the latest articles from a specified RSS feed (e.g., a Google News RSS feed for a particular search query).
  3. Filters Articles: It filters the collected articles based on a configurable condition (e.g., checking for specific keywords in the article title or description).
  4. Edits Fields: It transforms and renames fields from the RSS feed items to a standardized format.
  5. Merges Data: It combines the original RSS feed data with the transformed data.
  6. Prepares for Google Sheets: It includes a placeholder node for Google Sheets, indicating where the processed article data would be written.
  7. Manages Item Lists: It includes a node for item list operations, which could be used for deduplication, sorting, or limiting the number of articles processed.

Prerequisites/Requirements

  • n8n Instance: A running n8n instance.
  • RSS Feed URL: The URL of an RSS feed you wish to monitor (e.g., from Google News).
  • Google Sheets Account (Optional): If you intend to save the data to Google Sheets, you will need a Google account with access to Google Sheets and an n8n Google Sheets credential configured.

Setup/Usage

  1. Import the Workflow:
    • Copy the provided JSON workflow.
    • In your n8n instance, go to "Workflows" and click "New".
    • Click the three dots in the top right corner and select "Import from JSON".
    • Paste the JSON content and click "Import".
  2. Configure the Cron Trigger:
    • Click on the "Cron" node.
    • Adjust the "Mode" and "Value" to set your desired schedule for the workflow to run (e.g., every hour, daily).
  3. Configure the RSS Read Node:
    • Click on the "RSS Read" node.
    • In the "URL" field, enter the RSS feed URL you want to monitor (e.g., https://news.google.com/rss/search?q=n8n+workflow&hl=en-US&gl=US&ceid=US:en).
  4. Configure the Filter Node:
    • Click on the "Filter" node.
    • Define your desired filtering conditions. For example, you might want to filter articles where the title contains a specific keyword.
  5. Configure the Edit Fields (Set) Node:
    • Click on the "Edit Fields (Set)" node.
    • Review and adjust the fields being set or renamed to match your desired output structure.
  6. Configure Google Sheets (Optional):
    • Click on the "Google Sheets" node.
    • Select your Google Sheets credential or create a new one if you haven't already.
    • Choose the "Append Row" operation and specify the "Spreadsheet ID" and "Sheet Name" where you want to store the data. Map the input fields from the previous nodes to the columns in your Google Sheet.
  7. Activate the Workflow:
    • Once configured, toggle the workflow to "Active" in the top right corner of the workflow editor.

The workflow will now run automatically based on your defined schedule, fetching and processing news articles.

Related Templates

Automate meeting transcription & minutes distribution with OpenAI and Google Drive

Automated Meeting Recording Transcription & Minutes Distribution Workflow Managing meeting recordings manually—downloading audio, transcribing it, summarizing key points, saving documents, and notifying the team—quickly becomes repetitive and inefficient. This workflow eliminates all of those manual steps by automatically detecting new audio files uploaded to a designated Google Drive folder, converting them into high-quality transcripts using OpenAI, summarizing them into structured meeting minutes, transforming the content into a text file, uploading it back to Google Drive, and finally notifying a Chatwork room with the completed summary. What used to take hours can now be completed automatically within minutes, ensuring consistency, accuracy, and faster information sharing. Who’s it for This workflow is ideal for: Teams that need high-quality, client-ready meeting minutes generated automatically Project managers who require accurate summaries, decision tracking, and action items without manual effort Cross-functional teams handling multiple meetings and requiring structured, searchable documentation Organizations using Google Meet, Zoom, or Teams where recordings must be turned into polished minutes Anyone who wants a consistent, AI-assisted system that analyzes discussions, extracts insights, and formats them professionally By leveraging an advanced Meeting Minutes Generation System—capable of key-point extraction, noise reduction, speaker/topic organization, and review support—this workflow ensures that every meeting is transformed into a clean, structured, and highly usable document. --- How it works Audio file upload triggers the workflow When a new recording is uploaded to the designated Google Drive folder, the Google Drive Trigger immediately activates and begins processing. The audio file is downloaded The file is retrieved from Google Drive and prepared in binary format for accurate transcription. AI-powered transcription The audio is sent to OpenAI’s transcription engine, producing a complete and highly accurate transcript of the meeting. Generate structured, client-ready meeting minutes The transcript is processed by a specialized Meeting Minutes Generation System powered by a multi-step prompt. Instead of using a fixed template, the system intelligently analyzes the transcription and automatically generates a professionally structured document using the following capabilities: Extraction of key points while removing irrelevant conversation Organization of content by speaker, topic, and logical flow Automatic construction of headings and document structure Draft generation based on client-facing writing standards Review-support logic that allows refinement and improved readability Task-based orchestration (ingestion → key-point extraction → draft generation → review → final approval) Because the system dynamically determines the optimal structure, the resulting minutes adapt to the content of each meeting rather than following a rigid set of categories. If certain information cannot be derived from the transcript, the system will appropriately leave it out rather than forcing placeholder sections. Convert the minutes into a file The structured minutes are converted into a .txt or .docx document, ready for submission or archival. Upload the finalized document The completed meeting minutes are uploaded to a specific Google Drive folder and saved using a timestamped filename. Notify Chatwork A formatted notification—including the summarized content—is automatically posted to a Chatwork room, ensuring immediate team visibility. --- How to set up Import the workflow into your n8n environment. Authenticate Google Drive and select the folder to monitor for new recordings. Connect your OpenAI API keys for both transcription and structured minutes generation. Specify the Google Drive folder where the finished documents should be stored. Add your Chatwork API token and room ID for automated notifications. Upload a sample audio file to confirm the full end-to-end pipeline works correctly. --- Requirements n8n instance (cloud or self-hosted) Google Drive account with appropriate folder permissions OpenAI API credentials Chatwork API token Supported audio formats like mp3, wav, m4a, etc. --- How to customize the workflow Modify the minutes-generation prompt to reflect your organization’s preferred format Add Slack, Teams, or Discord notifications in addition to Chatwork Route different types of meetings to different folders or templates Save transcript and structured minutes separately for compliance or analysis Log metadata or decisions into Google Sheets or project management tools Store minutes in a vector database to enable semantic search across past meetings Attach the final document directly as a file in Chatwork Extend the system to support revision cycles, reviewer comments, or approval workflows

Yuki HirotaBy Yuki Hirota
262

Auto-send FireFlies meeting summaries via email using Gemini 2.5 Pro

This workflow automatically processes Fireflies.ai meeting recap emails, extracts the meeting transcript, generates a structured summary email, and sends it to a designated recipient. --- Key Advantages ✅ Full Automation of Meeting Summaries The workflow eliminates all manual steps from receiving the Fireflies email to sending a polished summary. This ensures: No delays No forgotten recaps No repetitive manual tasks ✅ Accurate Extraction of Meeting Information Using AI-based information extraction and custom parsing, the workflow reliably identifies: The correct meeting link The Fireflies meeting ID Relevant transcript data This avoids human error and ensures consistency. ✅ High-Quality, AI-Generated Email Summaries The Gemini-powered summary generator: Produces well-structured, readable emails Includes decisions, action items, and discussion points Automatically crafts a professional subject line Uses real content (no placeholders) This results in clear, usable communication for recipients. ✅ Robust Error-Free Data Handling The workflow integrates custom JavaScript steps to: Parse URLs safely Convert AI responses into valid JSON Ensure correct formatting before email delivery This guarantees the message is always properly structured. ✅ Professional Formatting By converting Markdown to HTML, the summary: Is visually clear Displays well on all email clients Enhances readability for recipients ✅ Easily Scalable and Adaptable The workflow can be expanded to: Send summaries to multiple recipients Add storage (e.g., Google Drive) Trigger based on additional conditions Integrate with CRMs or project management tools --- How It Works Trigger The workflow starts with a Gmail Trigger that checks for new emails with the subject "Your meeting recap" from fred@fireflies.ai every hour. Email Processing When a matching email is found, the workflow retrieves the full email content and extracts the meeting recap URL using an Information Extractor node powered by OpenAI GPT-4.1-mini. Meeting ID Extraction A Code Node extracts the meeting ID from the Fireflies URL (between :: and ?) for use in the next step. Transcript Fetching The meeting ID is sent to the Fireflies Node, which retrieves the full transcript and summary data (short summary, short overview, and full overview). AI-Powered Email Generation The meeting summary data is passed to a Google Gemini node, which generates a complete meeting summary email with a subject line and body in JSON format. Data Formatting The raw JSON output is parsed in a Code Node, and the email body is converted from Markdown to HTML using the Markdown Node. Email Delivery Finally, the email is sent via Gmail with the AI-generated subject and HTML body. --- Set Up Steps Configure Credentials Set up Gmail OAuth2 credentials for email triggering and sending. Add Fireflies.ai API credentials for fetching transcripts. Configure OpenAI and Google Gemini API keys for AI processing. Adjust Email Filters Update the Gmail Trigger filters (subject and sender) if Fireflies.ai uses a different sender or subject format. Customize Output Email Modify the recipient email in the Send email node to the desired address. Optional: Modify AI Prompts Adjust the system prompts in the Information Extractor and Email Agent nodes to change extraction behavior or email tone. Activate Workflow Ensure the workflow is set to Active in n8n, and test it by sending a sample Fireflies recap email to your connected Gmail account. --- Need help customizing? Contact me for consulting and support or add me on Linkedin.

DavideBy Davide
136

Generate short-form clips from YouTube videos with GPT-4o, Grok & Airtable

This n8n template demonstrates how to automate YouTube content repurposing using AI. Upload a video to Google Drive and automatically generate transcriptions, A/B testable titles, AI thumbnails, short-form clips with captions, and YouTube descriptions with chapter timestamps. Use cases include: Content creators who publish 1-2 long-form videos per week and need to extract 5-10 short-form clips, YouTube agencies managing multiple channels, or automation consultants building content systems for clients. Good to know Processing time is approximately 10-15 minutes per video depending on length Cost per video is roughly $1.00 (transcription $0.65, AI generation $0.35) YouTube captions take 10-60 minutes to generate after upload - the workflow includes automatic polling to check when captions are ready Manual steps still required: video clipping (using provided timestamps), social media posting, and YouTube A/B test setup How it works When a video is uploaded to Google Drive, the workflow automatically triggers and creates an Airtable record The video URL is sent to AssemblyAI (via Apify) for transcription with H:MM:SS.mmm timestamps GPT-4o-mini analyzes the transcript and generates 3 title variations optimized for A/B testing When you click "Generate thumbnail" in Airtable, your prompt is optimized and sent to Kie.ai's Nano Banana Pro model with 2 reference images for consistent branding After uploading to YouTube, the workflow polls YouTube's API every 5 minutes to check if auto-generated captions are ready Once captions are available, click "Generate clips" and Grok 4.1 Fast analyzes the transcript to identify 3-8 elite clips (45+ seconds each) with proper start/end boundaries and action-oriented captions GPT-4o-mini generates a YouTube description with chapter timestamps based on the transcript All outputs are saved to Airtable: titles, thumbnail, clip timestamps with captions, and description How to use Duplicate the provided Airtable base template and connect it to your n8n instance Create a Google Drive folder for uploading edited videos After activating the workflow, copy webhook URLs and paste them into Airtable button formulas and automations Upload your edited video to the designated Google Drive folder to trigger the system The workflow automatically generates titles and begins transcription Add your thumbnail prompt and 2 reference images to Airtable, then click "Generate thumbnail" Upload the video to YouTube as unlisted, paste the video ID into Airtable, and check the box to trigger clip generation Use the provided timestamps to manually clip videos in your editor Copy titles, thumbnail, clips, and description from Airtable to publish across platforms Requirements Airtable account (Pro plan recommended for automations) Google Drive for video upload monitoring Apify account for video transcription via AssemblyAI actor OpenAI API key for title and description generation (GPT-4o-mini) OpenRouter API key for clip identification (Grok 4.1 Fast) Kie.ai account for AI thumbnail generation (Nano Banana Pro model) YouTube Data API credentials for caption polling Customising this workflow Tailor the system prompts to your content niche by asking Claude to adjust them without changing the core structure Modify the clip identification criteria (length, caption style, number of clips) in the Grok prompt Adjust thumbnail generation style by updating the image prompt optimizer Add custom fields to Airtable for tracking performance metrics or additional metadata Integrate with additional platforms like TikTok or Instagram APIs for automated posting

JordanBy Jordan
946