Summarize regulatory news from NewsAPI with Gemini and Google Sheets plus error alerts

News Intelligence Workflow using NewsAPI, AI Model, Google Sheets & Error Alerts

This workflow automatically fetches news articles from NewsAPI, processes them using an AI model to generate summaries and key regulatory changes and stores both raw and processed data into Google Sheets. It also includes centralized error handling with email alerts for monitoring failures.

Quick Implementation Steps

1. [Signup / Login to your n8n account](https://n8n.partnerlinks.io/om1efg2qgvwi) 2. Add your NewsAPI key in the configuration node. 3. Set your Google Sheet ID and ensure required columns exist. 4. Update the search query (e.g., regulation, finance, etc.). 5. Configure email recipient for error alerts (optional). 6. Execute using the Manual Trigger node. 7. Review results in Google Sheets.

What It Does

This workflow automates the process of collecting and analyzing news articles. It starts by fetching the latest news based on a defined keyword using NewsAPI. The fetched data is cleaned, sorted and filtered to ensure only relevant and valid articles are processed further.

Each article is then processed individually in a controlled loop to avoid API rate limits. The workflow stores raw article data into Google Sheets for reference and backup. It then uses an AI model to generate a concise summary and extract key regulatory or policy changes from each article.

Finally, the structured AI output is formatted and updated back into the same Google Sheet. The workflow also includes a high-level error handling mechanism that collects errors from multiple nodes, formats them and sends email alerts for easier monitoring and debugging.