News Intelligence Workflow using NewsAPI, AI Model, Google Sheets & 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 Signup / Login to your n8n account Add your NewsAPI key in the configuration node. Set your Google Sheet ID and ensure required columns exist. Update the search query (e.g., regulation, finance, etc.). Configure email recipient for error alerts (optional). Execute using the Manual Trigger node. 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. Who It's For Business analysts tracking regulatory updates Compliance and legal teams Data analysts and automation engineers News aggregation platforms Anyone looking to automate news monitoring and summarization Requirements To use this workflow, you need: n8n account NewsAPI account and API key Google Sheets account with OAuth credentials configured in n8n A Google Sheet with the following columns: Title Source Published_At Content Summary Key Changes (Optional) Gmail account connected for error alerts How It Works & Setup Instructions 1. Trigger the Workflow Uses Manual Trigger node for execution. Ideal for testing; can be extended later. 2. Configure Variables In Workflow Config & Variables node: Add newsApiKey Set searchQuery (default: regulation) Define maxArticlesToFetch Set loopWaitSeconds Add googleSheetId Configure API timeout and headers if needed 3. Fetch News Data HTTP Request Node** calls NewsAPI using: Query keyword Sorting (publishedAt) API key authentication 4. Preprocess Articles Code Node (Python)**: Sorts articles by date Filters invalid entries Extracts required fields (title, content, source, etc.) 5. Limit Articles Limit Node** restricts number of articles processed. 6. Store Raw Data SplitInBatches + Wait + Google Sheets (Append)**: Stores raw articles into the same sheet Adds delay to avoid rate limits 7. Validate & Loop IF Node** filters valid articles SplitInBatches** processes one article at a time 8. AI Processing AI Node**: Generates: Summary (max 60 words) Key regulatory changes Ensures strict structured output 9. Format Output Code Node (JavaScript)**: Extracts summary and key changes Cleans and structures AI output 10. Update Sheet Google Sheets (Update)**: Updates existing rows based on Title Adds Summary and Key Changes 11. Error Handling Errors from multiple nodes are: Collected via Merge Node Formatted using Set Node Delayed using Wait Node Sent via Email Node How To Customize Nodes Search Query** Change config.searchQuery to track different topics (e.g., AI, finance, crypto). Article Limit** Adjust config.maxArticlesToFetch to process more or fewer articles. Delay Timing** Modify config.loopWaitSeconds to control API rate limits. AI Prompt** Customize the prompt in AI node to extract different insights. Google Sheet Mapping** Add/remove columns based on your reporting needs. Add-ons (Enhancements) Replace Manual Trigger with: Cron (scheduled runs) Webhook (real-time trigger) Add Slack/Telegram alerts for summaries Store data in a database instead of Google Sheets Add sentiment analysis to articles Build a dashboard using BI tools Use Case Examples Regulatory monitoring for finance or legal industries Daily news digest automation for teams Competitive intelligence tracking Research support for analysts Content curation for blogs or newsletters There can be many more use cases depending on how you customize the workflow. Troubleshooting Guide | Issue | Possible Cause | Solution | |------|--------------|---------| | No articles fetched | Invalid API key | Verify NewsAPI key | | Empty AI output | Incorrect prompt format | Check AI node prompt | | Google Sheet not updating | Wrong Sheet ID or permissions | Verify Sheet ID and OAuth access | | Duplicate entries | Matching column misconfigured | Ensure Title is used as match key | | Workflow stops unexpectedly | API timeout or rate limits | Increase wait time or timeout settings | | No email alerts | Email not configured | Add recipient email in Gmail node | Need Help? If you need assistance setting up this workflow, customizing nodes or building advanced automation solutions, feel free to reach out to our n8n automation team at WeblineIndia. WeblineIndia specializes in building scalable automation workflows, AI integrations and business process solutions tailored to your needs. Whether you're looking to extend this workflow or create something entirely new, expert help is just a step away. An n8n automation workflow template by WeblineIndia.
WeblineIndia
web
free
Others in the same category, ranked by how often they are opened.
