Importer des notes Google Keep dans Google Sheets avec OpenAI et Google Drive
Avancé
Ceci est unOther, AIworkflow d'automatisation du domainecontenant 18 nœuds.Utilise principalement des nœuds comme If, Set, Filter, GoogleDrive, GoogleSheets, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. Importer les notes Google Keep dans Google Sheets avec OpenAI et Google Drive
Prérequis
- •Informations d'identification Google Drive API
- •Informations d'identification Google Sheets API
- •Clé API OpenAI
Nœuds utilisés (18)
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
{
"nodes": [
{
"id": "ee3cd6ff-40ba-40d4-bbbf-90244da4a272",
"name": "Lors du clic sur 'Tester le workflow'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
-155
],
"parameters": {},
"typeVersion": 1
},
{
"id": "68584aab-c5f3-450a-a1e3-cddc8d64082d",
"name": "Extraire du fichier",
"type": "n8n-nodes-base.extractFromFile",
"position": [
1100,
-280
],
"parameters": {
"options": {},
"operation": "fromJson"
},
"typeVersion": 1
},
{
"id": "e23a67a1-44df-4b83-a80a-9383f4432c7d",
"name": "Si is archived est false",
"type": "n8n-nodes-base.if",
"position": [
1540,
-280
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "e051d2f2-7c22-4864-bbe7-4832cc54acaa",
"operator": {
"type": "boolean",
"operation": "false",
"singleValue": true
},
"leftValue": "={{ $json.data.isArchived }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "313764d0-f115-46d3-a2e3-1fde647f7d85",
"name": "OpenAI Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1848,
-60
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "1IOLtYX7aTspCAN8",
"name": "OpenAI Pollup"
}
},
"typeVersion": 1.2
},
{
"id": "81fcc7a0-955d-4930-b203-8e98d57e3c4c",
"name": "Si extension est json",
"type": "n8n-nodes-base.filter",
"position": [
660,
-280
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "7b80be39-b5cc-4f96-8529-75559aaece38",
"operator": {
"name": "filter.operator.equals",
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.name.split('.').pop(); }}",
"rightValue": "=json"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "1c8c81ea-d0ae-4925-ae4b-05482c1b5fa2",
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
-340,
-380
],
"parameters": {
"color": 4,
"width": 260,
"height": 440,
"content": "## How to export your Google keep notes \n* Google has a dedicated service for exporting your google data, called [Google Takeout](https://takeout.google.com/), you'll have to login it. \n* Click on \"Deselect all\" then select only Google Keep and click on \"Next\". \n- Select the destination (use \"Send download link via mail\" as you'll have to uncompress a zip file before to send it again to Google Drive)\n- Upload to Google Drive all json files from your uncompresed file, to specific directory and you are ready to start!\n"
},
"typeVersion": 1
},
{
"id": "31eb6398-cca0-4ed1-910a-470fa49c9727",
"name": "Rechercher dans le dossier 'Keep'",
"type": "n8n-nodes-base.googleDrive",
"position": [
220,
-155
],
"parameters": {
"limit": 2,
"filter": {
"folderId": {
"__rl": true,
"mode": "list",
"value": "1BggjRVCqyDnECK_mB2M-PYareptQv99P",
"cachedResultUrl": "https://drive.google.com/drive/folders/1BggjRVCqyDnECK_mB2M-PYareptQv99P",
"cachedResultName": "Keep"
},
"whatToSearch": "files"
},
"options": {},
"resource": "fileFolder"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "veQ5hnnOES56fTcI",
"name": "Google Drive account good"
}
},
"typeVersion": 3
},
{
"id": "653d04b2-4020-4254-a8f5-53e15228adb7",
"name": "Boucler tous les 10 éléments",
"type": "n8n-nodes-base.splitInBatches",
"position": [
440,
-155
],
"parameters": {
"options": {},
"batchSize": 10
},
"typeVersion": 3
},
{
"id": "c1171bd7-5e2d-49e6-a52b-6e9282cb093d",
"name": "Télécharger les fichiers",
"type": "n8n-nodes-base.googleDrive",
"position": [
880,
-280
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "id",
"value": "={{ $json.id }}"
},
"options": {},
"operation": "download"
},
"credentials": {
"googleDriveOAuth2Api": {
"id": "veQ5hnnOES56fTcI",
"name": "Google Drive account good"
}
},
"typeVersion": 3
},
{
"id": "4d9caff3-2ac8-40fc-91a4-1b395e693141",
"name": "Ajouter un traitement IA ici si nécessaire",
"type": "@n8n/n8n-nodes-langchain.agent",
"notes": "Yu can use this AI Agent to process a number or anything you need from your notes",
"position": [
1760,
-280
],
"parameters": {
"text": "=Extract the amount in euros of the input. output just the amount and nothing else. \nHere is the input:{{ $json.data.textContent }}",
"options": {},
"promptType": "define"
},
"typeVersion": 1.8
},
{
"id": "d97c4e02-4b1a-479f-8492-e601c553ac57",
"name": "Définir les champs pour l'exportation",
"type": "n8n-nodes-base.set",
"position": [
2136,
-280
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "d05409ea-b739-47bd-9c07-0dea40b83de1",
"name": "textContent",
"type": "string",
"value": "={{ $('If is archived is false').item.json.data.textContent }}"
},
{
"id": "acbe202e-de95-4a47-a90b-78556fec4650",
"name": "Edited",
"type": "string",
"value": "={{ new Date($('If is archived is false').item.json.data.userEditedTimestampUsec / 1000).toLocaleString() }}"
},
{
"id": "13f00e53-75fd-4db5-9a22-b5e329c72b47",
"name": "Created",
"type": "string",
"value": "={{ new Date($('If is archived is false').item.json.data.createdTimestampUsec / 1000).toLocaleString() }}"
},
{
"id": "7e58e874-5238-4fb6-8b00-ea947c59ec4b",
"name": "isArchived",
"type": "boolean",
"value": "={{ $('If is archived is false').item.json.data.isArchived }}"
},
{
"id": "721f31d8-4944-4a63-878e-71816eee755c",
"name": "Amount",
"type": "string",
"value": "={{ $json.output }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "0f8d9b1f-f5de-477f-ad50-eeb89bcf8dc7",
"name": "Ajouter à la feuille google",
"type": "n8n-nodes-base.googleSheets",
"position": [
2356,
-155
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "textContent",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "textContent",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Edited",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Edited",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Created",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "isArchived",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "isArchived",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1rjgyHw6XU4NTRCx4eXuQ0AIXhY3mWqxg1NiAhrSnuzE/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1rjgyHw6XU4NTRCx4eXuQ0AIXhY3mWqxg1NiAhrSnuzE",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1rjgyHw6XU4NTRCx4eXuQ0AIXhY3mWqxg1NiAhrSnuzE/edit?usp=drivesdk",
"cachedResultName": "googl keep export (10/05/25)"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "31141cf2-94d6-45ad-8632-18001a6d4d36",
"name": "Filtrer",
"type": "n8n-nodes-base.if",
"position": [
1320,
-280
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "or",
"conditions": [
{
"id": "11bacf5f-6675-4681-b205-5e5293eaae02",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json.data.textContentHtml }}",
"rightValue": "dépensé"
},
{
"id": "c40da1df-559c-4278-bde1-cdb8e65c8428",
"operator": {
"type": "string",
"operation": "contains"
},
"leftValue": "={{ $json.data.textContentHtml }}",
"rightValue": "depense"
}
]
}
},
"typeVersion": 2.2
},
{
"id": "c4c941f5-6579-4f4f-9916-cdd496498760",
"name": "Note adhésive1",
"type": "n8n-nodes-base.stickyNote",
"position": [
2300,
-360
],
"parameters": {
"color": 5,
"height": 360,
"content": "## Create an empty google sheet file\n\nThat will get your entries from the notes "
},
"typeVersion": 1
},
{
"id": "3ab60239-85cf-4c84-94d3-659fdfef4316",
"name": "Note adhésive2",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-300
],
"parameters": {
"color": 5,
"height": 360,
"content": "## Set the directory Where you put the files"
},
"typeVersion": 1
},
{
"id": "49546099-e072-4183-a14e-fff80928920d",
"name": "Note adhésive3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1240,
-480
],
"parameters": {
"color": 5,
"height": 360,
"content": "## Filter the files\n\nIf you need the content to contain a word, or after a certain date.\n\nIf you don't need to filter it, just remove the node"
},
"typeVersion": 1
},
{
"id": "195923a2-faf9-40c3-95c0-08fdc078e291",
"name": "Note adhésive4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1720,
-500
],
"parameters": {
"color": 5,
"width": 320,
"height": 560,
"content": "## Process each file with AI\n\nIf you need the extract some information from the contextq, you can do it here. If you don't need it, just delete the node"
},
"typeVersion": 1
},
{
"id": "07b3570a-72cf-480b-b3b8-fb461b57822d",
"name": "Note adhésive5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-340,
80
],
"parameters": {
"color": 4,
"width": 380,
"height": 300,
"content": "## Setup\n* Export your Google Keep notes (see \"how to export your Google Keep notes\")\n\n- Connect Google Drive, OpenAI, and Google Sheets in n8n.\n\n- Set the correct folder path for your notes in the “Search in ‘Keep’ folder” node.\n\n- Point the Google Sheet node to your spreadsheet"
},
"typeVersion": 1
},
{
"id": "48e1cff2-2748-4d15-91b4-d5ee2f5d9581",
"name": "Note adhésive6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-340,
-500
],
"parameters": {
"width": 720,
"height": 100,
"content": "## Contact me\n### If you need some help with this workflow: Write to me: [thomas@pollup.net](mailto:thomas@pollup.net)\n"
},
"typeVersion": 1
}
],
"connections": {
"31141cf2-94d6-45ad-8632-18001a6d4d36": {
"main": [
[
{
"node": "e23a67a1-44df-4b83-a80a-9383f4432c7d",
"type": "main",
"index": 0
}
]
]
},
"68584aab-c5f3-450a-a1e3-cddc8d64082d": {
"main": [
[
{
"node": "31141cf2-94d6-45ad-8632-18001a6d4d36",
"type": "main",
"index": 0
}
]
]
},
"313764d0-f115-46d3-a2e3-1fde647f7d85": {
"ai_languageModel": [
[
{
"node": "4d9caff3-2ac8-40fc-91a4-1b395e693141",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"c1171bd7-5e2d-49e6-a52b-6e9282cb093d": {
"main": [
[
{
"node": "68584aab-c5f3-450a-a1e3-cddc8d64082d",
"type": "main",
"index": 0
}
]
]
},
"0f8d9b1f-f5de-477f-ad50-eeb89bcf8dc7": {
"main": [
[
{
"node": "653d04b2-4020-4254-a8f5-53e15228adb7",
"type": "main",
"index": 0
}
]
]
},
"653d04b2-4020-4254-a8f5-53e15228adb7": {
"main": [
[],
[
{
"node": "81fcc7a0-955d-4930-b203-8e98d57e3c4c",
"type": "main",
"index": 0
}
]
]
},
"81fcc7a0-955d-4930-b203-8e98d57e3c4c": {
"main": [
[
{
"node": "c1171bd7-5e2d-49e6-a52b-6e9282cb093d",
"type": "main",
"index": 0
}
]
]
},
"e23a67a1-44df-4b83-a80a-9383f4432c7d": {
"main": [
[
{
"node": "4d9caff3-2ac8-40fc-91a4-1b395e693141",
"type": "main",
"index": 0
}
]
]
},
"31eb6398-cca0-4ed1-910a-470fa49c9727": {
"main": [
[
{
"node": "653d04b2-4020-4254-a8f5-53e15228adb7",
"type": "main",
"index": 0
}
]
]
},
"d97c4e02-4b1a-479f-8492-e601c553ac57": {
"main": [
[
{
"node": "0f8d9b1f-f5de-477f-ad50-eeb89bcf8dc7",
"type": "main",
"index": 0
}
]
]
},
"ee3cd6ff-40ba-40d4-bbbf-90244da4a272": {
"main": [
[
{
"node": "31eb6398-cca0-4ed1-910a-470fa49c9727",
"type": "main",
"index": 0
}
]
]
},
"4d9caff3-2ac8-40fc-91a4-1b395e693141": {
"main": [
[
{
"node": "d97c4e02-4b1a-479f-8492-e601c553ac57",
"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é - Autres, Intelligence Artificielle
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
Agent IA restaurant [Modèle]
🤖 Assistant IA pour WhatsApp, Instagram et Messenger
If
N8n
Set
+
If
N8n
Set
239 NœudsAmanda Benks
Autres
Préparation automatique de la refinement agile avec Gmail, OpenAI et Google Sheets
Utiliser Gmail, OpenAI et Google Sheets pour automatiser la préparation du raffinement Agile
If
Set
Gmail
+
If
Set
Gmail
51 NœudsWillemijn
Produit
Automatisation de la planification des sprints d'équipes agiles
Automatiser la planification des sprints pour les équipes agiles avec OpenAI, Google Agenda et Gmail
If
Set
Code
+
If
Set
Code
52 NœudsWillemijn
Produit
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
Enregistrement des informations nutritionnelles des repas de Telegram dans Google Sheets via un agent IA
Enregistrer les informations nutritionnelles des repas dans Google Sheets via un agent IA et Telegram
If
Set
Code
+
If
Set
Code
23 NœudsPollupAI
Autres
Automatisation des demandes LinkedIn et des messages d'ouverture avec Browserflow et Google Sheets
Utiliser Browserflow et Google Sheets pour automatiser les demandes LinkedIn et les messages d'ouverture
If
Set
Sort
+
If
Set
Sort
44 NœudsPollupAI
Ventes
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds18
Catégorie2
Types de nœuds11
Description de la difficulté
Auteur
PollupAI
@zeerobugWe create bespoke AI solutions, automations and agents that help your business as it scales.
Liens externes
Voir sur n8n.io →
Partager ce workflow