Create a detailed prompt for this Create a json n8n to search for latest tech news in…
- User
Create a detailed prompt for this Create a json n8n to search for latest tech news in hackernews , substack and devnews and rank them and store top 5 it in the excel sheet and then write the blog and store it in excel sheet for linkedin post and post in the linkedin 1 nd marked it as posted and create another automation to post the unposted based on rank and the sheet should be based on the topic.to post it in
Assistant
Here is a detailed prompt for creating an n8n workflow to achieve the described task:
Task 1: Search for latest tech news and store top 5 in Excel sheet
- Create an n8n workflow that:
- Searches for latest tech news on:
- Hacker News (using their API or RSS feed)
- Substack (using their API or RSS feed)
- Dev News (using their API or RSS feed)
- Combines the results from all three sources into a single list
- Ranks the news articles based on their relevance, popularity, or other relevant criteria (e.g., number of comments, upvotes, etc.)
- Selects the top 5 news articles based on the ranking
- Stores the top 5 news articles in an Excel sheet with the following columns:
- Title
- Summary
- URL
- Source (Hacker News, Substack, or Dev News)
- Rank
- Posted (initially set to "No")
- Searches for latest tech news on:
- The Excel sheet should be created with a specific structure, e.g., "Tech News" sheet with the above columns.
Task 2: Write a blog post based on top 5 news articles and store it in Excel sheet
- Create an n8n workflow that:
- Takes the top 5 news articles from the Excel sheet created in Task 1
- Generates a blog post based on the top 5 news articles (e.g., a summary of each article with a brief analysis)
- Stores the blog post in the same Excel sheet, in a new column named "Blog Post"
- The blog post should be written in a format suitable for a LinkedIn post.
Task 3: Post the blog post on LinkedIn and mark it as posted
- Create an n8n workflow that:
- Takes the blog post from the Excel sheet
- Posts the blog post on LinkedIn using the LinkedIn API
- Updates the "Posted" column in the Excel sheet to "Yes" for the corresponding news articles
Task 4: Create another automation to post unposted news articles based on rank and topic
- Create an n8n workflow that:
- Checks the Excel sheet for news articles that have not been posted yet (i.e., "Posted" column is "No")
- Ranks the unposted news articles based on their rank and topic (e.g., AI, Machine Learning, etc.)
- Selects the top unposted news article based on the ranking and topic
- Posts the selected news article on LinkedIn using the LinkedIn API
- Updates the "Posted" column in the Excel sheet to "Yes" for the corresponding news article
Additional requirements
- The Excel sheet should be organized by topic, with separate sheets or columns for different topics (e.g., AI, Machine Learning, etc.).
- The n8n workflows should be designed to run at regular intervals (e.g., daily, weekly, etc.) to fetch new news articles and post them on LinkedIn.
Here is a possible JSON representation of the n8n workflow:
{ "nodes": [ { "parameters": { "operation": "search", "query": "tech news" }, "name": "Hacker News API", "type": "n8n-nodes-hackernews", "typeVersion": 1, "credentials": { "apiKey": "YOUR_HACKER_NEWS_API_KEY" } }, { "parameters": { "operation": "search", "query": "tech news" }, "name": "Substack API", "type": "n8n-nodes-substack", "typeVersion": 1, "credentials": { "apiKey": "YOUR_SUBSTACK_API_KEY" } }, { "parameters": { "operation": "search", "query": "tech news" }, "name": "Dev News API", "type": "n8n-nodes-devnews", "typeVersion": 1, "credentials": { "apiKey": "YOUR_DEV_NEWS_API_KEY" } }, { "parameters": { "expression": "={{$json(\"title\")}} + \" - \" + {{$json(\"summary\")}}" }, "name": "Combine Results", "type": "n8n-nodes-function", "typeVersion": 1 }, { "parameters": { "column1": "title", "column2": "summary", "column3": "url", "column4": "source", "column5": "rank" }, "name": "Excel Sheet", "type": "n8n-nodes-excel", "typeVersion": 1, "credentials": { "filePath": "tech_news.xlsx" } }, { "parameters": { "text": "={{$json(\"blog_post\")}}" }, "name": "LinkedIn API", "type": "n8n-nodes-linkedin", "typeVersion": 1, "credentials": { "accessToken": "YOUR_LINKEDIN_ACCESS_TOKEN" } } ], "connections": { "Hacker News API": { "main": [ { "node": "Combine Results", "type": "main", "index": 0 } ] }, "Substack API": { "main": [ { "node": "Combine Results", "type": "main", "index": 1 } ] }, "Dev News API": { "main": [ { "node": "Combine Results", "type": "main", "index": 2 } ] }, "Combine Results": { "main": [ { "node": "Excel Sheet", "type": "main", "index": 0 } ] }, "Excel Sheet": { "main": [ { "node": "LinkedIn API", "type": "main", "index": 0 } ] } } }Note that this is a simplified representation of the n8n workflow, and you will need to modify it to fit your specific requirements. Additionally, you will need to replace the placeholders (e.g.,
YOUR_HACKER_NEWS_API_KEY) with your actual API keys and credentials.- Create an n8n workflow that:
- User
add the things like use free option for tools and make it two first to create and store it . Second post based on the status of like posted unposted based on the ranking of the news based on upvotes on the source website and post it in linkedin if it is not posted . Add to above prompt
Assistant
Here is the updated prompt:
Task 1: Create and Store Top 5 News Articles in Excel Sheet
- Create an n8n workflow that:
- Searches for latest tech news on:
- Hacker News (using their free API or RSS feed)
- Substack (using their free API or RSS feed)
- Dev News (using their free API or RSS feed)
- Combines the results from all three sources into a single list
- Ranks the news articles based on their upvotes on the source website
- Selects the top 5 news articles based on the ranking
- Stores the top 5 news articles in an Excel sheet with the following columns:
- Title
- Summary
- URL
- Source (Hacker News, Substack, or Dev News)
- Upvotes
- Posted (initially set to "No")
- Searches for latest tech news on:
- The Excel sheet should be created with a specific structure, e.g., "Tech News" sheet with the above columns.
- Use free APIs or RSS feeds for the news sources, such as:
- Hacker News: RSS feed (https://news.ycombinator.com/rss)
- Substack: RSS feed (https://substack.com/feed)
- Dev News: RSS feed (https://dev.to/feed)
Task 2: Post Unposted News Articles on LinkedIn based on Ranking
- Create another n8n workflow that:
- Checks the Excel sheet for news articles that have not been posted yet (i.e., "Posted" column is "No")
- Ranks the unposted news articles based on their upvotes on the source website
- Selects the top unposted news article based on the ranking
- Posts the selected news article on LinkedIn using the LinkedIn API (using a free tier or a developer account)
- Updates the "Posted" column in the Excel sheet to "Yes" for the corresponding news article
- Use a free or low-cost LinkedIn API, such as:
- LinkedIn Developer Account (https://developer.linkedin.com/)
- n8n's built-in LinkedIn node (using OAuth 2.0 authentication)
Additional Requirements
- The Excel sheet should be organized by topic, with separate sheets or columns for different topics (e.g., AI, Machine Learning, etc.).
- The n8n workflows should be designed to run at regular intervals (e.g., daily, weekly, etc.) to fetch new news articles and post them on LinkedIn.
- Use free or low-cost tools and APIs wherever possible to minimize costs.
Here is a possible JSON representation of the n8n workflow:
{ "nodes": [ { "parameters": { "url": "https://news.ycombinator.com/rss" }, "name": "Hacker News RSS", "type": "n8n-nodes-rss", "typeVersion": 1 }, { "parameters": { "url": "https://substack.com/feed" }, "name": "Substack RSS", "type": "n8n-nodes-rss", "typeVersion": 1 }, { "parameters": { "url": "https://dev.to/feed" }, "name": "Dev News RSS", "type": "n8n-nodes-rss", "typeVersion": 1 }, { "parameters": { "expression": "={{$json(\"title\")}} + \" - \" + {{$json(\"summary\")}}" }, "name": "Combine Results", "type": "n8n-nodes-function", "typeVersion": 1 }, { "parameters": { "column1": "title", "column2": "summary", "column3": "url", "column4": "source", "column5": "upvotes", "column6": "posted" }, "name": "Excel Sheet", "type": "n8n-nodes-excel", "typeVersion": 1, "credentials": { "filePath": "tech_news.xlsx" } }, { "parameters": { "expression": "={{$json(\"posted\")}} === \"No\"" }, "name": "Filter Unposted", "type": "n8n-nodes-function", "typeVersion": 1 }, { "parameters": { "text": "={{$json(\"title\")}} + \" - \" + {{$json(\"summary\")}} + \" \" + {{$json(\"url\")}}" }, "name": "LinkedIn API", "type": "n8n-nodes-linkedin", "typeVersion": 1, "credentials": { "accessToken": "YOUR_LINKEDIN_ACCESS_TOKEN" } } ], "connections": { "Hacker News RSS": { "main": [ { "node": "Combine Results", "type": "main", "index": 0 } ] }, "Substack RSS": { "main": [ { "node": "Combine Results", "type": "main", "index": 1 } ] }, "Dev News RSS": { "main": [ { "node": "Combine Results", "type": "main", "index": 2 } ] }, "Combine Results": { "main": [ { "node": "Excel Sheet", "type": "main", "index": 0 } ] }, "Excel Sheet": { "main": [ { "node": "Filter Unposted", "type": "main", "index": 0 } ] }, "Filter Unposted": { "main": [ { "node": "LinkedIn API", "type": "main", "index": 0 } ] } } }Note that this is a simplified representation of the n8n workflow, and you will need to modify it to fit your specific requirements. Additionally, you will need to replace the placeholders (e.g.,
YOUR_LINKEDIN_ACCESS_TOKEN) with your actual API keys and credentials.- Create an n8n workflow that:
Other models, same or similar prompt
Responses were produced in different, uncontrolled contexts (system prompts, settings, prior turns). This is not a benchmark.