AutomationMart
Home/Browse/Aggregate news articles from NewsAPI, Mediastack & CurrentsAPI into database
n8n

Aggregate news articles from NewsAPI, Mediastack & CurrentsAPI into database

n8nn8n29 modulesv1.0
AirtableGoogle Sheets

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 -

At a glance

Aggregate news articles from NewsAPI, Mediastack & CurrentsAPI into database is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects Airtable, Google Sheets. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Airtable, Google Sheets
Modules
29
Price
Free
Version
v1.0
Aggregate news articles from NewsAPI, Mediastack & CurrentsAPI into database workflow diagram

About this workflow

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. 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 articlelimit in: - newsapi.org categories - mediastack categories - currentsapi config

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Import Breeze.pm tasks automatically in Google Sheets

Every time a new task is created in Breeze.pm, Make will automatically add a new row in Google Sheets. The templates uses [this example spreadsheet](https://docs.google.com/spreadsheets/d/1JIm5CRSC6GWWZl3fsfP6pZol2cxFepuj8fSjV-R1btM/edit?usp=sharing).

Free

Automate responses to business emails with Make AI Tools and Google Sheets (draft emails)

Leverage the power of Make AI Tools and Google Sheets to automate responses for business emails, improve workflow, save time, and enhance customer communications. This automation creates a draft email of the response for you to review before forwarding. Please note: While in open beta, Make AI Tools has a 10m input and 10m output token limit.

Free

Automate Facebook page token renewal with data tables storage

Get Long-Lived Facebook Page Access Token with Data Table > Set up n8n self-hosted via Tino.vn VPS — use code VPSN8N for up to 39% off (affiliate link). Good to Know This workflow automatically solves the common issue of Facebook Page Access Tokens expiring. It proactively renews your Page Tokens and stores them in an n8n Data Table. It runs every two months, ensuring your Page Access Tokens remain valid. This guarantees seamless and uninterrupted automation for all your Facebook API integrat

Free

CYBERPULSE AI RedOps: Role-based LinkedIn profile discovery with Google OSINT

Description: Automates public profile discovery for CISO, CEO, and other key roles using Google Programmable Search. Extracts LinkedIn profile links, names, and timestamps to a structured Google Sheet for OSINT, exposure analysis, or Red Team prep. Who’s It For: Red Teams planning phishing simulations OSINT investigators and social engineers Cybersecurity trainers mapping exposure risk How It Works This workflow simulates role-based OSINT (Open Source Intelligence) by performing automated Linked

Free

Create expenses in Earned Value from data in a Google Sheets spreadsheet

When a new row is created in a Google Sheets spreadsheet, a new expense is created in Earned Value.

Free

Automated job applications & status tracking with LinkedIn, Indeed & Google Sheets

Apply to jobs automatically from Google Sheets with status tracking Who's it for Job seekers who want to streamline their application process, save time on repetitive tasks, and never miss following up on applications. Perfect for anyone managing multiple job applications across different platforms. What it does This workflow automatically applies to jobs from a Google Sheet, tracks application status, and keeps you updated with notifications. It handles the entire application lifecy

Free

Natural language to SQL converter for Google Sheets with GPT-4o

This n8n workflow template creates an intelligent data analysis system that converts natural language questions into Google Sheets SQL queries using OpenAI's GPT-4o model. The system generates proper Google Sheets query URLs and executes them via HTTP requests for efficient data retrieval. What This Workflow Does - Natural Language to SQL: Converts user questions into Google Sheets SQL syntax - Direct HTTP Queries: Bypasses API limits by using Google Sheets' built-in query functionality - Column

Free

Generate Financial Risk Reports 📈 from ElevenLabs interviews 🎙️using OpenAI

This workflow automates the process of receiving a post-call audio file and transcription from ElevenLabs, processing them, and generating a financial risk report. --- Key Advantages 1. ✅ End-to-End Automation The workflow fully automates the process from raw input (audio/transcript) to final delivery (email report), eliminating manual intervention. 2. ✅ AI-Powered Decision Making It leverages language models to: Analyze qualitative interview responses Convert them into quantitative scores Pr

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free