Ce système scrape les annonces, analyse les données (prix, surface, emplacement), attribue un score de qualité aux leads puis envoie les meilleurs à votre CRM ou par email. L’automatisation permet de réagir plus vite que vos concurrents et d’optimiser la performance commerciale sans effort manuel.
{
"id": "8Sbrzc7Au3ZGf62p",
"meta": {
"instanceId": "bcc0fe85b176c2837affb21bb7d7397fad2549880e73dc1f7a42e76ae94fd996",
"templateCredsSetupCompleted": true
},
"name": "Publish Videos & Images - Blotato",
"tags": [
{
"id": "3ys8SQgNTiRr899i",
"name": "social media",
"createdAt": "2025-03-17T08:37:35.227Z",
"updatedAt": "2025-04-07T06:13:46.923Z"
},
{
"id": "zyM31CVcOgUrUm2P",
"name": "blotato",
"createdAt": "2025-04-25T13:38:49.620Z",
"updatedAt": "2025-04-25T13:38:49.620Z"
},
{
"id": "2wv2YbZIQoYNx98Y",
"name": "schedule",
"createdAt": "2025-04-25T13:38:53.789Z",
"updatedAt": "2025-04-25T13:38:53.789Z"
},
{
"id": "PqlvV87F8bOW0yAK",
"name": "publish",
"createdAt": "2025-04-25T13:38:58.944Z",
"updatedAt": "2025-04-25T13:38:58.944Z"
}
],
"nodes": [
{
"id": "53b36edb-e273-4e68-8ae9-7d3de3f7533f",
"name": "[Instagram] Publish via Blotato",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
80
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={n "post": {n "target": {n "targetType": "instagram"n },n "content": {n "text": {{ $('Prepare for Publish').item.json.final_text_short.toJsonString() }},n "platform": "instagram",n "mediaUrls": ["{{ $json.url }}"]n },n "accountId": "{{ $('Prepare for Publish').item.json.instagram_id }}"n }n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "6fef0d35-9679-40f6-9224-cfb7c442056b",
"name": "[Facebook] Publish via Blotato",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
480
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={n "post": {n "target": {n "targetType": "facebook",n "pageId": "{{ $('Prepare for Publish').item.json.facebook_page_id }}"n },n "content": {n "text": {{ $('Prepare for Publish').item.json.final_text_long.toJsonString() }},n "platform": "facebook",n "mediaUrls": ["{{ $json.url }}"]n },n "accountId": "{{ $('Prepare for Publish').item.json.facebook_id }}"n }n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "3f744ee2-988b-45a6-9d88-a718780421cf",
"name": "[Linkedin] Publish via Blotato",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
880
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={n "post": {n "target": {n "targetType": "linkedin"n },n "content": {n "text": {{ $('Prepare for Publish').item.json.final_text_long.toJsonString() }},n "platform": "linkedin",n "mediaUrls": ["{{ $json.url }}"]n },n "accountId": "{{ $('Prepare for Publish').item.json.linkedin_id }}"n }n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "7f0ae540-090a-4b13-a094-2ac74e1a14b3",
"name": "[Tiktok] Publish via Blotato",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
1280
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={n "post": {n "target": {n "targetType": "tiktok",n "isYourBrand": false,n "disabledDuet": false,n "privacyLevel": "PUBLIC_TO_EVERYONE",n "isAiGenerated": true,n "disabledStitch": false,n "disabledComments": false,n "isBrandedContent": falsen },n "content": {n "text": "{{ $('Prepare for Publish').item.json.final_text_short }}",n "platform": "tiktok",n "mediaUrls": ["{{ $json.url }}"]n },n "accountId": "{{ $('Prepare for Publish').item.json.tiktok_id }}"n }n}n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "2593a621-0d0b-42b3-97ab-bf85785fb33c",
"name": "[Pinterest] Publish via Blotato",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
1680
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={n "post": {n "target": {n "targetType": "pinterest",n "boardId": "{{ $('Prepare for Publish').item.json.pinterested_board_id }}",n "link": "https://www.AIwithApex.com/"n },n "content": {n "text": {{ $('Prepare for Publish').item.json.final_text_short.toJsonString() }},n "platform": "pinterest",n "mediaUrls": ["{{ $('Upload Image to Blotato').item.json.url }}"]n },n "accountId": "{{ $('Prepare for Publish').item.json.pinterest_id }}"n }n}n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "b47da27b-b81f-4736-9c34-cd224d78f29d",
"name": "[Youtube] Publish via Blotato",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
280
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={n "post": {n "target": {n "targetType": "youtube",n "title": "{{ $('Ensure Valid YouTube Title').item.json.message.content.youtube_title }}",n "privacyStatus": "public",n "shouldNotifySubscribers": truen },n "content": {n "text": {{ $('Prepare for Publish').item.json.final_text_long.toJsonString() }},n "platform": "youtube",n "mediaUrls": ["{{ $json.url }}"]n },n "accountId": "{{ $('Prepare for Publish').item.json.youtube_id }}"n }n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "19f17323-45f5-4865-b754-e2d5f8fc6073",
"name": "[Threads] Publish via Blotato",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
680
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={n "post": {n "target": {n "targetType": "threads"n },n "content": {n "text": {{ $('Prepare for Publish').item.json.final_text_short.toJsonString() }},n "platform": "threads",n "mediaUrls": ["{{ $json.url }}"]n },n "accountId": "{{ $('Prepare for Publish').item.json.threads_id }}"n }n}n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "adaa3ac1-fa2a-422e-8b70-8c4cc74782ed",
"name": "[Twitter] Publish via Blotato",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
1080
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={n "post": {n "target": {n "targetType": "twitter"n },n "content": {n "text": {{ $('Prepare for Publish').item.json.final_text_short.toJsonString() }},n "platform": "twitter",n "mediaUrls": ["{{ $json.url }}"]n },n "accountId": "{{ $('Prepare for Publish').item.json.twitter_id }}"n }n}n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "af2d0a29-73d1-4ee0-84c9-f337a628b3ea",
"name": "[Bluesky] Publish via Blotato",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueErrorOutput",
"position": [
96,
1480
],
"parameters": {
"url": "https://backend.blotato.com/v2/posts",
"method": "POST",
"options": {},
"jsonBody": "={n "post": {n "target": {n "targetType": "bluesky"n },n "content": {n "text": {{ $('Prepare for Publish').item.json.final_text_short.toJsonString() }},n "platform": "bluesky",n "mediaUrls": ["{{ $('Upload Image to Blotato').item.json.url }}"]n },n "accountId": "{{ $('Prepare for Publish').item.json.bluesky_id }}"n }n}n",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "OEAfX6pMtcbyFBAp",
"name": "Blotato"
}
},
"typeVersion": 4.2
},
{
"id": "08253c79-44f6-471a-b7c9-b84046f16888",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
16,
-40
],
"parameters": {
"color": 2,
"width": 260,
"height": 1880,
"content": "# Publish to Social Media"
},
"typeVersion": 1
},
{
"id": "dae9e738-c391-47f6-bdf7-87055a5a77f0",
"name": "Prepare for Publish",
"type": "n8n-nodes-base.set",
"position": [
-564,
880
],
"parameters": {
"mode": "raw",
"options": {},
"jsonOutput": "={n "instagram_id": "2244",n "youtube_id": "1300",n "tiktok_id": "2761",n "facebook_id": "2152",n "facebook_page_id": "127923797405586",n "threads_id": "670",n "twitter_id": "1576",n "linkedin_id": "1730",n "pinterest_id": "447",n "pinterested_board_id": "1097611809123639891",n "bluesky_id": "1311",n "final_text_long": {{ $('Airtable').item.json.Script.toJsonString() }},n "final_text_short": {{ $('Airtable').item.json['Text for X'].toJsonString() }}n}"
},
"typeVersion": 3.4
},
{
"id": "aaa21d7f-e175-4516-8bde-e0b87e6e183d",
"name": "Airtable",
"type": "n8n-nodes-base.airtable",
"position": [
-1160,
880
],
"parameters": {
"id": "={{ $json.airtableID }}",
"base": {
"__rl": true,
"mode": "list",
"value": "appt2yDl6xXXyqboD",
"cachedResultUrl": "https://airtable.com/appt2yDl6xXXyqboD",
"cachedResultName": "Social Media System"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblM3kDu1qB2FdTOF",
"cachedResultUrl": "https://airtable.com/appt2yDl6xXXyqboD/tblM3kDu1qB2FdTOF",
"cachedResultName": "Media Creation"
},
"options": {}
},
"credentials": {
"airtableTokenApi": {
"id": "YzrajURFsZkojT3x",
"name": "Delete Me Later Please!"
}
},
"typeVersion": 2.1
},
{
"id": "e05d1ede-7d43-4c55-a353-6bc2bd0216d4",
"name": "Upload Video to Blotato",
"type": "n8n-nodes-base.httpRequest",
"position": [
-124,
880
],
"parameters": {
"url": "https://backend.blotato.com/v2/media",
"method": "POST",
"options": {},
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "url",
"value": "={{ $('Airtable').item.json['Video URL'] }}"
}
]
},
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "gNaQW1qT8liDV4ls",
"name": "Delete me toooooo!"
}
},
"typeVersion": 4.2
},
{
"id": "92fd39a9-74c1-4cbb-abb3-511f8230cee7",
"name": "Upload Image to Blotato",
"type": "n8n-nodes-base.httpRequest",
"position": [
-344,
880
],
"parameters": {
"url": "https://backend.blotato.com/v2/media",
"method": "POST",
"options": {},
"sendBody": true,
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "url",
"value": "={{ $('Airtable').item.json['Image URL'] }}"
}
]
},
"genericAuthType": "httpHeaderAuth"
},
"credentials": {
"httpHeaderAuth": {
"id": "gNaQW1qT8liDV4ls",
"name": "Delete me toooooo!"
}
},
"typeVersion": 4.2
},
{
"id": "12b8ecfe-f83b-4e32-a8d7-a71b7f5c9fd1",
"name": "Ensure Valid YouTube Title",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-940,
880
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "GPT-4.1-MINI"
},
"options": {},
"messages": {
"values": [
{
"content": "=CURRENT_TITLE:n{{ $json['Media Title'] }}"
},
{
"role": "assistant",
"content": "# TASKnYou specialize in creating Viral YouTube Short Video Titles. You are to take User's CURRENT_TITLE and re-write it to go viral.n## Rulesn - Maximum 100 Charactersn - Goal is Virality!n - Must be valid title for a YouTube Short Videon# OUTPUTnOutput must be in JSON format, example:n{ "youtube_title": "" }"
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "KzjXYSuzUOCnnvzB",
"name": "OpenAi account"
}
},
"typeVersion": 1.8
},
{
"id": "d83577ae-5aa7-4d47-a67b-30e30fcd2fa4",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1660,
1060
],
"parameters": {
"width": 880,
"height": 360,
"content": "## Quick Debug Checkingn### I set up quick links to social media to check whether the posting system succeeded or not. I tried video if possible, if not I used image. You can also find Blotato failed posts here: https://my.blotato.com/failednn[replace these with your own links if you like]nInstagram: https://www.instagram.com/moshehbenavraham/reels/nYoutube: https://www.youtube.com/@AIwithApex/shortsnFacebook: https://www.facebook.com/MoshehApexWebServices/gridnThreads: https://www.threads.com/@moshehbenavrahamnLinkedIn: https://www.linkedin.com/in/moshehbenavraham/recent-activity/all/nX / Twitter: https://x.com/MoshehAvrahamnTikTok: https://www.tiktok.com/@moshehavrahamnBluesky: https://bsky.app/profile/aiwithapex.bsky.socialnPinterest: https://www.pinterest.com/aiwithapex/artificial-intelligence-ai-ai-automation/n"
},
"typeVersion": 1
},
{
"id": "356518e3-1eb6-4cfe-bf77-a5f095553b74",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-880,
1440
],
"parameters": {
"width": 880,
"height": 300,
"content": "## Current Issues (last updated April 29, 2025)nn- Haven't confirmed, but you -have- to post to a FB Page?n- I believe you can only post to a particular Board in Pinterestn- Some Endpoints can handle longer text, some notn- Some Endpoints can handle videos, some notn- With Facebook, apparently only plain text is acceptedn- With LinkedIn, apparently only plain text is acceptedn- Haven't found info about ways to access what you have uploaded to Blotato, nor capacity limit, nor how long the assets are stored for -- did find a concurrency limit of using it 10 requests/minuten- Encountered this error with YouTube POST despite not posting that much: "Error: The request cannot be completed because you have exceeded your <a href="/youtube/v3/getting-started#quota">quota</a>.""
},
"typeVersion": 1
},
{
"id": "503a04c9-a740-4c5d-9f67-143a8dd1422f",
"name": "Airtable: Posted Instagram",
"type": "n8n-nodes-base.airtable",
"position": [
316,
-20
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appt2yDl6xXXyqboD",
"cachedResultUrl": "https://airtable.com/appt2yDl6xXXyqboD",
"cachedResultName": "Social Media System"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblM3kDu1qB2FdTOF",
"cachedResultUrl": "https://airtable.com/appt2yDl6xXXyqboD/tblM3kDu1qB2FdTOF",
"cachedResultName": "Media Creation"
},
"columns": {
"value": {
"id": "={{ $('Airtable').item.json.id",
"Production": "Completed"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Media Title",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Media Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Script",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Script",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Script Len",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Script Len",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Production",
"type": "options",
"display": true,
"options": [
{
"name": "Not Started",
"value": "Not Started"
},
{
"name": "In progress",
"value": "In progress"
},
{
"name": "Ready",
"value": "Ready"
},
{
"name": "Review",
"value": "Review"
},
{
"name": "Completed",
"value": "Completed"
},
{
"name": "Scheduled",
"value": "Scheduled"
},
{
"name": "Published",
"value": "Published"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Production",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Video URL",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Video URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Video",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Video",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Publish Date (from Content Creation)",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Publish Date (from Content Creation)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Publish Time (from Content Creation)",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Publish Time (from Content Creation)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Test",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Test",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Content Creation",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Content Creation",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Scenes",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Scenes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image URL",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Image URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Image",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image Caption",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Image Caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Text for X",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Text for X",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Text for LinkedIn",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Text for LinkedIn",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Social Channels",
"type": "array",
"display": true,
"options": [
{
"name": "Blog",
"value": "Blog"
},
{
"name": "Facebook",
"value": "Facebook"
},
{
"name": "Instagram",
"value": "Instagram"
},
{
"name": "LinkedIn",
"value": "LinkedIn"
},
{
"name": "TikTok",
"value": "TikTok"
},
{
"name": "X",
"value": "X"
},
{
"name": "YouTube",
"value": "YouTube"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Social Channels",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "n8n Publishing Date",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "n8n Publishing Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "n8n Publishing Time",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "n8n Publishing Time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Publishing Log",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Publishing Log",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "House Keeping",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "House Keeping",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "workflowId (from House Keeping)",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "workflowId (from House Keeping)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "recordID (from House Keeping)",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "recordID (from House Keeping)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created Time",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Created Time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Modified Time",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Modified Time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Record ID",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Record ID",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update"
},
"credentials": {
"airtableTokenApi": {
"id": "YzrajURFsZkojT3x",
"name": "Delete Me Later Please!"
}
},
"typeVersion": 2.1
},
{
"id": "f42a3763-8906-4278-b8d0-73611a1fae31",
"name": "Airtable: Posted Instagram1",
"type": "n8n-nodes-base.airtable",
"position": [
316,
180
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appt2yDl6xXXyqboD",
"cachedResultUrl": "https://airtable.com/appt2yDl6xXXyqboD",
"cachedResultName": "Social Media System"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblM3kDu1qB2FdTOF",
"cachedResultUrl": "https://airtable.com/appt2yDl6xXXyqboD/tblM3kDu1qB2FdTOF",
"cachedResultName": "Media Creation"
},
"columns": {
"value": {
"id": "={{ $('Airtable').item.json.id",
"Production": "In progress"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "Media Title",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Media Title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Script",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Script",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Script Len",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Script Len",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Production",
"type": "options",
"display": true,
"options": [
{
"name": "Not Started",
"value": "Not Started"
},
{
"name": "In progress",
"value": "In progress"
},
{
"name": "Ready",
"value": "Ready"
},
{
"name": "Review",
"value": "Review"
},
{
"name": "Completed",
"value": "Completed"
},
{
"name": "Scheduled",
"value": "Scheduled"
},
{
"name": "Published",
"value": "Published"
}
],
"removed": false,
"readOnly": false,
"required": false,
"displayName": "Production",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Video URL",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Video URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Video",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Video",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Publish Date (from Content Creation)",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Publish Date (from Content Creation)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Publish Time (from Content Creation)",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Publish Time (from Content Creation)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Test",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Test",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Content Creation",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Content Creation",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Scenes",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Scenes",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image URL",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Image URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image",
"type": "array",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Image",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image Caption",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Image Caption",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Text for X",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Text for X",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Text for LinkedIn",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Text for LinkedIn",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Social Channels",
"type": "array",
"display": true,
"options": [
{
"name": "Blog",
"value": "Blog"
},
{
"name": "Facebook",
"value": "Facebook"
},
{
"name": "Instagram",
"value": "Instagram"
},
{
"name": "LinkedIn",
"value": "LinkedIn"
},
{
"name": "TikTok",
"value": "TikTok"
},
{
"name": "X",
"value": "X"
},
{
"name": "YouTube",
"value": "YouTube"
}
],
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Social Channels",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "n8n Publishing Date",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "n8n Publishing Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "n8n Publishing Time",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "n8n Publishing Time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Publishing Log",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Publishing Log",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "House Keeping",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "House Keeping",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "workflowId (from House Keeping)",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "workflowId (from House Keeping)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "recordID (from House Keeping)",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "recordID (from House Keeping)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created Time",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Created Time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Modified Time",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Modified Time",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Record ID",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "Record ID",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update"
},
"credentials": {
"airtableTokenApi": {
"id": "YzrajURFsZkojT3x",
"name": "Delete Me Later Please!"
}
},
"typeVersion": 2.1
},
{
"id": "e6d9834b-a03e-4e98-9e38-a774eec2bc93",
"name": "Sticky Note3",
"type": "n8n-nodes-base.stickyNote",
"position": [
291,
-300
],
"parameters": {
"color": 2,
"width": 150,
"height": 640,
"content": "# Update Post Statusnn*note I didn't finish attaching all the platforms, left the labor to y'all :)"
},
"typeVersion": 1
},
{
"id": "fed0373f-7fa5-469c-9972-47d0a9a447a7",
"name": "When clicking u2018Test workflowu2019",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1600,
880
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c68f2436-f471-45a6-9292-2410937bd444",
"name": "Airtable Record ID",
"type": "n8n-nodes-base.set",
"position": [
-1380,
880
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "ca998655-fcdd-4169-b470-492cf5113b6a",
"name": "=airtableID",
"type": "string",
"value": "=recJBpGmgd7nuLpfe"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "7617f48c-f498-4458-a64c-3fb60938546e",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-972,
780
],
"parameters": {
"color": 5,
"width": 320,
"height": 260,
"content": "### May Not Be NecessarynnI added this because my incoming Titles were over the 100 character limit"
},
"typeVersion": 1
},
{
"id": "054bc64d-3a3c-4ba4-9bcc-e30729bb9c87",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2260,
300
],
"parameters": {
"width": 580,
"height": 1880,
"content": "# How to Add Example Table and Connect n8n to Airtablenn---nn## Part 1: Add the Example Table to Airtablenn1. **Create and Log into Your Airtable Account** n - If you don't have an Airtable account: [Sign up here (Affiliate link)](https://airtable.com/invite/r/6UyZyAAd)nn2. **Open the Example Base** n - Link: [Social Media System Base](https://airtable.com/appbOSIspSmMfeJeg/shr7htmWB9GNRrpw3)nn3. **Copy the Base** n - To the right of the title *"Social Media System"*, click **"Copy base"**.nn4. **Choose Your Workspace** n - Pick the workspace to copy the base into, then click **"Add base"**.nn**u2705 Congrats! You now have the example Base added.**nn---nn## Part 2: Connect n8n to Airtablenn### Step A: Create a Personal Access Token in Airtablenn1. **Create and Log into Your Airtable Account** n - [Sign up here (Affiliate link)](https://airtable.com/invite/r/6UyZyAAd)nn2. **Access Personal Tokens**n - Top right: click your **Account Icon** u2192 select **"Builder hub"**.n - Left navigation: go to **"Developers"** u2192 click **"Personal access tokens"**.nn3. **Create a New Token**n - Click **"Create token"**.n - Name your token (example: *"Airtable personal access token for n8n"*). n **(Don't create yet!)**nn4. **Set Scopes**n - Click **"+ Add a scope"** and enable these scopes:n - `data.records:read`n - `data.records:write`n - `schema.bases:read`nn5. **Optional: Restrict Access**n - If you want the credential limited to certain bases:n - Under **Access**, click **"+ Add a base"** and select the Base(s).nn6. **Finalize and Save the Token**n - After creation, a pop-up will show your token **only once**.n - **Copy and store it safely!**nn---nn### Step B: Add Airtable Credentials in n8nnn1. **Create and Log into Your n8n Account** n - [Sign up here (Affiliate link)](https://n8n.partnerlinks.io/aiwithapex)nn2. **Create a New Credential**n - Top right: next to the red-orange **"Create Workflow"** button, open the dropdown u2192 select **"Create Credential"**.n - (Alternatively, you can create it from inside any Airtable node.)nn3. **Input Token Details**n - In the popup, type **"Airtable personal access token api"**, click **"Continue"**.n - Paste your **saved Airtable token**.nn4. **Name the Credential Properly**n - Top left of the dialogue box: rename the token to something clearly recognizable.nn5. **Save and Test Connection**n - Click the top right **"Save"** button.n - You should see **"Connection tested successfully"**.n - You may now **close** the dialogue box.nn**u2705 Done! n8n is now connected to your Airtable base.**n"
},
"typeVersion": 1
},
{
"id": "f10bfe19-511e-4211-9d53-b72130bcf0ec",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1660,
300
],
"parameters": {
"width": 1300,
"height": 100,
"content": "# Blotato Affiliate Link, Please Support My Work: https://blotato.com/?ref=maxnYou will need the API key for blotato-api-key"
},
"typeVersion": 1
},
{
"id": "825d529c-813c-42d3-b100-0dba4a84d7fe",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-644,
420
],
"parameters": {
"color": 5,
"width": 260,
"height": 620,
"content": "## FILL ME IN!nn### Use Link Above to Log into Blotatonn- Bottom Left Gear for Settingsn- **IMPORTANT** Log into each social media platform you want to connect before using the connection buttons and do NOT use the "connect all pages" option.n- Log into each account and copy each "Account ID" into a safe placen- If using FaceBook, copy also the 'Page ID'n- If using Pinterest, use my PINTEREST BOARD ID SYSTEM (tm) to get your Board ID"
},
"typeVersion": 1
},
{
"id": "b27f7a30-aa19-4d0f-a7a0-7e5d5c0a1a2d",
"name": "Pinterest System (tm)",
"type": "n8n-nodes-base.formTrigger",
"position": [
-1600,
1940
],
"webhookId": "0724d1b9-05f6-46c2-9b74-e89fd44cbef3",
"parameters": {
"options": {},
"formTitle": "Pinterest System (tm)",
"formFields": {
"values": [
{
"fieldLabel": "Pinterest Board URL",
"placeholder": "https://www.pinterest.com/USERNAME/BOARD_NAME/",
"requiredField": true
}
]
},
"formDescription": "Put in your Pinterest Board Link here, it should look like this:nnhttps://www.pinterest.com/USERNAME/BOARD_NAME/nnExample:nhttps://www.pinterest.com/aiwithapex/artificial-intelligence-ai-ai-automation/"
},
"typeVersion": 2.2
},
{
"id": "3a5976ba-fb7d-4e33-a0bd-efbbf212031b",
"name": "Grab Pinterest Board Page",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1380,
1940
],
"parameters": {
"url": "={{ $json['Pinterest Board URL'] }}",
"options": {},
"jsonHeaders": "{n "User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/115.0.0.0 Safari/537.36",n "Accept": "text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8",n "Accept-Language": "en-US,en;q=0.9",n "Accept-Encoding": "gzip, deflate, br",n "Connection": "keep-alive",n "Referer": "https://www.pinterest.com/"n}",
"sendHeaders": true,
"specifyHeaders": "json"
},
"typeVersion": 4.2
},
{
"id": "659bb65c-7aaf-4aa4-958b-0f8e5bafaf7e",
"name": "Pinterest Page Sleuth",
"type": "n8n-nodes-base.code",
"position": [
-1160,
1940
],
"parameters": {
"jsCode": "// n8n Code Node JavaScriptnn// Get the first item OBJECT using $input.first() or $items[0]n// Let's use $input.first() as it's slightly more modern n8n syntaxnconst item = $input.first();nn// Check if an item was actually receivednif (!item) {n console.error("No input item received.");n // Return an empty array as expected by n8n if no inputn return [];n}nn// Check if the 'json' property exists on the item objectn// (This check might be redundant if the previous node always outputs JSON, but good practice)nif (!item.json || typeof item.json !== 'object') {n console.error("Input item does not have a 'json' object property.");n // Ensure item.json exists before adding error to itn item.json = item.json || {};n item.json.error = "Input item does not have a 'json' object property.";n // Return the item INSIDE an arrayn return [item];n}nn// Check if 'data' exists within 'json'n// <<>>nif (!item.json.hasOwnProperty('data')) {n console.error("Input item's 'json' property does not have a 'data' key.");n item.json.error = "Input item's 'json' property does not have a 'data' key.";n // Return the item INSIDE an arrayn return [item];n}nn// Assign the HTML string (adjust path if needed based on INPUT panel)nconst htmlString = item.json.data;nn// Check if HTML string exists and is a string typenif (typeof htmlString !== 'string') {n console.error("item.json.data is not a string.");n item.json.error = "item.json.data exists but is not a string.";n // Return the item INSIDE an arrayn return [item];n}nn// Check if HTML string is emptynif (!htmlString) {n console.error("item.json.data is an empty string or null/undefined.");n item.json.error = "item.json.data is empty or null.";n // Return the item INSIDE an arrayn return [item];n}n// </ END OF INPUT CHECKING >nnlet extractedBoardInfo = {};nlet processingError = null; // Renamed to avoid conflict with built-in 'error'nntry {n // 1. Find the JSON within the specific script tag using regexn const regex = /(.*?)/s;n const match = htmlString.match(regex);nn if (match && match[1]) {n const jsonString = match[1];n // 2. Parse the extracted JSON stringn const parsedData = JSON.parse(jsonString);nn // 3. Navigate through the nested structuren const boardsData = parsedData?.initialReduxState?.boards;nn if (boardsData && typeof boardsData === 'object' && Object.keys(boardsData).length > 0) {n const boardId = Object.keys(boardsData)[0];n const boardDetails = boardsData[boardId];nn if (boardDetails && boardDetails.id) {n // 4. Extract the desired informationn extractedBoardInfo = {n boardId: boardDetails.id,n name: boardDetails.name || null,n description: boardDetails.description || null,n url: boardDetails.url || null,n privacy: boardDetails.privacy || null,n pinCount: boardDetails.pin_count !== undefined ? boardDetails.pin_count : null,n followerCount: boardDetails.follower_count !== undefined ? boardDetails.follower_count : null,n createdAt: boardDetails.created_at || null,n ownerUsername: boardDetails.owner?.username || null,n ownerId: boardDetails.owner?.id || null,n ownerFullName: boardDetails.owner?.full_name || null,n };n } else {n processingError = "Board data structure invalid within __PWS_INITIAL_PROPS__ JSON.";n console.error(processingError);n }n } else {n processingError = "Boards data not found or empty in __PWS_INITIAL_PROPS__ JSON.";n console.error(processingError);n }n } else {n processingError = "Script tag with id='__PWS_INITIAL_PROPS__' not found or empty in HTML.";n console.error(processingError);n }n} catch (e) {n processingError = `Error processing HTML/JSON: ${e.message}`;n console.error(processingError, e);n}nn// 5. Prepare the final itemnif (Object.keys(extractedBoardInfo).length > 0) {n item.json.extractedBoardInfo = extractedBoardInfo;n // Optionally delete the large HTML string if no longer neededn // delete item.json.data;n} else {n // Add error information if extraction failedn item.json.error = processingError || "Failed to extract board information for unknown reasons.";n item.json.extractedBoardInfo = null;n}nn// Return the modified item INSIDE an array as required by n8nnreturn [item];"
},
"typeVersion": 2
},
{
"id": "09f00540-3fde-45a8-a20b-7415e81aa777",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1660,
1800
],
"parameters": {
"color": 4,
"width": 660,
"height": 300,
"content": "# Pinterest Page Sleuthn - Use either testing or active URL respectively depending if your workflow is active or notn - Simply paste your board's link and fetch ID!"
},
"typeVersion": 1
}
],
"active": true,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "4b3ebaa1-ec81-4de8-9366-633594a1b0ca",
"connections": {
"Airtable": {
"main": [
[
{
"node": "Ensure Valid YouTube Title",
"type": "main",
"index": 0
}
]
]
},
"Airtable Record ID": {
"main": [
[
{
"node": "Airtable",
"type": "main",
"index": 0
}
]
]
},
"Prepare for Publish": {
"main": [
[
{
"node": "Upload Image to Blotato",
"type": "main",
"index": 0
}
]
]
},
"Pinterest System (tm)": {
"main": [
[
{
"node": "Grab Pinterest Board Page",
"type": "main",
"index": 0
}
]
]
},
"Upload Image to Blotato": {
"main": [
[
{
"node": "Upload Video to Blotato",
"type": "main",
"index": 0
}
]
]
},
"Upload Video to Blotato": {
"main": [
[
{
"node": "[Instagram] Publish via Blotato",
"type": "main",
"index": 0
},
{
"node": "[Facebook] Publish via Blotato",
"type": "main",
"index": 0
},
{
"node": "[Linkedin] Publish via Blotato",
"type": "main",
"index": 0
},
{
"node": "[Tiktok] Publish via Blotato",
"type": "main",
"index": 0
},
{
"node": "[Youtube] Publish via Blotato",
"type": "main",
"index": 0
},
{
"node": "[Threads] Publish via Blotato",
"type": "main",
"index": 0
},
{
"node": "[Twitter] Publish via Blotato",
"type": "main",
"index": 0
},
{
"node": "[Bluesky] Publish via Blotato",
"type": "main",
"index": 0
},
{
"node": "[Pinterest] Publish via Blotato",
"type": "main",
"index": 0
}
]
]
},
"Grab Pinterest Board Page": {
"main": [
[
{
"node": "Pinterest Page Sleuth",
"type": "main",
"index": 0
}
]
]
},
"Ensure Valid YouTube Title": {
"main": [
[
{
"node": "Prepare for Publish",
"type": "main",
"index": 0
}
]
]
},
"[Instagram] Publish via Blotato": {
"main": [
[
{
"node": "Airtable: Posted Instagram",
"type": "main",
"index": 0
}
],
[
{
"node": "Airtable: Posted Instagram1",
"type": "main",
"index": 0
}
]
]
},
"When clicking u2018Test workflowu2019": {
"main": [
[
{
"node": "Airtable Record ID",
"type": "main",
"index": 0
}
]
]
}
}
}