Workflow n8n
Automatisation Google Sheets avec n8n : suivi des prix Amazon
Ce workflow n8n a pour objectif de suivre les prix des produits sur Amazon en utilisant Google Sheets. Il s'adresse aux entreprises qui souhaitent surveiller les fluctuations de prix de leurs produits afin d'optimiser leurs stratégies d'achat ou de vente. Grâce à cette automatisation n8n, les utilisateurs peuvent facilement gérer une liste de produits à surveiller, recevoir des alertes en cas de changements de prix, et conserver un historique des prix dans une feuille de calcul Google. Le processus commence par un déclencheur programmé qui active le workflow à intervalles réguliers. Ensuite, les produits à surveiller sont extraits de Google Sheets. Chaque produit est ensuite analysé à l'aide d'une requête HTTP vers Scrapeops pour obtenir les informations de prix actuelles. Si un changement de prix est détecté, une alerte est envoyée par email à l'utilisateur, et les données sont mises à jour dans Google Sheets pour maintenir un historique précis. Ce workflow permet non seulement de gagner du temps, mais aussi de prendre des décisions éclairées basées sur des données précises, ce qui renforce la compétitivité de l'entreprise sur le marché.
Tags clés :Google Sheetsautomatisationsuivi des prixn8ne-commerce
Catégorie: Scheduled · Tags: Google Sheets, automatisation, suivi des prix, n8n, e-commerce❤ 0
Workflow n8n Google Sheets, suivi des prix, e-commerce : vue d'ensemble
Schéma des nœuds et connexions de ce workflow n8n, généré à partir du JSON n8n.
Workflow n8n Google Sheets, suivi des prix, e-commerce : détail des nœuds
Inscris-toi pour voir l'intégralité du workflow
Inscription gratuite
S'inscrire gratuitementBesoin d'aide ?{
"id": "TqnC0nyAa0LRfYBX",
"meta": {
"instanceId": "c2ff056313a72210aa803da7c5191a260dbed0dab6ae2b8e39a8dd21701bf0ab",
"templateCredsSetupCompleted": true
},
"name": "Amazon Product Price Tracker",
"tags": [],
"nodes": [
{
"id": "cc15c8e6-53f9-4dd1-895f-34a72af4506f",
"name": "Products to Monitor",
"type": "n8n-nodes-base.googleSheets",
"position": [
40,
-220
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1hRv-TBXrpN6rkIU65WorttNHt-IPWas_An0sF4Of39U/edit#gid=0",
"cachedResultName": "Products to Monitor"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $json.spreadsheet_url }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "xWJJNb7VGUUp4vzV",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.5
},
{
"id": "4ec34045-ea02-40bc-a243-b50c804ab947",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
260,
-220
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "d5cdb7eb-144f-477b-83d6-85be5cd2eb79",
"name": "Scrapeops - Amazon Product",
"type": "n8n-nodes-base.httpRequest",
"position": [
720,
-80
],
"parameters": {
"url": "https://proxy.scrapeops.io/v1/structured-data/amazon/product",
"options": {},
"sendQuery": true,
"queryParameters": {
"parameters": [
{
"name": "asin",
"value": "={{ $('Loop Over Items').item.json.asin }}"
},
{
"name": "api_key",
"value": "={{ $('Setup').item.json.scrapeops_apikey }}"
}
]
}
},
"typeVersion": 4.2
},
{
"id": "32134749-17e9-456a-9814-2e03b34ce37b",
"name": "Fields",
"type": "n8n-nodes-base.set",
"position": [
940,
-80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "ae829540-06b7-4ea8-a5f8-d2750b02c530",
"name": "name",
"type": "string",
"value": "={{ $json.data.name }}"
},
{
"id": "4dec41ce-3522-481b-985f-455c858702e0",
"name": "pricing",
"type": "number",
"value": "={{ parseFloat(($json.data.pricing || \"\").replace(/[^\\d.-]/g, \"\")) || 0 }}"
},
{
"id": "ebb64d89-e9b2-4384-9778-fce8aa9eb3be",
"name": "product_url",
"type": "string",
"value": "=https://www.amazon.com/dp/{{ $('Loop Over Items').item.json.asin }}?th=1&psc=1"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "954afd09-609f-4ed1-94a0-6d6431b8a9e6",
"name": "Last Price",
"type": "n8n-nodes-base.set",
"position": [
480,
-80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "db85d431-5631-4629-99f8-426ec3d7ecc7",
"name": "last_pricing",
"type": "number",
"value": "={{ $json.pricing }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "695673df-6bf7-4e64-898c-f143c77c8ff0",
"name": "Price Change",
"type": "n8n-nodes-base.set",
"position": [
1420,
-180
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "4ef9bde2-62d3-4d6a-9759-4ae6c13db127",
"name": "price_change",
"type": "number",
"value": "={{ \n $('Last Price').item.json.last_pricing !== \"\" && $('Last Price').item.json.last_pricing !== undefined ? \n ($json.pricing - $('Last Price').item.json.last_pricing).toFixed(2) : \n 0 \n}}"
},
{
"id": "02e5a84b-76bf-4511-a78d-c725882a64dc",
"name": "percent_change",
"type": "number",
"value": "={{ \n $('Last Price').item.json.last_pricing !== \"\" && $('Last Price').item.json.last_pricing !== undefined && parseFloat($('Last Price').item.json.last_pricing) !== 0 ? \n ((($json.pricing - $('Last Price').item.json.last_pricing) / $('Last Price').item.json.last_pricing)).toFixed(2) : \n 0 \n}}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "ab56b334-c4a7-45f7-95d0-9c7e990c21d7",
"name": "Alert Status",
"type": "n8n-nodes-base.set",
"position": [
1600,
-180
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "fd261f8a-8417-4fdb-95de-bd71768300e6",
"name": "alert_status",
"type": "string",
"value": "={{ \n $json.percent_change > $('Loop Over Items').item.json.alert_threshold_high ? \n \"High\" : \n ($json.percent_change < $('Loop Over Items').item.json.alert_threshold_low ? \n \"Low\" : \n \"\")\n}}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "54f3ef24-58bc-4eba-b341-b14ab9f66d68",
"name": "Insert - Price History",
"type": "n8n-nodes-base.googleSheets",
"position": [
2020,
-180
],
"parameters": {
"columns": {
"value": {
"asin": "={{ $('Loop Over Items').item.json.asin }}",
"pricing": "={{ $('Scrapeops - Amazon Product').item.json.data.pricing.replace(/[^\\d.]/g, '') }}",
"timestamp": "={{$now.format(\"MM/dd/yyyy HH:mm:ss\")}}"
},
"schema": [
{
"id": "asin",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "asin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pricing",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "pricing",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "timestamp",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "timestamp",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "Price History"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $('Setup').item.json.spreadsheet_url }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "xWJJNb7VGUUp4vzV",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.5
},
{
"id": "b161e44b-1fbf-40f1-a485-a7b132f42efc",
"name": "Update - Products to Monitor",
"type": "n8n-nodes-base.googleSheets",
"position": [
1800,
-180
],
"parameters": {
"columns": {
"value": {
"asin": "={{ $('Loop Over Items').item.json.asin }}",
"name": "={{ $('Scrapeops - Amazon Product').item.json.data.name }}",
"pricing": "={{ $('Scrapeops - Amazon Product').item.json.data.pricing.replace(/[^\\d.]/g, '') }}",
"product_url": "=https://www.amazon.com/dp/{{ $('Loop Over Items').item.json.asin }}?th=1&psc=1",
"alert_status": "={{ $json.alert_status }}",
"last_updated": "={{$now.format(\"MM/dd/yyyy HH:mm:ss\")}}",
"price_change": "={{ $('Price Change').item.json.price_change }}",
"average_rating": "={{ $('Scrapeops - Amazon Product').item.json.data.average_rating }}",
"percent_change": "={{ $('Price Change').item.json.percent_change }}"
},
"schema": [
{
"id": "asin",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "asin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "alert_threshold_low",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "alert_threshold_low",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "alert_threshold_high",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "alert_threshold_high",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "average_rating",
"type": "string",
"display": true,
"required": false,
"displayName": "average_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "product_url",
"type": "string",
"display": true,
"required": false,
"displayName": "product_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "pricing",
"type": "string",
"display": true,
"required": false,
"displayName": "pricing",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "price_change",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "price_change",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "percent_change",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "percent_change",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "alert_status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "alert_status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_updated",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "last_updated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"asin"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "name",
"value": "Products to Monitor"
},
"documentId": {
"__rl": true,
"mode": "url",
"value": "={{ $('Setup').item.json.spreadsheet_url }}"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "xWJJNb7VGUUp4vzV",
"name": "Google Sheets account 2"
}
},
"typeVersion": 4.5
},
{
"id": "62372099-de2a-4dcf-afdf-e9d9697a7a95",
"name": "Send Email",
"type": "n8n-nodes-base.emailSend",
"position": [
2560,
120
],
"webhookId": "c0eb28fe-1c74-4692-9701-3790014c8951",
"parameters": {
"html": "=<!DOCTYPE html>\n<html>\n<head>\n <style>\n body { font-family: Arial, sans-serif; line-height: 1.6; color: #333; }\n .container { max-width: 600px; margin: 0 auto; padding: 20px; background: #fff; }\n .header { text-align: center; padding-bottom: 15px; border-bottom: 1px solid #eee; }\n .price-up { color: #d64541; font-weight: bold; }\n .price-down { color: #27ae60; font-weight: bold; }\n .price-details { background: #f5f5f5; padding: 15px; margin: 15px 0; border-radius: 5px; }\n .button {\n display: block;\n background-color: #2c3e50;\n color: white !important; \n text-decoration: none;\n text-align: center;\n padding: 10px;\n border-radius: 4px;\n margin: 20px auto;\n width: 200px;\n font-weight: bold;\n }\n .button:visited {\n color: white !important;\n background-color: #2c3e50 !important;\n text-decoration: none !important;\n }\n .button:hover {\n background-color: #34495e !important;\n text-decoration: none !important;\n }\n .footer { font-size: 12px; color: #999; text-align: center; margin-top: 20px; border-top: 1px solid #eee; padding-top: 15px; }\n </style>\n</head>\n<body>\n <div class=\"container\">\n <div class=\"header\">\n <h1>Price Alert</h1>\n <p>We've detected a significant price change for an item you're tracking</p>\n </div>\n\n <div class=\"price-details\">\n <h2 class=\"{{ $('Alert Status').item.json.alert_status === 'High' ? 'price-up' : 'price-down' }}\">\n {{ $('Alert Status').item.json.alert_status === 'High' ? 'Price Increased by ' : 'Price Decreased by ' }} \n {{ (Math.abs($('Update - Products to Monitor').item.json.percent_change * 100).toFixed(2)) }}%\n </h2>\n \n <h3>{{ $('Update - Products to Monitor').item.json.name }}</h3>\n <p>ASIN: {{ $json.asin }}</p>\n \n <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n <tr>\n <th align=\"left\">Previous Price</th>\n <th align=\"left\">Current Price</th>\n <th align=\"left\">Difference</th>\n </tr>\n <tr>\n <td>${{ $('Last Price').item.json.last_pricing.toFixed(2) }}</td>\n <td>${{ $('Update - Products to Monitor').item.json.pricing }}</td>\n <td>{{ \n $('Update - Products to Monitor').item.json.price_change >= 0 \n ? '$' + $('Update - Products to Monitor').item.json.price_change.toFixed(2) \n : '- $' + Math.abs($('Update - Products to Monitor').item.json.price_change).toFixed(2) \n }}</td>\n </tr>\n </table>\n \n <p>Last updated: {{ $('Insert - Price History').item.json.timestamp }}</p>\n </div>\n\n <a href=\"{{ $('Update - Products to Monitor').item.json.product_url }}\" class=\"button\">View Product</a>\n\n <div class=\"footer\">\n <p>This alert was generated by Amazon Price Tracker, your automated price monitoring system.</p>\n <p>© 2025 ScrapeOps. All rights reserved.</p>\n </div>\n </div>\n</body>\n</html>",
"options": {
"appendAttribution": false
},
"subject": "=Amazon Price Tracker Alert: {{ $('Update - Products to Monitor').item.json.name }} Price Change Detected",
"toEmail": "={{ $('Setup').item.json.to_email }}",
"fromEmail": "={{ $('Setup').item.json.from_email }}"
},
"credentials": {
"smtp": {
"id": "k3bEE2wVXvRZ42hg",
"name": "SMTP account"
}
},
"typeVersion": 2.1
},
{
"id": "834dd1f0-d651-48b4-8765-360d8d5dcf27",
"name": "Check Valid Price",
"type": "n8n-nodes-base.if",
"position": [
1160,
-80
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "f9d540d5-bc09-4970-904d-34977192b771",
"operator": {
"type": "number",
"operation": "gt"
},
"leftValue": "={{ $json.pricing }}",
"rightValue": 0
}
]
}
},
"typeVersion": 2.2
},
{
"id": "163385ad-6f41-4144-bf2a-6ba2e2425ae2",
"name": "Alert Decision",
"type": "n8n-nodes-base.if",
"position": [
2240,
-40
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "6b1f16aa-dd42-4889-9c07-7fdba5a56067",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $('Alert Status').item.json.alert_status }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "dd075f72-22bc-438e-a75b-a2437a8920c3",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1100,
-600
],
"parameters": {
"color": 5,
"width": 660,
"height": 360,
"content": "# Amazon Product Price Tracker\n\nThis workflow automates price monitoring for Amazon products using the ScrapeOps API. It tracks price changes over time, alerts you when prices cross your defined thresholds, and maintains a historical record of all price movements.\n\n## Features\n- Scheduled price checks for multiple Amazon products\n- Price change calculations (absolute and percentage)\n- Smart alerting based on customizable thresholds\n- Automated email notifications with detailed price information\n- Historical price tracking for trend analysis"
},
"typeVersion": 1
},
{
"id": "83324982-44e9-49cc-8782-d0520955c1ff",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1100,
-200
],
"parameters": {
"color": 5,
"width": 660,
"height": 740,
"content": "## API Configuration\nThis workflow requires a ScrapeOps API key to fetch Amazon product data.\nTo obtain your API key, register at https://scrapeops.io/app/register/main\n\n## API Documentation\nFor detailed information about the Amazon Product API endpoint used in this workflow,\nrefer to the official documentation at:\nhttps://scrapeops.io/docs/data-api/amazon-product-api/\nThe documentation provides details on all available parameters, response formats,\nand best practices for optimizing your API usage.\n\n## Integration Setup\nOnce registered, insert your API key in the \"Scrapeops - Amazon Product\" node parameters.\nThis workflow uses the structured data endpoint which returns clean, parsed product data\nin a consistent JSON format.\n\n## Google Sheets Configuration\nA Google Sheets spreadsheet is used to store the product data collected through this workflow.\nThe original template spreadsheet is shared in read-only mode through this link:\nhttps://docs.google.com/spreadsheets/d/1hRv-TBXrpN6rkIU65WorttNHt-IPWas_An0sF4Of39U\n\nTo use this workflow:\n1. Access the shared spreadsheet using the link above\n2. Make your own copy by going to File > Make a copy\n3. Share your copy with appropriate permissions\n4. In the n8n workflow, locate the \"Setup\" node\n5. Update the \"spreadsheet_url\" variable with the link to YOUR copy of the spreadsheet\n\nThis ensures each user works with their own separate spreadsheet, avoiding data overlap \nbetween different users while maintaining the original structure needed by the workflow."
},
"typeVersion": 1
},
{
"id": "2b3d3b37-7e9d-48a0-a97a-223f4d60c6a6",
"name": "Setup",
"type": "n8n-nodes-base.set",
"position": [
-160,
-220
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "6f1a8857-9ecc-4fcd-8803-4494ca230ae4",
"name": "spreadsheet_url",
"type": "string",
"value": "https://docs.google.com/spreadsheets/d/1hRv-TBXrpN6rkIU65WorttNHt-IPWas_An0sF4Of39U"
},
{
"id": "bbe91759-984c-4d62-b832-b37d84997211",
"name": "scrapeops_apikey",
"type": "string",
"value": ""
},
{
"id": "29428dd3-8659-43d0-a888-1e2ee7c37ab8",
"name": "from_email",
"type": "string",
"value": ""
},
{
"id": "d39032ee-895d-436e-9948-355d37abb740",
"name": "to_email",
"type": "string",
"value": ""
}
]
}
},
"typeVersion": 3.4
},
{
"id": "aab72c63-3864-42b4-87b6-c9911d8d09be",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-360,
-220
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours"
}
]
}
},
"typeVersion": 1.2
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "38990374-8154-4f1e-8026-ce206ed2d90d",
"connections": {
"Setup": {
"main": [
[
{
"node": "Products to Monitor",
"type": "main",
"index": 0
}
]
]
},
"Fields": {
"main": [
[
{
"node": "Check Valid Price",
"type": "main",
"index": 0
}
]
]
},
"Last Price": {
"main": [
[
{
"node": "Scrapeops - Amazon Product",
"type": "main",
"index": 0
}
]
]
},
"Send Email": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Alert Status": {
"main": [
[
{
"node": "Update - Products to Monitor",
"type": "main",
"index": 0
}
]
]
},
"Price Change": {
"main": [
[
{
"node": "Alert Status",
"type": "main",
"index": 0
}
]
]
},
"Alert Decision": {
"main": [
[
{
"node": "Send Email",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "Last Price",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Setup",
"type": "main",
"index": 0
}
]
]
},
"Check Valid Price": {
"main": [
[
{
"node": "Price Change",
"type": "main",
"index": 0
}
],
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Products to Monitor": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Insert - Price History": {
"main": [
[
{
"node": "Alert Decision",
"type": "main",
"index": 0
}
]
]
},
"Scrapeops - Amazon Product": {
"main": [
[
{
"node": "Fields",
"type": "main",
"index": 0
}
]
]
},
"Update - Products to Monitor": {
"main": [
[
{
"node": "Insert - Price History",
"type": "main",
"index": 0
}
]
]
}
}
}Workflow n8n Google Sheets, suivi des prix, e-commerce : pour qui est ce workflow ?
Ce workflow est destiné aux e-commerçants, aux responsables des achats et aux analystes de prix qui travaillent dans des entreprises de taille petite à moyenne. Un niveau technique de base est recommandé pour la configuration initiale du workflow.
Workflow n8n Google Sheets, suivi des prix, e-commerce : problème résolu
Ce workflow résout le problème de la surveillance manuelle des prix des produits sur Amazon, qui peut être chronophage et sujet à des erreurs. En automatisant ce processus, les utilisateurs éliminent les risques d'oubli et de perte d'opportunités d'achat. Après la mise en place, ils bénéficient d'une visibilité en temps réel sur les fluctuations de prix, ce qui leur permet de réagir rapidement et d'optimiser leurs marges.
Workflow n8n Google Sheets, suivi des prix, e-commerce : étapes du workflow
Étape 1 : Le workflow est déclenché selon un calendrier prédéfini.
- Étape 1 : Les produits à surveiller sont récupérés depuis Google Sheets.
- Étape 2 : Chaque produit est traité en lot pour interroger l'API de Scrapeops afin d'obtenir le prix actuel.
- Étape 3 : Les informations de prix sont analysées pour déterminer s'il y a eu un changement.
- Étape 4 : Si un changement est détecté, une alerte est envoyée par email à l'utilisateur.
- Étape 5 : Les données de prix sont mises à jour dans Google Sheets pour conserver un historique des prix.
Workflow n8n Google Sheets, suivi des prix, e-commerce : guide de personnalisation
Pour personnaliser ce workflow, vous pouvez modifier l'ID du document Google Sheets et le nom de la feuille pour correspondre à vos besoins. Assurez-vous également de configurer l'URL de l'API Scrapeops pour qu'elle corresponde aux produits que vous souhaitez surveiller. Vous pouvez ajuster les paramètres d'alerte par email, notamment l'adresse de destination et le contenu du message. Enfin, n'hésitez pas à ajouter d'autres noeuds pour intégrer des outils supplémentaires selon vos besoins.