Schedule OpenAI queries and save results to database
Workflow Description
Scheduled automation that sends periodic requests to OpenAI, processes responses, merges data with multiple formats, and stores results automatically in Noco Db with HTML handling and data transformation.
How it works
- 1.Trigger automation based on defined schedule
- 2.Send query to OpenAI and parse the response
- 3.Merge and format received data using code and transformation nodes
- 4.Store processed results in Noco Db tables
Use cases
- Generate periodic summaries or content and store automatically
- Monitor OpenAI outputs and organize them in a database
- Automate recurring reports and batch processing tasks
Requirements
- Valid OpenAI API key configured
- Noco Db instance with prepared tables for storage
- Continuously running n8n server
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (36)
Extract the HTML with the right css class
HTML Page
Summary
OpenAI
Keywords
OpenAI
Rename keywords
Set
Rename Summary
Set
Merge
Merge
Extract date
HTML Page
Select posts of last 7 days
Code
Merge date & links
Merge
HTTP Request1
HTTP Request
Merge Content with Date & Link
Merge
Extract individual posts
HTML Page
Sticky Note
Sticky Note
Merge ChatGPT output with Date & Link
Merge
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note
Retrieve the web page for further processsing
HTTP Request
Sticky Note9
Sticky Note
Sticky Note10
Sticky Note
Sticky Note11
Sticky Note
Sticky Note12
Sticky Note
Sticky Note13
Sticky Note
Sticky Note14
Sticky Note
Sticky Note15
Sticky Note
Schedule Trigger each week
Schedule Trigger
Sticky Note16
Sticky Note
NocoDB news database
Noco Db
Sticky Note17
Sticky Note
Sticky Note18
Sticky Note
Create single link items
Item Lists
Create single date items
Item Lists