Trends Social Media - {{ $('Loop Over TikTok Queries').first().json.Query }}

{ "edges": [ { "to": "94097653-0e95-47d5-ad66-3a2920249458", "from": "67f547d3-234b-48c4-a0e4-f22c68cddf50", "toPort": "0", "fromPort": "0" }, { "to": "ab6b8fd2-5171-4273-8a0e-898a8558f009", "from": "67f547d3-234b-48c4-a0e4-f22c68cddf50", "toPort": "0", "fromPort": "0" }, { "to": "7ff09b4e-f990-4d7c-8496-40b6e0674642", "from": "4913d4bc-5db1-453f-9825-04625f26ed0a", "toPort": "0", "fromPort": "0" }, { "to": "f57ac21e-eaf9-455c-812e-c34572957f7f", "from": "7ff09b4e-f990-4d7c-8496-40b6e0674642", "toPort": "0", "fromPort": "0" }, { "to": "ef644544-31a8-48de-a8b6-72f91b36a77a", "from": "9efb06ca-39fa-48e1-b9b1-5744b6a67e5c", "toPort": "0", "fromPort": "0" }, { "to": "9efb06ca-39fa-48e1-b9b1-5744b6a67e5c", "from": "f57ac21e-eaf9-455c-812e-c34572957f7f", "toPort": "0", "fromPort": "1" }, { "to": "67f547d3-234b-48c4-a0e4-f22c68cddf50", "from": "ef644544-31a8-48de-a8b6-72f91b36a77a", "toPort": "0", "fromPort": "0" }, { "to": "f57ac21e-eaf9-455c-812e-c34572957f7f", "from": "94097653-0e95-47d5-ad66-3a2920249458", "toPort": "0", "fromPort": "0" } ], "nodes": [ { "id": "4913d4bc-5db1-453f-9825-04625f26ed0a", "name": "When Schedule Triggers", "type": "trigger", "params": { "kind": "n8n-nodes-base.scheduleTrigger", "rule": { "interval": [ {} ] } }, "position": [ 1072, 848 ] }, { "id": "94097653-0e95-47d5-ad66-3a2920249458", "name": "Send TikTok Report by Email", "type": "integration", "params": { "sendTo": "user@example.com", "message": "=\n\n\n \n \n Trends Social Media - {{ $('Loop Over TikTok Queries').first().json.Query }}\n \n\n\n

\n \n \n\n \n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n

Hashtag	TikTok	Reddit	Instagram	Score Total
\n #{{ $('Loop Over TikTok Queries').first().json.Query }}\n	\n {{ $('Rank TikTok Posts1').all().filter(item => item.json.source === 'TikTok').reduce((sum, item) => sum + item.json.score, 0).toLocaleString('fr-FR') }}\n	\n {{ $('Rank TikTok Posts1').all().filter(item => item.json.source === 'Reddit').reduce((sum, item) => sum + item.json.score, 0).toLocaleString('fr-FR') }}\n	\n {{ $('Rank TikTok Posts1').all().filter(item => item.json.source === 'Instagram').reduce((sum, item) => sum + item.json.score, 0).toLocaleString('fr-FR') }}\n	\n {{ $('Rank TikTok Posts1').all().reduce((sum, item) => sum + item.json.score, 0).toLocaleString('fr-FR') }}\n

\n\n \n

#{{ $('Loop Over TikTok Queries').first().json.Query }}

\n \n \n \n \n \n \n \n \n \n \n \n \n \n {{ $('Rank TikTok Posts1').all().map(item => `\n \n \n \n \n \n \n \n \n `).join('') }}\n \n

Rang	Source	Auteur	Contenu	Score	Level
\n ${item.json.rank}\n	\n ${item.json.source}\n	\n ${item.json.author}\n	\n ${item.json.content} \n	\n ${item.json.score.toLocaleString('fr-FR')}\n	\n ${item.json.level}\n

\n\n \n \n

\n\n", "options": {}, "service": "gmail", "subject": "Social media monitoring", "operation": "read" }, "position": [ 2400, 848 ] }, { "id": "9efb06ca-39fa-48e1-b9b1-5744b6a67e5c", "name": "Scrape TikTok via Apify", "type": "http", "params": { "url": "https://api.apify.com/v2/acts/clockworks~tiktok-scraper/run-sync-get-dataset-items", "method": "POST", "options": {}, "jsonBody": "={\n \"hashtags\": [\"{{ $json.Query.replace(/\\s+/g, '') }}\"],\n \"resultsPerPage\": 50,\n \"oldestPostDateUnified\": \"7 days\"\n}", "sendBody": true, "sendHeaders": true, "specifyBody": "json", "authentication": "predefinedCredentialType", "headerParameters": { "parameters": [ { "name": "Content-Type", "value": "application/json" } ] }, "nodeCredentialType": "apifyApi" }, "position": [ 1744, 848 ] }, { "id": "ef644544-31a8-48de-a8b6-72f91b36a77a", "name": "Score and Sort TikTok Posts", "type": "code", "params": { "jsCode": "// Code pour nœud Code n8n - Classement TikTok avec score personnalisé\n// Récupérer les données d'entrée\nconst items = $input.all();\n\n// Vérifier si on a des données\nif (!items || items.length === 0) {\n console.log(\"❌ Aucune donnée d'entrée trouvée\");\n return [];\n}\n\n// Extraire les posts TikTok du JSON\nlet posts = [];\n\n// Si les données sont dans un tableau à l'intérieur du premier item\nif (items[0] && items[0].json && Array.isArray(items[0].json)) {\n posts = items[0].json;\n} \n// Si les données sont directement dans les items\nelse if (Array.isArray(items)) {\n posts = items.map(item => item.json);\n}\n\nconsole.log(`📥 ${posts.length} posts TikTok trouvés`);\n\n// Calculer le score pour chaque post TikTok\nconst postsWithScore = posts.map((post, index) => {\n // Métriques TikTok\n const likes = post.diggCount || 0;\n const comments = post.commentCount || 0;\n const shares = post.shareCount || 0;\n const views = post.playCount || 0;\n \n // Calcul du score : (likes * 1) + (comments * 2) + (shares * 3) + (views / 1000)\n const likesScore = likes * 1;\n const commentsScore = comments * 2;\n const sharesScore = shares * 3;\n const viewsScore = Math.floor(views / 1000);\n const totalScore = likesScore + commentsScore + sharesScore + viewsScore;\n \n return {\n json: {\n url: post.webVideoUrl || `https://www.tiktok.com/@${post.authorMeta?.name}/video/${post.id}`,\n caption: post.text || \"Pas de caption\",\n score: totalScore,\n // Données détaillées pour debug (optionnel)\n details: {\n likes: likes,\n comments: comments,\n shares: shares,\n views: views,\n author: post.authorMeta?.name || \"Inconnu\",\n id: post.id\n }\n }\n };\n}).filter(post => post.json.url); // Filtrer les posts sans URL\n\nconsole.log(`✅ ${postsWithScore.length} posts traités avec succès`);\n\n// Trier par score décroissant\nconst sortedPosts = postsWithScore.sort((a, b) => b.json.score - a.json.score);\n\n// Prendre les 10 meilleurs\nconst topPosts = sortedPosts.slice(0, 10);\n\n// Ajouter un rang à chaque post\nconst rankedPosts = topPosts.map((post, index) => ({\n json: {\n rank: index + 1,\n url: post.json.url,\n caption: post.json.caption,\n score: post.json.score\n }\n}));\n\n// Retourner les résultats avec le format demandé : url, caption, score\nreturn rankedPosts;" }, "position": [ 1984, 848 ] }, { "id": "f57ac21e-eaf9-455c-812e-c34572957f7f", "name": "Loop Over TikTok Queries", "type": "passthrough", "params": { "mode": "noOp", "options": {} }, "position": [ 1520, 848 ] }, { "id": "67f547d3-234b-48c4-a0e4-f22c68cddf50", "name": "Rank TikTok Posts1", "type": "code", "params": { "jsCode": "// Code pour nœud Code n8n - Classement TikTok\n// Récupérer le keyword dynamiquement\nconst keyword = $('Loop Over TikTok Queries').first().json.Query;\n\n// Récupérer les données du nœud précédent\nconst tiktokData = $('Score and Sort TikTok Posts').all();\n\n// Fonction pour déterminer le level basé sur le score\nfunction getLevel(score) {\n if (score >= 10000) return 'High';\n if (score >= 1000) return 'Medium';\n return 'Low';\n}\n\n// Fonction pour extraire l'auteur TikTok\nfunction getAuthor(item) {\n const tiktokMatch = item.url.match(/tiktok\\.com\\/@([^\\/]+)/);\n return tiktokMatch ? `@${tiktokMatch[1]}` : '@inconnu';\n}\n\n// Transformer les données TikTok\nconst tiktokPosts = tiktokData.map(item => ({\n json: {\n source: 'TikTok',\n keyword: keyword,\n author: getAuthor(item.json),\n content: (item.json.caption || 'Pas de caption').substring(0, 50) + '...',\n score: item.json.score,\n level: getLevel(item.json.score),\n url: item.json.url,\n originalRank: item.json.rank\n }\n}));\n\n// Trier par score décroissant\nconst sortedPosts = tiktokPosts.sort((a, b) => b.json.score - a.json.score);\n\n// Ajouter le rang\nconst rankedPosts = sortedPosts.map((post, index) => ({\n json: {\n ...post.json,\n rank: index + 1,\n date: new Date().toISOString().split('T')[0]\n }\n}));\n\n// Prendre le top 15\nconst topPosts = rankedPosts.slice(0, 15);\n\nreturn topPosts;" }, "position": [ 2176, 848 ] }, { "id": "7ff09b4e-f990-4d7c-8496-40b6e0674642", "name": "Get Queries from Table1", "type": "passthrough", "params": { "mode": "noOp", "operation": "get", "returnAll": true, "dataTableId": { "__rl": true, "mode": "list", "value": "BYMzHVIbNU0mmvAZ", "cachedResultUrl": "/projects/oTpNUA7ZOCuhiQA0/datatables/BYMzHVIbNU0mmvAZ", "cachedResultName": "Query social media" } }, "position": [ 1264, 848 ] }, { "id": "ab6b8fd2-5171-4273-8a0e-898a8558f009", "name": "Save Rankings to Table1", "type": "passthrough", "params": { "mode": "noOp", "columns": { "value": { "url": "={{ $json.url }}", "Date": "={{ $now.toISO() }}", "rank": "={{ $json.rank }}", "level": "={{ $json.level }}", "score": "={{ $json.score }}", "author": "={{ $json.author }}", "source": "={{ $json.source }}", "content": "={{ $json.content }}", "keyword": "={{ $json.keyword }}" }, "schema": [ { "id": "rank", "type": "number", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "rank", "defaultMatch": false }, { "id": "keyword", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "keyword", "defaultMatch": false }, { "id": "source", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "source", "defaultMatch": false }, { "id": "author", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "author", "defaultMatch": false }, { "id": "content", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "content", "defaultMatch": false }, { "id": "score", "type": "number", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "score", "defaultMatch": false }, { "id": "level", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "level", "defaultMatch": false }, { "id": "url", "type": "string", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "url", "defaultMatch": false }, { "id": "Date", "type": "dateTime", "display": true, "removed": false, "readOnly": false, "required": false, "displayName": "Date", "defaultMatch": false } ], "mappingMode": "defineBelow", "matchingColumns": [], "attemptToConvertTypes": false, "convertFieldsToString": false }, "options": {}, "dataTableId": { "__rl": true, "mode": "list", "value": "75Jvx9ALCoEGcdwY", "cachedResultUrl": "/projects/oTpNUA7ZOCuhiQA0/datatables/75Jvx9ALCoEGcdwY", "cachedResultName": "Trend Social media" } }, "position": [ 2400, 720 ] } ] }

Monitor TikTok hashtag trends with Apify and send ranked reports via Gmail