Scrape and summarize posts of a news site without RSS feed using AI and save them to a NocoDB

n8n template #2180

Summary

The News Site from Colt, a telecom company, does not offer an RSS feed, therefore web scraping is the choice to extract and process the news. The goal is to get only the newest posts, a summary of each post and their respective (technical) keywords. Note that the news site offers the links to each news post, but not the individual news. We collect first the links and dates of each post before extracting the newest ones. The result is sent to a SQL database, in this case a NocoDB database. This process happens each week thru a cron job. Requirements: Basic understanding of CSS selectors and how to get them via browser (usually: right click → inspect) ChatGPT API account - normal account

How to set it up

Open template #2180 on n8n.io and click Use for free, or copy the template JSON and paste it onto an empty canvas in n8n.
Create 2 credentials under Credentials → Add credential: NocoDB, OpenAI. Then open each of those nodes and pick the credential.
Check the model in the OpenAI node. The template may point at a model your account can't use; swap it for one you have access to.
Click Execute workflow and step through each node's output to confirm the data looks right.
Toggle the workflow to Active so its trigger runs on its own.

Hand off to your agent

Prompt

Help me set up the n8n workflow "Scrape and summarize posts of a news site without RSS feed using AI and save them to a NocoDB" (https://n8n.io/workflows/2180). It uses: HTTP Request, NocoDB, Code, OpenAI, HTML. Import the template JSON into my n8n instance, list every credential I need to create, and walk me through testing it.

Paste into Claude Code and it will do the rest.

Apps and nodes

HTTP RequestNocoDBCode OpenAI HTML

Questions

Yes. Askan published it free on n8n.io, and it has 26K views. It runs on n8n Cloud or a self-hosted n8n instance.

NocoDB, OpenAI. The other 3 nodes are built into n8n.

Similar workflows

NameViews