Aggregate News Articles from NewsAPI, Mediastack & CurrentsAPI into Database

Description

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 API_KEY in URL
call newsapi.org - categories → update API_KEY
call mediastack → update "ACCESS_KEY" in JSON
call currentsapi → update "API_KEY" 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
(source_category, title, summary, author, sources, content, images, publisher_date, 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 article_limit in:
newsapi.org categories
mediastack categories
currentsapi config