Unternehmenssoziale Medien-Aktivitäten vor Anrufen auflisten
Experte
Dies ist ein Sales-Bereich Automatisierungsworkflow mit 19 Nodes. Hauptsächlich werden Set, Code, Html, Gmail, Merge und andere Nodes verwendet. Auflistung der Unternehmensaktivitäten in sozialen Medien vor Anrufen
Voraussetzungen
- •Google-Konto + Gmail API-Anmeldedaten
- •Möglicherweise sind Ziel-API-Anmeldedaten erforderlich
Verwendete Nodes (19)
Kategorie
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
"meta": {
"instanceId": "3c58c896c9089c8fb4d7f2b069bf3119193f239a1f538829758e2f4d6b5f5b24"
},
"nodes": [
{
"id": "f59411f9-5dad-4f8c-af0c-c3ab25171107",
"name": "Aktuelle Tweets abrufen",
"type": "n8n-nodes-base.httpRequest",
"position": [
233.55908776779552,
1409.619212163096
],
"parameters": {
"url": "https://twitter154.p.rapidapi.com/user/tweets",
"options": {
"batching": {
"batch": {
"batchSize": 1,
"batchInterval": 2000
}
}
},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "limit",
"value": "10"
},
{
"name": "user_id",
"value": "={{ $json.twitter.id }}"
},
{
"name": "include_replies",
"value": "={{ false }}"
},
{
"name": "include_pinned",
"value": "={{ false }}"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "X-RapidAPI-Host",
"value": "twitter154.p.rapidapi.com"
},
{
"name": "X-RapidAPI-Key",
"value": "={{ $('Setup').first().json.twitterAPIKey }}"
}
]
}
},
"typeVersion": 4.1
},
{
"id": "c25d29ef-71bb-4ea1-8794-47911dac997f",
"name": "Einrichtung",
"type": "n8n-nodes-base.set",
"position": [
-440,
980
],
"parameters": {
"fields": {
"values": [
{
"name": "linkedInAPIKey"
},
{
"name": "twitterAPIKey"
},
{
"name": "emails"
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "5bf52838-157b-49fe-a4d8-3817198502dd",
"name": "Jeden Morgen um 7 Uhr",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-680,
980
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 7
}
]
}
},
"typeVersion": 1.1
},
{
"id": "aff4dd6e-a480-4f43-9b48-05172d4b7b2d",
"name": "Heutige Meetings abrufen",
"type": "n8n-nodes-base.googleCalendar",
"position": [
-80,
980
],
"parameters": {
"options": {
"timeMax": "={{ $now.endOf('day') }}",
"timeMin": "={{ $now.beginningOf('day') }}",
"singleEvents": true
},
"calendar": {
"__rl": true,
"mode": "list",
"value": "milorad.filipovic19@gmail.com",
"cachedResultName": "milorad.filipovic19@gmail.com"
},
"operation": "getAll"
},
"typeVersion": 1
},
{
"id": "63973273-3821-4c9f-8976-6dd47ac9a62e",
"name": "E-Mail-Domänen der Teilnehmer abrufen",
"type": "n8n-nodes-base.set",
"position": [
120,
980
],
"parameters": {
"fields": {
"values": [
{
"name": "domain",
"type": "arrayValue",
"arrayValue": "={{ $json.attendees.filter(a => !a.organizer).map(a => a.email.split('@').pop()) }}"
},
{
"name": "attendeeEmails",
"type": "arrayValue",
"arrayValue": "={{ $json.attendees.filter(a => !a.organizer).map(a => a.email) }}"
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "093b978f-8d5e-4051-be21-e8a7a3430c9c",
"name": "Aufteilen",
"type": "n8n-nodes-base.splitOut",
"position": [
300,
980
],
"parameters": {
"include": "selectedOtherFields",
"options": {},
"fieldToSplitOut": "domain",
"fieldsToInclude": "attendeeEmails, start"
},
"typeVersion": 1
},
{
"id": "467308c9-c6a0-4d1c-a6e1-4598075e62a6",
"name": "Aktuelle LinkedIn-Beiträge abrufen",
"type": "n8n-nodes-base.httpRequest",
"position": [
233.55908776779552,
1209.619212163096
],
"parameters": {
"url": "https://fresh-linkedin-profile-data.p.rapidapi.com/get-company-posts",
"options": {
"batching": {
"batch": {}
}
},
"sendQuery": true,
"sendHeaders": true,
"queryParameters": {
"parameters": [
{
"name": "linkedin_url",
"value": "=https://www.linkedin.com/{{ $json.linkedin.handle }}"
},
{
"name": "sort_by",
"value": "recent"
}
]
},
"headerParameters": {
"parameters": [
{
"name": "X-RapidAPI-Key",
"value": "={{ $('Setup').item.json.linkedInAPIKey }}"
},
{
"name": "X-RapidAPI-Host",
"value": "fresh-linkedin-profile-data.p.rapidapi.com"
}
]
}
},
"typeVersion": 4.1
},
{
"id": "71a9223b-4d71-4d0d-a4df-f8836d3c3d1f",
"name": "Unternehmensdaten der Teilnehmer anreichern",
"type": "n8n-nodes-base.clearbit",
"position": [
640,
980
],
"parameters": {
"domain": "={{ $json.domain }}",
"additionalFields": {}
},
"typeVersion": 1
},
{
"id": "0fad8349-2a4f-4cee-a03e-98e8d95b015c",
"name": "Gmail",
"type": "n8n-nodes-base.gmail",
"position": [
1313.5590877677955,
1309.619212163096
],
"parameters": {
"sendTo": "={{ $('Setup').first().json.emails }}",
"message": "={{ $json.html }}",
"options": {},
"subject": "=Latest social activity for: {{ $('Extract data for email').item.json.name }} "
},
"credentials": {
"gmailOAuth2": {
"id": "10",
"name": "mrdosija@gmail.com"
}
},
"typeVersion": 2.1
},
{
"id": "bf667011-717e-4a5a-ac7d-c377edb063f8",
"name": "LinkedIn-Beiträge formatieren",
"type": "n8n-nodes-base.code",
"position": [
453.5590877677955,
1209.619212163096
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "// console.log('LINKEDIN', $('Enrich attendee company').item.json.name.toLowerCase())\nconst company = $('Enrich attendee company').item.json.name.toLowerCase();\n\nlet html = `\n<div style=\"display: flex; align-items: center; margin: 2em 0 1em\">\n <img src=\"https://store-images.s-microsoft.com/image/apps.31120.9007199266245564.44dc7699-748d-4c34-ba5e-d04eb48f7960.bc4172bd-63f0-455a-9acd-5457f44e4473\" style=\"width: 20px; height: 20px; margin-right: 10px\" />\n <h3 style=\"margin: 0\">LinkedIn posts</h3>\n</div>\n<table style=\"width: 100%\">\n`;\nfor(article of $input.item.json.data.slice(0,10)) {\n html += `\n <tr>\n <td style=\"background-color: #f7f9fc; font-family: sans-serif; padding: 0.3em 1em\">\n <div>\n <a style=\"display: block; color: #000; text-decoration: none; margin-bottom: 5px; font-size: 1.1em\" href=\"${article.url}\"><i>${article.text}</i></a>\n </div>\n <p style=\"margin: 0; font-size: 0.8em\">\n <span title=\"Likes\">❤️ ${article.num_likes}</span> | <span title=\"Comments\">💬 ${article.num_comments}</span>\n </p>\n </td>\n </tr>\n `\n}\nhtml += '</table>';\n\nreturn { \n \"html_linkedin\": html,\n name: $('Switch').item.json.name,\n meeting: $('Split Out').item.json\n};"
},
"typeVersion": 2
},
{
"id": "ee7ad92e-d4ed-4046-8d31-9c5ce4dda92b",
"name": "Tweets formatieren",
"type": "n8n-nodes-base.code",
"position": [
453.5590877677955,
1409.619212163096
],
"parameters": {
"mode": "runOnceForEachItem",
"jsCode": "const company = $('Enrich attendee company').item.json.name.toLowerCase();\nlet html = `\n<div style=\"display: flex; align-items: center; margin: 2em 0 1em\">\n <img src=\"https://img.freepik.com/free-vector/new-2023-twitter-logo-x-icon-design_1017-45418.jpg?size=338&ext=jpg&ga=GA1.1.2008272138.1708473600&semt=ais\" style=\"width: 20px; height: 20px; margin-right: 10px\" />\n <h3 style=\"margin: 0\">Tweets</h3>\n</div>\n<table style=\"width: 100%\">`;\nfor(article of $input.item.json.results) {\n html += `\n <tr>\n <td style=\"background-color: #f7f9fc; font-family: sans-serif; padding: 0.3em 1em\">\n <div>\n <a style=\"display: block; color: #000; text-decoration: none; margin-bottom: 5px; font-size: 1.1em\" href=\"https://twitter.com/${article.user.username}/status/${article.tweet_id}\">\n <i>${article.text}</i></a>\n </div>\n <p style=\"margin: 0; font-size: 0.8em\">\n <span title=\"Retweets\">🔄 ${article.retweet_count}</span> | <span title=\"Favorites\">❤️ ${article.favorite_count}</span> | <span title=\"Replies\">💬 ${article.reply_count}</span>\n </p>\n </td>\n </tr>\n `\n}\nhtml += '</table>';\n\nreturn { \n \"html_twitter\": html,\n name: $('Switch').item.json.name,\n meeting: $('Split Out').item.json\n};"
},
"typeVersion": 2
},
{
"id": "0523a00c-e6d3-4158-a861-3bbdd1d6af24",
"name": "Alle Aktivitäten pro Unternehmen zusammenführen",
"type": "n8n-nodes-base.merge",
"position": [
693.5590877677955,
1309.619212163096
],
"parameters": {
"mode": "combine",
"options": {
"clashHandling": {
"values": {
"resolveClash": "preferInput2"
}
}
},
"joinMode": "keepEverything",
"mergeByFields": {
"values": [
{
"field1": "name",
"field2": "name"
}
]
}
},
"typeVersion": 2.1
},
{
"id": "f7f8a5fd-e768-4011-bdbb-cf41a617ce00",
"name": "Daten für E-Mail extrahieren",
"type": "n8n-nodes-base.set",
"position": [
873.5590877677955,
1309.619212163096
],
"parameters": {
"fields": {
"values": [
{
"name": "attendeeEmail",
"stringValue": "={{ $json.meeting.attendeeEmails.find(a => a.endsWith($json.meeting.domain)) }}"
},
{
"name": "startHour",
"type": "numberValue",
"numberValue": "={{ DateTime.fromISO($json.meeting.start.dateTime).hour }}"
},
{
"name": "startMinute",
"type": "numberValue",
"numberValue": "={{ DateTime.fromISO($json.meeting.start.dateTime).minute }}"
}
]
},
"include": "selected",
"options": {},
"includeFields": "name, html_twitter, html_linkedin"
},
"typeVersion": 3.2
},
{
"id": "679fb981-1774-4a3e-8aa4-0cef2f416ecb",
"name": "E-Mail-Vorlage vorbereiten",
"type": "n8n-nodes-base.html",
"position": [
1093.5590877677955,
1309.619212163096
],
"parameters": {
"html": "<!DOCTYPE html>\n\n<html>\n<head>\n <meta charset=\"UTF-8\" />\n <title>Social media activity for company: {{ $json.name }}</title>\n</head>\n<body>\n <div class=\"container\">\n <h2 style=\"font-size: 1.2em\">\n 🗓️ Meeting with \n <span>{{ $json.attendeeEmail }}</span> \n at {{ $json.startHour }}:{{ $json.startMinute < 10 ? `0${$json.startMinute}` : $json.startMinute }}h\n </h2>\n {{ $json.html_linkedin ?? ''}}\n {{ $json.html_twitter ?? ''}}\n </div>\n</body>\n</html>\n\n<style>\n.container {\n font-family: sans-serif;\n}\n</style>"
},
"typeVersion": 1.1
},
{
"id": "8d08145c-9376-4933-8cb2-05babc855b7a",
"name": "Switch",
"type": "n8n-nodes-base.switch",
"position": [
-6.440912232204482,
1309.619212163096
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "linkedin",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.linkedin.handle !== null }}",
"rightValue": ""
}
]
},
"renameOutput": true
},
{
"outputKey": "twitter",
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "bbb0310e-8b20-4bc6-a540-a4cd17470e28",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
},
"leftValue": "={{ $json.twitter.id !== null }}",
"rightValue": ""
}
]
},
"renameOutput": true
}
]
},
"options": {
"allMatchingOutputs": true,
"looseTypeValidation": false
}
},
"typeVersion": 3
},
{
"id": "e4332ab1-5618-477c-9c0b-a2a01278036f",
"name": "Kurznotiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
-520,
720
],
"parameters": {
"color": 7,
"width": 409.31582584657923,
"height": 426.61520915049425,
"content": "## Start here\n1️⃣ Register on [RapidAPI](https://rapidapi.com) and subscribe to these two APIs:\n- [Fresh LinkedIn Profile Data](https://rapidapi.com/freshdata-freshdata-default/api/fresh-linkedin-profile-data)\n- [Twitter](https://rapidapi.com/omarmhaimdat/api/twitter154)\n\n\n2️⃣ Set API keys for these two in `linkedInAPIKey` and `twitterAPIKey`fields of this node\n\n3️⃣ Set email addresses that should receive the list in the `emails` field of this node"
},
"typeVersion": 1
},
{
"id": "2b7a7085-8e19-40a2-9910-6ad829433706",
"name": "Kurznotiz1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-220.44091223220448,
1289.619212163096
],
"parameters": {
"color": 7,
"width": 334.90628250854803,
"height": 308.7389742148118,
"content": "\n\n\n\n\n\n\n\n\n\n\n\n\n\n💡 If you need to get activities from more social media accounts found by ClearBit, they can be added here, just make sure to process them properly in separate switch node branches"
},
"typeVersion": 1
},
{
"id": "8f616351-c18d-460c-9d58-abe01c04e90b",
"name": "Kurznotiz2",
"type": "n8n-nodes-base.stickyNote",
"position": [
840,
560
],
"parameters": {
"color": 5,
"width": 738.9631933644362,
"height": 717.2835666148258,
"content": "### You will receive one email for every company in your calendar. These emails will look something like this:\n\n"
},
"typeVersion": 1
},
{
"id": "dbd6c7df-d857-40e2-b1ba-cb1e68f9cb1a",
"name": "Nur Domänen-basierte behalten",
"type": "n8n-nodes-base.filter",
"position": [
460,
980
],
"parameters": {
"options": {},
"conditions": {
"options": {
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "881d891e-ea17-4879-a5cf-72d08b281f56",
"operator": {
"type": "string",
"operation": "exists",
"singleValue": true
},
"leftValue": "={{ $json.domain }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2
}
],
"pinData": {},
"connections": {
"c25d29ef-71bb-4ea1-8794-47911dac997f": {
"main": [
[
{
"node": "aff4dd6e-a480-4f43-9b48-05172d4b7b2d",
"type": "main",
"index": 0
}
]
]
},
"8d08145c-9376-4933-8cb2-05babc855b7a": {
"main": [
[
{
"node": "467308c9-c6a0-4d1c-a6e1-4598075e62a6",
"type": "main",
"index": 0
}
],
[
{
"node": "f59411f9-5dad-4f8c-af0c-c3ab25171107",
"type": "main",
"index": 0
}
]
]
},
"093b978f-8d5e-4051-be21-e8a7a3430c9c": {
"main": [
[
{
"node": "dbd6c7df-d857-40e2-b1ba-cb1e68f9cb1a",
"type": "main",
"index": 0
}
]
]
},
"ee7ad92e-d4ed-4046-8d31-9c5ce4dda92b": {
"main": [
[
{
"node": "0523a00c-e6d3-4158-a861-3bbdd1d6af24",
"type": "main",
"index": 1
}
]
]
},
"5bf52838-157b-49fe-a4d8-3817198502dd": {
"main": [
[
{
"node": "c25d29ef-71bb-4ea1-8794-47911dac997f",
"type": "main",
"index": 0
}
]
]
},
"f59411f9-5dad-4f8c-af0c-c3ab25171107": {
"main": [
[
{
"node": "ee7ad92e-d4ed-4046-8d31-9c5ce4dda92b",
"type": "main",
"index": 0
}
]
]
},
"bf667011-717e-4a5a-ac7d-c377edb063f8": {
"main": [
[
{
"node": "0523a00c-e6d3-4158-a861-3bbdd1d6af24",
"type": "main",
"index": 0
}
]
]
},
"f7f8a5fd-e768-4011-bdbb-cf41a617ce00": {
"main": [
[
{
"node": "679fb981-1774-4a3e-8aa4-0cef2f416ecb",
"type": "main",
"index": 0
}
]
]
},
"aff4dd6e-a480-4f43-9b48-05172d4b7b2d": {
"main": [
[
{
"node": "63973273-3821-4c9f-8976-6dd47ac9a62e",
"type": "main",
"index": 0
}
]
]
},
"679fb981-1774-4a3e-8aa4-0cef2f416ecb": {
"main": [
[
{
"node": "0fad8349-2a4f-4cee-a03e-98e8d95b015c",
"type": "main",
"index": 0
}
]
]
},
"71a9223b-4d71-4d0d-a4df-f8836d3c3d1f": {
"main": [
[
{
"node": "8d08145c-9376-4933-8cb2-05babc855b7a",
"type": "main",
"index": 0
}
]
]
},
"467308c9-c6a0-4d1c-a6e1-4598075e62a6": {
"main": [
[
{
"node": "bf667011-717e-4a5a-ac7d-c377edb063f8",
"type": "main",
"index": 0
}
]
]
},
"63973273-3821-4c9f-8976-6dd47ac9a62e": {
"main": [
[
{
"node": "093b978f-8d5e-4051-be21-e8a7a3430c9c",
"type": "main",
"index": 0
}
]
]
},
"dbd6c7df-d857-40e2-b1ba-cb1e68f9cb1a": {
"main": [
[
{
"node": "71a9223b-4d71-4d0d-a4df-f8836d3c3d1f",
"type": "main",
"index": 0
}
]
]
},
"0523a00c-e6d3-4158-a861-3bbdd1d6af24": {
"main": [
[
{
"node": "f7f8a5fd-e768-4011-bdbb-cf41a617ce00",
"type": "main",
"index": 0
}
]
]
}
}
}Häufig gestellte Fragen
Wie verwende ich diesen Workflow?
Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.
Für welche Szenarien ist dieser Workflow geeignet?
Experte - Vertrieb
Ist es kostenpflichtig?
Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.
Verwandte Workflows
Automatisierung von Vertriebsmeeting-Vorbereitung und Versand an WhatsApp mit AI und APIFY
Automatisierung der Vorbereitung von Verkaufsgesprächen und des Versands an WhatsApp mit AI und APIFY
If
Set
Html
+
If
Set
Html
61 NodesJimleuk
Vertrieb
Automatische Erzeugung von Social-Media-Briefings für Verkaufsgespräche mit KI und Google Kalender
Automatisiertes Senden von automatisch generierten Verkaufsmeeting-Briefings mit GPT-4, LinkedIn-Daten und WhatsApp
Set
Html
Wait
+
Set
Html
Wait
19 NodesOneclick AI Squad
Kundenbeziehungsmanagement
n8n-Knoten in der visuellen Referenzbibliothek erkunden
Erkundung von n8n-Knoten in der visuellen Referenzbibliothek
If
Ftp
Set
+
If
Ftp
Set
113 NodesI versus AI
Sonstiges
Lead-Generierung und E-Mail-Arbeitsabläufe
Automatisierung der B2B-Lead-Generierung und E-Mail-Marketing mit Google Maps, SendGrid und KI
If
Set
Code
+
If
Set
Code
141 NodesEzema Kingsley Chibuzo
Lead-Generierung
Automatisierung der Microsoft-Teams-Konferenzanalyse mit GPT-4.1, Outlook und Mem.ai
Automatisierte Analyse von Microsoft Teams-Besprechungen mit GPT-4.1, Outlook und Mem.ai
If
Set
Code
+
If
Set
Code
61 NodesWayne Simpson
Personalwesen
GitHub Synchronisations-Dashboard - V2
GitHub-Workflow-Versionskontroll-Dashboard mit Commit-Verlauf und Rollback-Funktion
If
N8n
Set
+
If
N8n
Set
94 NodesEduard
DevOps
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes19
Kategorie1
Node-Typen13
Autor
Externe Links
Auf n8n.io ansehen →
Diesen Workflow teilen