Many brands publish news without an RSS feed. This flow checks a news page each week, pulls the newest posts, and saves titles, short summaries, keywords, dates, and links into a NocoDB table. It helps marketing and comms teams track updates and plan content faster.

On a weekly schedule, it loads the listing page, uses CSS selectors to grab post links and dates, splits the arrays into single items, and pairs each link with its date. A code step keeps only items from the last set number of days. It opens each link, scrapes the title and body, and sends the text to OpenAI. OpenAI returns a summary under 70 words and three technical keywords. Merge by position keeps fields aligned even when scraping arrays. The results are combined with the link and date, then written to NocoDB as clean records.

Setup needs correct CSS selectors, an OpenAI API key, and a NocoDB API token. Expect less manual tracking, quicker research, and a reliable archive for weekly reporting. Use it for press monitoring, competitor updates, and content planning with very little upkeep.

• Weekly schedule trigger runs on a set day and time
• HTTP request loads the news listing page for scraping
• HTML extraction pulls links and dates using CSS selectors
• Array to item steps turn selector outputs into single records
• Merge by position keeps the right date matched with the right link
• Code filter keeps only posts from the last chosen number of days
• Per link scraping pulls each post title and main content
• OpenAI creates a short summary and three technical keywords
• NocoDB node stores title, summary, keywords, date, and link

• Reduce weekly news gathering from 2 hours to 10 minutes
• Automate 90% of copy and paste work for press posts
• Improve data consistency by using the same fields every time
• Filter out old posts so only recent items are reviewed
• Handle 10 times more posts without adding team workload
• Connect OpenAI and NocoDB to build a searchable research hub

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 the n8n credentials manager, create a new OpenAI credential. Get your API key from your OpenAI account API page, paste it in, and save.
4. In the n8n credentials manager, create a new NocoDB credential. Enter your NocoDB base URL and API token from your NocoDB settings, then save.
5. Open the Schedule Trigger node and set the weekly day and time you want the run to start.
6. Open the HTTP Request node that fetches the listing page. Confirm the target news URL is correct. Click Execute Node to verify you get a 200 status and HTML in the response.
7. Open the HTML extraction nodes for links and dates. Adjust the CSS selectors to match your target site. Use the node preview to confirm results are not empty and arrays are the same length.
8. Check the Create single link items and Create single date items nodes. Execute them to confirm each array splits into one item per post.
9. Open the Select posts of last 7 days code node. Set the day range you want and confirm the date format matches the scraped text. Run it to ensure only recent posts remain.
10. Open the Extract individual posts HTML node. Set the selectors for title and content. Test with one link to make sure the text is clean and present.
11. On the OpenAI Summary and Keywords nodes, choose your OpenAI credential and model. Execute them to see a short summary and exactly three keywords. Confirm the Rename nodes map these results to summary and keywords fields.
12. Open the NocoDB node. Select your NocoDB credential, choose the base and table, and map fields for title, summary, keywords, date, and link. Run a test insert and confirm the row appears in NocoDB.
13. Run the full workflow once. Check the execution log for errors like bad selectors or blocked requests. Update selectors if the site layout changes. When all looks good, save and activate the workflow.