Max aka Mosheh This workflow corresponds to n8n.io template #7223 — we link there as the canonical source.
This workflow follows the Airtable → Form Trigger recipe pattern — see all workflows that pair these two integrations.
The workflow JSON
Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →
{
"id": "aEUq6iIbhrcNa14Q",
"meta": {
"templateCredsSetupCompleted": true
},
"name": "Publish Videos & Images - New Blotato Node",
"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": "0d6f2a2e-8831-4dfd-b8b0-d915190c36bc",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
16,
-80
],
"parameters": {
"color": 2,
"width": 660,
"height": 3136,
"content": "# Publish to Social Media"
},
"typeVersion": 1
},
{
"id": "58ca96e2-0ef8-4ab9-b181-8d169dca70d5",
"name": "Prepare for Publish",
"type": "n8n-nodes-base.set",
"position": [
-576,
1520
],
"parameters": {
"mode": "raw",
"options": {},
"jsonOutput": "={\n \"instagram_id\": \"<instagram ID from connecting in Blotato Dashboard>\",\n \"youtube_id\": \"<youtube ID from connecting in Blotato Dashboard>\",\n \"tiktok_id\": \"<tiktok ID from connecting in Blotato Dashboard>\",\n \"facebook_id\": \"<facebook ID from connecting in Blotato Dashboard>\",\n \"facebook_page_id\": \"<facebook-page ID from connecting in Blotato Dashboard>\",\n \"threads_id\": \"<threads ID from connecting in Blotato Dashboard>\",\n \"twitter_id\": \"<twitter ID from connecting in Blotato Dashboard>\",\n \"linkedin_id\": \"<linked-in ID from connecting in Blotato Dashboard>\",\n \"pinterest_id\": \"<pinterest ID from connecting in Blotato Dashboard>\",\n \"pinterested_board_id\": \"<pinterest-board ID from connecting in Blotato Dashboard>\",\n \"bluesky_id\": \"<bluesky ID from connecting in Blotato Dashboard>\",\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": "2a3db81f-a8a5-4922-b89a-0cefdc205c5c",
"name": "Airtable",
"type": "n8n-nodes-base.airtable",
"position": [
-1152,
1520
],
"parameters": {
"id": "={{ $json.airtableID }}",
"base": {
"__rl": true,
"mode": "list",
"value": "appG0wM9Oe2bp1qhh",
"cachedResultUrl": "https://airtable.com/appG0wM9Oe2bp1qhh",
"cachedResultName": "Social Media System"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblM3kDu1qB2FdTOF",
"cachedResultUrl": "https://airtable.com/appG0wM9Oe2bp1qhh/tblM3kDu1qB2FdTOF",
"cachedResultName": "Media Creation"
},
"options": {}
},
"credentials": {
"airtableTokenApi": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "97dab6dc-b97c-449f-a318-91c59c57fcb4",
"name": "Ensure Valid YouTube Title",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-928,
1520
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-5-mini",
"cachedResultName": "GPT-5-MINI"
},
"options": {},
"messages": {
"values": [
{
"content": "=CURRENT_TITLE:\n{{ $json['Media Title'] }}"
},
{
"role": "assistant",
"content": "# TASK\nYou specialize in creating Viral YouTube Short Video Titles. You are to take User's CURRENT_TITLE and re-write it to go viral.\n## Rules\n - Maximum 100 Characters\n - Goal is Virality!\n - Must be valid title for a YouTube Short Video\n# OUTPUT\nOutput must be in JSON format, example:\n{ \"youtube_title\": \"<generated title per instructions>\" }"
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
},
"typeVersion": 1.8
},
{
"id": "5bb735a9-b55b-427f-b20b-a81764b9542c",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1632,
1728
],
"parameters": {
"width": 880,
"height": 360,
"content": "## Quick Debug Checking\n### 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/failed\n\n[replace these with your own links if you like]\nInstagram: https://www.instagram.com/moshehbenavraham/reels/\nYoutube: https://www.youtube.com/@AIwithApex/shorts\nFacebook: https://www.facebook.com/MoshehApexWebServices/grid\nThreads: https://www.threads.com/@moshehbenavraham\nLinkedIn: https://www.linkedin.com/in/moshehbenavraham/recent-activity/all/\nX / Twitter: https://x.com/MoshehAvraham\nTikTok: https://www.tiktok.com/@moshehavraham\nBluesky: https://bsky.app/profile/aiwithapex.bsky.social\nPinterest: https://www.pinterest.com/aiwithapex/artificial-intelligence-ai-ai-automation/\n"
},
"typeVersion": 1
},
{
"id": "5fad349c-b376-4993-90d7-5c7bffdec32d",
"name": "Airtable: Posted Instagram",
"type": "n8n-nodes-base.airtable",
"position": [
320,
-16
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appG0wM9Oe2bp1qhh",
"cachedResultUrl": "https://airtable.com/appG0wM9Oe2bp1qhh",
"cachedResultName": "Social Media System"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblM3kDu1qB2FdTOF",
"cachedResultUrl": "https://airtable.com/appG0wM9Oe2bp1qhh/tblM3kDu1qB2FdTOF",
"cachedResultName": "Media Creation"
},
"columns": {
"value": {
"id": "={{ $('Airtable').item.json.id }}",
"Publishing Log": "=| Instagram Success | "
},
"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": true,
"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": false,
"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": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "bab13e60-e6c4-4305-8b36-8c345f233084",
"name": "Airtable Record ID",
"type": "n8n-nodes-base.set",
"position": [
-1376,
1520
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "ca998655-fcdd-4169-b470-492cf5113b6a",
"name": "=airtableID",
"type": "string",
"value": "={{ $json.body.airtableID }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "de1d08e5-4f01-4509-ab12-88f50578ddac",
"name": "Sticky Note4",
"type": "n8n-nodes-base.stickyNote",
"position": [
-960,
1424
],
"parameters": {
"color": 5,
"width": 288,
"height": 260,
"content": "### May Not Be Necessary\n\nI added this because my incoming Titles were over the 100 character limit"
},
"typeVersion": 1
},
{
"id": "91d4e30f-11b2-45e0-8f92-c0c559735579",
"name": "Sticky Note5",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2256,
304
],
"parameters": {
"width": 580,
"height": 1880,
"content": "# How to Add Example Table and Connect n8n to Airtable\n\n---\n\n## Part 1: Add the Example Table to Airtable\n\n1. **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)\n\n2. **Open the Example Base** \n - Link: [Social Media System Base](https://airtable.com/appbOSIspSmMfeJeg/shr7htmWB9GNRrpw3)\n\n3. **Copy the Base** \n - To the right of the title *\"Social Media System\"*, click **\"Copy base\"**.\n\n4. **Choose Your Workspace** \n - Pick the workspace to copy the base into, then click **\"Add base\"**.\n\n**\u2705 Congrats! You now have the example Base added.**\n\n---\n\n## Part 2: Connect n8n to Airtable\n\n### Step A: Create a Personal Access Token in Airtable\n\n1. **Create and Log into Your Airtable Account** \n - [Sign up here (Affiliate link)](https://airtable.com/invite/r/6UyZyAAd)\n\n2. **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\"**.\n\n3. **Create a New Token**\n - Click **\"Create token\"**.\n - Name your token (example: *\"Airtable personal access token for n8n\"*). \n **(Don't create yet!)**\n\n4. **Set Scopes**\n - Click **\"+ Add a scope\"** and enable these scopes:\n - `data.records:read`\n - `data.records:write`\n - `schema.bases:read`\n\n5. **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).\n\n6. **Finalize and Save the Token**\n - After creation, a pop-up will show your token **only once**.\n - **Copy and store it safely!**\n\n---\n\n### Step B: Add Airtable Credentials in n8n\n\n1. **Create and Log into Your n8n Account** \n - [Sign up here (Affiliate link)](https://n8n.partnerlinks.io/aiwithapex)\n\n2. **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.)\n\n3. **Input Token Details**\n - In the popup, type **\"Airtable personal access token api\"**, click **\"Continue\"**.\n - Paste your **saved Airtable token**.\n\n4. **Name the Credential Properly**\n - Top left of the dialogue box: rename the token to something clearly recognizable.\n\n5. **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.\n\n**\u2705 Done! n8n is now connected to your Airtable base.**\n"
},
"typeVersion": 1
},
{
"id": "fffd8254-03ce-4e27-869c-b6f555db24c9",
"name": "Sticky Note6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1664,
-32
],
"parameters": {
"width": 996,
"height": 1460,
"content": "# Blotato Affiliate Link, Please Support My Work: https://blotato.com/?ref=max\nYou will need the API key for blotato-api-key\n\n### **Verified Blotato Node - Installation Methods**\n\n#### **1. Via the Nodes Panel (Easiest - for Verified Nodes)**\nThis works for both cloud and self-hosted instances:\n\n1. Open any workflow and click '+' or press Tab to open the nodes panel\n2. Search for \"Blotato\"\n3. You'll see it in the \"More from the community\" section at the bottom\n4. Select the node to see supported actions, then click \"Install\"\n5. The node will be installed for your entire instance\n\n**Note for Cloud Users:** On n8n cloud, instance owners can toggle verified community nodes in the Cloud Admin Panel.\n\n#### **2. Via Settings > Community Nodes (GUI Method)**\nFor self-hosted instances with GUI support:\n\n1. Go to Settings > Community Nodes\n2. Click \"Install\"\n3. Enter the package name: `n8n-nodes-blotato`\n4. Check \"I understand the risks of installing unverified code from a public source\"\n5. Click \"Install\"\n\n#### **3. Manual Installation (Command Line)**\nFor self-hosted instances running in queue mode or when GUI installation isn't available:\n\n```bash\nnpm install -g n8n-nodes-blotato\n```\nThen restart n8n.\n\n### **Setting Up Blotato Credentials**\n\nAfter installation:\n1. Go to Blotato Settings > API > Copy API Key\n2. Create new credentials in n8n\n3. Paste the API key in n8n, save, test, then select this credential on Blotato nodes\n\n### **Important Notes**\n\n- **Permissions:** Only the n8n instance owner can install and manage community nodes. Admin accounts can uninstall them\n- **Cloud vs Self-hosted:** Unverified community nodes aren't available on n8n cloud and require self-hosting, but Blotato is verified so it works on both\n- **All Users:** Once installed, all members of an n8n instance can use the community nodes in their workflows\n\n### **Using as an AI Tool**\n\nIf you want to use community nodes (like Blotato) as tools in AI Agents:\n- Set the `N8N_COMMUNITY_PACKAGES_ALLOW_TOOL_USAGE` environment variable to `true`\n\n### **Updates and Maintenance**\n\n- When a new version is available, n8n displays an \"Update\" button on the node\n- To rollback to a previous version, uninstall and reinstall specifying the target version (e.g., `n8n-nodes-blotato@1.0.1`)\n\nThe Blotato node enables you to automate posting to 9 social platforms (Instagram, TikTok, YouTube, Facebook, LinkedIn, Threads, Twitter/X, Pinterest, and Bluesky) directly from your n8n workflows!"
},
"typeVersion": 1
},
{
"id": "3cbb67c6-37f4-4bfd-8dc4-b97dafeef255",
"name": "Sticky Note7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-656,
1072
],
"parameters": {
"color": 5,
"width": 260,
"height": 620,
"content": "## FILL ME IN!\n\n### Use Link Above to Log into Blotato\n\n- Bottom Left Gear for Settings\n- **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 place\n- 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": "762cf890-9403-4ea0-859a-0710aa8a6521",
"name": "Pinterest System (tm)",
"type": "n8n-nodes-base.formTrigger",
"position": [
-928,
2384
],
"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:\n\nhttps://www.pinterest.com/USERNAME/BOARD_NAME/\n\nExample:\nhttps://www.pinterest.com/aiwithapex/artificial-intelligence-ai-ai-automation/"
},
"typeVersion": 2.2
},
{
"id": "f5fc1fdd-0b55-4327-908f-4d20e022d475",
"name": "Grab Pinterest Board Page",
"type": "n8n-nodes-base.httpRequest",
"position": [
-704,
2384
],
"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/0.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": "d32b138d-bb62-48b2-970d-e5e2f78ad910",
"name": "Pinterest Page Sleuth",
"type": "n8n-nodes-base.code",
"position": [
-480,
2384
],
"parameters": {
"jsCode": "// n8n Code Node JavaScript\n\n// Get the first item OBJECT using $input.first() or $items[0]\n// Let's use $input.first() as it's slightly more modern n8n syntax\nconst item = $input.first();\n\n// Check if an item was actually received\nif (!item) {\n console.error(\"No input item received.\");\n // Return an empty array as expected by n8n if no input\n return [];\n}\n\n// Check if the 'json' property exists on the item object\n// (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 it\n item.json = item.json || {};\n item.json.error = \"Input item does not have a 'json' object property.\";\n // Return the item INSIDE an array\n return [item];\n}\n\n// Check if 'data' exists within 'json'\n// <<< VERIFY this path 'item.json.data' using the INPUT panel in n8n editor >>>\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 array\n return [item];\n}\n\n// Assign the HTML string (adjust path if needed based on INPUT panel)\nconst htmlString = item.json.data;\n\n// Check if HTML string exists and is a string type\nif (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 array\n return [item];\n}\n\n// Check if HTML string is empty\nif (!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 array\n return [item];\n}\n// </ END OF INPUT CHECKING >\n\nlet extractedBoardInfo = {};\nlet processingError = null; // Renamed to avoid conflict with built-in 'error'\n\ntry {\n // 1. Find the JSON within the specific script tag using regex\n const regex = /<script id=\"__PWS_INITIAL_PROPS__\" type=\"application\\/json\">(.*?)<\\/script>/s;\n const match = htmlString.match(regex);\n\n if (match && match[1]) {\n const jsonString = match[1];\n // 2. Parse the extracted JSON string\n const parsedData = JSON.parse(jsonString);\n\n // 3. Navigate through the nested structure\n const boardsData = parsedData?.initialReduxState?.boards;\n\n if (boardsData && typeof boardsData === 'object' && Object.keys(boardsData).length > 0) {\n const boardId = Object.keys(boardsData)[0];\n const boardDetails = boardsData[boardId];\n\n if (boardDetails && boardDetails.id) {\n // 4. Extract the desired information\n 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}\n\n// 5. Prepare the final item\nif (Object.keys(extractedBoardInfo).length > 0) {\n item.json.extractedBoardInfo = extractedBoardInfo;\n // Optionally delete the large HTML string if no longer needed\n // delete item.json.data;\n} else {\n // Add error information if extraction failed\n item.json.error = processingError || \"Failed to extract board information for unknown reasons.\";\n item.json.extractedBoardInfo = null;\n}\n\n// Return the modified item INSIDE an array as required by n8n\nreturn [item];"
},
"typeVersion": 2
},
{
"id": "cf955569-4d4c-45d6-8b5c-a953e0620619",
"name": "Sticky Note8",
"type": "n8n-nodes-base.stickyNote",
"position": [
-992,
2256
],
"parameters": {
"color": 4,
"width": 660,
"height": 300,
"content": "# Pinterest Page Sleuth\n - Use either testing or active URL respectively depending if your workflow is active or not\n - Simply paste your board's link and fetch ID!"
},
"typeVersion": 1
},
{
"id": "43b8bca4-0335-41d9-a25d-4e3f446f4d99",
"name": "Webhook from Content Creation",
"type": "n8n-nodes-base.webhook",
"position": [
-1600,
1520
],
"parameters": {
"path": "ec7544f9-a19a-419c-ac6a-597a32a6d262",
"options": {},
"httpMethod": "POST"
},
"typeVersion": 2
},
{
"id": "a457fe44-0de0-4c78-8e96-395c83a6e8fb",
"name": "Telegram: User Update",
"type": "n8n-nodes-base.telegram",
"disabled": true,
"position": [
96,
3056
],
"parameters": {
"text": "=Media completed! \ud83d\udcad Scheduling or posting now!",
"chatId": "={{ $('Airtable: Retrieve Content Entry').item.json['Telegram Chat ID'][0] }}",
"additionalFields": {
"appendAttribution": false
}
},
"credentials": {
"telegramApi": {
"name": "<your credential>"
}
},
"typeVersion": 1.2
},
{
"id": "6ea352bb-1f6f-4a9c-95f8-4aface2150a9",
"name": "Sticky Note9",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
3008
],
"parameters": {
"color": 4,
"width": 700,
"height": 216,
"content": "## Reporting"
},
"typeVersion": 1
},
{
"id": "ef7b5c22-a3d2-4063-a16b-b1939c1469eb",
"name": "Update Managing Agent",
"type": "n8n-nodes-base.httpRequest",
"onError": "continueRegularOutput",
"disabled": true,
"position": [
320,
3056
],
"parameters": {
"url": "https://webhook.url",
"method": "POST",
"options": {},
"jsonBody": "={\n \"messageToManagingAgent\": \"Social media published! Social Media Agent Job COMPLETE [[SOCIAL_MEDIA_AGENT]] \"\n}",
"sendBody": true,
"specifyBody": "json"
},
"typeVersion": 4.2
},
{
"id": "90ef394a-b60b-4d8c-95e3-eb0e6d378927",
"name": "Finalize Transaction!",
"type": "n8n-nodes-base.airtable",
"disabled": true,
"position": [
544,
3056
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appG0wM9Oe2bp1qhh",
"cachedResultUrl": "https://airtable.com/appG0wM9Oe2bp1qhh",
"cachedResultName": "Social Media System"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblM3kDu1qB2FdTOF",
"cachedResultUrl": "https://airtable.com/appG0wM9Oe2bp1qhh/tblM3kDu1qB2FdTOF",
"cachedResultName": "Media Creation"
},
"columns": {
"value": {
"id": "={{ $('Airtable').item.json.id",
"Production": "Published",
"n8n Publishing Date": "={{ $now }}",
"n8n Publishing Time": "={{ $now }}"
},
"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"
},
{
"name": "Failed to Publish Instagram",
"value": "Failed to Publish Instagram"
}
],
"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": false,
"readOnly": false,
"required": false,
"displayName": "n8n Publishing Date",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "n8n Publishing Time",
"type": "string",
"display": true,
"removed": false,
"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": "TTS Script",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "TTS Script",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Narration Link",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Narration Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Slide Image Prompt 1",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Slide Image Prompt 1",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Slide Image Prompt 2",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Slide Image Prompt 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Slide Image Prompt 3",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Slide Image Prompt 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Slide Image Prompt 4",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Slide Image Prompt 4",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Slide Image Prompt 5",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Slide Image Prompt 5",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "GDrive Folder Link",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "GDrive Folder Link",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image URL 2",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Image URL 2",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image URL 3",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Image URL 3",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image URL 4",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Image URL 4",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image URL 5",
"type": "string",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Image URL 5",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Chat ID",
"type": "number",
"display": true,
"removed": true,
"readOnly": false,
"required": false,
"displayName": "Chat ID",
"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": {
"name": "<your credential>"
}
},
"typeVersion": 2.1
},
{
"id": "85016b26-cce8-42e8-a855-4098f8c1b5ce",
"name": "Wait",
"type": "n8n-nodes-base.wait",
"position": [
96,
752
],
"parameters": {
"amount": "={{ Math.random() * 37 + 3 }}"
},
"typeVersion": 1.1
},
{
"id": "158f0710-58df-46b6-a808-57572b6c61c9",
"name": "Wait1",
"type": "n8n-nodes-base.wait",
"position": [
96,
1328
],
"parameters": {
"amount": "={{ Math.random() * 37 + 3 }}"
},
"typeVersion": 1.1
},
{
"id": "4f9da763-04a6-412f-b74e-347868aaff3a",
"name": "Airtable: Posted Instagram - Fail",
"type": "n8n-nodes-base.airtable",
"position": [
320,
176
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appG0wM9Oe2bp1qhh",
"cachedResultUrl": "https://airtable.com/appG0wM9Oe2bp1qhh",
"cachedResultName": "Social Media System"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblM3kDu1qB2FdTOF",
"cachedResultUrl": "https://airtable.com/appG0wM9Oe2bp1qhh/tblM3kDu1qB2FdTOF",
"cachedResultName": "Media Creation"
},
"columns": {
"value": {
"id": "={{ $('Airtable').item.json.id",
"Publishing Log": "| Instagram FAILED | "
},
"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": true,
"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"
},
Credentials you'll need
Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.
airtableTokenApiblotatoApiopenAiApitelegramApi
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
This workflow contains community nodes that are only compatible with the self-hosted version of n8n.
Source: https://n8n.io/workflows/7223/ — original creator credit. Request a take-down →
Related workflows
Workflows that share integrations, category, or trigger type with this one. All free to copy and import.
Voice Note -> Veo 3 AD. Uses telegramTrigger, telegram, openAi, httpRequest. Event-driven trigger; 49 nodes.
Telegram Trigger, Telegram, OpenAI +3
This workflow is designed for content creators, agencies, influencers, and automation builders who want to transform viral videos into personalized avatar-based edits — and automatically publish them
Telegram Trigger, Telegram, HTTP Request +3
This workflow is perfect for eCommerce brands, content creators, and marketing teams who want to automatically generate short, eye-catching videos from their product images — without editing software
Telegram Trigger, HTTP Request, Telegram +2
How it works • Automates multi-platform social media posting (Instagram, YouTube, TikTok, etc.) using AI-generated content • Integrates Airtable, n8n, and Blotato for full content scheduling and publi
HTTP Request, Airtable, OpenAI +1
inoreader_AI->196267257. Uses httpRequest, openAi, telegram, airtable. Event-driven trigger; 28 nodes.
HTTP Request, OpenAI, Telegram +2