Instantly share code, notes, and snippets.
Created
August 6, 2025 19:21
-
Star
0
(0)
You must be signed in to star a gist -
Fork
0
(0)
You must be signed in to fork a gist
-
-
Save raress96/95e62aa4da5b0c3a08d745c5af938704 to your computer and use it in GitHub Desktop.
n8n newsletter to social posts
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "name": "Newsletter to Social Posts", | |
| "nodes": [ | |
| { | |
| "parameters": { | |
| "pollTimes": { | |
| "item": [ | |
| { | |
| "mode": "everyX", | |
| "value": 12 | |
| } | |
| ] | |
| }, | |
| "feedUrl": "https://rss.beehiiv.com/feeds/JL4rs5EQ05.xml" | |
| }, | |
| "type": "n8n-nodes-base.rssFeedReadTrigger", | |
| "typeVersion": 1, | |
| "position": [ | |
| 0, | |
| 0 | |
| ], | |
| "id": "d6cef6ed-a348-4dc5-84e7-cf0092019aa8", | |
| "name": "RSS Feed Trigger" | |
| }, | |
| { | |
| "parameters": { | |
| "promptType": "define", | |
| "text": "=Create 3 engaging tweets from this newsletter article. Each tweet should highlight a different key point. Keep tweets under 250 characters to leave room for the link. Make them conversational and interesting.\n\nArticle Title: {{ $json.title }}\n\nArticle Content: {{ $json['content:encodedSnippet'] }}\n\nFormat the output as:\nTweet 1: [tweet text]\n\nTweet 2: [tweet text]\n\nTweet 3: [tweet text]", | |
| "hasOutputParser": true, | |
| "batching": {} | |
| }, | |
| "type": "@n8n/n8n-nodes-langchain.chainLlm", | |
| "typeVersion": 1.7, | |
| "position": [ | |
| 208, | |
| 0 | |
| ], | |
| "id": "94d72a5b-3aab-4e2a-8680-4cf160f0172e", | |
| "name": "Basic LLM Chain" | |
| }, | |
| { | |
| "parameters": { | |
| "model": { | |
| "__rl": true, | |
| "mode": "list", | |
| "value": "claude-sonnet-4-20250514", | |
| "cachedResultName": "Claude 4 Sonnet" | |
| }, | |
| "options": {} | |
| }, | |
| "type": "@n8n/n8n-nodes-langchain.lmChatAnthropic", | |
| "typeVersion": 1.3, | |
| "position": [ | |
| 208, | |
| 192 | |
| ], | |
| "id": "05266ddf-de53-45c9-91b3-9c3726982084", | |
| "name": "Anthropic Chat Model", | |
| "credentials": { | |
| "anthropicApi": { | |
| "id": "alrCUFBOO3cFNuSb", | |
| "name": "Anthropic account" | |
| } | |
| } | |
| }, | |
| { | |
| "parameters": { | |
| "options": { | |
| "numberOfItems": 3, | |
| "separator": "\\n" | |
| } | |
| }, | |
| "type": "@n8n/n8n-nodes-langchain.outputParserItemList", | |
| "typeVersion": 1, | |
| "position": [ | |
| 400, | |
| 192 | |
| ], | |
| "id": "22c48d50-4cf3-4caa-ac7c-9c2b84f166ad", | |
| "name": "Item List Output Parser" | |
| }, | |
| { | |
| "parameters": { | |
| "operation": "append", | |
| "documentId": { | |
| "__rl": true, | |
| "value": "1Yy-UbdkEskyUS9qB_gkRyZIoOujm4jQB9n8aVI-E6HQ", | |
| "mode": "list", | |
| "cachedResultName": "Declassified Technologies N8N", | |
| "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Yy-UbdkEskyUS9qB_gkRyZIoOujm4jQB9n8aVI-E6HQ/edit?usp=drivesdk" | |
| }, | |
| "sheetName": { | |
| "__rl": true, | |
| "value": "gid=0", | |
| "mode": "list", | |
| "cachedResultName": "Tweets", | |
| "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1Yy-UbdkEskyUS9qB_gkRyZIoOujm4jQB9n8aVI-E6HQ/edit#gid=0" | |
| }, | |
| "columns": { | |
| "mappingMode": "defineBelow", | |
| "value": { | |
| "Date": "={{ $now.format('dd-MM-yyyy') }}", | |
| "Title": "={{ $('RSS Feed Trigger').item.json.title }}", | |
| "Text": "={{ $json.text }}", | |
| "Status": "Pending", | |
| "Link": "={{ $('RSS Feed Trigger').item.json.link }}" | |
| }, | |
| "matchingColumns": [], | |
| "schema": [ | |
| { | |
| "id": "Date", | |
| "displayName": "Date", | |
| "required": false, | |
| "defaultMatch": false, | |
| "display": true, | |
| "type": "string", | |
| "canBeUsedToMatch": true, | |
| "removed": false | |
| }, | |
| { | |
| "id": "Title", | |
| "displayName": "Title", | |
| "required": false, | |
| "defaultMatch": false, | |
| "display": true, | |
| "type": "string", | |
| "canBeUsedToMatch": true, | |
| "removed": false | |
| }, | |
| { | |
| "id": "Text", | |
| "displayName": "Text", | |
| "required": false, | |
| "defaultMatch": false, | |
| "display": true, | |
| "type": "string", | |
| "canBeUsedToMatch": true, | |
| "removed": false | |
| }, | |
| { | |
| "id": "Status", | |
| "displayName": "Status", | |
| "required": false, | |
| "defaultMatch": false, | |
| "display": true, | |
| "type": "string", | |
| "canBeUsedToMatch": true, | |
| "removed": false | |
| }, | |
| { | |
| "id": "Link", | |
| "displayName": "Link", | |
| "required": false, | |
| "defaultMatch": false, | |
| "display": true, | |
| "type": "string", | |
| "canBeUsedToMatch": true, | |
| "removed": false | |
| } | |
| ], | |
| "attemptToConvertTypes": false, | |
| "convertFieldsToString": false | |
| }, | |
| "options": {} | |
| }, | |
| "type": "n8n-nodes-base.googleSheets", | |
| "typeVersion": 4.6, | |
| "position": [ | |
| 560, | |
| 0 | |
| ], | |
| "id": "1018f236-ca1e-4cab-aeae-46f666b6ca42", | |
| "name": "Append row in sheet", | |
| "alwaysOutputData": false, | |
| "retryOnFail": false, | |
| "credentials": { | |
| "googleSheetsOAuth2Api": { | |
| "id": "zFpL6m8REMyfgVYi", | |
| "name": "Google Sheets account" | |
| } | |
| } | |
| } | |
| ], | |
| "pinData": {}, | |
| "connections": { | |
| "RSS Feed Trigger": { | |
| "main": [ | |
| [ | |
| { | |
| "node": "Basic LLM Chain", | |
| "type": "main", | |
| "index": 0 | |
| } | |
| ] | |
| ] | |
| }, | |
| "Anthropic Chat Model": { | |
| "ai_languageModel": [ | |
| [ | |
| { | |
| "node": "Basic LLM Chain", | |
| "type": "ai_languageModel", | |
| "index": 0 | |
| } | |
| ] | |
| ] | |
| }, | |
| "Item List Output Parser": { | |
| "ai_outputParser": [ | |
| [ | |
| { | |
| "node": "Basic LLM Chain", | |
| "type": "ai_outputParser", | |
| "index": 0 | |
| } | |
| ] | |
| ] | |
| }, | |
| "Basic LLM Chain": { | |
| "main": [ | |
| [ | |
| { | |
| "node": "Append row in sheet", | |
| "type": "main", | |
| "index": 0 | |
| } | |
| ] | |
| ] | |
| } | |
| }, | |
| "active": true, | |
| "settings": { | |
| "executionOrder": "v1" | |
| }, | |
| "versionId": "a4fc0d6e-aecc-4762-a47e-e95655d306d3", | |
| "meta": { | |
| "templateCredsSetupCompleted": true, | |
| "instanceId": "36335612fb8179ba16c105c375ede670670378b76d746421232259a7b1e4f096" | |
| }, | |
| "id": "eDyr1uA7fE7ojasa", | |
| "tags": [] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment