Aggregate news articles from NewsAPI, Mediastack & CurrentsAPI into database

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

What this workflow does

This workflow has 29 nodes and runs on a schedule (every day at 06:00) (plus 3 other triggers). Along the way it connects NocoDB. It also calls newsapi.org, api.currentsapi.services and api.mediastack.com over HTTP.

How it runs

Trigger: On a schedule (every day at 06:00) (plus 3 other triggers).

1. currentsapi config (Edit Fields (Set)): sets 2 fields: article_limit, category
2. mediastack categories (Edit Fields (Set)): sets 2 fields: article_limit, categories
3. call newsapi.org - Top Headlines (HTTP Request): calls newsapi.org
4. newsapi.org categories (Edit Fields (Set)): sets 2 fields: article_limit, categories
5. call currentsapi (HTTP Request): calls api.currentsapi.services
6. Itemize Mediastack Categories (Code): runs custom JavaScript code
7. Split Out: splits a list into separate items
8. Itemize Newsapi Categories (Code): runs custom JavaScript code
9. Split Out: splits a list into separate items
10. Loop Over Mediastack (Loop Over Items (Split in Batches)): loops over the items in batches

…plus 15 more steps. See the full node list below.

Services it uses

NocoDB

HTTP calls to: newsapi.org, api.currentsapi.services, api.mediastack.com

Before you upgrade to n8n 3.0

Nodes used (8)

• Split Outn8n-nodes-base.splitOut
• Edit Fields (Set)n8n-nodes-base.set
• NocoDBn8n-nodes-base.nocoDb
• HTTP Requestn8n-nodes-base.httpRequest
• Schedule Triggern8n-nodes-base.scheduleTrigger
• Coden8n-nodes-base.code
• Waitn8n-nodes-base.wait
• Loop Over Items (Split in Batches)n8n-nodes-base.splitInBatches

From the author

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…

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