Templates / Aggregate news articles from NewsAPI, Mediastack & CurrentsAPI into database

Aggregate news articles from NewsAPI, Mediastack & CurrentsAPI into database

Ready for 3.0

by Joel Gamble · 6,815 views · created 2025-12-07 · Market Research

Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.

Nodes used (8)

NocoDB

What it does

This workflow pulls news articles from NewsAPI, Mediastack, and CurrentsAPI on a scheduled basis. Each provider’s results are normalized into a consistent schema, then written into your database (NocoDB by default). Use case: automated aggregation of categorized news for content pipelines, research agents, or editorial queues. What You Must Update Before Running 1. API Keys Replace all placeholder keys: - call newsapi.org - Top Headlines → update APIKEY in URL - call newsapi.org - categories → update APIKEY - call mediastack → update "ACCESSKEY" in JSON - call currentsapi → update "APIKEY" param 2. Database Connection Workflow uses NocoDB to store results. You must: - Update the NocoDB API Token credential to your own - Ensure your table includes the fields used in the create operations (sourcecategory, title, summary, author, sources, content, images, publisherdate, etc.) If you prefer Google Sheets, Airtable, or another DB: - Replace each NocoDB node with your equivalent “create row” operation - The Set nodes already provide all normalized fields you need 3. Scheduling All schedulers are disabled by default. Enable the following so the workflow runs automatically: - NewsAPI – Top Headlines - NewsAPI – Categories - Mediastack - CurrentsAPI You may change the run times, but all four must be scheduled for the workflow to function as designed. What You Can Configure 1. Categories Defined in: - newsapi.org categories - mediastack categories Edit these arrays to pull only the categories you care about or to match your API plan limits. 2. Article Limits Adjust articlelimit in: - newsapi.org categories - mediastack categories - currentsapi config

View the original on n8n.io → Check your own copy

Get the weekly “what broke” email

New templates, newly broken ones, and n8n release changes. One short email a week.

Form not loading? Subscribe here.