Skip to content

Instantly share code, notes, and snippets.

@RakinJakaria
Created August 30, 2025 18:15
Show Gist options
  • Select an option

  • Save RakinJakaria/e456a9dcd894f0bfb26ba09b168cec74 to your computer and use it in GitHub Desktop.

Select an option

Save RakinJakaria/e456a9dcd894f0bfb26ba09b168cec74 to your computer and use it in GitHub Desktop.
n8n workflow for the AI Agents Challenge - Automates social media profile scraping and analysis.
{
"name": "Social Presence Research Agent with Bright Data",
"nodes": [
{
"parameters": {
"rules": {
"values": [
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"leftValue": "={{ $json['Social Media'] }}",
"rightValue": "Facebook",
"operator": {
"type": "string",
"operation": "equals"
},
"id": "1afd7458-0c3c-4eaa-b9a9-7a97572a7e7b"
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "Facebook"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "6b3b0525-fa0f-4311-87d2-5cd5980d0be7",
"leftValue": "={{ $json['Social Media'] }}",
"rightValue": "Instagram",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "Instagram"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "f514c36c-4069-4402-97ed-b81ef46e84f2",
"leftValue": "={{ $json['Social Media'] }}",
"rightValue": "Linkedin",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "Linkedin"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "4752a398-cb72-440c-b3c4-bdb957be8573",
"leftValue": "={{ $json[\"Social Media\"] }}",
"rightValue": "X",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "X"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "6d8f3b6a-7c16-46b9-b2d8-a523153b9678",
"leftValue": "={{ $json['Social Media'] }}",
"rightValue": "YouTube",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "YouTube"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "9b05f6ec-37c0-4bb2-a14e-7b0cb39e5008",
"leftValue": "={{ $json['Social Media'] }}",
"rightValue": "Pinterest",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "Pinterest"
},
{
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "3eabf32c-d2e5-4db0-83ba-9d2b6e5605ea",
"leftValue": "={{ $json['Social Media'] }}",
"rightValue": "TikTok",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"renameOutput": true,
"outputKey": "TikTok"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.switch",
"typeVersion": 3.2,
"position": [
-240,
-144
],
"id": "d295895a-ac0d-4b63-9505-4ac3a1674fef",
"name": "Define"
},
{
"parameters": {
"formTitle": "Analyze Anyone 🤖",
"formDescription": "Research Anyone Social Presence",
"formFields": {
"values": [
{
"fieldLabel": "Profile URL",
"requiredField": true
},
{
"fieldLabel": "Social Media",
"fieldType": "dropdown",
"fieldOptions": {
"values": [
{
"option": "Facebook"
},
{
"option": "Instagram"
},
{
"option": "Linkedin"
},
{
"option": "X"
},
{
"option": "YouTube"
},
{
"option": "TikTok"
},
{
"option": "Pinterest"
}
]
},
"requiredField": true
}
]
},
"options": {}
},
"type": "n8n-nodes-base.formTrigger",
"typeVersion": 2.2,
"position": [
-624,
-64
],
"id": "c4a681ca-eb49-4682-8532-b11dd588f28e",
"name": "Form",
"webhookId": "4d723344-ef53-4e81-a5ab-b9a115baa9fb"
},
{
"parameters": {
"resource": "webScrapper",
"operation": "triggerCollectionByUrl",
"dataset_id": {
"__rl": true,
"value": "gd_lkaxegm826bjpoo9m5",
"mode": "list",
"cachedResultName": "Facebook - Pages Posts by Profile URL"
},
"urls": "=[{\"url\":\"{{ $json['Profile URL'] }}\"}]",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
448,
-1968
],
"id": "5d660111-edc1-4b5b-aff0-86ca6ac19314",
"name": "Initiate batch extraction for Facebook",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"resource": "webScrapper",
"operation": "monitorProgressSnapshot",
"snapshot_id": "={{ $json.snapshot_id }}",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
976,
-1968
],
"id": "1a8496dd-04e9-4aad-8eb7-0da5b6a35a3d",
"name": "Check the status for Facebook Data",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"resource": "webScrapper",
"operation": "downloadSnapshot",
"snapshot_id": "={{ $('Check the status for Facebook Data').item.json.snapshot_id }}",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
1664,
-2064
],
"id": "5393cdc2-04da-49ef-b0ce-d54e18dff52c",
"name": "Download the Facebook Data",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "6da8c8b2-b8d3-4fd9-80bc-1855f25d1109",
"leftValue": "={{ $json.status }}",
"rightValue": "ready",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
1184,
-1968
],
"id": "5451ecae-d05e-49df-befe-81bb3037b02b",
"name": "Facebook Condition"
},
{
"parameters": {
"options": {
"reset": true
}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
1456,
-1888
],
"id": "a8029a62-5c1f-46b1-9fa3-f1ead2b64829",
"name": "Retry for Facebook"
},
{
"parameters": {
"amount": 20
},
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
768,
-1968
],
"id": "af1a1b1c-8171-4176-8d73-4df4d001289a",
"name": "Wait for Facebook",
"webhookId": "4f1294f3-6ddc-4bc7-8c18-c844d61ebbe9"
},
{
"parameters": {
"aggregate": "aggregateAllItemData",
"destinationFieldName": "facebook data",
"options": {}
},
"type": "n8n-nodes-base.aggregate",
"typeVersion": 1,
"position": [
2096,
-2064
],
"id": "c97faef7-46db-4a4f-9ab0-4ca6fa26f2f2",
"name": "Aggregate FaceBook Data"
},
{
"parameters": {
"resource": "spreadsheet",
"title": "=Facebook Data of {{ $('Form').item.json[\"Profile URL\"] }}",
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1456,
-2064
],
"id": "f5e7fd2a-f374-447e-8c79-c2022fe82e28",
"name": "Create spreadsheet for Facebook Data",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "5QVbNjH1NwujrK2D",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "={{ $('Create spreadsheet for Facebook Data').item.json.spreadsheetId }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Sheet1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NQpiGnfY0BrL5wUUUK7wA-2knzLFlQc39Oj9dJcHieQ/edit#gid=0"
},
"columns": {
"mappingMode": "autoMapInputData",
"value": {},
"matchingColumns": [],
"schema": [
{
"id": "url",
"displayName": "url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_id",
"displayName": "post_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "user_url",
"displayName": "user_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "user_username_raw",
"displayName": "user_username_raw",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "content",
"displayName": "content",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "date_posted",
"displayName": "date_posted",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "num_comments",
"displayName": "num_comments",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "num_shares",
"displayName": "num_shares",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_name",
"displayName": "page_name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "profile_id",
"displayName": "profile_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_intro",
"displayName": "page_intro",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_category",
"displayName": "page_category",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_logo",
"displayName": "page_logo",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_external_website",
"displayName": "page_external_website",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_followers",
"displayName": "page_followers",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_is_verified",
"displayName": "page_is_verified",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "original_post",
"displayName": "original_post",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "attachments",
"displayName": "attachments",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_external_image",
"displayName": "post_external_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_url",
"displayName": "page_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "header_image",
"displayName": "header_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "avatar_image_url",
"displayName": "avatar_image_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "profile_handle",
"displayName": "profile_handle",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "is_sponsored",
"displayName": "is_sponsored",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "shortcode",
"displayName": "shortcode",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "video_view_count",
"displayName": "video_view_count",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "likes",
"displayName": "likes",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_type",
"displayName": "post_type",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "following",
"displayName": "following",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "link_description_text",
"displayName": "link_description_text",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "count_reactions_type",
"displayName": "count_reactions_type",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "is_page",
"displayName": "is_page",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_phone",
"displayName": "page_phone",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_email",
"displayName": "page_email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_creation_time",
"displayName": "page_creation_time",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_reviews_score",
"displayName": "page_reviews_score",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_reviewers_amount",
"displayName": "page_reviewers_amount",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_price_range",
"displayName": "page_price_range",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "about",
"displayName": "about",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "active_ads_urls",
"displayName": "active_ads_urls",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "delegate_page_id",
"displayName": "delegate_page_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "privacy_and_legal_info",
"displayName": "privacy_and_legal_info",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "timestamp",
"displayName": "timestamp",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "input",
"displayName": "input",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_image",
"displayName": "post_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1888,
-2064
],
"id": "a4822175-4dec-46bb-97f6-27ebd9bd89f9",
"name": "Append row in sheet for Facebook Data",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "5QVbNjH1NwujrK2D",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"text": "=Facebook Data: {{ JSON.stringify($json['facebook data']) }}\n\nYour Task is to Analyze the persons Facebook profile based on the Facebook data and create a beautiful Report in HTML format.",
"attributes": {
"attributes": [
{
"name": "Analyzed Report ",
"description": "=Report in HTML code",
"required": true
},
{
"name": "Report Name",
"description": "name of that analyzed report",
"required": true
}
]
},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"typeVersion": 1.2,
"position": [
2304,
-2064
],
"id": "dfcbbe02-0219-4431-87e8-680f750a1979",
"name": "Facebook Data Report Process"
},
{
"parameters": {
"sendTo": "jakariaislam1044@gmail.com",
"subject": "={{ $json.output['Report Name'] }}",
"message": "={{ $json.output['Analyzed Report '] }}",
"options": {
"appendAttribution": false
}
},
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.1,
"position": [
2672,
-2064
],
"id": "51288631-97da-413c-a912-1fab449af2e7",
"name": "Facebook Analyze Report Mail",
"webhookId": "fb11df27-301c-4e4d-8ef0-e7270d98eeef",
"credentials": {
"gmailOAuth2": {
"id": "AoLyxjViXkDxpXt3",
"name": "Gmail account"
}
}
},
{
"parameters": {
"resource": "webScrapper",
"operation": "triggerCollectionByUrl",
"dataset_id": {
"__rl": true,
"value": "gd_l1vikfch901nx3by4",
"mode": "list",
"cachedResultName": "Instagram - Profiles"
},
"urls": "=[{\"url\":\"{{ $json['Profile URL'] }}\"}]",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
464,
-1344
],
"id": "d9fea477-c420-4d00-a7ec-2e674c002c4c",
"name": "Initiate batch extraction for Instagram",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"amount": 20
},
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
672,
-1344
],
"id": "59feda3f-ac96-4ed9-9936-74bee03a72d4",
"name": "Wait for Instagram",
"webhookId": "4f1294f3-6ddc-4bc7-8c18-c844d61ebbe9"
},
{
"parameters": {
"resource": "webScrapper",
"operation": "monitorProgressSnapshot",
"snapshot_id": "={{ $json.snapshot_id }}",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
880,
-1344
],
"id": "5562eb13-2f1f-418b-a3e4-0daebbaa6b91",
"name": "Check the status for Instagram Data",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "6da8c8b2-b8d3-4fd9-80bc-1855f25d1109",
"leftValue": "={{ $json.status }}",
"rightValue": "ready",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
1088,
-1344
],
"id": "a8844a59-9478-422a-b2a3-40b5c855c0e7",
"name": "Instagram Condition"
},
{
"parameters": {
"options": {
"reset": true
}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
1360,
-1264
],
"id": "fcff6e99-9b39-446e-b546-50cd47c15715",
"name": "Retry for Instagram"
},
{
"parameters": {
"resource": "spreadsheet",
"title": "=Instagram Data of {{ $('Form').item.json[\"Profile URL\"] }}",
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1360,
-1440
],
"id": "15ee0298-ac81-49b6-aeae-d2bd87061409",
"name": "Create spreadsheet for Instagram Data",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "5QVbNjH1NwujrK2D",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"resource": "webScrapper",
"operation": "downloadSnapshot",
"snapshot_id": "={{ $('Check the status for Instagram Data').item.json.snapshot_id }}",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
1568,
-1440
],
"id": "66c56163-b622-431a-8c66-c288319195f0",
"name": "Download the Instagram Data",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "={{ $('Create spreadsheet for Instagram Data').item.json.spreadsheetId }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Sheet1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NQpiGnfY0BrL5wUUUK7wA-2knzLFlQc39Oj9dJcHieQ/edit#gid=0"
},
"columns": {
"mappingMode": "autoMapInputData",
"value": {},
"matchingColumns": [],
"schema": [
{
"id": "url",
"displayName": "url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_id",
"displayName": "post_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "user_url",
"displayName": "user_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "user_username_raw",
"displayName": "user_username_raw",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "content",
"displayName": "content",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "date_posted",
"displayName": "date_posted",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "num_comments",
"displayName": "num_comments",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "num_shares",
"displayName": "num_shares",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_name",
"displayName": "page_name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "profile_id",
"displayName": "profile_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_intro",
"displayName": "page_intro",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_category",
"displayName": "page_category",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_logo",
"displayName": "page_logo",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_external_website",
"displayName": "page_external_website",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_followers",
"displayName": "page_followers",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_is_verified",
"displayName": "page_is_verified",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "original_post",
"displayName": "original_post",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "attachments",
"displayName": "attachments",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_external_image",
"displayName": "post_external_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_url",
"displayName": "page_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "header_image",
"displayName": "header_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "avatar_image_url",
"displayName": "avatar_image_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "profile_handle",
"displayName": "profile_handle",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "is_sponsored",
"displayName": "is_sponsored",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "shortcode",
"displayName": "shortcode",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "video_view_count",
"displayName": "video_view_count",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "likes",
"displayName": "likes",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_type",
"displayName": "post_type",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "following",
"displayName": "following",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "link_description_text",
"displayName": "link_description_text",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "count_reactions_type",
"displayName": "count_reactions_type",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "is_page",
"displayName": "is_page",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_phone",
"displayName": "page_phone",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_email",
"displayName": "page_email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_creation_time",
"displayName": "page_creation_time",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_reviews_score",
"displayName": "page_reviews_score",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_reviewers_amount",
"displayName": "page_reviewers_amount",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_price_range",
"displayName": "page_price_range",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "about",
"displayName": "about",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "active_ads_urls",
"displayName": "active_ads_urls",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "delegate_page_id",
"displayName": "delegate_page_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "privacy_and_legal_info",
"displayName": "privacy_and_legal_info",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "timestamp",
"displayName": "timestamp",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "input",
"displayName": "input",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_image",
"displayName": "post_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1792,
-1440
],
"id": "82067f52-9a91-42b5-95c5-285279899834",
"name": "Append row in sheet for Instagram Data",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "5QVbNjH1NwujrK2D",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"aggregate": "aggregateAllItemData",
"destinationFieldName": "instagram data",
"options": {}
},
"type": "n8n-nodes-base.aggregate",
"typeVersion": 1,
"position": [
2000,
-1440
],
"id": "3a0f6d18-786b-4603-b5a1-f05561a13771",
"name": "Aggregate Instagram Data"
},
{
"parameters": {
"text": "=Instagram Data: {{ JSON.stringify($json['instagram data']) }}\n\nYour Task is to Analyze the persons Instagram profile based on the Instagram data and create a beautiful Report in HTML format.",
"attributes": {
"attributes": [
{
"name": "Analyzed Report ",
"description": "=Report in HTML code",
"required": true
},
{
"name": "Report Name",
"description": "name of that analyzed report",
"required": true
}
]
},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"typeVersion": 1.2,
"position": [
2208,
-1440
],
"id": "7f6fd83b-b640-480f-9f22-35f0f6d00615",
"name": "Instagram Data Report Process"
},
{
"parameters": {
"sendTo": "jakariaislam1044@gmail.com",
"subject": "={{ $json.output['Report Name'] }}",
"message": "={{ $json.output['Analyzed Report '] }}",
"options": {
"appendAttribution": false
}
},
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.1,
"position": [
2576,
-1440
],
"id": "17d7999c-40b7-4851-ab4b-e9a965f6b5d4",
"name": "Instagram Analyze Report Mail",
"webhookId": "fb11df27-301c-4e4d-8ef0-e7270d98eeef",
"credentials": {
"gmailOAuth2": {
"id": "AoLyxjViXkDxpXt3",
"name": "Gmail account"
}
}
},
{
"parameters": {
"resource": "webScrapper",
"operation": "triggerCollectionByUrl",
"dataset_id": {
"__rl": true,
"value": "gd_l1viktl72bvl7bjuj0",
"mode": "list",
"cachedResultName": "LinkedIn people profiles"
},
"urls": "=[{\"url\":\"{{ $json['Profile URL'] }}\"}]",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
464,
-704
],
"id": "60dac38f-9831-4821-8848-043c65c77b84",
"name": "Initiate batch extraction for Linkedin",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"amount": 20
},
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
672,
-704
],
"id": "ae03a5fe-b261-4f00-acdb-271fb9390bc6",
"name": "Wait for Linkedin",
"webhookId": "4f1294f3-6ddc-4bc7-8c18-c844d61ebbe9"
},
{
"parameters": {
"resource": "webScrapper",
"operation": "monitorProgressSnapshot",
"snapshot_id": "={{ $json.snapshot_id }}",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
880,
-704
],
"id": "fa475a24-2a5a-4b3e-a2d1-6fd8772b4649",
"name": "Check the status for Linkedin Data",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "6da8c8b2-b8d3-4fd9-80bc-1855f25d1109",
"leftValue": "={{ $json.status }}",
"rightValue": "ready",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
1088,
-704
],
"id": "8c58acba-7f17-42ec-9456-5009f13f3210",
"name": "Linkedin Condition"
},
{
"parameters": {
"options": {
"reset": true
}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
1360,
-624
],
"id": "77f464eb-35c5-4196-b44c-e20eaedefc9b",
"name": "Retry for Linkedin"
},
{
"parameters": {
"resource": "spreadsheet",
"title": "=Linkedin Data of {{ $('Form').item.json[\"Profile URL\"] }}",
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1360,
-800
],
"id": "f4e1408e-5f2b-428e-ae72-daed42e2e782",
"name": "Create spreadsheet for Linkedin Data",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "5QVbNjH1NwujrK2D",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"resource": "webScrapper",
"operation": "downloadSnapshot",
"snapshot_id": "={{ $('Check the status for Linkedin Data').item.json.snapshot_id }}",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
1552,
-800
],
"id": "1bd5e3b5-3084-404b-884e-fdcaa0752091",
"name": "Download the Linkedin Data",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "={{ $('Create spreadsheet for Linkedin Data').item.json.spreadsheetId }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Sheet1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NQpiGnfY0BrL5wUUUK7wA-2knzLFlQc39Oj9dJcHieQ/edit#gid=0"
},
"columns": {
"mappingMode": "autoMapInputData",
"value": {},
"matchingColumns": [],
"schema": [
{
"id": "url",
"displayName": "url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_id",
"displayName": "post_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "user_url",
"displayName": "user_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "user_username_raw",
"displayName": "user_username_raw",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "content",
"displayName": "content",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "date_posted",
"displayName": "date_posted",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "num_comments",
"displayName": "num_comments",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "num_shares",
"displayName": "num_shares",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_name",
"displayName": "page_name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "profile_id",
"displayName": "profile_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_intro",
"displayName": "page_intro",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_category",
"displayName": "page_category",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_logo",
"displayName": "page_logo",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_external_website",
"displayName": "page_external_website",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_followers",
"displayName": "page_followers",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_is_verified",
"displayName": "page_is_verified",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "original_post",
"displayName": "original_post",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "attachments",
"displayName": "attachments",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_external_image",
"displayName": "post_external_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_url",
"displayName": "page_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "header_image",
"displayName": "header_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "avatar_image_url",
"displayName": "avatar_image_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "profile_handle",
"displayName": "profile_handle",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "is_sponsored",
"displayName": "is_sponsored",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "shortcode",
"displayName": "shortcode",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "video_view_count",
"displayName": "video_view_count",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "likes",
"displayName": "likes",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_type",
"displayName": "post_type",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "following",
"displayName": "following",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "link_description_text",
"displayName": "link_description_text",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "count_reactions_type",
"displayName": "count_reactions_type",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "is_page",
"displayName": "is_page",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_phone",
"displayName": "page_phone",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_email",
"displayName": "page_email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_creation_time",
"displayName": "page_creation_time",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_reviews_score",
"displayName": "page_reviews_score",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_reviewers_amount",
"displayName": "page_reviewers_amount",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_price_range",
"displayName": "page_price_range",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "about",
"displayName": "about",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "active_ads_urls",
"displayName": "active_ads_urls",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "delegate_page_id",
"displayName": "delegate_page_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "privacy_and_legal_info",
"displayName": "privacy_and_legal_info",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "timestamp",
"displayName": "timestamp",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "input",
"displayName": "input",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_image",
"displayName": "post_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1776,
-800
],
"id": "8b86f1f9-832d-4407-8e3e-235604ed0bec",
"name": "Append row in sheet for Linkedin Data",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "5QVbNjH1NwujrK2D",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"aggregate": "aggregateAllItemData",
"destinationFieldName": "linkedin data",
"options": {}
},
"type": "n8n-nodes-base.aggregate",
"typeVersion": 1,
"position": [
2000,
-800
],
"id": "73a4eb25-89d0-48f8-938b-07b43c56c895",
"name": "Aggregate Linkedin Data"
},
{
"parameters": {
"sendTo": "jakariaislam1044@gmail.com",
"subject": "={{ $json.output['Report Name'] }}",
"message": "={{ $json.output['Analyzed Report '] }}",
"options": {
"appendAttribution": false
}
},
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.1,
"position": [
2576,
-800
],
"id": "69437963-5a6a-4ec8-8aae-c5ee55e455c5",
"name": "Linkedin Analyze Report Mail",
"webhookId": "fb11df27-301c-4e4d-8ef0-e7270d98eeef",
"credentials": {
"gmailOAuth2": {
"id": "AoLyxjViXkDxpXt3",
"name": "Gmail account"
}
}
},
{
"parameters": {
"text": "=Linkedin Profile Data: {{ JSON.stringify($json['linkedin data']) }}\n\nYour Task is to Analyze the persons Linkedin profile based on the Linkedin data and create a beautiful Report in HTML format.",
"attributes": {
"attributes": [
{
"name": "Analyzed Report ",
"description": "=Report in HTML code",
"required": true
},
{
"name": "Report Name",
"description": "name of that analyzed report",
"required": true
}
]
},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"typeVersion": 1.2,
"position": [
2208,
-800
],
"id": "bd181a7d-e93c-4e79-a671-5a9c97b718d9",
"name": "Linkedin Data Report Process"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "8d339917-ccf8-4b75-bded-37fce3e9b80d",
"name": "url",
"value": "=https://docs.google.com/spreadsheets/d/{{ $('Create spreadsheet for Facebook Data').item.json.spreadsheetId }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
2880,
-2064
],
"id": "2e74eb7f-78df-410e-9d92-e0caf3eae08c",
"name": "Facebook Data URL"
},
{
"parameters": {
"operation": "completion",
"completionTitle": "Here the Facebook Data Sheet 🔽",
"completionMessage": "={{ $json.url }}",
"options": {}
},
"type": "n8n-nodes-base.form",
"typeVersion": 1,
"position": [
3088,
-2064
],
"id": "bb88db80-2bfb-457b-8dbd-792194299e58",
"name": "End Result for Facebook",
"webhookId": "5f50d293-8c56-4055-8cc5-31fc94538391"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "8d339917-ccf8-4b75-bded-37fce3e9b80d",
"name": "url",
"value": "=https://docs.google.com/spreadsheets/d/{{ $('Create spreadsheet for Instagram Data').item.json.spreadsheetId }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
2832,
-1440
],
"id": "7c761597-feb2-44c3-af66-ebc6a6a4a607",
"name": "Instagram Data URL"
},
{
"parameters": {
"operation": "completion",
"completionTitle": "Here the Instagram Data Sheet 🔽",
"completionMessage": "={{ $json.url }}",
"options": {}
},
"type": "n8n-nodes-base.form",
"typeVersion": 1,
"position": [
3040,
-1440
],
"id": "8338d3f7-b4c4-44b1-ba2f-d28e5205cc61",
"name": "End Result for Instagram",
"webhookId": "5f50d293-8c56-4055-8cc5-31fc94538391"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "8d339917-ccf8-4b75-bded-37fce3e9b80d",
"name": "url",
"value": "=https://docs.google.com/spreadsheets/d/{{ $('Create spreadsheet for Linkedin Data').item.json.spreadsheetId }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
2768,
-800
],
"id": "8de51ee4-7e79-4b70-aaa3-1fcb85bbbf7f",
"name": "Linkedin Data URL"
},
{
"parameters": {
"operation": "completion",
"completionTitle": "Here the Linkedin Data Sheet 🔽",
"completionMessage": "={{ $json.url }}",
"options": {}
},
"type": "n8n-nodes-base.form",
"typeVersion": 1,
"position": [
3008,
-800
],
"id": "63e1dbba-091e-4f15-b14c-8e69ebdf914e",
"name": "End Result for Linkedin",
"webhookId": "5f50d293-8c56-4055-8cc5-31fc94538391"
},
{
"parameters": {
"resource": "webScrapper",
"operation": "triggerCollectionByUrl",
"dataset_id": {
"__rl": true,
"value": "gd_lwxmeb2u1cniijd7t4",
"mode": "list",
"cachedResultName": "X (formerly Twitter) - Profiles"
},
"urls": "=[{\"url\":\"{{ $json['Profile URL'] }}\"}]",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
480,
-64
],
"id": "dda2678d-55b4-4605-bb56-8e2701130c27",
"name": "Initiate batch extraction for X",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"amount": 20
},
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
800,
-64
],
"id": "ccd26aa1-56bb-422c-9d67-324a7bd3f9ee",
"name": "Wait for X",
"webhookId": "4f1294f3-6ddc-4bc7-8c18-c844d61ebbe9"
},
{
"parameters": {
"resource": "webScrapper",
"operation": "monitorProgressSnapshot",
"snapshot_id": "={{ $json.snapshot_id }}",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
1008,
-64
],
"id": "685d17a5-0a8e-4fcb-927b-6d0566801ac4",
"name": "Check the status for X Data",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "6da8c8b2-b8d3-4fd9-80bc-1855f25d1109",
"leftValue": "={{ $json.status }}",
"rightValue": "ready",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
1216,
-64
],
"id": "485e96f1-17ab-4b8e-b3e5-4a6f22cf2829",
"name": "X Condition"
},
{
"parameters": {
"options": {
"reset": true
}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
1488,
16
],
"id": "1d063580-9940-4e35-832e-5c00ecfdf0f7",
"name": "Retry for X"
},
{
"parameters": {
"resource": "spreadsheet",
"title": "=X Data of {{ $('Form').item.json[\"Profile URL\"] }}",
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1488,
-160
],
"id": "f658f93f-cb68-4c09-8584-1bf86f9eb761",
"name": "Create spreadsheet for X Data",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "5QVbNjH1NwujrK2D",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"resource": "webScrapper",
"operation": "downloadSnapshot",
"snapshot_id": "={{ $('Check the status for X Data').item.json.snapshot_id }}",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
1696,
-160
],
"id": "1d241f1f-2530-4312-bd4b-03745da85f5b",
"name": "Download the X Data",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "={{ $('Create spreadsheet for X Data').item.json.spreadsheetId }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Sheet1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NQpiGnfY0BrL5wUUUK7wA-2knzLFlQc39Oj9dJcHieQ/edit#gid=0"
},
"columns": {
"mappingMode": "autoMapInputData",
"value": {},
"matchingColumns": [],
"schema": [
{
"id": "url",
"displayName": "url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_id",
"displayName": "post_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "user_url",
"displayName": "user_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "user_username_raw",
"displayName": "user_username_raw",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "content",
"displayName": "content",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "date_posted",
"displayName": "date_posted",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "num_comments",
"displayName": "num_comments",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "num_shares",
"displayName": "num_shares",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_name",
"displayName": "page_name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "profile_id",
"displayName": "profile_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_intro",
"displayName": "page_intro",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_category",
"displayName": "page_category",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_logo",
"displayName": "page_logo",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_external_website",
"displayName": "page_external_website",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_followers",
"displayName": "page_followers",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_is_verified",
"displayName": "page_is_verified",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "original_post",
"displayName": "original_post",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "attachments",
"displayName": "attachments",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_external_image",
"displayName": "post_external_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_url",
"displayName": "page_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "header_image",
"displayName": "header_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "avatar_image_url",
"displayName": "avatar_image_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "profile_handle",
"displayName": "profile_handle",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "is_sponsored",
"displayName": "is_sponsored",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "shortcode",
"displayName": "shortcode",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "video_view_count",
"displayName": "video_view_count",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "likes",
"displayName": "likes",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_type",
"displayName": "post_type",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "following",
"displayName": "following",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "link_description_text",
"displayName": "link_description_text",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "count_reactions_type",
"displayName": "count_reactions_type",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "is_page",
"displayName": "is_page",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_phone",
"displayName": "page_phone",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_email",
"displayName": "page_email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_creation_time",
"displayName": "page_creation_time",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_reviews_score",
"displayName": "page_reviews_score",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_reviewers_amount",
"displayName": "page_reviewers_amount",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_price_range",
"displayName": "page_price_range",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "about",
"displayName": "about",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "active_ads_urls",
"displayName": "active_ads_urls",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "delegate_page_id",
"displayName": "delegate_page_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "privacy_and_legal_info",
"displayName": "privacy_and_legal_info",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "timestamp",
"displayName": "timestamp",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "input",
"displayName": "input",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_image",
"displayName": "post_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1920,
-160
],
"id": "43067ecc-c5b4-4e65-b90f-c5a62e945f67",
"name": "Append row in sheet for X Data",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "5QVbNjH1NwujrK2D",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"aggregate": "aggregateAllItemData",
"destinationFieldName": "x data",
"options": {}
},
"type": "n8n-nodes-base.aggregate",
"typeVersion": 1,
"position": [
2128,
-160
],
"id": "1d12aa0c-74fe-4bbf-8a78-a53496d73627",
"name": "Aggregate X Data"
},
{
"parameters": {
"text": "=X Profile Data: {{ JSON.stringify($json['x data']) }}\n\nYour Task is to Analyze the persons X profile based on the X data and create a beautiful Report in HTML format.",
"attributes": {
"attributes": [
{
"name": "Analyzed Report ",
"description": "=Report in HTML code",
"required": true
},
{
"name": "Report Name",
"description": "name of that analyzed report",
"required": true
}
]
},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"typeVersion": 1.2,
"position": [
2336,
-160
],
"id": "a26ebaba-8c56-4476-a5f8-5ea49d9528d2",
"name": "X Data Report Process"
},
{
"parameters": {
"sendTo": "jakariaislam1044@gmail.com",
"subject": "={{ $json.output['Report Name'] }}",
"message": "={{ $json.output['Analyzed Report '] }}",
"options": {
"appendAttribution": false
}
},
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.1,
"position": [
2704,
-160
],
"id": "33f996a0-02a9-4df9-a2aa-d945d49cfb42",
"name": "X Analyze Report Mail",
"webhookId": "fb11df27-301c-4e4d-8ef0-e7270d98eeef",
"credentials": {
"gmailOAuth2": {
"id": "AoLyxjViXkDxpXt3",
"name": "Gmail account"
}
}
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "8d339917-ccf8-4b75-bded-37fce3e9b80d",
"name": "url",
"value": "=https://docs.google.com/spreadsheets/d/{{ $('Create spreadsheet for X Data').item.json.spreadsheetId }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
2912,
-160
],
"id": "82574bde-2a81-48ce-9963-faadc72bb3df",
"name": "X Data URL"
},
{
"parameters": {
"operation": "completion",
"completionTitle": "Here the X Data Sheet 🔽",
"completionMessage": "={{ $json.url }}",
"options": {}
},
"type": "n8n-nodes-base.form",
"typeVersion": 1,
"position": [
3120,
-160
],
"id": "fcea7f27-6ba2-49e5-a3eb-e3c5521291b0",
"name": "End Result for X",
"webhookId": "5f50d293-8c56-4055-8cc5-31fc94538391"
},
{
"parameters": {
"resource": "webScrapper",
"operation": "triggerCollectionByUrl",
"dataset_id": {
"__rl": true,
"value": "gd_lk538t2k2p1k3oos71",
"mode": "list",
"cachedResultName": "YouTube - Profiles"
},
"urls": "=[{\"url\":\"{{ $json['Profile URL'] }}\"}]",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
464,
592
],
"id": "3b441a6b-4051-4576-b77b-55d1ff458767",
"name": "Initiate batch extraction for YouTube",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"amount": 20
},
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
784,
592
],
"id": "560c43b9-e2dc-48d8-8486-990fae1f15e5",
"name": "Wait for YouTube",
"webhookId": "4f1294f3-6ddc-4bc7-8c18-c844d61ebbe9"
},
{
"parameters": {
"resource": "webScrapper",
"operation": "monitorProgressSnapshot",
"snapshot_id": "={{ $json.snapshot_id }}",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
992,
592
],
"id": "76680229-8a6c-4f56-bfad-d887f279fbe9",
"name": "Check the status for YouTube Data",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "6da8c8b2-b8d3-4fd9-80bc-1855f25d1109",
"leftValue": "={{ $json.status }}",
"rightValue": "ready",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
1200,
592
],
"id": "7a591d52-6012-4589-902c-5106d3fd8a95",
"name": "YouTube Condition"
},
{
"parameters": {
"resource": "spreadsheet",
"title": "=YouTube Data of {{ $('Form').item.json[\"Profile URL\"] }}",
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1472,
496
],
"id": "2cc55683-7d95-429d-9e13-a8d8ca4aa73b",
"name": "Create spreadsheet for YouTube Data",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "5QVbNjH1NwujrK2D",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"options": {
"reset": true
}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
1472,
672
],
"id": "bf7e3205-e43e-465b-842e-572cf5ae7381",
"name": "Retry for YouTube"
},
{
"parameters": {
"resource": "webScrapper",
"operation": "downloadSnapshot",
"snapshot_id": "={{ $('Check the status for YouTube Data').item.json.snapshot_id }}",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
1680,
496
],
"id": "ec0e7b3c-bc48-4185-93f8-39702b0eec63",
"name": "Download the YouTube Data",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "={{ $('Create spreadsheet for YouTube Data').item.json.spreadsheetId }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Sheet1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1e_OUDWIS0ITPicpLqm2ZpPm1cr6L99X0arG8HA_B_wg/edit#gid=0"
},
"columns": {
"mappingMode": "autoMapInputData",
"value": {},
"matchingColumns": [
"id"
],
"schema": [
{
"id": "url",
"displayName": "url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "handle",
"displayName": "handle",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "handle_md5",
"displayName": "handle_md5",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "banner_img",
"displayName": "banner_img",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "profile_image",
"displayName": "profile_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "name",
"displayName": "name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "subscribers",
"displayName": "subscribers",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Description",
"displayName": "Description",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "videos_count",
"displayName": "videos_count",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "created_date",
"displayName": "created_date",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "views",
"displayName": "views",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Details",
"displayName": "Details",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "Links",
"displayName": "Links",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "identifier",
"displayName": "identifier",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "id",
"displayName": "id",
"required": false,
"defaultMatch": true,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "has_podcast",
"displayName": "has_podcast",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "top_videos",
"displayName": "top_videos",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "timestamp",
"displayName": "timestamp",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "input",
"displayName": "input",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1904,
496
],
"id": "95099cc4-0513-4b65-ac9d-548ecee008b8",
"name": "Append row in sheet for YouTube Data",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "5QVbNjH1NwujrK2D",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"aggregate": "aggregateAllItemData",
"destinationFieldName": "youtube data",
"options": {}
},
"type": "n8n-nodes-base.aggregate",
"typeVersion": 1,
"position": [
2112,
496
],
"id": "4841b5c9-f86c-484e-a247-76d384453533",
"name": "Aggregate YouTube Data"
},
{
"parameters": {
"text": "=YouTube Profile Data: {{ JSON.stringify($json['youtube data']) }}\n\nYour Task is to Analyze the persons YouTube profile based on the YouTube data and create a beautiful Report in HTML format.",
"attributes": {
"attributes": [
{
"name": "Analyzed Report ",
"description": "=Report in HTML code",
"required": true
},
{
"name": "Report Name",
"description": "name of that analyzed report",
"required": true
}
]
},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"typeVersion": 1.2,
"position": [
2320,
496
],
"id": "eb45a744-b628-4a77-add4-4c979480c1df",
"name": "YouTube Data Report Process"
},
{
"parameters": {
"sendTo": "jakariaislam1044@gmail.com",
"subject": "={{ $json.output['Report Name'] }}",
"message": "={{ $json.output['Analyzed Report '] }}",
"options": {
"appendAttribution": false
}
},
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.1,
"position": [
2688,
496
],
"id": "c7db5ee7-b915-4c0d-810d-f7051bfa8645",
"name": "YouTube Analyze Report Mail",
"webhookId": "fb11df27-301c-4e4d-8ef0-e7270d98eeef",
"credentials": {
"gmailOAuth2": {
"id": "AoLyxjViXkDxpXt3",
"name": "Gmail account"
}
}
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "8d339917-ccf8-4b75-bded-37fce3e9b80d",
"name": "url",
"value": "=https://docs.google.com/spreadsheets/d/{{ $('Create spreadsheet for YouTube Data').item.json.spreadsheetId }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
2896,
496
],
"id": "91828ef9-c993-4245-a82b-6f8534739478",
"name": "YouTube Data URL"
},
{
"parameters": {
"operation": "completion",
"completionTitle": "Here the YouTube Data Sheet 🔽",
"completionMessage": "={{ $json.url }}",
"options": {}
},
"type": "n8n-nodes-base.form",
"typeVersion": 1,
"position": [
3104,
496
],
"id": "f1d7fd6a-5bb6-4f21-b209-47adbb0a5bc9",
"name": "End Result for YouTube",
"webhookId": "5f50d293-8c56-4055-8cc5-31fc94538391"
},
{
"parameters": {
"resource": "webScrapper",
"operation": "triggerCollectionByUrl",
"dataset_id": {
"__rl": true,
"value": "gd_lk0zv93c2m9qdph46z",
"mode": "list",
"cachedResultName": "Pinterest - Profiles"
},
"urls": "=[{\"url\":\"{{ $json['Profile URL'] }}\"}]",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
448,
1216
],
"id": "70a1a8c4-be6e-4482-9844-e53e90fd9bfd",
"name": "Initiate batch extraction for Pinterest",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"amount": 20
},
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
784,
1216
],
"id": "b2fc1134-5ba2-47cc-956d-6b94120760b9",
"name": "Wait for Pinterest",
"webhookId": "4f1294f3-6ddc-4bc7-8c18-c844d61ebbe9"
},
{
"parameters": {
"resource": "webScrapper",
"operation": "monitorProgressSnapshot",
"snapshot_id": "={{ $json.snapshot_id }}",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
992,
1216
],
"id": "aa990378-9f09-48d9-90a3-8990cf151f30",
"name": "Check the status for Pinterest Data",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "6da8c8b2-b8d3-4fd9-80bc-1855f25d1109",
"leftValue": "={{ $json.status }}",
"rightValue": "ready",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
1200,
1216
],
"id": "0a4edb06-a4d0-48ea-ac68-cbac20f44723",
"name": "Pinterest Condition"
},
{
"parameters": {
"resource": "spreadsheet",
"title": "=Pinterest Data of {{ $('Form').item.json[\"Profile URL\"] }}",
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1472,
1120
],
"id": "a9738d43-af44-4eb9-a6fc-b373ab5a1c57",
"name": "Create spreadsheet for Pinterest Data",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "5QVbNjH1NwujrK2D",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"options": {
"reset": true
}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
1472,
1296
],
"id": "9b93cce3-db86-40b8-8e69-97a774d9eb5c",
"name": "Retry for Pinterest"
},
{
"parameters": {
"resource": "webScrapper",
"operation": "downloadSnapshot",
"snapshot_id": "={{ $('Check the status for Pinterest Data').item.json.snapshot_id }}",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
1680,
1120
],
"id": "8577ff9c-62e5-4cf7-a03b-94eff9b6c11d",
"name": "Download the Pinterest Data",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "={{ $('Create spreadsheet for Pinterest Data').item.json.spreadsheetId }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Sheet1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NQpiGnfY0BrL5wUUUK7wA-2knzLFlQc39Oj9dJcHieQ/edit#gid=0"
},
"columns": {
"mappingMode": "autoMapInputData",
"value": {},
"matchingColumns": [],
"schema": [
{
"id": "url",
"displayName": "url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_id",
"displayName": "post_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "user_url",
"displayName": "user_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "user_username_raw",
"displayName": "user_username_raw",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "content",
"displayName": "content",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "date_posted",
"displayName": "date_posted",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "num_comments",
"displayName": "num_comments",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "num_shares",
"displayName": "num_shares",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_name",
"displayName": "page_name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "profile_id",
"displayName": "profile_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_intro",
"displayName": "page_intro",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_category",
"displayName": "page_category",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_logo",
"displayName": "page_logo",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_external_website",
"displayName": "page_external_website",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_followers",
"displayName": "page_followers",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_is_verified",
"displayName": "page_is_verified",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "original_post",
"displayName": "original_post",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "attachments",
"displayName": "attachments",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_external_image",
"displayName": "post_external_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_url",
"displayName": "page_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "header_image",
"displayName": "header_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "avatar_image_url",
"displayName": "avatar_image_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "profile_handle",
"displayName": "profile_handle",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "is_sponsored",
"displayName": "is_sponsored",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "shortcode",
"displayName": "shortcode",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "video_view_count",
"displayName": "video_view_count",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "likes",
"displayName": "likes",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_type",
"displayName": "post_type",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "following",
"displayName": "following",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "link_description_text",
"displayName": "link_description_text",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "count_reactions_type",
"displayName": "count_reactions_type",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "is_page",
"displayName": "is_page",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_phone",
"displayName": "page_phone",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_email",
"displayName": "page_email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_creation_time",
"displayName": "page_creation_time",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_reviews_score",
"displayName": "page_reviews_score",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_reviewers_amount",
"displayName": "page_reviewers_amount",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_price_range",
"displayName": "page_price_range",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "about",
"displayName": "about",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "active_ads_urls",
"displayName": "active_ads_urls",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "delegate_page_id",
"displayName": "delegate_page_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "privacy_and_legal_info",
"displayName": "privacy_and_legal_info",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "timestamp",
"displayName": "timestamp",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "input",
"displayName": "input",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_image",
"displayName": "post_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1904,
1120
],
"id": "ff15ecf8-86d0-445f-a7dd-7f75933db5f3",
"name": "Append row in sheet for Pinterest Data",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "5QVbNjH1NwujrK2D",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"aggregate": "aggregateAllItemData",
"destinationFieldName": "pinterest data",
"options": {}
},
"type": "n8n-nodes-base.aggregate",
"typeVersion": 1,
"position": [
2112,
1120
],
"id": "a6012a45-302b-4bd9-a7e3-6af1a6c5d35f",
"name": "Aggregate Pinterest Data"
},
{
"parameters": {
"text": "=Pinterest Profile Data: {{ JSON.stringify($json['pinterest data']) }}\n\nYour Task is to Analyze the persons Pinterest profile based on the Pinterest data and create a beautiful Report in HTML format.",
"attributes": {
"attributes": [
{
"name": "Analyzed Report ",
"description": "=Report in HTML code",
"required": true
},
{
"name": "Report Name",
"description": "name of that analyzed report",
"required": true
}
]
},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"typeVersion": 1.2,
"position": [
2320,
1120
],
"id": "94a72e8e-0788-462a-b140-031fb4bb1f1d",
"name": "Pinterest Data Report Process"
},
{
"parameters": {
"sendTo": "jakariaislam1044@gmail.com",
"subject": "={{ $json.output['Report Name'] }}",
"message": "={{ $json.output['Analyzed Report '] }}",
"options": {
"appendAttribution": false
}
},
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.1,
"position": [
2688,
1120
],
"id": "d523bccf-626f-4187-bca1-11698f0b187a",
"name": "Pinterest Analyze Report Mail",
"webhookId": "fb11df27-301c-4e4d-8ef0-e7270d98eeef",
"credentials": {
"gmailOAuth2": {
"id": "AoLyxjViXkDxpXt3",
"name": "Gmail account"
}
}
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "8d339917-ccf8-4b75-bded-37fce3e9b80d",
"name": "url",
"value": "=https://docs.google.com/spreadsheets/d/{{ $('Create spreadsheet for Pinterest Data').item.json.spreadsheetId }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
2896,
1120
],
"id": "a87e0cf3-0fc2-4473-b63c-8adb58093915",
"name": "Pinterest Data URL"
},
{
"parameters": {
"operation": "completion",
"completionTitle": "Here the Pinterest Data Sheet 🔽",
"completionMessage": "={{ $json.url }}",
"options": {}
},
"type": "n8n-nodes-base.form",
"typeVersion": 1,
"position": [
3104,
1120
],
"id": "1f7a9c20-d1aa-4a83-a43c-34f9b785f691",
"name": "End Result for Pinterest",
"webhookId": "5f50d293-8c56-4055-8cc5-31fc94538391"
},
{
"parameters": {
"resource": "webScrapper",
"operation": "triggerCollectionByUrl",
"dataset_id": {
"__rl": true,
"value": "gd_l1villgoiiidt09ci",
"mode": "list",
"cachedResultName": "TikTok - Profiles"
},
"urls": "=[{\"url\":\"{{ $json['Profile URL'] }}\"}]",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
480,
1856
],
"id": "c4500821-5f87-4b6d-b027-e1241e95eccc",
"name": "Initiate batch extraction for TikTok",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"amount": 20
},
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
800,
1856
],
"id": "29590565-2719-4c0a-a1da-00e8c2703fbb",
"name": "Wait for TikTok",
"webhookId": "4f1294f3-6ddc-4bc7-8c18-c844d61ebbe9"
},
{
"parameters": {
"resource": "webScrapper",
"operation": "monitorProgressSnapshot",
"snapshot_id": "={{ $json.snapshot_id }}",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
1008,
1856
],
"id": "a18bf9ab-8023-4e30-a310-02826d95a28b",
"name": "Check the status for TikTok Data",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "6da8c8b2-b8d3-4fd9-80bc-1855f25d1109",
"leftValue": "={{ $json.status }}",
"rightValue": "ready",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
1216,
1856
],
"id": "e37e11c2-f0ad-4cb0-a0fd-5d4720cbd1f9",
"name": "TikTok Condition"
},
{
"parameters": {
"resource": "spreadsheet",
"title": "=TikTok Data of {{ $('Form').item.json[\"Profile URL\"] }}",
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1488,
1760
],
"id": "2a85695d-cd63-4e74-81ec-15262d88c998",
"name": "Create spreadsheet for TikTok Data",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "5QVbNjH1NwujrK2D",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"options": {
"reset": true
}
},
"type": "n8n-nodes-base.splitInBatches",
"typeVersion": 3,
"position": [
1488,
1936
],
"id": "c1509f8d-c1d8-4843-885e-eec6bcf23d7c",
"name": "Retry for TikTok"
},
{
"parameters": {
"resource": "webScrapper",
"operation": "downloadSnapshot",
"snapshot_id": "={{ $('Check the status for TikTok Data').item.json.snapshot_id }}",
"requestOptions": {}
},
"type": "@brightdata/n8n-nodes-brightdata.brightData",
"typeVersion": 1,
"position": [
1696,
1760
],
"id": "20737ee0-e65b-4c9b-8f2e-52db66702ca1",
"name": "Download the TikTok Data",
"credentials": {
"brightdataApi": {
"id": "LN8hrxyOpoPUSVJg",
"name": "BrightData account"
}
}
},
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "={{ $('Create spreadsheet for TikTok Data').item.json.spreadsheetId }}",
"mode": "id"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Sheet1",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1NQpiGnfY0BrL5wUUUK7wA-2knzLFlQc39Oj9dJcHieQ/edit#gid=0"
},
"columns": {
"mappingMode": "autoMapInputData",
"value": {},
"matchingColumns": [],
"schema": [
{
"id": "url",
"displayName": "url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_id",
"displayName": "post_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "user_url",
"displayName": "user_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "user_username_raw",
"displayName": "user_username_raw",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "content",
"displayName": "content",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "date_posted",
"displayName": "date_posted",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "num_comments",
"displayName": "num_comments",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "num_shares",
"displayName": "num_shares",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_name",
"displayName": "page_name",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "profile_id",
"displayName": "profile_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_intro",
"displayName": "page_intro",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_category",
"displayName": "page_category",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_logo",
"displayName": "page_logo",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_external_website",
"displayName": "page_external_website",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_followers",
"displayName": "page_followers",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_is_verified",
"displayName": "page_is_verified",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "original_post",
"displayName": "original_post",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "attachments",
"displayName": "attachments",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_external_image",
"displayName": "post_external_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_url",
"displayName": "page_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "header_image",
"displayName": "header_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "avatar_image_url",
"displayName": "avatar_image_url",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "profile_handle",
"displayName": "profile_handle",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "is_sponsored",
"displayName": "is_sponsored",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "shortcode",
"displayName": "shortcode",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "video_view_count",
"displayName": "video_view_count",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "likes",
"displayName": "likes",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_type",
"displayName": "post_type",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "following",
"displayName": "following",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "link_description_text",
"displayName": "link_description_text",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "count_reactions_type",
"displayName": "count_reactions_type",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "is_page",
"displayName": "is_page",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_phone",
"displayName": "page_phone",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_email",
"displayName": "page_email",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_creation_time",
"displayName": "page_creation_time",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_reviews_score",
"displayName": "page_reviews_score",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_reviewers_amount",
"displayName": "page_reviewers_amount",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "page_price_range",
"displayName": "page_price_range",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "about",
"displayName": "about",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "active_ads_urls",
"displayName": "active_ads_urls",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "delegate_page_id",
"displayName": "delegate_page_id",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "privacy_and_legal_info",
"displayName": "privacy_and_legal_info",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "timestamp",
"displayName": "timestamp",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "input",
"displayName": "input",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "post_image",
"displayName": "post_image",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.7,
"position": [
1920,
1760
],
"id": "f741b904-094b-4a96-bdfd-b300f3920441",
"name": "Append row in sheet for TikTok Data",
"credentials": {
"googleSheetsOAuth2Api": {
"id": "5QVbNjH1NwujrK2D",
"name": "Google Sheets account"
}
}
},
{
"parameters": {
"aggregate": "aggregateAllItemData",
"destinationFieldName": "tiktok data",
"options": {}
},
"type": "n8n-nodes-base.aggregate",
"typeVersion": 1,
"position": [
2128,
1760
],
"id": "ea58a676-24e2-4041-9c68-f7b8bf5af992",
"name": "Aggregate TikTok Data"
},
{
"parameters": {
"text": "=TikTok Profile Data: {{ JSON.stringify($json['tiktok data']) }}\n\nYour Task is to Analyze the persons TikTok profile based on the TikTok data and create a beautiful Report in HTML format.",
"attributes": {
"attributes": [
{
"name": "Analyzed Report ",
"description": "=Report in HTML code",
"required": true
},
{
"name": "Report Name",
"description": "name of that analyzed report",
"required": true
}
]
},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.informationExtractor",
"typeVersion": 1.2,
"position": [
2336,
1760
],
"id": "6a34ab29-86cc-475b-89fe-d5616e8fe83a",
"name": "TikTok Data Report Process"
},
{
"parameters": {
"sendTo": "jakariaislam1044@gmail.com",
"subject": "={{ $json.output['Report Name'] }}",
"message": "={{ $json.output['Analyzed Report '] }}",
"options": {
"appendAttribution": false
}
},
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.1,
"position": [
2704,
1760
],
"id": "82570668-d431-415b-acba-6ca2a40196f4",
"name": "TikTok Analyze Report Mail",
"webhookId": "fb11df27-301c-4e4d-8ef0-e7270d98eeef",
"credentials": {
"gmailOAuth2": {
"id": "AoLyxjViXkDxpXt3",
"name": "Gmail account"
}
}
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "8d339917-ccf8-4b75-bded-37fce3e9b80d",
"name": "url",
"value": "=https://docs.google.com/spreadsheets/d/{{ $('Create spreadsheet for TikTok Data').item.json.spreadsheetId }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
2912,
1760
],
"id": "7734ea67-48a4-43a9-a661-7d4527141d2b",
"name": "TikTok Data URL"
},
{
"parameters": {
"operation": "completion",
"completionTitle": "Here the TikTok Data Sheet 🔽",
"completionMessage": "={{ $json.url }}",
"options": {}
},
"type": "n8n-nodes-base.form",
"typeVersion": 1,
"position": [
3120,
1760
],
"id": "774a9fe5-0215-480a-99f1-5ed37eac5850",
"name": "End Result for TikTok",
"webhookId": "5f50d293-8c56-4055-8cc5-31fc94538391"
},
{
"parameters": {
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.lmChatGoogleGemini",
"typeVersion": 1,
"position": [
3648,
2064
],
"id": "9a2afbad-22a4-4058-96b2-a5e49bd42c52",
"name": "Gemini 2.5 Flash",
"credentials": {
"googlePalmApi": {
"id": "r1ZkzE6I04xcx5en",
"name": "Google Gemini(PaLM) Api account"
}
}
},
{
"parameters": {
"content": "# For Facebook",
"height": 512,
"width": 2992
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
352,
-2128
],
"id": "996dc713-2437-4afc-93b0-ace12b3064bd",
"name": "Sticky Note"
},
{
"parameters": {
"content": "# For Instagram",
"height": 512,
"width": 2992
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
368,
-1504
],
"id": "1f25e3d4-53b0-4d7a-8b86-4c4b6d268000",
"name": "Sticky Note1"
},
{
"parameters": {
"content": "# For Linkedin",
"height": 512,
"width": 2992
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
368,
-880
],
"id": "c2aa7ddf-599d-4682-8135-6a00e01e9695",
"name": "Sticky Note2"
},
{
"parameters": {
"content": "# For X",
"height": 512,
"width": 2992
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
368,
-240
],
"id": "59720f3c-03cb-410f-b08e-e5c646d32795",
"name": "Sticky Note3"
},
{
"parameters": {
"content": "# For YouTube",
"height": 512,
"width": 2992
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
368,
416
],
"id": "29b05456-1119-489b-89de-ce082027df5b",
"name": "Sticky Note4"
},
{
"parameters": {
"content": "# For Pinterest",
"height": 512,
"width": 2992
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
368,
1056
],
"id": "52499433-4aed-488e-8489-5f70497cc61e",
"name": "Sticky Note5"
},
{
"parameters": {
"content": "# For TikTok",
"height": 512,
"width": 2992
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
368,
1696
],
"id": "c23a95ea-0206-46f7-9c13-81928e65497b",
"name": "Sticky Note6"
},
{
"parameters": {
"content": "# Brain",
"height": 336,
"width": 320
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
3520,
1872
],
"id": "dd7d617f-f4fd-485e-ac8e-3b4c2f61126e",
"name": "Sticky Note7"
},
{
"parameters": {
"content": "# Filtering",
"height": 464,
"width": 288
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-336,
-272
],
"id": "6d876fd8-41fb-4e85-aed1-b181db011cc0",
"name": "Sticky Note8"
},
{
"parameters": {
"content": "# User Input",
"height": 272,
"width": 256
},
"type": "n8n-nodes-base.stickyNote",
"typeVersion": 1,
"position": [
-704,
-176
],
"id": "e5784fd2-8ab9-416b-98ec-9c013f23de21",
"name": "Sticky Note9"
}
],
"pinData": {},
"connections": {
"Form": {
"main": [
[
{
"node": "Define",
"type": "main",
"index": 0
}
]
]
},
"Define": {
"main": [
[
{
"node": "Initiate batch extraction for Facebook",
"type": "main",
"index": 0
}
],
[
{
"node": "Initiate batch extraction for Instagram",
"type": "main",
"index": 0
}
],
[
{
"node": "Initiate batch extraction for Linkedin",
"type": "main",
"index": 0
}
],
[
{
"node": "Initiate batch extraction for X",
"type": "main",
"index": 0
}
],
[
{
"node": "Initiate batch extraction for YouTube",
"type": "main",
"index": 0
}
],
[
{
"node": "Initiate batch extraction for Pinterest",
"type": "main",
"index": 0
}
],
[
{
"node": "Initiate batch extraction for TikTok",
"type": "main",
"index": 0
}
]
]
},
"Initiate batch extraction for Facebook": {
"main": [
[
{
"node": "Wait for Facebook",
"type": "main",
"index": 0
}
]
]
},
"Check the status for Facebook Data": {
"main": [
[
{
"node": "Facebook Condition",
"type": "main",
"index": 0
}
]
]
},
"Facebook Condition": {
"main": [
[
{
"node": "Create spreadsheet for Facebook Data",
"type": "main",
"index": 0
}
],
[
{
"node": "Retry for Facebook",
"type": "main",
"index": 0
}
]
]
},
"Retry for Facebook": {
"main": [
[],
[
{
"node": "Wait for Facebook",
"type": "main",
"index": 0
}
]
]
},
"Wait for Facebook": {
"main": [
[
{
"node": "Check the status for Facebook Data",
"type": "main",
"index": 0
}
]
]
},
"Download the Facebook Data": {
"main": [
[
{
"node": "Append row in sheet for Facebook Data",
"type": "main",
"index": 0
}
]
]
},
"Create spreadsheet for Facebook Data": {
"main": [
[
{
"node": "Download the Facebook Data",
"type": "main",
"index": 0
}
]
]
},
"Append row in sheet for Facebook Data": {
"main": [
[
{
"node": "Aggregate FaceBook Data",
"type": "main",
"index": 0
}
]
]
},
"Aggregate FaceBook Data": {
"main": [
[
{
"node": "Facebook Data Report Process",
"type": "main",
"index": 0
}
]
]
},
"Facebook Data Report Process": {
"main": [
[
{
"node": "Facebook Analyze Report Mail",
"type": "main",
"index": 0
}
]
]
},
"Initiate batch extraction for Instagram": {
"main": [
[
{
"node": "Wait for Instagram",
"type": "main",
"index": 0
}
]
]
},
"Wait for Instagram": {
"main": [
[
{
"node": "Check the status for Instagram Data",
"type": "main",
"index": 0
}
]
]
},
"Check the status for Instagram Data": {
"main": [
[
{
"node": "Instagram Condition",
"type": "main",
"index": 0
}
]
]
},
"Instagram Condition": {
"main": [
[
{
"node": "Create spreadsheet for Instagram Data",
"type": "main",
"index": 0
}
],
[
{
"node": "Retry for Instagram",
"type": "main",
"index": 0
}
]
]
},
"Retry for Instagram": {
"main": [
[],
[
{
"node": "Wait for Instagram",
"type": "main",
"index": 0
}
]
]
},
"Create spreadsheet for Instagram Data": {
"main": [
[
{
"node": "Download the Instagram Data",
"type": "main",
"index": 0
}
]
]
},
"Download the Instagram Data": {
"main": [
[
{
"node": "Append row in sheet for Instagram Data",
"type": "main",
"index": 0
}
]
]
},
"Append row in sheet for Instagram Data": {
"main": [
[
{
"node": "Aggregate Instagram Data",
"type": "main",
"index": 0
}
]
]
},
"Aggregate Instagram Data": {
"main": [
[
{
"node": "Instagram Data Report Process",
"type": "main",
"index": 0
}
]
]
},
"Instagram Data Report Process": {
"main": [
[
{
"node": "Instagram Analyze Report Mail",
"type": "main",
"index": 0
}
]
]
},
"Initiate batch extraction for Linkedin": {
"main": [
[
{
"node": "Wait for Linkedin",
"type": "main",
"index": 0
}
]
]
},
"Wait for Linkedin": {
"main": [
[
{
"node": "Check the status for Linkedin Data",
"type": "main",
"index": 0
}
]
]
},
"Check the status for Linkedin Data": {
"main": [
[
{
"node": "Linkedin Condition",
"type": "main",
"index": 0
}
]
]
},
"Linkedin Condition": {
"main": [
[
{
"node": "Create spreadsheet for Linkedin Data",
"type": "main",
"index": 0
}
],
[
{
"node": "Retry for Linkedin",
"type": "main",
"index": 0
}
]
]
},
"Retry for Linkedin": {
"main": [
[],
[
{
"node": "Wait for Linkedin",
"type": "main",
"index": 0
}
]
]
},
"Create spreadsheet for Linkedin Data": {
"main": [
[
{
"node": "Download the Linkedin Data",
"type": "main",
"index": 0
}
]
]
},
"Download the Linkedin Data": {
"main": [
[
{
"node": "Append row in sheet for Linkedin Data",
"type": "main",
"index": 0
}
]
]
},
"Append row in sheet for Linkedin Data": {
"main": [
[
{
"node": "Aggregate Linkedin Data",
"type": "main",
"index": 0
}
]
]
},
"Aggregate Linkedin Data": {
"main": [
[
{
"node": "Linkedin Data Report Process",
"type": "main",
"index": 0
}
]
]
},
"Linkedin Data Report Process": {
"main": [
[
{
"node": "Linkedin Analyze Report Mail",
"type": "main",
"index": 0
}
]
]
},
"Facebook Analyze Report Mail": {
"main": [
[
{
"node": "Facebook Data URL",
"type": "main",
"index": 0
}
]
]
},
"Facebook Data URL": {
"main": [
[
{
"node": "End Result for Facebook",
"type": "main",
"index": 0
}
]
]
},
"Instagram Analyze Report Mail": {
"main": [
[
{
"node": "Instagram Data URL",
"type": "main",
"index": 0
}
]
]
},
"Instagram Data URL": {
"main": [
[
{
"node": "End Result for Instagram",
"type": "main",
"index": 0
}
]
]
},
"Linkedin Analyze Report Mail": {
"main": [
[
{
"node": "Linkedin Data URL",
"type": "main",
"index": 0
}
]
]
},
"Linkedin Data URL": {
"main": [
[
{
"node": "End Result for Linkedin",
"type": "main",
"index": 0
}
]
]
},
"Initiate batch extraction for X": {
"main": [
[
{
"node": "Wait for X",
"type": "main",
"index": 0
}
]
]
},
"Wait for X": {
"main": [
[
{
"node": "Check the status for X Data",
"type": "main",
"index": 0
}
]
]
},
"Check the status for X Data": {
"main": [
[
{
"node": "X Condition",
"type": "main",
"index": 0
}
]
]
},
"X Condition": {
"main": [
[
{
"node": "Create spreadsheet for X Data",
"type": "main",
"index": 0
}
],
[
{
"node": "Retry for X",
"type": "main",
"index": 0
}
]
]
},
"Retry for X": {
"main": [
[],
[
{
"node": "Wait for X",
"type": "main",
"index": 0
}
]
]
},
"Create spreadsheet for X Data": {
"main": [
[
{
"node": "Download the X Data",
"type": "main",
"index": 0
}
]
]
},
"Download the X Data": {
"main": [
[
{
"node": "Append row in sheet for X Data",
"type": "main",
"index": 0
}
]
]
},
"Append row in sheet for X Data": {
"main": [
[
{
"node": "Aggregate X Data",
"type": "main",
"index": 0
}
]
]
},
"Aggregate X Data": {
"main": [
[
{
"node": "X Data Report Process",
"type": "main",
"index": 0
}
]
]
},
"X Data Report Process": {
"main": [
[
{
"node": "X Analyze Report Mail",
"type": "main",
"index": 0
}
]
]
},
"X Analyze Report Mail": {
"main": [
[
{
"node": "X Data URL",
"type": "main",
"index": 0
}
]
]
},
"X Data URL": {
"main": [
[
{
"node": "End Result for X",
"type": "main",
"index": 0
}
]
]
},
"Initiate batch extraction for YouTube": {
"main": [
[
{
"node": "Wait for YouTube",
"type": "main",
"index": 0
}
]
]
},
"Wait for YouTube": {
"main": [
[
{
"node": "Check the status for YouTube Data",
"type": "main",
"index": 0
}
]
]
},
"Check the status for YouTube Data": {
"main": [
[
{
"node": "YouTube Condition",
"type": "main",
"index": 0
}
]
]
},
"YouTube Condition": {
"main": [
[
{
"node": "Create spreadsheet for YouTube Data",
"type": "main",
"index": 0
}
],
[
{
"node": "Retry for YouTube",
"type": "main",
"index": 0
}
]
]
},
"Create spreadsheet for YouTube Data": {
"main": [
[
{
"node": "Download the YouTube Data",
"type": "main",
"index": 0
}
]
]
},
"Retry for YouTube": {
"main": [
[],
[
{
"node": "Wait for YouTube",
"type": "main",
"index": 0
}
]
]
},
"Download the YouTube Data": {
"main": [
[
{
"node": "Append row in sheet for YouTube Data",
"type": "main",
"index": 0
}
]
]
},
"Append row in sheet for YouTube Data": {
"main": [
[
{
"node": "Aggregate YouTube Data",
"type": "main",
"index": 0
}
]
]
},
"Aggregate YouTube Data": {
"main": [
[
{
"node": "YouTube Data Report Process",
"type": "main",
"index": 0
}
]
]
},
"YouTube Data Report Process": {
"main": [
[
{
"node": "YouTube Analyze Report Mail",
"type": "main",
"index": 0
}
]
]
},
"YouTube Analyze Report Mail": {
"main": [
[
{
"node": "YouTube Data URL",
"type": "main",
"index": 0
}
]
]
},
"YouTube Data URL": {
"main": [
[
{
"node": "End Result for YouTube",
"type": "main",
"index": 0
}
]
]
},
"Initiate batch extraction for Pinterest": {
"main": [
[
{
"node": "Wait for Pinterest",
"type": "main",
"index": 0
}
]
]
},
"Wait for Pinterest": {
"main": [
[
{
"node": "Check the status for Pinterest Data",
"type": "main",
"index": 0
}
]
]
},
"Check the status for Pinterest Data": {
"main": [
[
{
"node": "Pinterest Condition",
"type": "main",
"index": 0
}
]
]
},
"Pinterest Condition": {
"main": [
[
{
"node": "Create spreadsheet for Pinterest Data",
"type": "main",
"index": 0
}
],
[
{
"node": "Retry for Pinterest",
"type": "main",
"index": 0
}
]
]
},
"Create spreadsheet for Pinterest Data": {
"main": [
[
{
"node": "Download the Pinterest Data",
"type": "main",
"index": 0
}
]
]
},
"Retry for Pinterest": {
"main": [
[],
[
{
"node": "Wait for Pinterest",
"type": "main",
"index": 0
}
]
]
},
"Download the Pinterest Data": {
"main": [
[
{
"node": "Append row in sheet for Pinterest Data",
"type": "main",
"index": 0
}
]
]
},
"Append row in sheet for Pinterest Data": {
"main": [
[
{
"node": "Aggregate Pinterest Data",
"type": "main",
"index": 0
}
]
]
},
"Aggregate Pinterest Data": {
"main": [
[
{
"node": "Pinterest Data Report Process",
"type": "main",
"index": 0
}
]
]
},
"Pinterest Data Report Process": {
"main": [
[
{
"node": "Pinterest Analyze Report Mail",
"type": "main",
"index": 0
}
]
]
},
"Pinterest Analyze Report Mail": {
"main": [
[
{
"node": "Pinterest Data URL",
"type": "main",
"index": 0
}
]
]
},
"Pinterest Data URL": {
"main": [
[
{
"node": "End Result for Pinterest",
"type": "main",
"index": 0
}
]
]
},
"Initiate batch extraction for TikTok": {
"main": [
[
{
"node": "Wait for TikTok",
"type": "main",
"index": 0
}
]
]
},
"Wait for TikTok": {
"main": [
[
{
"node": "Check the status for TikTok Data",
"type": "main",
"index": 0
}
]
]
},
"Check the status for TikTok Data": {
"main": [
[
{
"node": "TikTok Condition",
"type": "main",
"index": 0
}
]
]
},
"TikTok Condition": {
"main": [
[
{
"node": "Create spreadsheet for TikTok Data",
"type": "main",
"index": 0
}
],
[
{
"node": "Retry for TikTok",
"type": "main",
"index": 0
}
]
]
},
"Create spreadsheet for TikTok Data": {
"main": [
[
{
"node": "Download the TikTok Data",
"type": "main",
"index": 0
}
]
]
},
"Retry for TikTok": {
"main": [
[],
[
{
"node": "Wait for TikTok",
"type": "main",
"index": 0
}
]
]
},
"Download the TikTok Data": {
"main": [
[
{
"node": "Append row in sheet for TikTok Data",
"type": "main",
"index": 0
}
]
]
},
"Append row in sheet for TikTok Data": {
"main": [
[
{
"node": "Aggregate TikTok Data",
"type": "main",
"index": 0
}
]
]
},
"Aggregate TikTok Data": {
"main": [
[
{
"node": "TikTok Data Report Process",
"type": "main",
"index": 0
}
]
]
},
"TikTok Data Report Process": {
"main": [
[
{
"node": "TikTok Analyze Report Mail",
"type": "main",
"index": 0
}
]
]
},
"TikTok Analyze Report Mail": {
"main": [
[
{
"node": "TikTok Data URL",
"type": "main",
"index": 0
}
]
]
},
"TikTok Data URL": {
"main": [
[
{
"node": "End Result for TikTok",
"type": "main",
"index": 0
}
]
]
},
"Gemini 2.5 Flash": {
"ai_languageModel": [
[
{
"node": "Facebook Data Report Process",
"type": "ai_languageModel",
"index": 0
},
{
"node": "Instagram Data Report Process",
"type": "ai_languageModel",
"index": 0
},
{
"node": "Linkedin Data Report Process",
"type": "ai_languageModel",
"index": 0
},
{
"node": "X Data Report Process",
"type": "ai_languageModel",
"index": 0
},
{
"node": "YouTube Data Report Process",
"type": "ai_languageModel",
"index": 0
},
{
"node": "Pinterest Data Report Process",
"type": "ai_languageModel",
"index": 0
},
{
"node": "TikTok Data Report Process",
"type": "ai_languageModel",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "ef2b8f37-8b99-4279-b679-bf7b7116baf2",
"meta": {
"templateCredsSetupCompleted": true,
"instanceId": "125e3b631be5af75b5d8304f7125cd5c84e5ea96c148171cca4bfb3fcc88fe9b"
},
"id": "BwqNDhZChmroTKae",
"tags": []
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment