Les contrats fournisseurs sont gérés plus efficacement grâce à l’automatisation : centralisation, rappels d’échéances, archivage des avenants et suivi des obligations. Ce système sécurise la relation fournisseurs et prépare la gestion aux audits ou renégociations.
{
"meta": {
"instanceId": "6a2a7715680b8313f7cb4676321c5baa46680adfb913072f089f2766f42e43bd",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "7594b4b8-506e-4f87-b921-ad376c9b85f2",
"name": "Wait",
"type": "n8n-nodes-base.wait",
"position": [
1260,
0
],
"webhookId": "2126ffb5-dcff-4328-85f7-aff6470bffd1",
"parameters": {
"amount": 60
},
"typeVersion": 1.1
},
{
"id": "0a9e1ed8-2fbe-421a-89a1-663709cbcaaf",
"name": "Set Prompt",
"type": "n8n-nodes-base.set",
"position": [
1420,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "a21fe2d1-533b-4f09-94aa-9312c3dd05b8",
"name": "prompt",
"type": "string",
"value": "=Analyze reels: 1. How it starts 2. How it ends 3. What is going on video. For us important to understand main params of the video to be able reproduct it. Params: 1. Background 2. Pose 3. Text 4. Clothes 5. Context 6. People/participants/roles Example of result: Example 1: - Girl in the frame in evening dress - Party - Text: u201cLet's already admit that the most important ponte of a man is a gorgeous wife by his sideu201d - Formatting: White text in the center on the background of a dynamic frame. Example 2: - Behind-the-scenes moments from the shooting of the video - A girl with a beautiful figure, large breasts in a swimsuit and bathing skirt - Text below u201cWhen at 35 you explain to your man that you need a hand in the frame for the strongest partu201d."
}
]
}
},
"typeVersion": 3.4
},
{
"id": "78f145dc-cfd4-41b6-86d0-f1036adb6ef5",
"name": "Gemini - Generate Upload URL",
"type": "n8n-nodes-base.httpRequest",
"position": [
580,
0
],
"parameters": {
"url": "https://generativelanguage.googleapis.com/upload/v1beta/files",
"method": "POST",
"options": {
"response": {
"response": {
"fullResponse": true
}
}
},
"jsonBody": "={n"file": {n"display_name": "{{ $json.Video[0].filename }}"n}n}",
"sendBody": true,
"sendQuery": true,
"sendHeaders": true,
"specifyBody": "json",
"queryParameters": {
"parameters": [
{
"name": "key",
"value": ""
}
]
},
"headerParameters": {
"parameters": [
{
"name": "X-Goog-Upload-Protocol",
"value": "resumable"
},
{
"name": "X-Goog-Upload-Command",
"value": "start"
},
{
"name": "X-Goog-Upload-Header-Content-Length",
"value": "={{ $json.Video[0].size }}"
},
{
"name": "X-Goog-Upload-Header-Content-Type",
"value": "={{ $json.Video[0].type }}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "d93b28b4-2dec-45e8-87a3-81e6b5392885",
"name": "Gemini - Upload File",
"type": "n8n-nodes-base.httpRequest",
"position": [
920,
0
],
"parameters": {
"url": "={{ $('Gemini - Generate Upload URL').item.json.headers['x-goog-upload-url'] }}",
"method": "POST",
"options": {
"response": {}
},
"sendBody": true,
"sendQuery": true,
"contentType": "binaryData",
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "key",
"value": ""
}
]
},
"headerParameters": {
"parameters": [
{
"name": "Content-Length",
"value": "={{ $('Get Video').item.json.Video[0].size }}"
},
{
"name": "X-Goog-Upload-Offset",
"value": "0"
},
{
"name": "X-Goog-Upload-Command",
"value": "upload, finalize"
}
]
},
"inputDataFieldName": "data"
},
"typeVersion": 4.2
},
{
"id": "a5092a20-d120-47a3-a139-4b7698d4ccba",
"name": "Gemini - Ask Questions",
"type": "n8n-nodes-base.httpRequest",
"position": [
1620,
0
],
"parameters": {
"url": "https://generativelanguage.googleapis.com/v1beta/models/gemini-1.5-pro:generateContent",
"method": "POST",
"options": {
"response": {}
},
"jsonBody": "={n "contents": [n {n "parts": [n {n "text": "{{ $json.prompt }}"n },n {n "file_data": {n "mime_type": "{{ $('Save Values').item.json.mimeType }}",n "file_uri": "{{ $('Save Values').item.json.gemini_file_url }}"n }n }n ]n }n ]n}n",
"sendBody": true,
"sendQuery": true,
"specifyBody": "json",
"queryParameters": {
"parameters": [
{
"name": "key",
"value": ""
}
]
}
},
"typeVersion": 4.2
},
{
"id": "300d5f57-27ac-4cc5-95ba-df5086a9a57b",
"name": "Save Values",
"type": "n8n-nodes-base.set",
"position": [
1100,
0
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "4fb7b732-17f9-41a2-986d-5d62b1331242",
"name": "gemini_file_url",
"type": "string",
"value": "={{ $json.file.uri }}"
},
{
"id": "5f3018b4-571f-433c-a07b-2fb86f63b9b6",
"name": "mimeType",
"type": "string",
"value": "={{ $json.file.mimeType }}"
},
{
"id": "c5532f11-ec31-49f8-aa26-7f42b7d24fa4",
"name": "airtable_rec_id",
"type": "string",
"value": "={{ $('Get Video').item.json.id }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "e78d9080-0115-47db-b3c0-8ef8fb5944b1",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
-800
],
"parameters": {
"width": 2180,
"height": 380,
"content": "## Scenario 1"
},
"typeVersion": 1
},
{
"id": "e2dd16b8-e565-4010-a274-a6b4aabcd35a",
"name": "Apify - Fetch Reels",
"type": "n8n-nodes-base.httpRequest",
"position": [
760,
-700
],
"parameters": {
"url": "https://api.apify.com/v2/acts/apify~instagram-scraper/run-sync-get-dataset-items",
"method": "POST",
"options": {},
"jsonBody": "={n "addParentData": false,n "directUrls": [n "https://www.instagram.com/{{ $json['Instagram Username'] }}/"n ],n "enhanceUserSearchWithFacebookPage": false,n "isUserReelFeedURL": false,n "isUserTaggedFeedURL": false,n "onlyPostsNewerThan": "{{ new Date().toISOString().slice(0, 10).replace(/-\d+$/, '-01') }}",n "resultsLimit": 20,n "resultsType": "stories"n}",
"sendBody": true,
"sendQuery": true,
"specifyBody": "json",
"queryParameters": {
"parameters": [
{
"name": "token",
"value": ""
}
]
}
},
"typeVersion": 4.2
},
{
"id": "b29c8e1f-0b36-4e8b-bf07-dd9c04f24a66",
"name": "Sort",
"type": "n8n-nodes-base.sort",
"position": [
1180,
-700
],
"parameters": {
"options": {},
"sortFieldsUi": {
"sortField": [
{
"order": "descending",
"fieldName": "views"
}
]
}
},
"typeVersion": 1
},
{
"id": "b5aa98b2-22f1-474d-92b0-892c8b227322",
"name": "Limit",
"type": "n8n-nodes-base.limit",
"position": [
1380,
-700
],
"parameters": {},
"typeVersion": 1
},
{
"id": "bc40f3f8-58cd-4790-975f-2f6e9761ef54",
"name": "Save Fields",
"type": "n8n-nodes-base.set",
"position": [
960,
-700
],
"parameters": {
"mode": "raw",
"options": {},
"jsonOutput": "={n "url": {{ JSON.stringify($json.videoUrl) }}n,n "views": {{ $json.videoViewCount }},n"caption": {{ JSON.stringify($json.caption) }}n,n"creator": "{{ $('Loop Over Items').item.json.Name }}"n}"
},
"typeVersion": 3.4
},
{
"id": "0623571f-cef0-4a1d-9bed-a397ed264ac4",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
500,
-700
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "7d675702-a9c4-4440-b44d-30ee8e36d206",
"name": "Execute Workflow1",
"type": "n8n-nodes-base.executeWorkflow",
"position": [
1860,
-700
],
"parameters": {
"options": {},
"workflowId": {
"__rl": true,
"mode": "list",
"value": "6gkO35O8e27oFfyq",
"cachedResultName": "Gemini - Video Analysis 2"
}
},
"typeVersion": 1.1
},
{
"id": "30692806-c116-46de-8407-66ac94470cc4",
"name": "Download File",
"type": "n8n-nodes-base.httpRequest",
"position": [
760,
0
],
"parameters": {
"url": "={{ $('Get Video').item.json.Video[0].url }}",
"options": {
"response": {
"response": {
"responseFormat": "file"
}
}
}
},
"typeVersion": 4.2
},
{
"id": "0d130bb6-c445-4b7e-8628-442b26d4654a",
"name": "Create Video",
"type": "n8n-nodes-base.airtable",
"position": [
1640,
-700
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appndgSF4faN4jPXi",
"cachedResultUrl": "https://airtable.com/appndgSF4faN4jPXi",
"cachedResultName": "Philipp's Base"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbldgihe8Tx1DsAWq",
"cachedResultUrl": "https://airtable.com/appndgSF4faN4jPXi/tbldgihe8Tx1DsAWq",
"cachedResultName": "Videos"
},
"columns": {
"value": {
"Video": "={{ [ {"url":$json.url} ] }}",
"Views": "={{ $json.views }}",
"Caption": "={{ $json.caption }}",
"Creator": "={{ [$json.creator] }}"
},
"schema": [
{
"id": "Caption",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Video",
"type": "array",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Video",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Guideline",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Guideline",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Creation Date",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "Creation Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Creator",
"type": "array",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Creator",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Views",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Views",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"Name"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {
"typecast": true
},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "XT7hvl1w201jtBhx",
"name": "Philipp Key 2"
}
},
"typeVersion": 2.1
},
{
"id": "c59bbd59-1f64-4606-a074-1303f423408c",
"name": "Get Video",
"type": "n8n-nodes-base.airtable",
"position": [
380,
0
],
"parameters": {
"id": "={{ $json.id }}",
"base": {
"__rl": true,
"mode": "list",
"value": "appndgSF4faN4jPXi",
"cachedResultUrl": "https://airtable.com/appndgSF4faN4jPXi",
"cachedResultName": "Philipp's Base"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbldgihe8Tx1DsAWq",
"cachedResultUrl": "https://airtable.com/appndgSF4faN4jPXi/tbldgihe8Tx1DsAWq",
"cachedResultName": "Videos"
},
"options": {}
},
"credentials": {
"airtableTokenApi": {
"id": "XT7hvl1w201jtBhx",
"name": "Philipp Key 2"
}
},
"typeVersion": 2.1
},
{
"id": "f588e905-464b-4a24-b8cd-69b6c176b1c8",
"name": "Set Guideline",
"type": "n8n-nodes-base.airtable",
"position": [
1800,
0
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appndgSF4faN4jPXi",
"cachedResultUrl": "https://airtable.com/appndgSF4faN4jPXi",
"cachedResultName": "Philipp's Base"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbldgihe8Tx1DsAWq",
"cachedResultUrl": "https://airtable.com/appndgSF4faN4jPXi/tbldgihe8Tx1DsAWq",
"cachedResultName": "Videos"
},
"columns": {
"value": {
"id": "={{ $('Get Video').first().json.id }}",
"Guideline": "={{ $json.candidates[0].content.parts[0].text }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "ID",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "ID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Video",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Video",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Guideline",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Guideline",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update"
},
"credentials": {
"airtableTokenApi": {
"id": "XT7hvl1w201jtBhx",
"name": "Philipp Key 2"
}
},
"typeVersion": 2.1
},
{
"id": "54d5c8ab-1e69-4c73-a869-8aaccc306fea",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
-120
],
"parameters": {
"width": 2180,
"height": 380,
"content": "## Scenario 2"
},
"typeVersion": 1
},
{
"id": "7de49be9-cdcd-41f1-a996-79b31bf795a7",
"name": "Search Creators",
"type": "n8n-nodes-base.airtable",
"position": [
280,
-700
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appndgSF4faN4jPXi",
"cachedResultUrl": "https://airtable.com/appndgSF4faN4jPXi",
"cachedResultName": "Philipp's Base"
},
"limit": null,
"table": {
"__rl": true,
"mode": "list",
"value": "tbl8uSud7C0kZe3RO",
"cachedResultUrl": "https://airtable.com/appndgSF4faN4jPXi/tbl8uSud7C0kZe3RO",
"cachedResultName": "Creators"
},
"options": {},
"operation": "search",
"returnAll": false
},
"credentials": {
"airtableTokenApi": {
"id": "XT7hvl1w201jtBhx",
"name": "Philipp Key 2"
}
},
"typeVersion": 2.1
},
{
"id": "bdda9fe7-e1a5-4e9e-b562-577b97424152",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
60,
-700
],
"parameters": {
"rule": {
"interval": [
{
"field": "months"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "ad77267d-3bba-463a-b9d2-f5aeb444e746",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
700,
-800
],
"parameters": {
"color": 6,
"width": 220,
"height": 80,
"content": "### Replace Apify token"
},
"typeVersion": 1
},
{
"id": "9f444c18-d8b9-4544-9f7e-7ca2a97b4efe",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
520,
-120
],
"parameters": {
"color": 6,
"width": 200,
"height": 80,
"content": "### Replace Google token"
},
"typeVersion": 1
},
{
"id": "48b0acfb-cb7e-4ea5-b0fa-779a2adaf82a",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
880,
-120
],
"parameters": {
"color": 6,
"width": 200,
"height": 80,
"content": "### Replace Google token"
},
"typeVersion": 1
},
{
"id": "ce2c2e36-faf2-4b32-a67d-d4229d8de4cf",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
1580,
-120
],
"parameters": {
"color": 6,
"width": 200,
"height": 80,
"content": "### Replace Google token"
},
"typeVersion": 1
},
{
"id": "0eb22e2b-19ab-4e09-9917-cf6dcff6cc1e",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1360,
-120
],
"parameters": {
"color": 6,
"width": 200,
"height": 80,
"content": "### Set own prompt for analysis"
},
"typeVersion": 1
},
{
"id": "2ab98afe-0846-4ece-a559-1cbcbfbb7af9",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-780,
-800
],
"parameters": {
"color": 7,
"width": 636.2128494576581,
"height": 497.1532689930921,
"content": "n## Copy Viral Reels with Gemini AIn**Made by [Mark Shcherbakov](https://www.linkedin.com/in/marklowcoding/) from community [5minAI](https://www.skool.com/5minai)**nnAnalyzing video performance on Instagram can be tedious and time-consuming, requiring multiple steps and data extraction. This workflow automates the process of fetching, analyzing, and recording insights from Instagram Reels, making it simpler for users to track engagement metrics without manual intervention.nnThis workflow integrates several services to analyze Instagram Reels, allowing users to:n- Automatically fetch recent Reels from specified creators.n- Analyze the most-watched videos for insights.n- Store and manage data in Airtable for easy access and reporting.nn"
},
"typeVersion": 1
},
{
"id": "0b83903a-c464-4049-8ef4-30976d8d24b5",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
-780,
-280
],
"parameters": {
"color": 7,
"width": 280,
"height": 346,
"content": "### Set up stepsnn1. **Create accounts**:n - Set up Airtable, Edify, n8n, and Gemini accounts.nn2. **Prepare triggers and modules**:n - Replace credentials in each node accordingly.nn3. **Configure data flow**:n - Ensure modules are set to fetch and analyze the correct data fields as outlined in the guide."
},
"typeVersion": 1
},
{
"id": "9973661d-d662-4b12-90f2-bf007532a58a",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-480,
-280
],
"parameters": {
"color": 7,
"width": 330.5152611046425,
"height": 239.5888196628349,
"content": "### ... or watch set up video [8 min]n[](https://youtu.be/SQPPM0KLsrM)n"
},
"typeVersion": 1
},
{
"id": "532e9b78-95de-40ea-ba3e-c7c028f4afa7",
"name": "When Executed by Another Workflow",
"type": "n8n-nodes-base.executeWorkflowTrigger",
"position": [
160,
0
],
"parameters": {
"inputSource": "passthrough"
},
"typeVersion": 1.1
}
],
"pinData": {},
"connections": {
"Sort": {
"main": [
[
{
"node": "Limit",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Set Prompt",
"type": "main",
"index": 0
}
]
]
},
"Limit": {
"main": [
[
{
"node": "Create Video",
"type": "main",
"index": 0
}
]
]
},
"Get Video": {
"main": [
[
{
"node": "Gemini - Generate Upload URL",
"type": "main",
"index": 0
}
]
]
},
"Set Prompt": {
"main": [
[
{
"node": "Gemini - Ask Questions",
"type": "main",
"index": 0
}
]
]
},
"Save Fields": {
"main": [
[
{
"node": "Sort",
"type": "main",
"index": 0
}
]
]
},
"Save Values": {
"main": [
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Create Video": {
"main": [
[
{
"node": "Execute Workflow1",
"type": "main",
"index": 0
}
]
]
},
"Download File": {
"main": [
[
{
"node": "Gemini - Upload File",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Apify - Fetch Reels",
"type": "main",
"index": 0
}
]
]
},
"Search Creators": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Search Creators",
"type": "main",
"index": 0
}
]
]
},
"Execute Workflow1": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Apify - Fetch Reels": {
"main": [
[
{
"node": "Save Fields",
"type": "main",
"index": 0
}
]
]
},
"Gemini - Upload File": {
"main": [
[
{
"node": "Save Values",
"type": "main",
"index": 0
}
]
]
},
"Gemini - Ask Questions": {
"main": [
[
{
"node": "Set Guideline",
"type": "main",
"index": 0
}
]
]
},
"Gemini - Generate Upload URL": {
"main": [
[
{
"node": "Download File",
"type": "main",
"index": 0
}
]
]
},
"When Executed by Another Workflow": {
"main": [
[
{
"node": "Get Video",
"type": "main",
"index": 0
}
]
]
}
}
}