Automated Social Media Content
Takes in a URL from a YouTube podcast and creates posts for Instagram, LinkedIn and Facebook
Shared 8/25/2025
228 views
Visual Workflow
JSON Code
{
"meta": {
"instanceId": "125637e355429ab06f8886794f7df9252a3e338f92a1957141a8989e48f2b612",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "bd72ee1b-83da-4aa5-9e7b-a5ce34fab223",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"position": [
112,
352
],
"parameters": {
"numberInputs": 3
},
"typeVersion": 3.2
},
{
"id": "94c6a3d7-bcad-430e-864f-322096bf0c35",
"name": "Add to FB Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-112,
368
],
"parameters": {
"columns": {
"value": {
"Status": "={{ $json.status }}",
"Context": "={{ $json.original_context }}",
"Platform": "={{ $json.platform }}",
"Image URL": "={{ $json.image_url }}",
"Created Date": "={{new Date().toISOString()}}",
"Post Content": "={{ $json.post_content }}"
},
"schema": [
{
"id": "Post Content",
"type": "string",
"display": true,
"required": false,
"displayName": "Post Content",
"defaultMatch": false
},
{
"id": "Image URL",
"type": "string",
"display": true,
"required": false,
"displayName": "Image URL",
"defaultMatch": false
},
{
"id": "Platform",
"type": "string",
"display": true,
"required": false,
"displayName": "Platform",
"defaultMatch": false
},
{
"id": "Context",
"type": "string",
"display": true,
"required": false,
"displayName": "Context",
"defaultMatch": false
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false
},
{
"id": "Created Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Created Date",
"defaultMatch": false
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1761109783,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit#gid=1761109783",
"cachedResultName": "Facebook"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit?usp=drivesdk",
"cachedResultName": "Automated Social Media Content"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "qVntjW61XxH91qGU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "85656f94-9944-4935-b096-8a813f840c10",
"name": "Add to LI Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-112,
544
],
"parameters": {
"columns": {
"value": {
"Status": "={{ $json.status }}",
"Context": "={{ $json.original_context }}",
"Platform": "={{ $json.platform }}",
"Image URL": "={{ $json.image_url }}",
"Created Date": "={{new Date().toISOString()}}",
"Post Content": "={{ $json.post_content }}"
},
"schema": [
{
"id": "Post Content",
"type": "string",
"display": true,
"required": false,
"displayName": "Post Content",
"defaultMatch": false
},
{
"id": "Image URL",
"type": "string",
"display": true,
"required": false,
"displayName": "Image URL",
"defaultMatch": false
},
{
"id": "Platform",
"type": "string",
"display": true,
"required": false,
"displayName": "Platform",
"defaultMatch": false
},
{
"id": "Context",
"type": "string",
"display": true,
"required": false,
"displayName": "Context",
"defaultMatch": false
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false
},
{
"id": "Created Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Created Date",
"defaultMatch": false
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 552737460,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit#gid=552737460",
"cachedResultName": "LinkedIn"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit?usp=drivesdk",
"cachedResultName": "Automated Social Media Content"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "qVntjW61XxH91qGU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "92d1477a-9217-4288-a684-70bb40585f60",
"name": "Add to IG Sheet",
"type": "n8n-nodes-base.googleSheets",
"position": [
-112,
144
],
"parameters": {
"columns": {
"value": {
"Status": "={{ $json.status }}",
"Context": "={{ $json.original_context }}",
"Platform": "={{ $json.platform }}",
"Image URL": "={{ $json.image_url }}",
"Created Date": "={{new Date().toISOString()}}",
"Post Content": "={{ $json.post_content }}"
},
"schema": [
{
"id": "Post Content",
"type": "string",
"display": true,
"required": false,
"displayName": "Post Content",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Image URL",
"type": "string",
"display": true,
"required": false,
"displayName": "Image URL",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Platform",
"type": "string",
"display": true,
"required": false,
"displayName": "Platform",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Context",
"type": "string",
"display": true,
"required": false,
"displayName": "Context",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Status",
"type": "string",
"display": true,
"required": false,
"displayName": "Status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Created Date",
"type": "string",
"display": true,
"required": false,
"displayName": "Created Date",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit#gid=0",
"cachedResultName": "Instagram"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit?usp=drivesdk",
"cachedResultName": "Automated Social Media Content"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "qVntjW61XxH91qGU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "ef5b76df-af58-4237-9da5-3ae903aa031f",
"name": "Set FB JSON",
"type": "n8n-nodes-base.set",
"position": [
-336,
368
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "post-content",
"name": "post_content",
"type": "string",
"value": "={{ $('Facebook Post Generator').item.json.message.content }}"
},
{
"id": "image-url",
"name": "image_url",
"type": "string",
"value": "={{ $json.url }}"
},
{
"id": "platform",
"name": "platform",
"type": "string",
"value": "Facebook"
},
{
"id": "original-context",
"name": "original_context",
"type": "string",
"value": "={{ $('Loop Over Items').item.json.paragraphTranscript }}"
},
{
"id": "status",
"name": "status",
"type": "string",
"value": "pending"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "3fb7fcf7-7070-4238-91c3-cb2c3c360f32",
"name": "Set LI JSON",
"type": "n8n-nodes-base.set",
"position": [
-336,
544
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "post-content",
"name": "post_content",
"type": "string",
"value": "={{ $('LinkedIn Post Generator').item.json.message.content }}"
},
{
"id": "image-url",
"name": "image_url",
"type": "string",
"value": "={{ $json.url }}"
},
{
"id": "platform",
"name": "platform",
"type": "string",
"value": "LinkedIn"
},
{
"id": "original-context",
"name": "original_context",
"type": "string",
"value": "={{ $('Loop Over Items').item.json.paragraphTranscript }}"
},
{
"id": "status",
"name": "status",
"type": "string",
"value": "pending"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "5913bad7-1a7e-4905-8689-98e070470918",
"name": "Set IG JSON",
"type": "n8n-nodes-base.set",
"position": [
-336,
144
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "post-content",
"name": "post_content",
"type": "string",
"value": "={{ $('Instagram Post Generator').item.json.message.content }}"
},
{
"id": "image-url",
"name": "image_url",
"type": "string",
"value": "={{ $json.url }}"
},
{
"id": "platform",
"name": "platform",
"type": "string",
"value": "Instagram"
},
{
"id": "original-context",
"name": "original_context",
"type": "string",
"value": "={{ $('Loop Over Items').item.json.paragraphTranscript }}"
},
{
"id": "status",
"name": "status",
"type": "string",
"value": "pending"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "227825b9-cb49-4e91-b903-3cd3a95309dc",
"name": "Facebook Post Generator",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-928,
368
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "GPT-4.1-MINI"
},
"options": {},
"messages": {
"values": [
{
"role": "system",
"content": "You are a Facebook content creator. Take the provided transcript section and context, then write an engaging Facebook post. Make it conversational, include call-to-action, and optimize for Facebook's algorithm."
},
{
"content": "=Transcript section: {{ $json.transcript }}\n\nContext: {{ $json.context }}\n\nWrite a Facebook post based on this content."
}
]
}
},
"credentials": {
"openAiApi": {
"id": "YlmU06HqWiBuScWV",
"name": "OpenAi account"
}
},
"typeVersion": 1.8
},
{
"id": "61b2a942-a247-4ae0-8717-01354ccc72d9",
"name": "LinkedIn Post Generator",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-928,
544
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "GPT-4.1-MINI"
},
"options": {},
"messages": {
"values": [
{
"role": "system",
"content": "You are a LinkedIn content strategist. Take the provided transcript section and context, then write a professional LinkedIn post. Make it longer and more detailed than Instagram, include professional insights, and use LinkedIn-appropriate tone."
},
{
"content": "=Transcript section: {{ $json.paragraphTranscript }}\n\nContext: {{ $json.contextAndFeedback }}\n\nWrite a LinkedIn post based on this content."
}
]
}
},
"credentials": {
"openAiApi": {
"id": "YlmU06HqWiBuScWV",
"name": "OpenAi account"
}
},
"typeVersion": 1.8
},
{
"id": "6950cc42-668e-47d6-ac16-3636d639b061",
"name": "Instagram Post Generator",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-928,
144
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "GPT-4.1-MINI"
},
"options": {},
"messages": {
"values": [
{
"role": "system",
"content": "You are an Instagram content creator. Take the provided transcript section and context, then write an engaging Instagram post. Keep it concise, use relevant hashtags, and make it shareable. Focus on the key insight or takeaway."
},
{
"content": "=Transcript section: {{ $json.transcript }}\n\nContext: {{ $json.context }}\n\nWrite an Instagram post based on this content."
}
]
}
},
"credentials": {
"openAiApi": {
"id": "YlmU06HqWiBuScWV",
"name": "OpenAi account"
}
},
"typeVersion": 1.8
},
{
"id": "db5d5485-2949-4a3d-9633-024532a1d767",
"name": "Loop Over Items",
"type": "n8n-nodes-base.splitInBatches",
"position": [
-1152,
352
],
"parameters": {
"options": {}
},
"typeVersion": 3
},
{
"id": "31687ddb-2d17-4ad8-8bb1-58205fe697a3",
"name": "Split Out",
"type": "n8n-nodes-base.splitOut",
"position": [
-1360,
352
],
"parameters": {
"options": {},
"fieldToSplitOut": "message.content.sections"
},
"typeVersion": 1
},
{
"id": "14c1d8ee-2cd1-4edf-b7bf-43378a0151f4",
"name": "OpenAI - Extract Engaging Points",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-1744,
352
],
"parameters": {
"modelId": {
"__rl": true,
"mode": "list",
"value": "gpt-4.1-mini",
"cachedResultName": "GPT-4.1-MINI"
},
"options": {},
"messages": {
"values": [
{
"role": "system",
"content": "=You are a helpful, intelligent content writing assistant that works with transcripts."
},
{
"role": "system",
"content": "=You take as input a long, meandering transcript, and you identify the 10 most interesting, engaging points.\nYou then generate JSON containing those interesting, engaging points in this structure:\n{\n\"sections\": [\n{\n\"number\": 1,\n\"paragraphTranscript\": \"paragraph of the relevant part of the transcript goes here.\",\n\"contextAndFeedback\": \"a description of why this point is interesting, and some ways to make it even better.\",\n\"deepExplanation\": \"a one-paragraph writeup based on the transcript section that expands upon its points, clarifies any ambiguities, and generally fills in any blanks.\",\n\"shortImageDescription\": \"a one-sentence description of an image that illustrates the concept. description must have one, simple character (like a bunny or an animal) and be catered to a younger audience. Image description should never talk about text.\"\n}\n]\n}\nRules:\n\nWrite in a spartan, laconic tone of voice.\nCopy any transcript sections exactly as they are.\nLook for unorthodox, or interesting ways to make the content better in the contextAndFeedback string.\nMake sure your paragraphTranscript string is longer than just one sentence. Try and capture at least one whole paragraph of the transcript.\n\nGenerate 10 points. The transcript is below:"
},
{
"content": "=Here is the transcript to analyze:\n\n{{ $json.subtitles[0].srt || $json.transcript || $json.text }}"
}
]
},
"jsonOutput": true
},
"credentials": {
"openAiApi": {
"id": "YlmU06HqWiBuScWV",
"name": "OpenAi account"
}
},
"typeVersion": 1.8
},
{
"id": "a497c613-53b8-489a-9931-baa167220ef9",
"name": "Get Transcript via Apify",
"type": "n8n-nodes-base.httpRequest",
"position": [
-1968,
352
],
"parameters": {
"url": "https://api.apify.com/v2/acts/streamers~youtube-scraper/run-sync-get-dataset-items",
"options": {},
"jsonBody": "={\n \"startUrls\": [{\n \"url\": \"{{ $json['YouTube Podcast URL'] }}\"\n }],\n \"downloadSubtitles\": true,\n \"downloadCaptions\": true,\n \"maxResults\": 1\n}",
"sendBody": true,
"specifyBody": "json",
"authentication": "genericCredentialType",
"genericAuthType": "httpBearerAuth"
},
"credentials": {
"httpBearerAuth": {
"id": "iY8H078a2KNxUk0z",
"name": "Apify token"
}
},
"typeVersion": 4.2
},
{
"id": "970fd7b3-6244-4e17-a46d-92cb909a6b10",
"name": "On form submission",
"type": "n8n-nodes-base.formTrigger",
"position": [
-2176,
352
],
"webhookId": "podcast-repurposing-form",
"parameters": {
"options": {},
"formTitle": "Podcast Repurposing Engine",
"formFields": {
"values": [
{
"fieldLabel": "YouTube Podcast URL",
"placeholder": "https://www.youtube.com/watch?v=...",
"requiredField": true
}
]
},
"formDescription": "Enter a YouTube podcast URL to automatically generate social media content"
},
"typeVersion": 2.2
},
{
"id": "9b5f0c34-aa82-4ca3-b872-5d61ee6eeadd",
"name": "Generate Instagram Image",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-544,
144
],
"parameters": {
"prompt": "Colorful, soft watercolor of {{ $('Loop Over Items').item.json.image_description }} in watercolor bunny style, cute and professional",
"options": {
"size": "1024x1024",
"style": "natural",
"returnImageUrls": true
},
"resource": "image"
},
"credentials": {
"openAiApi": {
"id": "YlmU06HqWiBuScWV",
"name": "OpenAi account"
}
},
"typeVersion": 1.8
},
{
"id": "1af0f429-ea3f-40fa-ac17-a61411915278",
"name": "Generate Facebook Image",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-544,
368
],
"parameters": {
"prompt": "Colorful, soft watercolor of {{ $('Loop Over Items').item.json.image_description }} in watercolor bunny style, cute and professional, Facebook-friendly design",
"options": {
"size": "1024x1024",
"style": "natural",
"returnImageUrls": true
},
"resource": "image"
},
"credentials": {
"openAiApi": {
"id": "YlmU06HqWiBuScWV",
"name": "OpenAi account"
}
},
"typeVersion": 1.8
},
{
"id": "2265bcfe-531d-4398-bef4-5ae88645d3a1",
"name": "Generate LinkedIn Image",
"type": "@n8n/n8n-nodes-langchain.openAi",
"position": [
-544,
544
],
"parameters": {
"prompt": "Colorful, soft watercolor of {{ $('Loop Over Items').item.json.image_description }} in watercolor bunny style, cute and professional LinkedIn aesthetic",
"options": {
"size": "1024x1024",
"style": "natural",
"returnImageUrls": true
},
"resource": "image"
},
"credentials": {
"openAiApi": {
"id": "YlmU06HqWiBuScWV",
"name": "OpenAi account"
}
},
"typeVersion": 1.8
},
{
"id": "11ec6126-7a74-4ca3-bf5e-80727d06ec81",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-1216,
960
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 7
}
]
}
},
"typeVersion": 1.2
},
{
"id": "dfd969a6-6fc2-4581-abf3-e98ad9fb88d1",
"name": "Check Instagram Posts",
"type": "n8n-nodes-base.googleSheets",
"position": [
-944,
784
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit#gid=0",
"cachedResultName": "Instagram"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit?usp=drivesdk",
"cachedResultName": "Automated Social Media Content"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "qVntjW61XxH91qGU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "2ed8e9a3-50fe-47af-8396-91cd33e8e523",
"name": "Check LinkedIn Posts",
"type": "n8n-nodes-base.googleSheets",
"position": [
-944,
960
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 552737460,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit#gid=552737460",
"cachedResultName": "LinkedIn"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit?usp=drivesdk",
"cachedResultName": "Automated Social Media Content"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "qVntjW61XxH91qGU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "d8f8745f-0739-489f-a95f-516d66458b21",
"name": "Check Facebook Posts",
"type": "n8n-nodes-base.googleSheets",
"position": [
-944,
1152
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1761109783,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit#gid=1761109783",
"cachedResultName": "Facebook"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit?usp=drivesdk",
"cachedResultName": "Automated Social Media Content"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "qVntjW61XxH91qGU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "e38f6526-95fc-4805-a01b-c1a13d02246c",
"name": "HTTP Request",
"type": "n8n-nodes-base.httpRequest",
"position": [
-768,
960
],
"parameters": {
"url": "={{ $json.postImage }}",
"options": {
"allowUnauthorizedCerts": true
}
},
"typeVersion": 4.2
},
{
"id": "f44388fb-6c44-46c8-ab97-bfaaf7304b78",
"name": "Publish to Facebook",
"type": "n8n-nodes-base.facebookGraphApi",
"position": [
-768,
1152
],
"parameters": {
"edge": "photos",
"node": "me",
"options": {
"queryParameters": {
"parameter": [
{
"name": "message",
"value": "={{ $json.postBody }}"
},
{
"name": "url",
"value": "={{ $json.postImage }}"
}
]
}
},
"graphApiVersion": "v17.0",
"httpRequestMethod": "POST",
"allowUnauthorizedCerts": "={{ false }}"
},
"credentials": {
"facebookGraphApi": {
"id": "Ll9X807UYoe99uPS",
"name": "Facebook Graph account"
}
},
"typeVersion": 1
},
{
"id": "616a431c-9e10-4bc4-81dc-19218745167a",
"name": "Publish to LinkedIn",
"type": "n8n-nodes-base.linkedIn",
"position": [
-576,
960
],
"parameters": {
"text": "={{ $json.postBody }}",
"postAs": "organization",
"organization": "91415714",
"additionalFields": {},
"shareMediaCategory": "IMAGE"
},
"credentials": {
"linkedInOAuth2Api": {
"id": "f2ak8kevxWukCsuY",
"name": "LinkedIn account"
}
},
"typeVersion": 1
},
{
"id": "99df76eb-8f69-4dde-af1f-5cac1ab8dc9d",
"name": "Upload to IG",
"type": "n8n-nodes-base.facebookGraphApi",
"position": [
-768,
784
],
"parameters": {
"edge": "media",
"node": "17841448359715989",
"options": {
"queryParameters": {
"parameter": [
{
"name": "caption",
"value": "={{ $json.postBody }}"
},
{
"name": "image_url",
"value": "={{ $json.postImage }}"
}
]
}
},
"graphApiVersion": "v17.0",
"httpRequestMethod": "POST",
"allowUnauthorizedCerts": "={{ false }}"
},
"credentials": {
"facebookGraphApi": {
"id": "Ll9X807UYoe99uPS",
"name": "Facebook Graph account"
}
},
"typeVersion": 1
},
{
"id": "6b935c26-b1eb-4028-812d-650a24f7cc8c",
"name": "Post on IG",
"type": "n8n-nodes-base.facebookGraphApi",
"position": [
-576,
784
],
"parameters": {
"edge": "media_publish",
"node": "17841448359715989",
"options": {
"queryParameters": {
"parameter": [
{
"name": "creation_id",
"value": "={{ $json.id }}"
}
]
}
},
"graphApiVersion": "v17.0",
"httpRequestMethod": "POST",
"allowUnauthorizedCerts": "={{ false }}"
},
"credentials": {
"facebookGraphApi": {
"id": "Ll9X807UYoe99uPS",
"name": "Facebook Graph account"
}
},
"typeVersion": 1
},
{
"id": "6dc80918-8034-4ac4-9f8e-119bfa184664",
"name": "Update Google Sheets DB (FB)",
"type": "n8n-nodes-base.googleSheets",
"position": [
-576,
1152
],
"parameters": {
"columns": {
"value": {
"postBody": "={{ $('Check Facebook Posts').item.json.postBody }}",
"postedOn": "={{ $now.format('DD') }}",
"dateAdded": "={{ $('Check Facebook Posts').item.json.dateAdded }}",
"postImage": "={{ $('Check Facebook Posts').item.json.postImage }}"
},
"schema": [
{
"id": "dateAdded",
"type": "string",
"display": true,
"required": false,
"displayName": "dateAdded",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "postBody",
"type": "string",
"display": true,
"required": false,
"displayName": "postBody",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "postImage",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "postImage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "postedOn",
"type": "string",
"display": true,
"required": false,
"displayName": "postedOn",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"postImage"
]
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1761109783,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit#gid=1761109783",
"cachedResultName": "Facebook"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit?usp=drivesdk",
"cachedResultName": "Automated Social Media Content"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "qVntjW61XxH91qGU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "69e71173-fa20-448a-bc9a-6a73a64369b5",
"name": "Update Google Sheets DB (LI)",
"type": "n8n-nodes-base.googleSheets",
"position": [
-400,
960
],
"parameters": {
"columns": {
"value": {
"postBody": "={{ $('Check LinkedIn Posts').item.json.postBody }}",
"postedOn": "={{ $now.format('DD') }}",
"dateAdded": "={{ $('Check LinkedIn Posts').item.json.dateAdded }}",
"postImage": "={{ $('Check LinkedIn Posts').item.json.postImage }}"
},
"schema": [
{
"id": "dateAdded",
"type": "string",
"display": true,
"required": false,
"displayName": "dateAdded",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "postBody",
"type": "string",
"display": true,
"required": false,
"displayName": "postBody",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "postImage",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "postImage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "postedOn",
"type": "string",
"display": true,
"required": false,
"displayName": "postedOn",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"postImage"
]
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 552737460,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit#gid=552737460",
"cachedResultName": "LinkedIn"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit?usp=drivesdk",
"cachedResultName": "Automated Social Media Content"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "qVntjW61XxH91qGU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "055dd9bf-63c2-422a-96e2-69ad45165ea7",
"name": "Update Google Sheets DB (IG)",
"type": "n8n-nodes-base.googleSheets",
"position": [
-400,
784
],
"parameters": {
"columns": {
"value": {
"postBody": "={{ $('Check Instagram Posts').item.json.postBody }}",
"postedOn": "={{ $now.format('DD') }}",
"dateAdded": "={{ $('Check Instagram Posts').item.json.dateAdded }}",
"postImage": "={{ $('Check Instagram Posts').item.json.postImage }}"
},
"schema": [
{
"id": "dateAdded",
"type": "string",
"display": true,
"required": false,
"displayName": "dateAdded",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "postBody",
"type": "string",
"display": true,
"required": false,
"displayName": "postBody",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "postImage",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "postImage",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "postedOn",
"type": "string",
"display": true,
"required": false,
"displayName": "postedOn",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "row_number",
"type": "string",
"display": true,
"removed": true,
"readOnly": true,
"required": false,
"displayName": "row_number",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"postImage"
]
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit#gid=0",
"cachedResultName": "Instagram"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-KQAtP9pS7T2XQJsPXPk_EYIipNpTBW7YjCMVLC19Xo/edit?usp=drivesdk",
"cachedResultName": "Automated Social Media Content"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "qVntjW61XxH91qGU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
}
],
"pinData": {},
"connections": {
"Split Out": {
"main": [
[
{
"node": "Loop Over Items",
"type": "main",
"index": 0
}
]
]
},
"Post on IG": {
"main": [
[
{
"node": "Update Google Sheets DB (IG)",
"type": "main",
"index": 0
}
]
]
},
"Set FB JSON": {
"main": [
[
{
"node": "Add to FB Sheet",
"type": "main",
"index": 0
}
]
]
},
"Set IG JSON": {
"main": [
[
{
"node": "Add to IG Sheet",
"type": "main",
"index": 0
}
]
]
},
"Set LI JSON": {
"main": [
[
{
"node": "Add to LI Sheet",
"type": "main",
"index": 0
}
]
]
},
"HTTP Request": {
"main": [
[
{
"node": "Publish to LinkedIn",
"type": "main",
"index": 0
}
]
]
},
"Upload to IG": {
"main": [
[
{
"node": "Post on IG",
"type": "main",
"index": 0
}
]
]
},
"Add to FB Sheet": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Add to IG Sheet": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Add to LI Sheet": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 2
}
]
]
},
"Loop Over Items": {
"main": [
[],
[
{
"node": "LinkedIn Post Generator",
"type": "main",
"index": 0
},
{
"node": "Facebook Post Generator",
"type": "main",
"index": 0
},
{
"node": "Instagram Post Generator",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Check Instagram Posts",
"type": "main",
"index": 0
},
{
"node": "Check LinkedIn Posts",
"type": "main",
"index": 0
},
{
"node": "Check Facebook Posts",
"type": "main",
"index": 0
}
]
]
},
"On form submission": {
"main": [
[
{
"node": "Get Transcript via Apify",
"type": "main",
"index": 0
}
]
]
},
"Publish to Facebook": {
"main": [
[
{
"node": "Update Google Sheets DB (FB)",
"type": "main",
"index": 0
}
]
]
},
"Publish to LinkedIn": {
"main": [
[
{
"node": "Update Google Sheets DB (LI)",
"type": "main",
"index": 0
}
]
]
},
"Check Facebook Posts": {
"main": [
[
{
"node": "Publish to Facebook",
"type": "main",
"index": 0
}
]
]
},
"Check LinkedIn Posts": {
"main": [
[
{
"node": "HTTP Request",
"type": "main",
"index": 0
}
]
]
},
"Check Instagram Posts": {
"main": [
[
{
"node": "Upload to IG",
"type": "main",
"index": 0
}
]
]
},
"Facebook Post Generator": {
"main": [
[
{
"node": "Generate Facebook Image",
"type": "main",
"index": 0
}
]
]
},
"Generate Facebook Image": {
"main": [
[
{
"node": "Set FB JSON",
"type": "main",
"index": 0
}
]
]
},
"Generate LinkedIn Image": {
"main": [
[
{
"node": "Set LI JSON",
"type": "main",
"index": 0
}
]
]
},
"LinkedIn Post Generator": {
"main": [
[
{
"node": "Generate LinkedIn Image",
"type": "main",
"index": 0
}
]
]
},
"Generate Instagram Image": {
"main": [
[
{
"node": "Set IG JSON",
"type": "main",
"index": 0
}
]
]
},
"Get Transcript via Apify": {
"main": [
[
{
"node": "OpenAI - Extract Engaging Points",
"type": "main",
"index": 0
}
]
]
},
"Instagram Post Generator": {
"main": [
[
{
"node": "Generate Instagram Image",
"type": "main",
"index": 0
}
]
]
},
"OpenAI - Extract Engaging Points": {
"main": [
[
{
"node": "Split Out",
"type": "main",
"index": 0
}
]
]
}
}
}