workflows.fit
Back to n8n workflows
n8n templateFreeBy Joel Gamble

Aggregate news articles from NewsAPI, Mediastack & CurrentsAPI into database

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). U...

DevelopmentCore NodesData & StorageSticky NoteSplit OutSetNoco Db
Loading interactive preview...

Template notes

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.