Analyse quotidienne des actualités UPSC
Avancé
Ceci est uncontenant 20 nœuds.Utilise principalement des nœuds comme Code, Html, HttpRequest, GoogleSheets, ManualTrigger. Extraction automatique des résumés des actualités UPSC The Hindu vers Google Sheets avec Gemini AI
Prérequis
- •Peut nécessiter les informations d'identification d'authentification de l'API cible
- •Informations d'identification Google Sheets API
- •Clé API Google Gemini
Nœuds utilisés (20)
Catégorie
-
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
"name": "Daily UPSC Current Affairs Analysis from The Hindu to Google Sheets",
"tags": [],
"nodes": [
{
"name": "Lors du clic sur 'Exécuter le workflow'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-64,
160
],
"parameters": {},
"typeVersion": 1,
"id": "Lors-du-clic-sur-Ex-cuter-le-workflow--0"
},
{
"name": "HTTP Request: Obtenir la première page de The Hindu",
"type": "n8n-nodes-base.httpRequest",
"position": [
272,
16
],
"parameters": {
"url": "https://www.thehindu.com/latest-news/",
"options": {},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "User-Agent",
"value": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36"
}
]
}
},
"typeVersion": 4.2,
"id": "HTTP-Request-Obtenir-la-premi-re-page-de-The-Hindu-1"
},
{
"name": "Agent IA: Filtrer et analyser l'actualité UPSC",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1616,
16
],
"parameters": {
"text": "=Please analyze only those news article which is important for upsc exam (left others) (Only 5-6 most important article needed.) and provide the following information in a structured JSON format.\nOnly 5-6 most important article needed.\n\nArticle URL: {{ $('Code in JavaScript: Pair URL & Title').item.json.url }}\nArticle Content:\n{{ $json.articleText }}\n\nBased on the content, provide:\n1. A brief summary (2-3 sentences).\n2. What is important for the UPSC exam (1 sentence).\n3. The main subject (e.g., Polity, Economy, International Relations, Science & Tech, Environment).\n\nUpload on the google sheet in following columns:\nDate;\tURL;\tSubject;\tBrief Summary;\tWhat is Important",
"options": {
"systemMessage": "You are an AI expert in Current Affairs analysis for the UPSC Civil Services Examination. Your task is to filter, analyze, and summarize news articles from The Hindu based *strictly* on their relevance to the official UPSC syllabus (GS Papers I, II, III, IV) and Current Affairs. For every article provided, you must first assess its importance. If it is not one of the *top 5-6 most important* articles, output a rejection statement and do not call the Append tool. If it is relevant, call the Append tool with the extracted and analyzed data.",
"returnIntermediateSteps": true
},
"promptType": "define"
},
"typeVersion": 2.2,
"id": "Agent-IA-Filtrer-et-analyser-l-actualit-UPSC-2"
},
{
"name": "Google Gemini Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
1600,
160
],
"parameters": {
"options": {}
},
"credentials": {},
"typeVersion": 1,
"id": "Google-Gemini-Chat-Model-3"
},
{
"name": "HTML: Extraire les liens et titres d'articles",
"type": "n8n-nodes-base.html",
"position": [
512,
16
],
"parameters": {
"options": {},
"operation": "extractHtmlContent",
"extractionValues": {
"values": [
{
"key": "url",
"attribute": "href",
"cssSelector": "h3.title > a",
"returnArray": true,
"returnValue": "attribute"
},
{
"key": "title",
"cssSelector": "h3.title > a",
"returnArray": true
}
]
}
},
"typeVersion": 1.2,
"id": "HTML-Extraire-les-liens-et-titres-d-articles-4"
},
{
"name": "HTTP Request1: Obtenir le contenu complet de l'article",
"type": "n8n-nodes-base.httpRequest",
"position": [
1104,
16
],
"parameters": {
"url": "={{ $json.url }}",
"options": {},
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "User-Agent",
"value": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36"
}
]
}
},
"typeVersion": 4.2,
"id": "HTTP-Request1-Obtenir-le-contenu-complet-de-l-article-5"
},
{
"name": "HTML1: Extraire le corps de l'article",
"type": "n8n-nodes-base.html",
"position": [
1376,
16
],
"parameters": {
"options": {},
"operation": "extractHtmlContent",
"extractionValues": {
"values": [
{
"key": "articleText",
"cssSelector": "div[id^=\"content-body-\"]"
}
]
}
},
"typeVersion": 1.2,
"id": "HTML1-Extraire-le-corps-de-l-article-6"
},
{
"name": "Ajouter une ligne dans la feuille",
"type": "n8n-nodes-base.googleSheets",
"position": [
1920,
16
],
"parameters": {
"columns": {
"value": {
"URL": "={{ $json.intermediateSteps[0].action.toolInput.URL || $json.URL }}",
"Date": "={{ $json.intermediateSteps[0].action.toolInput.Date || $json.Date }}",
"Subject": "={{ $json.intermediateSteps[0].action.toolInput.Subject || $json.Subject }}",
"Brief Summary": "={{ $json.intermediateSteps[0].action.toolInput.Brief_Summary || $json['Brief Summary'] }}",
"What is Important": "={{ $json.intermediateSteps[0].action.toolInput.What_is_Important || $json['What is Important'] }}"
},
"schema": [
{
"id": "Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Subject",
"type": "string",
"display": true,
"required": false,
"displayName": "Subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Brief Summary",
"type": "string",
"display": true,
"required": false,
"displayName": "Brief Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "What is Important",
"type": "string",
"display": true,
"required": false,
"displayName": "What is Important",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "<GOOGLE_SHEET_GID_UPSC_NEWS>",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/<GOOGLE_SHEET_ID_UPSC_NEWS>/edit#gid=<GOOGLE_SHEET_GID_UPSC_NEWS>",
"cachedResultName": "UPSC Hindu News"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "<GOOGLE_SHEET_ID_UPSC_NEWS>",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/<GOOGLE_SHEET_ID_UPSC_NEWS>/edit?usp=drivesdk",
"cachedResultName": "Untitled spreadsheet"
}
},
"credentials": {},
"typeVersion": 4.7,
"id": "Ajouter-une-ligne-dans-la-feuille-7"
},
{
"name": "Ajouter une ligne dans la feuille dans Google Sheets1",
"type": "n8n-nodes-base.googleSheetsTool",
"position": [
1776,
160
],
"parameters": {
"columns": {
"value": {
"URL": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('URL', ``, 'string') }}",
"Date": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Date', ``, 'string') }}",
"Subject": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Subject', ``, 'string') }}",
"Brief Summary": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Brief_Summary', ``, 'string') }}",
"What is Important": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('What_is_Important', ``, 'string') }}"
},
"schema": [
{
"id": "Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Subject",
"type": "string",
"display": true,
"required": false,
"displayName": "Subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Brief Summary",
"type": "string",
"display": true,
"required": false,
"displayName": "Brief Summary",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "What is Important",
"type": "string",
"display": true,
"required": false,
"displayName": "What is Important",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"useAppend": true
},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "<GOOGLE_SHEET_GID_UPSC_NEWS>",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/<GOOGLE_SHEET_ID_UPSC_NEWS>/edit#gid=<GOOGLE_SHEET_GID_UPSC_NEWS>",
"cachedResultName": "UPSC Hindu News"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "<GOOGLE_SHEET_ID_UPSC_NEWS>",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/<GOOGLE_SHEET_ID_UPSC_NEWS>/edit?usp=drivesdk",
"cachedResultName": "Untitled spreadsheet"
},
"descriptionType": "manual",
"toolDescription": "Append row in sheet in Google Sheets"
},
"credentials": {},
"typeVersion": 4.7,
"id": "Ajouter-une-ligne-dans-la-feuille-dans-Google-Sheets1-8"
},
{
"name": "Code en JavaScript: Associer URL et Titre",
"type": "n8n-nodes-base.code",
"position": [
832,
16
],
"parameters": {
"jsCode": "// Get the JSON output from the previous node, which is named \"HTML: Extract Article Links & Titles\"\nconst inputData = $('HTML: Extract Article Links & Titles').first().json;\n\n// Get the arrays from that data\nconst urls = inputData.url;\nconst titles = inputData.title;\n\nconst pairedItems = [];\n\n// Loop through the URLs and pair each one with its title\nfor (let i = 0; i < urls.length; i++) {\n pairedItems.push({\n json: {\n url: urls[i],\n title: titles[i]\n }\n });\n}\n\n// Return the new list of paired items\nreturn pairedItems;"
},
"typeVersion": 2,
"id": "Code-en-JavaScript-Associer-URL-et-Titre-9"
},
{
"name": "Déclencheur programmé: Quotidien à 7h",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-64,
-16
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 7
}
]
}
},
"typeVersion": 1.2,
"id": "D-clencheur-programm-Quotidien-7h-10"
},
{
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
-704,
-128
],
"parameters": {
"width": 480,
"height": 816,
"content": "Automated Daily UPSC Current Affairs Compilation\n\nThis workflow automates the process of creating daily current affairs notes for the Competitive Exams like UPSC.\n\nIt scrapes the latest news from The Hindu, uses an **AI Agent (powered by Google Gemini)** to filter only the **most relevant articles** (5-6 per run), generates a concise summary and UPSC-specific importance note, and automatically logs the analyzed data to a **Google Sheet**.\n\n## Who’s it for\n\n* **UPSC/CSE Aspirants** who want a curated, concise, and focused daily current affairs digest.\n* **Coaching Institutes** who need to automate the creation of daily study material.\n* **Educators** focused on Governance, Economy, and International Relations topics.\n\n## Requirements\n\n* **Google Gemini API Key:** For the Chat Model node.\n* **Google Sheets:** To store the final compiled current affairs digest.\n\n## How to set up\n\n1. **Credentials:** Connect your **Google Gemini** and **Google Sheets** credentials.\n2. **Google Sheet Setup:** Link the two Google Sheets nodes to your spreadsheet. Ensure your sheet has the column headers: `Date`, `URL`, `Subject`, `Brief Summary`, and `What is Important`.\n3. **Scheduling:** Adjust the **Schedule Trigger** time (default is 7 AM) if needed."
},
"typeVersion": 1,
"id": "Note-adh-sive-11"
},
{
"name": "Note adhésive1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-160,
-96
],
"parameters": {
"width": 288,
"height": 416,
"content": "Sets the time for the workflow to run every morning."
},
"typeVersion": 1,
"id": "Note-adh-sive1-12"
},
{
"name": "Note adhésive2",
"type": "n8n-nodes-base.stickyNote",
"position": [
144,
-96
],
"parameters": {
"width": 288,
"height": 400,
"content": "Sends a request to the latest news section of Newspaper Web."
},
"typeVersion": 1,
"id": "Note-adh-sive2-13"
},
{
"name": "Note adhésive3",
"type": "n8n-nodes-base.stickyNote",
"position": [
448,
-96
],
"parameters": {
"width": 272,
"height": 384,
"content": "Parses the received HTML "
},
"typeVersion": 1,
"id": "Note-adh-sive3-14"
},
{
"name": "Note adhésive4",
"type": "n8n-nodes-base.stickyNote",
"position": [
736,
-96
],
"parameters": {
"width": 272,
"height": 384,
"content": "Creates a separate data item for every single news article for individual processing"
},
"typeVersion": 1,
"id": "Note-adh-sive4-15"
},
{
"name": "Note adhésive5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1024,
-96
],
"parameters": {
"width": 272,
"height": 384,
"content": "Retrieve its full text/HTML content."
},
"typeVersion": 1,
"id": "Note-adh-sive5-16"
},
{
"name": "Note adhésive6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1312,
-96
],
"parameters": {
"height": 384,
"content": "Isolates and extracts the clean, primary article text"
},
"typeVersion": 1,
"id": "Note-adh-sive6-17"
},
{
"name": "Note adhésive7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1568,
-96
],
"parameters": {
"width": 304,
"height": 384,
"content": "Filter for UPSC relevance, summarize, categorize, and prepare the data for the sheet"
},
"typeVersion": 1,
"id": "Note-adh-sive7-18"
},
{
"name": "Note adhésive8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1888,
-96
],
"parameters": {
"width": 256,
"height": 368,
"content": "Ensuring the structured data is physically written to the Google Sheet."
},
"typeVersion": 1,
"id": "Note-adh-sive8-19"
}
],
"active": false,
"settings": {
"executionOrder": "v1"
},
"connections": {
"Google-Gemini-Chat-Model-3": {
"ai_languageModel": [
[
{
"node": "Agent-IA-Filtrer-et-analyser-l-actualit-UPSC-2",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"HTML1-Extraire-le-corps-de-l-article-6": {
"main": [
[
{
"node": "Agent-IA-Filtrer-et-analyser-l-actualit-UPSC-2",
"type": "main",
"index": 0
}
]
]
},
"D-clencheur-programm-Quotidien-7h-10": {
"main": [
[
{
"node": "HTTP-Request-Obtenir-la-premi-re-page-de-The-Hindu-1",
"type": "main",
"index": 0
}
]
]
},
"Agent-IA-Filtrer-et-analyser-l-actualit-UPSC-2": {
"main": [
[
{
"node": "Ajouter-une-ligne-dans-la-feuille-7",
"type": "main",
"index": 0
}
]
]
},
"Code-en-JavaScript-Associer-URL-et-Titre-9": {
"main": [
[
{
"node": "HTTP-Request1-Obtenir-le-contenu-complet-de-l-article-5",
"type": "main",
"index": 0
}
]
]
},
"HTML-Extraire-les-liens-et-titres-d-articles-4": {
"main": [
[
{
"node": "Code-en-JavaScript-Associer-URL-et-Titre-9",
"type": "main",
"index": 0
}
]
]
},
"Lors-du-clic-sur-Ex-cuter-le-workflow--0": {
"main": [
[
{
"node": "HTTP-Request-Obtenir-la-premi-re-page-de-The-Hindu-1",
"type": "main",
"index": 0
}
]
]
},
"Ajouter-une-ligne-dans-la-feuille-dans-Google-Sheets1-8": {
"ai_tool": [
[
{
"node": "Agent-IA-Filtrer-et-analyser-l-actualit-UPSC-2",
"type": "ai_tool",
"index": 0
}
]
]
},
"HTTP-Request-Obtenir-la-premi-re-page-de-The-Hindu-1": {
"main": [
[
{
"node": "HTML-Extraire-les-liens-et-titres-d-articles-4",
"type": "main",
"index": 0
}
]
]
},
"HTTP-Request1-Obtenir-le-contenu-complet-de-l-article-5": {
"main": [
[
{
"node": "HTML1-Extraire-le-corps-de-l-article-6",
"type": "main",
"index": 0
}
]
]
}
}
}Foire aux questions
Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Avancé
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
Explorer les nœuds n8n dans la bibliothèque de références visuelles
Explorer les nœuds n8n dans la base de références visuelles
If
Ftp
Set
+
If
Ftp
Set
113 NœudsI versus AI
Autres
Génération et publication automatiques de votes QCM uniques sur Telegram avec l'IA
Génération de votes de questions à choix uniques uniques et publication sur Telegram en utilisant Gemini AI et Google Sheets
If
Aggregate
Http Request
+
If
Aggregate
Http Request
15 NœudsPawan
Création de contenu
Agrégation de contenu
Automatiser la publication de publications sur les réseaux sociaux à partir d'articles de site web vers LinkedIn et X/Twitter avec Gemini AI
If
Set
Xml
+
If
Set
Xml
34 NœudsVadim
Création de contenu
Automatisation du développement de partenaires commerciaux avec Google Maps, GPT-4 et WhatsApp
Automatisation du développement de partenaires commerciaux avec Google Maps, GPT-4 et WhatsApp
If
Set
Code
+
If
Set
Code
64 NœudsKhairul Muhtadin
Chatbot IA
Mes flux de travail
Automatisation de la recherche d'offres d'emploi avec LinkedIn, Google Sheets, notation de CV IA et lettres de motivation automatisées
Set
Code
Html
+
Set
Code
Html
27 NœudsJugal
Vente de copies de blog WordPress
Automatisation de la création de contenu de blog SEO avec GPT-4, Perplexity AI et WordPress
Set
Code
Notion
+
Set
Code
Notion
39 NœudsLukaszB
Intelligence Artificielle
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds20
Catégorie-
Types de nœuds10
Description de la difficulté
Auteur
Pawan
@gladiatorAutomation consultant with expertise in n8n, AI models, and workflow optimization. I help educators, startups, and businesses design scalable automation for content creation, exam prep, and process efficiency. Skilled in integrating Google Sheets, Telegram, and AI agents for impactful results.
Liens externes
Voir sur n8n.io →
Partager ce workflow