G
GTM Vault
Browse
  • Dashboard
    • Automations
    • Skills
    • Prompts
    • Makers
  • Sign in
All Automations

Aggregate news articles from NewsAPI, Mediastack & CurrentsAPI into database

Automatically aggregates news articles from NewsAPI, Mediastack, and CurrentsAPI into a centralized database for content pipelines.

workflow
Joel Gambleby Joel Gambleon n8n
Nodes

34

Triggers

4

Platform

n8n

Tech Stack
NO
Noco Db
How It Works

This workflow schedules regular pulls from three major news APIs, normalizes article data into a consistent schema, and stores results in NocoDB. Perfect for automated content aggregation, research workflows, and editorial management systems.

1

Schedule news API calls

Triggers automated requests to NewsAPI, Mediastack, and CurrentsAPI based on configured schedule intervals.

2

Fetch articles from multiple sources

Retrieves news articles from each API provider using specified categories and article limits.

3

Normalize article data

Transforms each API response into a consistent schema with standardized fields for title, content, author, and metadata.

4

Store articles in database

Creates new records in NocoDB with normalized article data including source, category, and publication details.

What You'll Need

Attached Files
workflow.json
Noco Db
  • NewsAPI account with API key
  • Mediastack API access token
  • CurrentsAPI account credentials
  • NocoDB instance with configured table schema
  • Database table with required fields for article storage

This automation has 3 configurable settings you'll customize during setup.