Bright Data、Cal.com、Airtableを使った会議準備とリード拡充の自動化
上級
これはSales, AI分野の自動化ワークフローで、23個のノードを含みます。主にSet, Gmail, Filter, Switch, Webhookなどのノードを使用、AI技術を活用したスマート自動化を実現。 Bright Data、Cal.com、Airtableを使った会議準備とリード充実の自動化
前提条件
- •Googleアカウント + Gmail API認証情報
- •HTTP Webhookエンドポイント（n8nが自動生成）
- •Airtable API Key
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "db80165df40cb07c0377167c050b3f9ab0b0fb04f0e8cae0dc53f5a8527103ca",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "f359d12b-3c06-4f6b-9ac6-4acb852e6c05",
"name": "必要なフィールドをマッピング",
"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": "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": "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": "経歴を編集",
"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": "OpenRouter Chat Model",
"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": "リードデータを更新",
"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": "会議準備エージェント",
"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": "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": "イベントをルーティング",
"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": "付箋",
"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": "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": "付箋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": "付箋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": "付箋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": "付箋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": "付箋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": "付箋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": "付箋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": "付箋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": "会議サマリーを更新",
"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": "管理者に通知",
"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": "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
}
]
]
}
}
}よくある質問
このワークフローの使い方は？
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか？
上級 - 営業, 人工知能
有料ですか？
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス（OpenAI APIなど）は別途料金が発生する場合があります。
関連ワークフロー
[テンプレート] AIペットショップ v8
AIペットショップアシスタント - GPT-4o、Googleカレンダー、WhatsApp/Instagram/Facebookを統合
If
N8n
Set
+
If
N8n
Set
244 ノードAmanda Benks
営業
基于动态提示与AirtableのAIデータ抽出
経由动态提示与Airtable实现AIデータ抽出
Set
Code
Filter
+
Set
Code
Filter
51 ノードJimleuk
人工知能
AIメール分诊与GPT-4警报系统及Telegram通知
AIメール分诊与GPT-4警报系统及Telegram通知
If
Set
Gmail
+
If
Set
Gmail
104 ノードPeter Joslyn
サポート
AI、ElevenLabs、マルチプラットフォーム公開を使ってPOVビデオの作成と承認
AI、ElevenLabs、そしてマルチプラットフォーム公開を使ったPOVビデオの作成と承認（TikTok/IG/YT）
If
Set
Code
+
If
Set
Code
60 ノードImmanuel
デザイン
高级販売AIエージェント
AI販売エージェント：WhatsApp、FB、IG、OpenAI、Airtable、Supabase自動预约
If
Set
Switch
+
If
Set
Switch
58 ノードSam Yassine
営業
AI个性化多製品メールマーケティング
基于SMTP轮换のAI个性化多製品メールマーケティング（GPT-4o/o3-mini）
If
Code
Wait
+
If
Code
Wait
41 ノードBadr
営業
ワークフロー情報
難易度
上級
ノード数23
カテゴリー2
ノードタイプ11
作成者
Imperol
@imperolqAutomation expert with years of experience helping businesses improve their efficiency and productivity with smart automations that are affordable, scalable, and flexible.
外部リンク
n8n.ioで表示 →
このワークフローを共有