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