Turn a news page without an RSS feed into usable, tagged content. Each week the system collects the newest posts, creates a short summary, extracts key technical terms, and saves everything in a structured database. Teams use it for content briefs, reports, and research with almost no manual work.

A weekly schedule loads the main news page, pulls all links and dates with CSS selectors, and splits the results into single items. Links and dates are matched by position, then a code step keeps only recent posts. For each new link, the page is fetched, the title and body are extracted, and OpenAI writes a short summary and three keywords. The final records are merged with the original date and link, then stored in NocoDB for easy filtering and sharing.

Setup needs working CSS selectors, an OpenAI API key, and a NocoDB API token. Expect big time savings on research and content prep, plus more consistent tagging. It suits marketing and comms teams that track industry updates, vendor news, or competitor activity on a weekly cycle.

• Weekly schedule runs the collection without manual effort
• HTML extraction grabs links, dates, titles, and content with CSS selectors
• Array to item conversion enables clean looping over each post
• Merge by position pairs dates with the right links
• Code filter keeps only posts from the last set number of days
• HTTP requests fetch each post page for detailed parsing
• OpenAI generates a short summary and three technical keywords
• NocoDB write stores date, link, title, summary, and keywords in a table

• Reduce weekly news collection from 3 hours to 10 minutes
• Automate 90 percent of research and tagging work
• Improve tagging accuracy by standardizing keywords
• Create consistent short summaries for fast team reviews
• Store posts in one place for search and reporting

1. Import the template into n8n: Create a new workflow in n8n > Click the three dots menu > Select 'Import from File' > Choose the downloaded JSON file.
2. You'll need accounts with OpenAI and NocoDB. See the Tools Required section above for links to create accounts with these services.
3. In n8n, open the Schedule Trigger node and set the weekly run time that fits your reporting schedule.
4. Open the HTTP Request node that loads the news listing page and confirm the target URL is correct for your site.
5. Open the HTML extract nodes and update the CSS selectors for links, dates, title, and content based on your target page structure. Use your browser Inspect tool to find the right selectors.
6. Check the Item Lists nodes that create single items to ensure arrays are split into one item per link and one item per date.
7. Open the Merge nodes that combine links and dates by position and confirm the outputs line up correctly.
8. Open the Code node that filters recent posts and set the date range you want, such as 7 days.
9. In the OpenAI nodes, double click, then on the Credential to connect with dropdown, click Create new credential, and enter your OpenAI API key from the OpenAI account API page.
10. In the NocoDB node, double click, then on the Credential to connect with dropdown, click Create new credential, and add your NocoDB API token and base URL from your NocoDB workspace.
11. Map the NocoDB fields to include date, link, title, summary, and keywords. Create columns in your NocoDB table if they do not exist yet.
12. Run the workflow once manually. Check each step’s output. If you see empty results, adjust CSS selectors. If dates do not match links, review the merge by position step.
13. Review the summaries and keywords in NocoDB. If the tone or length is off, tweak the OpenAI prompts in the nodes.
14. Turn the workflow on and monitor the next weekly run. If the site layout changes, update the CSS selectors and re test.