Ce workflow extrait automatiquement des informations clés de vos documents PDF et les enregistre dans une base de données ou un fichier Excel.
Ce workflow extrait automatiquement des informations clés de vos documents PDF et les enregistre dans une base de données ou un fichier Excel.
{
"name": "RSS Feed Scraper - YT",
"nodes": [
{
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 8
}
]
}
},
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
80,
260
],
"id": "4a52e0ef-ee96-4509-8907-3cf8e950d924",
"name": "Schedule Trigger"
},
{
"parameters": {
"jsCode": "return[n { "json": { "feed": "https://www.coindesk.com/arc/outboundfeeds/rss/" } },n { "json": { "feed": "https://cointelegraph.com/rss" } },n { "json": { "feed": "https://bitcoinmagazine.com/feed" } },n { "json": { "feed": "https://cryptoslate.com/feed/" } },n { "json": { "feed": "https://decrypt.co/feed" } },n { "json": { "feed": "https://www.theblock.co/rss.xml" } },n { "json": { "feed": "https://ambcrypto.com/feed/" } },n { "json": { "feed": "https://www.newsbtc.com/feed/" } },n { "json": { "feed": "https://news.bitcoin.com/feed/" } },n { "json": { "feed": "https://cryptopotato.com/feed/" } }n]"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
300,
260
],
"id": "e22659cb-3517-4283-bd59-3d1e8ec7aee7",
"name": "RSS Feeds"
},
{
"parameters": {
"options": {}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
520,
260
],
"id": "ad3df186-46aa-4e54-9aca-4a54a3f84b19",
"name": "Loop Over Items"
},
{
"parameters": {
"url": "={{ $json.feed }}",
"options": {}
},
"type": "n8n-nodes-base.rssFeedRead",
"typeVersion": 1.1,
"position": [
800,
360
],
"id": "d086f379-5811-4e86-915a-8611104aeaf2",
"name": "RSS Read"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "aabfdeff-d854-4ea8-9446-a77fae3c589e",
"leftValue": "={{ $('RSS Read').first().json.pubDate }}",
"rightValue": "={{ DateTime.now().minus({ days: 3 }) }}",
"operator": {
"type": "dateTime",
"operation": "afterOrEquals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
740,
160
],
"id": "b54b86b3-de81-45f1-b3e3-848cf0f6ea80",
"name": "If"
},
{
"parameters": {
"maxItems": 10
},
"type": "n8n-nodes-base.limit",
"typeVersion": 1,
"position": [
980,
120
],
"id": "e1605143-de3a-45c8-9984-eff6bfbee0a3",
"name": "Limit"
},
{
"parameters": {
"url": "={{ $('If').item.json.link }}",
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
1200,
120
],
"id": "362c8eb7-e0cb-40a4-bd2a-ec5d56571c3e",
"name": "getContent"
},
{
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"typeVersion": 1.2,
"position": [
1640,
360
],
"id": "921d9369-34de-4611-be35-835ed7bb579e",
"name": "OpenAI Chat Model1"
},
{
"parameters": {
"html": "={{ $json.data }}",
"options": {}
},
"type": "n8n-nodes-base.markdown",
"typeVersion": 1,
"position": [
1420,
120
],
"id": "548bbb0d-e521-4c50-9585-298e3ef974ee",
"name": "Markdown"
},
{
"parameters": {
"promptType": "define",
"text": "={{ $json.data }}",
"messages": {
"messageValues": [
{
"message": "=You are a helpful, intelligent summarizer assistant. Your task is to identify the main body text of the article and create a detailed summary of its contents. Identify any key subjects or themes and the main topic of the article.nnSummaries should be no more than 1000 characters. do not include any extra words or phrases like "summary of article" or "the article discusses""
}
]
}
},
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"typeVersion": 1.5,
"position": [
1620,
120
],
"id": "a73fabdc-66b6-48f7-9f4e-6d5a95b4c458",
"name": "summarizeArticles"
},
{
"parameters": {
"mode": "raw",
"jsonOutput": "={n "sourceSummary": {{ JSON.stringify($json.text) }},n "sourceURL": {{ JSON.stringify($('Limit').item.json.link) }},n "sourceHeadline": {{ JSON.stringify($('Limit').item.json.title) }}n}",
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
1980,
120
],
"id": "c1b95264-e1e7-4b4d-a781-6ed69dadb4c6",
"name": "setFields1"
},
{
"parameters": {
"authentication": "airtableOAuth2Api",
"operation": "create",
"base": {
"__rl": true,
"value": "appQ4oga8PGMIYQeH",
"mode": "list",
"cachedResultName": "n8n - Social Content - YT",
"cachedResultUrl": "https://airtable.com/appQ4oga8PGMIYQeH"
},
"table": {
"__rl": true,
"value": "tblZwA0JCNPeORaGi",
"mode": "list",
"cachedResultName": "Social Posts",
"cachedResultUrl": "https://airtable.com/appNHfiGGwCjBtUnw/tblZwA0JCNPeORaGi"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"needsImage?": "No",
"sourceHeadline": "={{ $json.sourceHeadline }}",
"sourceSummary": "={{ $json.sourceSummary }}",
"sourceURL": "={{ $json.sourceURL }}",
"Status": "Waiting for Content"
},
"matchingColumns": [],
"schema": [
{
"id": "sourceHeadline",
"displayName": "sourceHeadline",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
},
{
"id": "sourceSummary",
"displayName": "sourceSummary",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
},
{
"id": "goToArticle",
"displayName": "goToArticle",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": true,
"removed": true
},
{
"id": "socialChannels",
"displayName": "socialChannels",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "array",
"options": [
{
"name": "Twitter",
"value": "Twitter"
},
{
"name": "LinkedIn",
"value": "LinkedIn"
},
{
"name": "Blog",
"value": "Blog"
},
{
"name": "Instagram",
"value": "Instagram"
},
{
"name": "Facebook",
"value": "Facebook"
}
],
"readOnly": false,
"removed": false
},
{
"id": "needsImage?",
"displayName": "needsImage?",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "options",
"options": [
{
"name": "Yes",
"value": "Yes"
},
{
"name": "No",
"value": "No"
}
],
"readOnly": false,
"removed": false
},
{
"id": "twitterCopy",
"displayName": "twitterCopy",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
},
{
"id": "linkedinCopy",
"displayName": "linkedinCopy",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
},
{
"id": "blogCopy",
"displayName": "blogCopy",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
},
{
"id": "imagePrompt",
"displayName": "imagePrompt",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
},
{
"id": "postImage",
"displayName": "postImage",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "array",
"readOnly": false,
"removed": false
},
{
"id": "Status",
"displayName": "Status",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "options",
"options": [
{
"name": "Waiting for Content",
"value": "Waiting for Content"
},
{
"name": "Needs Approval",
"value": "Needs Approval"
},
{
"name": "Approved",
"value": "Approved"
},
{
"name": "Posted",
"value": "Posted"
}
],
"readOnly": false,
"removed": false
},
{
"id": "datePosted",
"displayName": "datePosted",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
},
{
"id": "ID",
"displayName": "ID",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": true,
"removed": true
},
{
"id": "sourceURL",
"displayName": "sourceURL",
"required": false,
"defaultMatch": false,
"canBeUsedToMatch": true,
"display": true,
"type": "string",
"readOnly": false,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.airtable",
"typeVersion": 2.1,
"position": [
2200,
120
],
"id": "be507736-0b13-4f04-8375-2b55870c8c4f",
"name": "Airtable1"
},
{
"parameters": {
"content": "## INPUT: RSS Feed",
"height": 620,
"width": 2500
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
0,
0
],
"id": "024c442d-509c-4ffb-9d48-52ac8f5d7964",
"name": "Sticky Note2"
}
],
"pinData": {},
"connections": {
"Schedule Trigger": {
"main": [
[
{
"node": "RSS Feeds",
"type": "main",
"index": 0
}
]
]
},
"RSS Feeds": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[
{
"node": "If",
"type": "main",
"index": 0
}
],
[
{
"node": "RSS Read",
"type": "main",
"index": 0
}
]
]
},
"RSS Read": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"If": {
"main": [
[
{
"node": "Limit",
"type": "main",
"index": 0
}
]
]
},
"Limit": {
"main": [
[
{
"node": "getContent",
"type": "main",
"index": 0
}
]
]
},
"getContent": {
"main": [
[
{
"node": "Markdown",
"type": "main",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "summarizeArticles",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Markdown": {
"main": [
[
{
"node": "summarizeArticles",
"type": "main",
"index": 0
}
]
]
},
"summarizeArticles": {
"main": [
[
{
"node": "setFields1",
"type": "main",
"index": 0
}
]
]
},
"setFields1": {
"main": [
[
{
"node": "Airtable1",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "d00a0b4d-3b26-4365-bc28-6b15ffff38ae",
"meta": {
"instanceId": "ca3f3f1b54754cc6a8bf7018ef2c4b3d517f36ec4d32b4741e6f00bea7ac9b4a"
},
"id": "AAKducOXNpWechnI",
"tags": []
}