Générer des descriptions IA pour de nouvelles entrées Google Sheets avec GPT-4.1-mini
Intermédiaire
Ceci est unContent Creation, Multimodal AIworkflow d'automatisation du domainecontenant 9 nœuds.Utilise principalement des nœuds comme GoogleSheets, Agent, GoogleSheetsTrigger, LmChatOpenAi, OutputParserStructured. Générer des descriptions IA pour de nouvelles entrées Google Sheets avec GPT-4.1-mini
Prérequis
- •Informations d'identification Google Sheets API
- •Clé API OpenAI
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
{
"meta": {
"instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "0ad754e7-e05a-4935-a792-f3178248099a",
"name": "Modèle de chat OpenAI",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-1024,
160
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "4l6TDfLZVFS24g3X",
"name": "OpenAi account 4"
}
},
"typeVersion": 1.2
},
{
"id": "7f83e0b2-5561-480f-b3c6-9bba76158752",
"name": "Analyseur de sortie structurée",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
-832,
128
],
"parameters": {
"jsonSchemaExample": "{\n\t\"description\": \"description\"\n}"
},
"typeVersion": 1.3
},
{
"id": "d88108ee-e1a0-43d2-948a-37bd706a33b5",
"name": "Mettre à jour une ligne dans la feuille",
"type": "n8n-nodes-base.googleSheets",
"position": [
-672,
-336
],
"parameters": {
"columns": {
"value": {
"topic": "={{ $('Row added - Google Sheet').item.json.topic }}",
"description": "={{ $json.output.description }}"
},
"schema": [
{
"id": "topic",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "topic",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "description",
"type": "string",
"display": true,
"required": false,
"displayName": "description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "number",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"topic"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit#gid=0",
"cachedResultName": "data"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit?usp=drivesdk",
"cachedResultName": "Sheets Triggers"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "bfa0fde3-6ddb-4e69-a1d5-b6d86ef89672",
"name": "Ajouter une ligne dans la feuille",
"type": "n8n-nodes-base.googleSheets",
"position": [
-656,
-32
],
"parameters": {
"columns": {
"value": {
"Update": "={{ $('Row added - Google Sheet').item.json.topic }} was added"
},
"schema": [
{
"id": "Update",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Update",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"topic"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 196803262,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit#gid=196803262",
"cachedResultName": "actions"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit?usp=drivesdk",
"cachedResultName": "Sheets Triggers"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "ae9c19db-71eb-4b38-adba-ca5d7468bdc2",
"name": "Note adhésive16",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2432,
-656
],
"parameters": {
"width": 2016,
"content": "## 📬 Need Help or Want to Customize This?\n📧 [robert@ynteractive.com](mailto:robert@ynteractive.com) \n🔗 [LinkedIn](https://www.linkedin.com/in/robert-breen-29429625/)"
},
"typeVersion": 1
},
{
"id": "6196c4fc-679c-4b5e-bbcc-685917d4fa5a",
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2432,
-480
],
"parameters": {
"color": 5,
"width": 904,
"height": 860,
"content": "### Step 1: Set Up Your Google Sheets\n\n**Option 1: Use Our Pre-Made Template (Recommended)**\n1. Copy our template: [AI Description Generator Template](https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit?usp=sharing)\n2. Click \"File\" → \"Make a copy\" to create your own version\n3. Rename it as desired (e.g., \"My AI Content Generator\")\n4. Note your new sheet's URL - you'll need this for the workflow\n\n**Option 2: Create From Scratch**\n1. Go to [Google Sheets](https://sheets.google.com/)\n2. Create a new spreadsheet\n3. **Set up the main \"data\" tab:**\n - Rename \"Sheet1\" to \"data\"\n - Set up column headers in row 1:\n - A1: `topic`\n - B1: `description`\n4. **Create an \"actions\" tab:**\n - Add a new sheet and name it \"actions\"\n - Set up column headers:\n - A1: `Update`\n5. Copy your sheet's URL\n\n### Step 2: Configure Google API Access\n\n1. **Enable Google Sheets API**\n - Go to [Google Cloud Console](https://console.cloud.google.com/)\n - Create a new project or select existing one\n - Enable \"Google Sheets API\"\n - Enable \"Google Drive API\"\n\n"
},
"typeVersion": 1
},
{
"id": "ab630ed2-52a0-42ac-9e3d-3d9826ceb7e4",
"name": "Ligne ajoutée - Feuille Google",
"type": "n8n-nodes-base.googleSheetsTrigger",
"position": [
-1376,
96
],
"parameters": {
"event": "rowAdded",
"options": {},
"pollTimes": {
"item": [
{
"mode": "everyMinute"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit#gid=0",
"cachedResultName": "data"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1d8O_Iwg5UtDjHM22zWHMegORatYzaQUYmzrcYnG5OSs/edit?usp=drivesdk",
"cachedResultName": "Sheets Triggers"
}
},
"credentials": {
"googleSheetsTriggerOAuth2Api": {
"id": "5qZk3IRejGCu9qrm",
"name": "Google Sheets Trigger account"
}
},
"typeVersion": 1
},
{
"id": "5b4d1f11-89c8-4b38-89f1-2e353eaa9b40",
"name": "Rédacteur de description",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-992,
-112
],
"parameters": {
"text": "={{ $json.topic }}",
"options": {
"systemMessage": "write a description of the topic. \n\noutput like this. \n\n{\n\t\"description\": \"description\"\n}"
},
"promptType": "define",
"hasOutputParser": true
},
"typeVersion": 2.2
},
{
"id": "8150251e-63e2-43a0-8952-85b86c796df0",
"name": "Note adhésive1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1504,
-480
],
"parameters": {
"color": 4,
"width": 1096,
"height": 860,
"content": "\n### Step 4: Import and Configure the N8N Workflow\n\n1. **Import the Workflow**\n - Copy the workflow JSON from the template\n - In your N8N instance, go to Workflows → Import from JSON\n - Paste the JSON and import\n\n2. **Configure OpenAI Credentials**\n - Click on the \"OpenAI Chat Model\" node\n - Set up credentials using your OpenAI API key\n - Test the connection to ensure it works\n\n3. **Configure Google Sheets Integration**\n \n **For the Trigger Node:**\n - Click on \"Row added - Google Sheet\" node\n - Set up Google Sheets Trigger OAuth2 credentials\n - Select your spreadsheet from the dropdown\n - Choose the \"data\" sheet\n - Set polling to \"Every Minute\" (already configured)\n\n"
},
"typeVersion": 1
}
],
"pinData": {
"Row added - Google Sheet": [
{
"topic": "n8n",
"description": ""
}
]
},
"connections": {
"0ad754e7-e05a-4935-a792-f3178248099a": {
"ai_languageModel": [
[
{
"node": "5b4d1f11-89c8-4b38-89f1-2e353eaa9b40",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"5b4d1f11-89c8-4b38-89f1-2e353eaa9b40": {
"main": [
[
{
"node": "d88108ee-e1a0-43d2-948a-37bd706a33b5",
"type": "main",
"index": 0
},
{
"node": "bfa0fde3-6ddb-4e69-a1d5-b6d86ef89672",
"type": "main",
"index": 0
}
]
]
},
"ab630ed2-52a0-42ac-9e3d-3d9826ceb7e4": {
"main": [
[
{
"node": "5b4d1f11-89c8-4b38-89f1-2e353eaa9b40",
"type": "main",
"index": 0
}
]
]
},
"7f83e0b2-5561-480f-b3c6-9bba76158752": {
"ai_outputParser": [
[
{
"node": "5b4d1f11-89c8-4b38-89f1-2e353eaa9b40",
"type": "ai_outputParser",
"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é ?
Intermédiaire - Création de contenu, IA Multimodale
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
Éditeur de rédaction et de blog pour blogs
Éditeur d'écriture et de blog avec mémoire basée sur Google Sheets (GPT-4)
If
Code
Filter
+
If
Code
Filter
18 NœudsRobert Breen
Création de contenu
Enregistreur de notes de podcast
Créer des scripts publicitaires Meta à fort taux de conversion avec GPT et Gemini en combinant les données de performance
Set
Google Sheets
Manual Trigger
+
Set
Google Sheets
Manual Trigger
12 NœudsRobert Breen
Création de contenu
Traduction automatique multilingue du contenu de blog
Traduire automatiquement le contenu du blog en plusieurs langues en utilisant GPT-4o et Markdown
Set
Merge
Split Out
+
Set
Merge
Split Out
12 NœudsRobert Breen
Création de contenu
Extraction de données structurées Dun & Bradstreet (GPT-4o)
Extraire des données structurées à partir de rapports Dun & Bradstreet avec GPT-4o
Http Request
Convert To File
Agent
+
Http Request
Convert To File
Agent
11 NœudsRobert Breen
Création de contenu
Générer des titres Instagram à partir de l'analyse d'étiquettes avec Apify + GPT-4o-mini
Générer des titres Instagram à partir de l'analyse des étiquettes avec Apify + GPT-4o-mini
Set
Code
Merge
+
Set
Code
Merge
17 NœudsRobert Breen
Création de contenu
AI网站chatbot - GPT与Google表格CRM线索收集
intégrationGPTetGoogle表格deAI网站chatbot - CRM线索收集系统
Code
Google Sheets
Agent
+
Code
Google Sheets
Agent
14 NœudsRobert Breen
Génération de leads
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds9
Catégorie2
Types de nœuds6
Description de la difficulté
Auteur
Robert Breen
@rbreenProfessional services consultant with over 10 years of experience solving complex business problems across industries. I specialize in n8n and process automation—designing custom workflows that integrate tools like Google Calendar, Airtable, GPT, and internal systems. Whether you need to automate scheduling, sync data, or streamline operations, I build solutions that save time and drive results.
Liens externes
Voir sur n8n.io →
Partager ce workflow