Extraction des données de factures PDF vers Google Sheets avec Gemini AI 📄
Avancé
Ceci est unContent Creation, Multimodal AIworkflow d'automatisation du domainecontenant 28 nœuds.Utilise principalement des nœuds comme Code, Gmail, Limit, GoogleDrive, HttpRequest. Extraire des données de factures de PDF vers Google Sheets avec Gemini AI 📄
Prérequis
- •Compte Google et informations d'identification Gmail API
- •Informations d'identification Google Drive API
- •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 (28)
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": "dca66bfe20538326afcf0ea9818c4e437640a050446b589da002699d11b2eea7",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "714b6c99-8f0a-439b-94d7-29bea1589dba",
"name": "Note Intro",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1888,
-880
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "36f55639-f8b7-4733-b9e5-a17551fdb633",
"name": "Note Configuration",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1520,
-880
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "f1b4ea4f-7566-41e2-af24-e4a19b5d93c5",
"name": "Note Extraction IA",
"type": "n8n-nodes-base.stickyNote",
"position": [
432,
-992
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "37dbc171-8e58-4eb6-a326-e3629dfc41b0",
"name": "Note Séparation des données",
"type": "n8n-nodes-base.stickyNote",
"position": [
992,
-1008
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "11ffaff7-b3cc-408a-9abe-43b794a5463f",
"name": "Note Sheets Google",
"type": "n8n-nodes-base.stickyNote",
"position": [
1584,
-944
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "9c4e40cd-8129-428d-a88d-b5562350b75b",
"name": "Note Gmail",
"type": "n8n-nodes-base.stickyNote",
"position": [
1376,
-1312
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "ffcac485-5c9c-485c-bc6e-fb01a00aecb9",
"name": "Note Extension",
"type": "n8n-nodes-base.stickyNote",
"position": [
1664,
-1312
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "44ec1ad5-daa0-49fc-b502-4f176a112413",
"name": "Comparer les jeux de données1",
"type": "n8n-nodes-base.compareDatasets",
"position": [
-432,
-720
],
"parameters": {},
"typeVersion": 2.3
},
{
"id": "2c3bbfee-8ca9-4e88-bf9c-e4cdbb99d9db",
"name": "Extraire du fichier1",
"type": "n8n-nodes-base.extractFromFile",
"position": [
256,
-704
],
"parameters": {},
"typeVersion": 1
},
{
"id": "559ca06b-7caf-4852-b27c-44fa8f24f416",
"name": "Modèle de chat Google Gemini2",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
512,
-560
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3dbb9100-2549-4421-814c-a3260e31cf4d",
"name": "Journaliser le traitement du document1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1680,
-720
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "1b3f9c22-09a3-401f-9f1a-3226dd535a4d",
"name": "Nettoyer la sortie1",
"type": "n8n-nodes-base.code",
"position": [
-656,
-800
],
"parameters": {},
"typeVersion": 2
},
{
"id": "96c85220-8cf0-4e6a-bbb5-870a7129c3ea",
"name": "Obtenir la liste des fichiers PDF1",
"type": "n8n-nodes-base.httpRequest",
"position": [
-848,
-800
],
"parameters": {},
"typeVersion": 4.2
},
{
"id": "8c29b1cf-983f-4a4c-a031-b42f351f7b46",
"name": "Lire les documents traités1",
"type": "n8n-nodes-base.googleSheets",
"position": [
-736,
-608
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "74c6773d-4794-4b9a-8600-0c3d76dd8ca4",
"name": "Note adhésive4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-928,
-880
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "70d08a7f-2e3f-4c87-b211-42f9431fdd79",
"name": "Note adhésive5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-144,
-880
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "df813074-a781-45ea-98a0-5941f22fa7f8",
"name": "Agent IA - extraire les éléments cibles du texte1",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
544,
-784
],
"parameters": {},
"typeVersion": 1.9
},
{
"id": "479aa135-bed9-464d-9d0f-fd1e21f0958f",
"name": "Note adhésive7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1184,
-880
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "fcdb2e08-cb36-479b-85fc-3e30219e5d24",
"name": "Déclencheur Drive Google1",
"type": "n8n-nodes-base.googleDriveTrigger",
"position": [
-1120,
-704
],
"parameters": {},
"typeVersion": 1
},
{
"id": "548694d2-ced7-4047-8ce2-99077202c840",
"name": "Télécharger le fichier1",
"type": "n8n-nodes-base.googleDrive",
"position": [
64,
-704
],
"parameters": {},
"typeVersion": 3
},
{
"id": "0fcd4caf-6f6b-41ad-b882-c7c58fd3e0e4",
"name": "Analyseur de sortie structurée1",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
688,
-608
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "1f2a7b86-5134-4541-8c84-f5544f62f4c8",
"name": "Modèle de chat Google Gemini3",
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"position": [
768,
-480
],
"parameters": {},
"typeVersion": 1
},
{
"id": "7f825e30-be8e-4ada-a74e-0831ea3580bd",
"name": "Limite1",
"type": "n8n-nodes-base.limit",
"disabled": true,
"position": [
-128,
-704
],
"parameters": {},
"typeVersion": 1
},
{
"id": "11e663ae-b30d-4b22-9c85-92a09bf94818",
"name": "Envoyer un message1",
"type": "n8n-nodes-base.gmail",
"position": [
1456,
-1120
],
"webhookId": "8783a094-d477-4a8a-af9c-ce6fa4c5bb29",
"parameters": {},
"executeOnce": true,
"typeVersion": 2.1
},
{
"id": "2c9e2591-51ca-4cf3-b1b8-f30a854a0a0f",
"name": "Mettre à jour les champs de facture1",
"type": "n8n-nodes-base.googleSheets",
"position": [
1456,
-784
],
"parameters": {},
"typeVersion": 4.5
},
{
"id": "02719e23-6981-4dab-81ba-b49ff1462cb2",
"name": "Boucler sur les éléments1",
"type": "n8n-nodes-base.splitInBatches",
"position": [
1008,
-784
],
"parameters": {},
"typeVersion": 3
},
{
"id": "767efe5c-6da5-4048-a56a-dec53da68438",
"name": "Code en JavaScript1",
"type": "n8n-nodes-base.code",
"position": [
1232,
-784
],
"parameters": {},
"typeVersion": 2
},
{
"id": "571d934d-c285-402a-aab3-7020dc9e2614",
"name": "Note adhésive",
"type": "n8n-nodes-base.stickyNote",
"position": [
208,
-880
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"7f825e30-be8e-4ada-a74e-0831ea3580bd": {
"main": [
[
{
"node": "548694d2-ced7-4047-8ce2-99077202c840",
"type": "main",
"index": 0
}
]
]
},
"1b3f9c22-09a3-401f-9f1a-3226dd535a4d": {
"main": [
[
{
"node": "44ec1ad5-daa0-49fc-b502-4f176a112413",
"type": "main",
"index": 0
}
]
]
},
"548694d2-ced7-4047-8ce2-99077202c840": {
"main": [
[
{
"node": "2c3bbfee-8ca9-4e88-bf9c-e4cdbb99d9db",
"type": "main",
"index": 0
}
]
]
},
"02719e23-6981-4dab-81ba-b49ff1462cb2": {
"main": [
[
{
"node": "11e663ae-b30d-4b22-9c85-92a09bf94818",
"type": "main",
"index": 0
}
],
[
{
"node": "767efe5c-6da5-4048-a56a-dec53da68438",
"type": "main",
"index": 0
}
]
]
},
"44ec1ad5-daa0-49fc-b502-4f176a112413": {
"main": [
[
{
"node": "7f825e30-be8e-4ada-a74e-0831ea3580bd",
"type": "main",
"index": 0
}
]
]
},
"2c3bbfee-8ca9-4e88-bf9c-e4cdbb99d9db": {
"main": [
[
{
"node": "df813074-a781-45ea-98a0-5941f22fa7f8",
"type": "main",
"index": 0
}
]
]
},
"767efe5c-6da5-4048-a56a-dec53da68438": {
"main": [
[
{
"node": "2c9e2591-51ca-4cf3-b1b8-f30a854a0a0f",
"type": "main",
"index": 0
}
]
]
},
"8c29b1cf-983f-4a4c-a031-b42f351f7b46": {
"main": [
[
{
"node": "44ec1ad5-daa0-49fc-b502-4f176a112413",
"type": "main",
"index": 1
}
]
]
},
"fcdb2e08-cb36-479b-85fc-3e30219e5d24": {
"main": [
[
{
"node": "96c85220-8cf0-4e6a-bbb5-870a7129c3ea",
"type": "main",
"index": 0
},
{
"node": "8c29b1cf-983f-4a4c-a031-b42f351f7b46",
"type": "main",
"index": 0
}
]
]
},
"96c85220-8cf0-4e6a-bbb5-870a7129c3ea": {
"main": [
[
{
"node": "1b3f9c22-09a3-401f-9f1a-3226dd535a4d",
"type": "main",
"index": 0
}
]
]
},
"2c9e2591-51ca-4cf3-b1b8-f30a854a0a0f": {
"main": [
[
{
"node": "3dbb9100-2549-4421-814c-a3260e31cf4d",
"type": "main",
"index": 0
}
]
]
},
"559ca06b-7caf-4852-b27c-44fa8f24f416": {
"ai_languageModel": [
[
{
"node": "df813074-a781-45ea-98a0-5941f22fa7f8",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"1f2a7b86-5134-4541-8c84-f5544f62f4c8": {
"ai_languageModel": [
[
{
"node": "0fcd4caf-6f6b-41ad-b882-c7c58fd3e0e4",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"0fcd4caf-6f6b-41ad-b882-c7c58fd3e0e4": {
"ai_outputParser": [
[
{
"node": "df813074-a781-45ea-98a0-5941f22fa7f8",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"3dbb9100-2549-4421-814c-a3260e31cf4d": {
"main": [
[
{
"node": "02719e23-6981-4dab-81ba-b49ff1462cb2",
"type": "main",
"index": 0
}
]
]
},
"df813074-a781-45ea-98a0-5941f22fa7f8": {
"main": [
[
{
"node": "02719e23-6981-4dab-81ba-b49ff1462cb2",
"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é - 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
Anonymiser et reformater des CVs avec Gemini AI, Google Sheets et Apps Script
Utiliser Gemini AI, Google Sheets et Apps Script pour anonymiser et reformater des CV
Code
Google Drive
Http Request
+
Code
Google Drive
Http Request
18 NœudsLouis
Ressources Humaines
AI驱动dee-mail分诊与automatique回复系统，intégrationOpenAIagentetGmail
AI驱动dee-mail分诊与automatique回复系统，intégrationOpenAIagentetGmail
If
Set
Gmail
+
If
Set
Gmail
68 NœudsAbdullahi Ahmed
Création de contenu
Automatisation du criblage des qualifications DEI avec Azure OpenAI et Google Workspace
Filtrage automatisé des qualifications DEI via Azure GPT-4o, Google Drive et Sheets
If
Code
Gmail
+
If
Code
Gmail
19 NœudsRahul Joshi
Création de contenu
Automatisation de courts métrages sans visage avec OpenAI, RunwayML et ElevenLabs
Automatisation de courts métrages sans visage : du script aux réseaux sociaux avec OpenAI, RunwayML et ElevenLabs
Set
Code
Wait
+
Set
Code
Wait
56 NœudsLeeWei
Création de contenu
Automatisation de la recherche d'emploi et de la personnalisation des CV avec Mistral AI, LinkedIn et Google Sheets
Automatisation de la recherche d'offres d'emploi et de la personnalisation de CV avec Mistral AI, LinkedIn et Google Sheets
Set
Code
Html
+
Set
Code
Html
46 NœudsJordan Hoyle
Productivité personnelle
Processus de scraping et de contact Apollo 1 ✅
Génération automatisée de prospects avec Apollo, analyse IA et suivi par e-mail programmé
If
Code
Wait
+
If
Code
Wait
39 NœudsDeniz
Création de contenu
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds28
Catégorie2
Types de nœuds14
Description de la difficulté
Auteur
Louis
@louisdl🚀 Business & tech consultant specialized in No Code automation and AI. I help SMEs, startups, and independents save time and cut costs with scalable workflows in n8n and other tools. Passionate about making automation simple, useful, and human-centered. 👉 Also sharing automation insights on YouTube Find all my links here : https://linktr.ee/cashflows.routine And my AI Agency here : https://agence-alain.fr
Liens externes
Voir sur n8n.io →
Partager ce workflow