Automatisation de la préparation des réunions et de l'enrichissement des prospects avec Bright Data, Cal.com et Airtable
Avancé
Ceci est unSales, AIworkflow d'automatisation du domainecontenant 23 nœuds.Utilise principalement des nœuds comme Set, Gmail, Filter, Switch, Webhook, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. Utiliser Bright Data, Cal.com et Airtable pour automatiser la préparation des réunions et l'enrichissement des prospects
Prérequis
- •Compte Google et informations d'identification Gmail API
- •Point de terminaison HTTP Webhook (généré automatiquement par n8n)
- •Clé API Airtable
Nœuds utilisés (23)
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": "db80165df40cb07c0377167c050b3f9ab0b0fb04f0e8cae0dc53f5a8527103ca",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "f359d12b-3c06-4f6b-9ac6-4acb852e6c05",
"name": "Mapper les champs nécessaires",
"type": "n8n-nodes-base.set",
"position": [
460,
60
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "332ac717-6d9e-4bb1-a29c-415f2519f7d0",
"name": "title",
"type": "string",
"value": "={{ $json.title }}"
},
{
"id": "f94cd637-1254-4d50-af94-7a1d5e9b135f",
"name": "description",
"type": "string",
"value": "={{ $json.additionalNotes }}"
},
{
"id": "c527097e-949d-4a34-a1bd-ef47105c064f",
"name": "videoCallUrl",
"type": "string",
"value": "={{ $json.metadata.videoCallUrl }}"
},
{
"id": "ceb36c00-ced6-49a6-8fd5-81feebb62cc9",
"name": "status",
"type": "string",
"value": "={{ $json.status }}"
},
{
"id": "1b49259d-fe8d-4582-b8d9-0cc4eee83e83",
"name": "length",
"type": "number",
"value": "={{ $json.length }}"
},
{
"id": "fee35065-650b-4b94-96f9-6dcf4306fc69",
"name": "name",
"type": "string",
"value": "={{ $json.responses.name.value }}"
},
{
"id": "0372c2d0-abe2-42c0-8a3e-45be7e802e1d",
"name": "email",
"type": "string",
"value": "={{ $json.responses.email.value }}"
},
{
"id": "de9e48b5-02b0-4648-bd61-c4391cdc216d",
"name": "responsesnotes",
"type": "string",
"value": "={{ $json.responses.notes.value }}"
},
{
"id": "4afed284-dc20-450a-85bb-3a676a382411",
"name": "startTime",
"type": "string",
"value": "={{ $json.startTime }}"
},
{
"id": "4ba399f9-3df0-4437-86e8-f2bf5a67aa61",
"name": "endTime",
"type": "string",
"value": "={{ $json.endTime }}"
},
{
"id": "753b9aca-a068-4f0e-ace1-827edaac1a62",
"name": "agenda",
"type": "string",
"value": "={{ $json.responses.title.value || $json.responses.agenda.value}}"
},
{
"id": "ee9dd182-9a1c-4c45-ae4b-9ec3949b9033",
"name": "purpose",
"type": "string",
"value": "={{ $json.userFieldsResponses.purpose.label }}"
},
{
"id": "fdc9ecf9-a14f-41e5-9d8a-7fc61afbb35b",
"name": "Linkedin",
"type": "string",
"value": "={{ $json.responses.Linkedin.value }}"
},
{
"id": "a9e1537e-ba15-4ee6-be86-dc48f32cbfac",
"name": "business-website",
"type": "string",
"value": "={{ $json.responses['business-website'].value }}"
},
{
"id": "8fa1ba2d-a080-4158-a7ef-d933389239dc",
"name": "Guest",
"type": "string",
"value": "={{ $json.responses.guests.value[0] }}"
},
{
"id": "f7d07121-64bf-4b96-a916-f31a639920bb",
"name": "iCalUID",
"type": "string",
"value": "={{ $json.iCalUID }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "552b5079-df32-45dd-8808-0b549cb4682d",
"name": "Webhook",
"type": "n8n-nodes-base.webhook",
"position": [
-160,
60
],
"webhookId": "83231439-9c32-443c-86ea-8645f3d76640",
"parameters": {
"path": "83231439-9c32-443c-86ea-8645f3d76640",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2
},
{
"id": "da2e6463-dcf3-4c29-a469-d893404d08d4",
"name": "Créer json",
"type": "n8n-nodes-base.set",
"position": [
280,
60
],
"parameters": {
"mode": "raw",
"options": {},
"jsonOutput": "={{ $json.body.payload }}"
},
"typeVersion": 3.4
},
{
"id": "650ba393-c127-4676-bbdf-b6b3276b6c33",
"name": "Si a linkedin",
"type": "n8n-nodes-base.filter",
"position": [
820,
60
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"id": "74273d5b-b315-4f94-be05-ab2237fe7143",
"operator": {
"type": "string",
"operation": "notEmpty",
"singleValue": true
},
"leftValue": "={{ $('Map needed fields').first().json.Linkedin }}",
"rightValue": ""
}
]
}
},
"typeVersion": 2.2
},
{
"id": "eed1b925-f458-4fcb-b840-efeb4a74dc62",
"name": "Modifier la biographie",
"type": "n8n-nodes-base.set",
"position": [
1140,
60
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "b0eb19b6-7dec-40ad-8ccb-7fc1e1ebdd85",
"name": "name",
"type": "string",
"value": "={{ $json.name }}"
},
{
"id": "3a213d32-a17d-46d1-848a-64b759677ca3",
"name": "city",
"type": "string",
"value": "={{ $json.city }}"
},
{
"id": "1273634d-efd2-4fc0-a821-df9d3fea06a8",
"name": "country_code",
"type": "string",
"value": "={{ $json.country_code }}"
},
{
"id": "08485677-973e-438a-a9f3-8b62d64a0ff4",
"name": "position",
"type": "string",
"value": "={{ $json.position }}"
},
{
"id": "c15f6f1e-11cf-40fb-b9ac-e216fc3760d7",
"name": "about",
"type": "string",
"value": "={{ $json.about }}"
},
{
"id": "49ea1e20-a376-4d67-9b2c-19371ea23174",
"name": "current_company",
"type": "string",
"value": "={{ $json.current_company.name }}"
},
{
"id": "85e53350-bf31-4a69-aed6-4fe7a2bd0d33",
"name": "current_company",
"type": "string",
"value": "={{ $json.current_company.link }}"
},
{
"id": "68ca9297-4b0e-45de-8a09-5e9a4ed1bfac",
"name": "experience",
"type": "array",
"value": "={{ $json.experience.map(item => item.positions) }}"
},
{
"id": "8b2d2663-b254-43f1-b11a-3d5f3e76140b",
"name": "url",
"type": "string",
"value": "={{ $json.url }}"
},
{
"id": "58086e21-6200-4afb-9588-fd5fafffa807",
"name": "educations_details",
"type": "string",
"value": "={{ $json.educations_details }}"
},
{
"id": "9a583f42-0a83-4419-82a4-56abb6d35bb7",
"name": "followers",
"type": "number",
"value": "={{ $json.followers }}"
},
{
"id": "e3031132-32d4-446e-bcdc-4265c3ea171d",
"name": "connections",
"type": "number",
"value": "={{ $json.connections }}"
},
{
"id": "8abda043-2f59-4eb5-a272-ee40cbbab368",
"name": "activity",
"type": "array",
"value": "={{ $json.activity }}"
},
{
"id": "2268fcc1-9556-41d9-83f4-17c18f560629",
"name": "current_company name",
"type": "string",
"value": "={{ $json.current_company.name }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "01f093cb-3cb1-4e75-80fd-0a181e24d21d",
"name": "Modèle de chat OpenRouter",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenRouter",
"position": [
1360,
420
],
"parameters": {
"options": {}
},
"credentials": {
"openRouterApi": {
"id": "DjsDsrPkJRSfqINF",
"name": "OpenRouter account"
}
},
"typeVersion": 1
},
{
"id": "95311415-caa6-4e18-bdd9-1a1f700f3690",
"name": "Mettre à jour les données du prospect",
"type": "n8n-nodes-base.airtable",
"position": [
1320,
-60
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appiSZ70ow7uVxv7t",
"cachedResultUrl": "https://airtable.com/appiSZ70ow7uVxv7t",
"cachedResultName": "Appointments & Calls Manager"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbljEjTMx1j4MQ8fV",
"cachedResultUrl": "https://airtable.com/appiSZ70ow7uVxv7t/tbljEjTMx1j4MQ8fV",
"cachedResultName": "Lead Enrichment"
},
"columns": {
"value": {
"city": "={{ $('Edit bio').item.json.city }}",
"about": "={{ $('Edit bio').item.json.about }}",
"company": "={{ $('Edit bio').item.json['current_company name'] }}",
"country": "={{ $('Edit bio').item.json.country_code }}",
"full_name": "={{ $('Edit bio').item.json.name }}",
"job_title": "={{ $('Edit bio').item.json.position }}",
"public_id": "={{ $('Scrap Linkedin').item.json.id }}",
"experiences": "={{ $json.experience?.toJsonString() }}",
"linkedin_url": "={{ $('Map needed fields').item.json.Linkedin }}",
"follower_count": "={{ $('Edit bio').item.json.followers }}",
"Appointments & Calls": "={{ $('Map needed fields').item.json.title }}",
"company_linkedin_url": "={{ $json.current_company }}"
},
"schema": [
{
"id": "full_name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "full_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "about",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "about",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "city",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "city",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "company",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_description",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "company_description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_domain",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "company_domain",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_employee_range",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "company_employee_range",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_industry",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "company_industry",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_linkedin_url",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "company_linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_website",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "company_website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "connection_count",
"type": "number",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "connection_count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "country",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "country",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "current_company_join_year",
"type": "number",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "current_company_join_year",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "experiences",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "experiences",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "first_name",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "first_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "follower_count",
"type": "number",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "follower_count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "headline",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "headline",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_title",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "linkedin_url",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "linkedin_url",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "public_id",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "public_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Appointments & Calls",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Appointments & Calls",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "CAa937hASXcJZWTv",
"name": "Airtable Personal Access Token account✅"
}
},
"typeVersion": 2.1
},
{
"id": "2e9f499d-6889-4e72-88ba-cb11856b5b91",
"name": "Agent de préparation de réunion",
"type": "@n8n/n8n-nodes-langchain.chainLlm",
"position": [
1340,
160
],
"parameters": {
"text": "={{ $json?.toJsonString() }}",
"batching": {},
"messages": {
"messageValues": [
{
"message": "=You are an AI assistant specializing in generating meeting preparation documents for business professionals. Your goal is to analyze provided data (specifically LinkedIn profiles and meeting agendas) and synthesize it into actionable insights to facilitate productive introductory calls. You are detail-oriented, organized, and capable of extracting key information and identifying relevant connections.\n\n**Task:**\n\nGenerate a comprehensive meeting preparation document for an introductory call with a prospect, based on the LinkedIn profile data and meeting agenda provided. The output should follow the format described below and be tailored to the specific information in the input data.\n\n**Input Format:**\n\nYou will receive a JSON object containing a LinkedIn profile and a string containing the meeting agenda. The LinkedIn profile will contain fields such as `name`, `position`, `about`, `experience`, `activity` and other relevant details. The `experience` field is an array of job objects, each containing `title`, `company`, `description`, etc. The `activity` field is an array of the users' recent LinkedIn likes.\n\n**Output Format:**\n\nThe output should be a well-formatted document, easily readable and actionable, adhering to the following structure:"
}
]
},
"promptType": "define"
},
"typeVersion": 1.7
},
{
"id": "954fe099-0861-4c60-998a-431712e4f322",
"name": "Ajouter au CRM",
"type": "n8n-nodes-base.airtable",
"position": [
640,
60
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appiSZ70ow7uVxv7t",
"cachedResultUrl": "https://airtable.com/appiSZ70ow7uVxv7t",
"cachedResultName": "Appointments & Calls Manager"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbl9JXgSsQyVLE3tV",
"cachedResultUrl": "https://airtable.com/appiSZ70ow7uVxv7t/tbl9JXgSsQyVLE3tV",
"cachedResultName": "Appointments and calls"
},
"columns": {
"value": {
"Name": "={{ $json.name }}",
"Email": "={{ $json.email }}",
"Notes": "={{ $json.description }}",
"Source": "Cal.com",
"Status": "Booked",
"Meeting": "={{ $json.title }}",
"iCalUID": "={{ $json.iCalUID }}",
"Accepted": "={{ $json.status.toSentenceCase() }}",
"End-time": "={{ $json.endTime.toDateTime() }}",
"Linkedin": "={{ $json.Linkedin }}",
"Start-time": "={{ $json.startTime.toDateTime() }}",
"Meeting Link": "={{ $json.videoCallUrl }}",
"business-website": "={{ $json['business-website'] }}",
"Reason For Schedule": "={{ $json.agenda }}"
},
"schema": [
{
"id": "Name",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Meeting",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Meeting",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notes",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead data",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Lead data",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "options",
"display": true,
"options": [
{
"name": "Booked",
"value": "Booked"
},
{
"name": "No Show",
"value": "No Show"
},
{
"name": "Done",
"value": "Done"
},
{
"name": "Rescheduled",
"value": "Rescheduled"
},
{
"name": "Showed Up",
"value": "Showed Up"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Date",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Start-time",
"type": "dateTime",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Start-time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "End-time",
"type": "dateTime",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "End-time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Accepted",
"type": "options",
"display": true,
"options": [
{
"name": "Accepted",
"value": "Accepted"
},
{
"name": "accepted",
"value": "accepted"
},
{
"name": "needsAction",
"value": "needsAction"
},
{
"name": "declined",
"value": "declined"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Accepted",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Meeting Link",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Meeting Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Open Meeting",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Open Meeting",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Source",
"type": "options",
"display": true,
"options": [
{
"name": "Cal.com",
"value": "Cal.com"
},
{
"name": "G calendar",
"value": "G calendar"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Source",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "updated",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "updated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Outcome",
"type": "options",
"display": true,
"options": [
{
"name": "Positive",
"value": "Positive"
},
{
"name": "Negative",
"value": "Negative"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Outcome",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Meeting_prep",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Meeting_prep",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Calendar Link",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Calendar Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Created",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Reason For Schedule",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Reason For Schedule",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "business-website",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "business-website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Linkedin",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Linkedin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "about (from Lead data)",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "about (from Lead data)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created time",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Created time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "How did the meeting go?",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "How did the meeting go?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Extra notes",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Extra notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "FOLLOW UP",
"type": "options",
"display": true,
"options": [
{
"name": "",
"value": ""
},
{
"name": "Sent",
"value": "Sent"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "FOLLOW UP",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "iCalUID",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "iCalUID",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "create"
},
"credentials": {
"airtableTokenApi": {
"id": "CAa937hASXcJZWTv",
"name": "Airtable Personal Access Token account✅"
}
},
"typeVersion": 2.1
},
{
"id": "19049aeb-3b17-499d-a9f9-37bedaf3c340",
"name": "Router les événements",
"type": "n8n-nodes-base.switch",
"position": [
60,
60
],
"parameters": {
"rules": {
"values": [
{
"outputKey": "BOOKING_CREATED",
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "strict"
},
"combinator": "and",
"conditions": [
{
"operator": {
"type": "string",
"operation": "equals"
},
"leftValue": "={{ $json.body.triggerEvent }}",
"rightValue": "BOOKING_CREATED"
}
]
},
"renameOutput": true
}
]
},
"options": {}
},
"typeVersion": 3.2
},
{
"id": "1b6ed86d-bd2b-488d-abdf-b83fdae2276b",
"name": "Note autocollante",
"type": "n8n-nodes-base.stickyNote",
"position": [
260,
-160
],
"parameters": {
"width": 720,
"height": 80,
"content": "## Cal.com Meeting Prep Agent with Bright Data API"
},
"typeVersion": 1
},
{
"id": "c64cf170-1576-4fcd-b977-1a429d20775f",
"name": "Scraper Linkedin",
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"position": [
980,
60
],
"parameters": {
"urls": "=[{\"url\":\"{{ $('Map needed fields').item.json.Linkedin }}\"}]",
"resource": "webScrapper",
"dataset_id": {
"__rl": true,
"mode": "list",
"value": "gd_l1viktl72bvl7bjuj0",
"cachedResultName": "LinkedIn people profiles"
},
"requestOptions": {}
},
"credentials": {
"brightdataApi": {
"id": "jC05AXjztTfYsOeL",
"name": "BrightData account Zack"
}
},
"typeVersion": 1
},
{
"id": "30a77cf2-baa3-4c82-a3e7-13f8135db38d",
"name": "Note autocollante 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-800,
0
],
"parameters": {
"width": 460,
"height": 260,
"content": "## Summary\n\nCapture the webhook from cal.com for new bookings\n\nEnsure you have a field on the form to collect linkedin posts. This can be optional or mandatory depending on your preferences\n\nWhen a new event is booked, we will be adding the leads to an airtable CRM for appointments and new bookings. This table will contain all the items and items needed\n\nIf the lead has linkedin then we do a research on linkedin for their content and posts and perform a lead enrichment to get as much info as we can about the leads and create a new meeting prep\n"
},
"typeVersion": 1
},
{
"id": "c8786d8b-529d-4af8-a392-e5b2a5e653ae",
"name": "Note autocollante 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-200,
-60
],
"parameters": {
"width": 200,
"height": 400,
"content": "Receive webhook on a new meeting booked"
},
"typeVersion": 1
},
{
"id": "7e245466-782e-4d89-b22a-908e67813226",
"name": "Note autocollante 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
-60
],
"parameters": {
"width": 340,
"height": 400,
"content": "Split the object data into a json for easy mapping\n\nYou can drag and drop the fields you have on the `Map Needed fields` node"
},
"typeVersion": 1
},
{
"id": "292d8261-1e4c-441b-a970-88c61ad32b27",
"name": "Note autocollante 4",
"type": "n8n-nodes-base.stickyNote",
"position": [
600,
-60
],
"parameters": {
"width": 180,
"height": 400,
"content": "Add the leads to your CRM\n\nMake a copy of this [Airtable CRM](https://airtable.com/appiSZ70ow7uVxv7t/shrvmFKqRYGX6iUZY) \n\nYou can use any CRM of choice for this\n\n"
},
"typeVersion": 1
},
{
"id": "fa69af0a-561e-4834-8229-41e0ded2b3f1",
"name": "Note autocollante 5",
"type": "n8n-nodes-base.stickyNote",
"position": [
800,
-60
],
"parameters": {
"width": 480,
"height": 380,
"content": "Filter only leads with linkedin urls and send this to Bright Data API.\n\nGet a copy of the API and select the dataset we want. In this case we are researching for the leads Profile on Linkedin"
},
"typeVersion": 1
},
{
"id": "4a6c0152-da5b-459b-ad04-201be06ba209",
"name": "Note autocollante 6",
"type": "n8n-nodes-base.stickyNote",
"position": [
1300,
-140
],
"parameters": {
"width": 260,
"height": 240,
"content": "Add the new enriched leads data to the leads table "
},
"typeVersion": 1
},
{
"id": "38c458fe-10d7-4ad7-8f92-a3ebd374010e",
"name": "Note autocollante 7",
"type": "n8n-nodes-base.stickyNote",
"position": [
1300,
120
],
"parameters": {
"width": 900,
"height": 280,
"content": "Create a meeting Prep and Share via email"
},
"typeVersion": 1
},
{
"id": "424aac19-9d96-4447-8e4e-29e51c33a872",
"name": "Note autocollante 8",
"type": "n8n-nodes-base.stickyNote",
"position": [
20,
-60
],
"parameters": {
"width": 200,
"height": 400,
"content": "You can route the data based on other Cal events eg Meeting started, ended etc"
},
"typeVersion": 1
},
{
"id": "29f09e3f-e477-4168-8c91-befde3e47ea6",
"name": "Mettre à jour le résumé de la réunion",
"type": "n8n-nodes-base.airtable",
"position": [
2020,
160
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appiSZ70ow7uVxv7t",
"cachedResultUrl": "https://airtable.com/appiSZ70ow7uVxv7t",
"cachedResultName": "Appointments & Calls Manager"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tbl9JXgSsQyVLE3tV",
"cachedResultUrl": "https://airtable.com/appiSZ70ow7uVxv7t/tbl9JXgSsQyVLE3tV",
"cachedResultName": "Appointments and calls"
},
"columns": {
"value": {
"id": "={{ $('Add to CRM').first().json.id }}",
"Meeting_prep": "={{ $('create HTML').item.json.text }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Meeting",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Meeting",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Notes",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Notes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead data",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Lead data",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "options",
"display": true,
"options": [
{
"name": "Booked",
"value": "Booked"
},
{
"name": "No Show",
"value": "No Show"
},
{
"name": "Done",
"value": "Done"
},
{
"name": "Rescheduled",
"value": "Rescheduled"
},
{
"name": "Showed Up",
"value": "Showed Up"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Start-time",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Start-time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "End-time",
"type": "dateTime",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "End-time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Email",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Accepted",
"type": "options",
"display": true,
"options": [
{
"name": "Accepted",
"value": "Accepted"
},
{
"name": "accepted",
"value": "accepted"
},
{
"name": "needsAction",
"value": "needsAction"
},
{
"name": "declined",
"value": "declined"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Accepted",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Meeting Link",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Meeting Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Open Meeting",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Open Meeting",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Source",
"type": "options",
"display": true,
"options": [
{
"name": "Cal.com",
"value": "Cal.com"
},
{
"name": "G calendar",
"value": "G calendar"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Source",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "updated",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "updated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Meeting_prep",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Meeting_prep",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Created",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Reason For Schedule",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Reason For Schedule",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "business-website",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "business-website",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Linkedin",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Linkedin",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created time",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Created time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "iCalUID",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "iCalUID",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Lead Enrichment",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Lead Enrichment",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update"
},
"credentials": {
"airtableTokenApi": {
"id": "CAa937hASXcJZWTv",
"name": "Airtable Personal Access Token account✅"
}
},
"typeVersion": 2.1
},
{
"id": "05f75d10-4a7a-41ef-829a-fa9c6599a10b",
"name": "Notifier l'administrateur",
"type": "n8n-nodes-base.gmail",
"position": [
1820,
160
],
"webhookId": "409d2278-a1bb-4d6f-980a-c9206a3c4f21",
"parameters": {
"sendTo": "={your email}",
"message": "={{ $json.data }}",
"options": {},
"subject": "New Meeting Prep Email"
},
"credentials": {
"gmailOAuth2": {
"id": "8PS0qVYNzZvoWNA7",
"name": "phoenix✅"
}
},
"typeVersion": 2.1
},
{
"id": "4eb75676-c5b8-4ad6-9dc7-451cb695efd8",
"name": "Créer HTML",
"type": "n8n-nodes-base.markdown",
"position": [
1660,
160
],
"parameters": {
"mode": "markdownToHtml",
"options": {},
"markdown": "={{ $json.text }}"
},
"typeVersion": 1
}
],
"pinData": {
"Webhook": [
{
"body": {
"payload": {
"uid": "72ieneey7haPWhCp64sk6W",
"type": "30min",
"price": 0,
"title": "Introductions and Discovery Call between Zacharia Kimotho and Anish M",
"length": 30,
"status": "ACCEPTED",
"endTime": "2025-05-30T10:00:00Z",
"iCalUID": "72ieneey7haPWhCp64sk6W@Cal.com",
"currency": "usd",
"location": "integrations:google:meet",
"metadata": {
"videoCallUrl": "https://meet.google.com/zgv-jrnv-ijx"
},
"attendees": [
{
"name": "Anish M",
"email": "anish@processary.com",
"language": {
"locale": "en"
},
"lastName": "",
"timeZone": "Asia/Calcutta",
"firstName": "",
"utcOffset": 330
}
],
"bookerUrl": "https://cal.com",
"bookingId": 8194170,
"organizer": {
"id": 994846,
"name": "Zacharia Kimotho",
"email": "kimothozacharia5@gmail.com",
"language": {
"locale": "en"
},
"timeZone": "Africa/Nairobi",
"username": "effibotics",
"utcOffset": 180,
"timeFormat": "h:mma"
},
"responses": {
"name": {
"label": "your_name",
"value": "Anish M",
"isHidden": false
},
"email": {
"label": "email_address",
"value": "anish@processary.com",
"isHidden": false
},
"notes": {
"label": "additional_notes",
"isHidden": false
},
"title": {
"label": "what_is_this_meeting_about",
"isHidden": true
},
"Budget": {
"label": "What is your budget",
"isHidden": true
},
"agenda": {
"label": " What is this meeting about?",
"value": "Debugging an n8n workflow discussed on LinkedIn",
"isHidden": false
},
"guests": {
"label": "additional_guests",
"value": [],
"isHidden": false
},
"purpose": {
"label": "Reason for scheduling the call",
"isHidden": true
},
"Linkedin": {
"label": "Enter your Linkedin Url",
"value": "https://www.linkedin.com/in/experienceswithanish",
"isHidden": false
},
"business": {
"label": "Business name",
"value": "Processary",
"isHidden": false
},
"location": {
"label": "location",
"value": {
"value": "integrations:google:meet",
"optionValue": ""
},
"isHidden": false
},
"business-website": {
"label": "Enter your website",
"value": "processary.com",
"isHidden": false
},
"rescheduleReason": {
"label": "reason_for_reschedule",
"isHidden": false
}
},
"startTime": "2025-05-30T09:30:00Z",
"appsStatus": [
{
"type": "google_calendar",
"errors": [],
"appName": "google-calendar",
"success": 1,
"failures": 0,
"warnings": []
},
{
"type": "conferencing",
"errors": [],
"appName": "Google Meet",
"success": 1,
"failures": 0
}
],
"eventTitle": "Introductions and Discovery Call",
"description": "",
"eventTypeId": 1303048,
"customInputs": {},
"iCalSequence": 0,
"conferenceData": {
"createRequest": {
"requestId": "8a0ce172-f69a-51b5-8481-93feb73d58e2"
}
},
"schedulingType": null,
"additionalNotes": "",
"oneTimePassword": null,
"eventDescription": "",
"seatsPerTimeSlot": null,
"hideCalendarNotes": false,
"customReplyToEmail": null,
"hideOrganizerEmail": false,
"seatsShowAttendees": true,
"destinationCalendar": [
{
"id": 358680,
"userId": 994846,
"externalId": "kimothozacharia5@gmail.com",
"eventTypeId": null,
"integration": "google_calendar",
"credentialId": 576040,
"primaryEmail": "kimothozacharia5@gmail.com",
"delegationCredentialId": null,
"domainWideDelegationCredentialId": null
}
],
"userFieldsResponses": {
"Budget": {
"label": "What is your budget",
"isHidden": true
},
"agenda": {
"label": " What is this meeting about?",
"value": "Debugging an n8n workflow discussed on LinkedIn",
"isHidden": false
},
"purpose": {
"label": "Reason for scheduling the call",
"isHidden": true
},
"Linkedin": {
"label": "Enter your Linkedin Url",
"value": "https://www.linkedin.com/in/experienceswithanish",
"isHidden": false
},
"business": {
"label": "Business name",
"value": "Processary",
"isHidden": false
},
"business-website": {
"label": "Enter your website",
"value": "processary.com",
"isHidden": false
}
},
"requiresConfirmation": false,
"hideCalendarEventDetails": false,
"seatsShowAvailabilityCount": true
},
"createdAt": "2025-05-29T14:29:45.015Z",
"triggerEvent": "BOOKING_CREATED"
},
"query": {},
"params": {},
"headers": {
"via": "1.1 Caddy",
"host": "dev.funautomations.io",
"accept": "*/*",
"baggage": "sentry-environment=vercel-production,sentry-public_key=a1ea40f454a84538876a4b18e1c360d4,sentry-trace_id=5fb7580bc99f41cfb19def7424e150e3,sentry-sampled=false,sentry-sample_rand=0.20993134619029008,sentry-sample_rate=0",
"user-agent": "node",
"x-vercel-id": "bom1:bom1::pmmdh-1748528982534-0e80201ef08f",
"content-type": "application/json",
"sentry-trace": "5fb7580bc99f41cfb19def7424e150e3-68b8822ca6e48f74-0",
"content-length": "3549",
"sec-fetch-mode": "cors",
"accept-encoding": "br, gzip, deflate",
"accept-language": "*",
"x-forwarded-for": "18.223.44.214",
"x-forwarded-host": "dev.funautomations.io",
"x-forwarded-proto": "https",
"x-cal-signature-256": "no-secret-provided"
},
"webhookUrl": "https://dev.funautomations.io/webhook/83231439-9c32-443c-86ea-8645f3d76640",
"executionMode": "production"
}
]
},
"connections": {
"552b5079-df32-45dd-8808-0b549cb4682d": {
"main": [
[
{
"node": "19049aeb-3b17-499d-a9f9-37bedaf3c340",
"type": "main",
"index": 0
}
]
]
},
"eed1b925-f458-4fcb-b840-efeb4a74dc62": {
"main": [
[
{
"node": "2e9f499d-6889-4e72-88ba-cb11856b5b91",
"type": "main",
"index": 0
},
{
"node": "95311415-caa6-4e18-bdd9-1a1f700f3690",
"type": "main",
"index": 0
}
]
]
},
"954fe099-0861-4c60-998a-431712e4f322": {
"main": [
[
{
"node": "650ba393-c127-4676-bbdf-b6b3276b6c33",
"type": "main",
"index": 0
}
]
]
},
"4eb75676-c5b8-4ad6-9dc7-451cb695efd8": {
"main": [
[
{
"node": "05f75d10-4a7a-41ef-829a-fa9c6599a10b",
"type": "main",
"index": 0
}
]
]
},
"da2e6463-dcf3-4c29-a469-d893404d08d4": {
"main": [
[
{
"node": "f359d12b-3c06-4f6b-9ac6-4acb852e6c05",
"type": "main",
"index": 0
}
]
]
},
"05f75d10-4a7a-41ef-829a-fa9c6599a10b": {
"main": [
[
{
"node": "29f09e3f-e477-4168-8c91-befde3e47ea6",
"type": "main",
"index": 0
}
]
]
},
"19049aeb-3b17-499d-a9f9-37bedaf3c340": {
"main": [
[
{
"node": "da2e6463-dcf3-4c29-a469-d893404d08d4",
"type": "main",
"index": 0
}
]
]
},
"c64cf170-1576-4fcd-b977-1a429d20775f": {
"main": [
[
{
"node": "eed1b925-f458-4fcb-b840-efeb4a74dc62",
"type": "main",
"index": 0
}
]
]
},
"650ba393-c127-4676-bbdf-b6b3276b6c33": {
"main": [
[
{
"node": "c64cf170-1576-4fcd-b977-1a429d20775f",
"type": "main",
"index": 0
}
]
]
},
"95311415-caa6-4e18-bdd9-1a1f700f3690": {
"main": [
[]
]
},
"f359d12b-3c06-4f6b-9ac6-4acb852e6c05": {
"main": [
[
{
"node": "954fe099-0861-4c60-998a-431712e4f322",
"type": "main",
"index": 0
}
]
]
},
"2e9f499d-6889-4e72-88ba-cb11856b5b91": {
"main": [
[
{
"node": "4eb75676-c5b8-4ad6-9dc7-451cb695efd8",
"type": "main",
"index": 0
}
]
]
},
"01f093cb-3cb1-4e75-80fd-0a181e24d21d": {
"ai_languageModel": [
[
{
"node": "2e9f499d-6889-4e72-88ba-cb11856b5b91",
"type": "ai_languageModel",
"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é - Ventes, Intelligence Artificielle
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
[Modèle] AI Pet Shop v8
🐶 Assistant de magasin de pets IA - Intégration de GPT-4o, Google Calendar et WhatsApp/Instagram/Facebook
If
N8n
Set
+
If
N8n
Set
244 NœudsAmanda Benks
Ventes
基于动态提示与AirtabledeAIdonnéesextraction
via动态提示与Airtable实现AIdonnéesextraction
Set
Code
Filter
+
Set
Code
Filter
51 NœudsJimleuk
Intelligence Artificielle
AIe-mail分诊与GPT-4警报系统及Telegramnotification
AIe-mail分诊与GPT-4警报系统及Telegramnotification
If
Set
Gmail
+
If
Set
Gmail
104 NœudsPeter Joslyn
Support
Créer et approuver des vidéos POV en utilisant l'IA, ElevenLabs et une publication multiplateforme
Créer et approuver des vidéos POV (TikTok/IG/YT) avec IA, ElevenLabs et publication multiplateforme
If
Set
Code
+
If
Set
Code
60 NœudsImmanuel
Design
高级ventesAIagent
AIventesagent：WhatsApp、FB、IG、OpenAI、Airtable、Supabaseautomatique预约
If
Set
Switch
+
If
Set
Switch
58 NœudsSam Yassine
Ventes
marketinge-mailAI个性化多produit
基于SMTP轮换deAI个性化多produite-mailmarketing（GPT-4o/o3-mini）
If
Code
Wait
+
If
Code
Wait
41 NœudsBadr
Ventes
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds23
Catégorie2
Types de nœuds11
Description de la difficulté
Auteur
Imperol
@imperolqAutomation expert with years of experience helping businesses improve their efficiency and productivity with smart automations that are affordable, scalable, and flexible.
Liens externes
Voir sur n8n.io →
Partager ce workflow