📊 Aggregate news articles from NewsAPI, Mediastack & CurrentsAPI into database

⚡ 3,767 views · 📊 Market Research & Insights

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

🔗 Nodes Used

HTTP Request, NocoDB, Schedule Trigger

📥 Import

Download workflow.json and import into n8n: Workflow menu → Import from File

📖 Importing guide · 🔑 Credential setup