This workflow follows the Facebookgraphapi → Google Sheets 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 →
{
"name": "Blogdan UGC (blogger)",
"nodes": [
{
"parameters": {
"operation": "append",
"documentId": {
"__rl": true,
"value": "1AiE0NPDjciKqUhEuyNlAjNQcCJ-Qa12rDvuxeIvh2rs",
"mode": "list",
"cachedResultName": "Blog",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1AiE0NPDjciKqUhEuyNlAjNQcCJ-Qa12rDvuxeIvh2rs/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 1762650866,
"mode": "list",
"cachedResultName": "Blogger",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1AiE0NPDjciKqUhEuyNlAjNQcCJ-Qa12rDvuxeIvh2rs/edit#gid=1762650866"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Link": "={{ $('RSS Reader').item.json.link }}",
"Kaynak": "blogger",
"\u0130sim": "={{ $('de\u011fi\u015fkenler').item.json['blog url'] }}",
"Ba\u015fl\u0131k": "={{ $('RSS Reader').item.json.title }}",
"\u0130\u00e7erik": "={{ $('RSS Reader').item.json.content }}"
},
"matchingColumns": [],
"schema": [
{
"id": "Kaynak",
"displayName": "Kaynak",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "\u0130sim",
"displayName": "\u0130sim",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Ba\u015fl\u0131k",
"displayName": "Ba\u015fl\u0131k",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Link",
"displayName": "Link",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "\u0130\u00e7erik",
"displayName": "\u0130\u00e7erik",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Durum",
"displayName": "Durum",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.6,
"position": [
1540,
780
],
"id": "318f0402-9d66-4402-906c-214912b16738",
"name": "Google Sheets",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 1
},
{
"triggerAtHour": 13
}
]
}
},
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
140,
780
],
"id": "898d4e18-404e-438c-9b16-74a6c920d361",
"name": "Schedule Trigger"
},
{
"parameters": {
"documentId": {
"__rl": true,
"value": "1AiE0NPDjciKqUhEuyNlAjNQcCJ-Qa12rDvuxeIvh2rs",
"mode": "list",
"cachedResultName": "Blog",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1AiE0NPDjciKqUhEuyNlAjNQcCJ-Qa12rDvuxeIvh2rs/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": 1762650866,
"mode": "list",
"cachedResultName": "Blogger",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1AiE0NPDjciKqUhEuyNlAjNQcCJ-Qa12rDvuxeIvh2rs/edit#gid=1762650866"
},
"filtersUI": {
"values": [
{
"lookupColumn": "Durum"
}
]
},
"options": {
"returnFirstMatch": true
}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.6,
"position": [
500,
1600
],
"id": "49dd2743-7535-4560-acbd-1d7d70ddf5ff",
"name": "Google Sheets4",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"jsCode": "const text = $json[\"message\"][\"content\"];\n\nconst parts = text.split(/\\n\\s*\\n/); // Bo\u015f sat\u0131ra g\u00f6re b\u00f6l\n\nreturn {\n paragraph1: parts[0]?.trim() || '',\n paragraph2: parts[1]?.trim() || ''\n};\n"
},
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
1240,
1600
],
"id": "0a15229f-9b5e-4029-aebc-2a114c7cebf8",
"name": "Code"
},
{
"parameters": {
"method": "POST",
"url": "https://queue.fal.run/workflows/PROTOTIPAL/blog2ugc",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "=Key {{ $('keys').item.json['fal_key'] }}"
}
]
},
"sendBody": true,
"bodyParameters": {
"parameters": [
{
"name": "metin_1",
"value": "={{ $json.metin1 }}"
},
{
"name": "metin_2",
"value": "={{ $json.metin2 }}"
},
{
"name": "avatar_prompt",
"value": "={{ $('Sistem Promptlar\u0131').item.json['Avatar prompt \u00fcretici sistem promptu'] }}"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
1860,
1640
],
"id": "73438547-3bb4-4fcc-b5fa-15fa3ad6c31d",
"name": "Video \u00dcretim \u0130ste\u011fi"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "f103750e-ad77-40ce-9ab9-ad626a5d88db",
"name": "fal_key",
"value": "660d23d7-c569-4c12-9a8e-cf7eff1918aa:5432eb57748278259594183c3cafc8bd",
"type": "string"
},
{
"id": "2dbc8059-3ae4-489b-ab7b-b825036c1103",
"name": "Instagram hesap kodu",
"value": "17841474103124053",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
240,
1600
],
"id": "03330fec-0fea-4f58-a0f1-7c338a4414da",
"name": "keys"
},
{
"parameters": {
"url": "=https://queue.fal.run/workflows/PROTOTIPAL/blog2ugc/requests/{{ $json.request_id }}/status",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "=Key {{ $('keys').item.json['fal_key'] }}"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
2240,
1640
],
"id": "64075d17-d0f8-4a3c-b58d-8ec6761298d0",
"name": "Durum Kontrol"
},
{
"parameters": {
"amount": 1,
"unit": "minutes"
},
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
2380,
1900
],
"id": "3e466e77-5cf1-4591-b415-1b27b3bea405",
"name": "Wait"
},
{
"parameters": {
"url": "=https://queue.fal.run/workflows/PROTOTIPAL/blog2ugc/requests/{{ $json.request_id }}",
"sendHeaders": true,
"headerParameters": {
"parameters": [
{
"name": "Authorization",
"value": "=Key {{ $('keys').item.json['fal_key'] }}"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
2780,
1620
],
"id": "11066f33-67df-4c4f-b396-55fd965bba2a",
"name": "Videoyu Al"
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "strict",
"version": 2
},
"conditions": [
{
"id": "4293e7df-5233-44f8-94ab-c584bb48f356",
"leftValue": "={{ $json.status }}",
"rightValue": "COMPLETED",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"options": {}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
2460,
1640
],
"id": "d110e174-5b3a-408b-bf38-8d87f9ac85e1",
"name": "If1"
},
{
"parameters": {
"httpRequestMethod": "POST",
"graphApiVersion": "v22.0",
"node": "={{ $('keys').item.json['Instagram hesap kodu'] }}",
"edge": "media",
"options": {
"queryParameters": {
"parameter": [
{
"name": "media_type",
"value": "REELS"
},
{
"name": "video_url",
"value": "={{ $('Videoyu Al').item.json.video_url }}"
},
{
"name": "caption",
"value": "={{ $json.message.content }}"
}
]
}
}
},
"type": "n8n-nodes-base.facebookGraphApi",
"typeVersion": 1,
"position": [
4180,
840
],
"id": "c6416738-c7ed-429d-b37f-9aca709186d7",
"name": "Post Konteyner Olu\u015ftur",
"credentials": {
"facebookGraphApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"amount": 60
},
"type": "n8n-nodes-base.wait",
"typeVersion": 1.1,
"position": [
4420,
840
],
"id": "005a0025-6def-4d83-ae0c-0111e0fc1ade",
"name": "Wait2"
},
{
"parameters": {
"httpRequestMethod": "POST",
"graphApiVersion": "v22.0",
"node": "={{ $('keys').item.json['Instagram hesap kodu'] }}",
"edge": "media_publish",
"options": {
"queryParameters": {
"parameter": [
{
"name": "creation_id",
"value": "={{ $json.id }}"
}
]
}
}
},
"type": "n8n-nodes-base.facebookGraphApi",
"typeVersion": 1,
"position": [
4640,
840
],
"id": "56f9d00e-b87c-4b37-83b2-31f92685e733",
"name": "Postu Payla\u015f",
"credentials": {
"facebookGraphApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"modelId": {
"__rl": true,
"value": "gpt-4o",
"mode": "list",
"cachedResultName": "GPT-4O"
},
"messages": {
"values": [
{
"content": "={{ $('Sistem Promptlar\u0131').item.json['Metin yaz\u0131c\u0131 sistem promptu'] }}\n\n\n{{ $json['\u0130\u00e7erik'] }} "
},
{
"content": "Sen profesyonel bir senaristsin. Kullan\u0131c\u0131 sana bir i\u00e7erik verecek. Senin g\u00f6revin, bu i\u00e7eri\u011fe dayanarak etkileyici, sade ve do\u011fal bir konu\u015fma metni olu\u015fturmakt\u0131r. \u00c7\u0131kt\u0131n yaln\u0131zca 2 paragraf olacak. Her paragraf, yapay zeka taraf\u0131ndan seslendirildi\u011finde en fazla 10 saniye s\u00fcrecek kadar k\u0131sa olmal\u0131. Tercihen 8\u20139 saniyelik bir uzunluk hedefle. C\u00fcmleler k\u0131sa, net ve kolay anla\u015f\u0131l\u0131r olsun. Gereksiz kelimelerden ka\u00e7\u0131n. Paragraflar birbirini tamamlas\u0131n ama ba\u011f\u0131ms\u0131z olarak da anlaml\u0131 olsun. Format d\u00fcz yaz\u0131 \u015feklinde olsun \u2014 ba\u015fl\u0131k, madde i\u015fareti, a\u00e7\u0131klama ya da ek bilgi ekleme. Sadece 2 k\u0131sa paragraf \u00fcret ve ba\u015fka hi\u00e7bir \u015fey yazma.",
"role": "system"
}
]
},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.openAi",
"typeVersion": 1.8,
"position": [
840,
1600
],
"id": "5a627c34-cdf2-4073-b9de-df2620d0f2dc",
"name": "Konu\u015fma Metni Yaz\u0131c\u0131",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "902951e7-badd-4a0e-b096-e502f3ac21e9",
"name": "Metin yaz\u0131c\u0131 sistem promptu",
"value": "Sen profesyonel bir metin yazar\u0131 ve konu\u015fma senaristisin. Sana bir blog yaz\u0131s\u0131 verilecek. Bu blog yaz\u0131s\u0131 T\u00fcrk\u00e7e veya \u0130ngilizce olabilir. Blogun dilinden ba\u011f\u0131ms\u0131z olarak bana sadece T\u00dcRK\u00c7E bir sonu\u00e7 vereceksin. Amac\u0131n, bu blog yaz\u0131s\u0131n\u0131 anlay\u0131p onun hakk\u0131nda toplamda 20 saniyelik bir konu\u015fma metni yazmak. Bu metin yapay zeka taraf\u0131ndan seslendirilecek. Bu y\u00fczden do\u011fal, ak\u0131c\u0131 ve etkileyici bir dille yaz. Samimi ama bilgi verici ve vurucu bir ton kullan. K\u0131sa ve net c\u00fcmleler tercih et. Metni iki ayr\u0131 paragrafa b\u00f6l: - \u0130lk paragraf yakla\u015f\u0131k **10 saniyelik** olacak. - \u0130kinci paragraf da yakla\u015f\u0131k **10 saniyelik** olacak. Her iki paragraf da kendi i\u00e7inde anlaml\u0131 ve ak\u0131\u015fl\u0131 olmal\u0131. \u0130lk paragraf dikkat \u00e7ekici bir giri\u015f ve bilgi vermeye ba\u015flarken, ikinci paragraf devam\u0131 niteli\u011finde olmal\u0131 ve g\u00fc\u00e7l\u00fc bir kapan\u0131\u015f yapmal\u0131. Sadece iki paragraf halinde \u00e7\u0131kt\u0131y\u0131 ver. Ekstra hi\u00e7bir a\u00e7\u0131klama, etiket veya ba\u015fl\u0131k ekleme.",
"type": "string"
},
{
"id": "6fa51b8a-2a6e-47c5-a0db-0976de61ee20",
"name": "Post a\u00e7\u0131klama yaz\u0131c\u0131 sistem promptu",
"value": "Sen instagram i\u00e7in post a\u00e7\u0131klamas\u0131 yazan bir asistans\u0131n. A\u015fa\u011f\u0131daki video metnine uygun bir a\u00e7\u0131klama yaz. Birka\u00e7 c\u00fcmle olsun. \u00c7\u0131kt\u0131 olarak yaln\u0131zca a\u00e7\u0131klama olsun, ba\u015fka bir \u015fey yazma.",
"type": "string"
},
{
"id": "b3220190-d21b-4989-a110-4b577e1b229b",
"name": "Youtube Title Yaz\u0131c\u0131 Sistem Promptu",
"value": "Sen Youtube shorts videolar\u0131 i\u00e7in bir Title \u00fcretici asistans\u0131n. a\u015fa\u011f\u0131daki video metnine g\u00f6re 3-4 kelimelik video title olu\u015ftur. \u00e7\u0131kt\u0131 olarak yaln\u0131zca 1 ba\u015fl\u0131k olsun hi\u00e7bir \u015fey ekleme.",
"type": "string"
},
{
"id": "2d014ee5-00ff-4074-bb03-3884c712d07e",
"name": "Avatar prompt \u00fcretici sistem promptu",
"value": "Sen profesyonel bir yapay zeka prompt \u00fcreticisisin. G\u00f6revin, T\u00fcrk insanlar\u0131n\u0131 do\u011fal ve ger\u00e7ek\u00e7i \u015fekilde tasvir eden, sosyal medyada kullan\u0131c\u0131 taraf\u0131ndan \u00fcretilmi\u015f i\u00e7erik (UGC) tarz\u0131nda foto\u011fraflar olu\u015fturmak i\u00e7in ayr\u0131nt\u0131l\u0131 promptlar \u00fcretmektir. \u00dcretilen g\u00f6rseller, cep telefonuyla \u00e7ekilmi\u015f gibi g\u00f6r\u00fcnmeli; samimi, do\u011fal, plans\u0131z ama estetik olmal\u0131d\u0131r. Her prompt; T\u00fcrkiye\u2019de ya\u015fayan bir insan\u0131 (kad\u0131n veya erkek) g\u00fcnl\u00fck ya\u015fam\u0131n i\u00e7inden do\u011fal bir sahnede betimlemelidir. \u0130nsanlar T\u00fcrk g\u00f6r\u00fcn\u00fcm\u00fcne sahip olmal\u0131 (ten rengi, sa\u00e7 tipi, y\u00fcz hatlar\u0131 gibi). Sahne; bir kafede kahve i\u00e7erken, sokakta y\u00fcr\u00fcrken, evde rahat bir an ya\u015farken, bir \u00fcr\u00fcn\u00fc tan\u0131t\u0131rken ya da selfie \u00e7ekerken olabilir. I\u015f\u0131k, arka plan ve poz detaylar\u0131 da ger\u00e7ek hayatla uyumlu olacak \u015fekilde a\u00e7\u0131k\u00e7a belirtilmelidir. Kameran\u0131n genellikle el ile tutuldu\u011fu, selfie veya yak\u0131n \u00e7ekim tarz\u0131nda olmas\u0131 tercih edilir. Foto\u011fraflar yapay g\u00f6r\u00fcnmemeli; do\u011fal, s\u0131cak ve sosyal medyada payla\u015f\u0131labilir tarzda olmal\u0131d\u0131r. Her seferinde farkl\u0131 bir ki\u015fi, ortam ve his anlat\u0131lmal\u0131d\u0131r. Sadece prompt \u00fcret, a\u00e7\u0131klama ya da yorum yapma.",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
-20,
1600
],
"id": "fdcdde5b-b717-4b83-ac51-dfe35bffbb49",
"name": "Sistem Promptlar\u0131"
},
{
"parameters": {
"modelId": {
"__rl": true,
"value": "gpt-4o",
"mode": "list",
"cachedResultName": "GPT-4O"
},
"messages": {
"values": [
{
"content": "={{ $('Sistem Promptlar\u0131').item.json['Post a\u00e7\u0131klama yaz\u0131c\u0131 sistem promptu'] }}\n\n{{ $('Konu\u015fma Metni Yaz\u0131c\u0131').item.json.message.content }}",
"role": "system"
}
]
},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.openAi",
"typeVersion": 1.8,
"position": [
3000,
1620
],
"id": "f577e15a-24b4-4ccc-9c6f-97c7a53012da",
"name": "Post a\u00e7\u0131klama yaz\u0131c\u0131",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"resource": "video",
"operation": "upload",
"title": "={{ $('Youtube Title Yaz\u0131c\u0131').item.json.message.content }}",
"regionCode": "TR",
"categoryId": "28",
"options": {
"description": "={{ $json.message.content }}"
}
},
"type": "n8n-nodes-base.youTube",
"typeVersion": 1,
"position": [
4580,
1760
],
"id": "5f972e91-4a50-4942-b5b5-5bccc7048aa8",
"name": "YouTube",
"credentials": {
"youTubeOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"url": "={{ $('Videoyu Al').item.json.video_url }}",
"options": {
"response": {
"response": {
"responseFormat": "file"
}
}
}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
4320,
1760
],
"id": "26db1d6d-af64-40f5-849d-fa0180154869",
"name": "Youtube videosunu haz\u0131rla"
},
{
"parameters": {
"operation": "update",
"documentId": {
"__rl": true,
"value": "1AiE0NPDjciKqUhEuyNlAjNQcCJ-Qa12rDvuxeIvh2rs",
"mode": "list",
"cachedResultName": "Blog",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1AiE0NPDjciKqUhEuyNlAjNQcCJ-Qa12rDvuxeIvh2rs/edit?usp=drivesdk"
},
"sheetName": {
"__rl": true,
"value": "gid=0",
"mode": "list",
"cachedResultName": "Blog Linkleri",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1AiE0NPDjciKqUhEuyNlAjNQcCJ-Qa12rDvuxeIvh2rs/edit#gid=0"
},
"columns": {
"mappingMode": "defineBelow",
"value": {
"Durum": "B\u0130TT\u0130",
"Link": "={{ $('Google Sheets4').item.json['Link'] }}"
},
"matchingColumns": [
"Link"
],
"schema": [
{
"id": "Kaynak",
"displayName": "Kaynak",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "\u0130sim",
"displayName": "\u0130sim",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": true
},
{
"id": "Link",
"displayName": "Link",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"removed": false
},
{
"id": "Durum",
"displayName": "Durum",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true
},
{
"id": "row_number",
"displayName": "row_number",
"required": false,
"defaultMatch": false,
"display": true,
"type": "string",
"canBeUsedToMatch": true,
"readOnly": true,
"removed": true
}
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {}
},
"type": "n8n-nodes-base.googleSheets",
"typeVersion": 4.6,
"position": [
4980,
1520
],
"id": "af0623c4-e5be-464d-8dae-ff71941902ae",
"name": "Google Sheets5",
"credentials": {
"googleSheetsOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "67358ca2-28e2-4364-ba8b-6ad24892bd1b",
"name": "metin1",
"value": "={{ $json.paragraph1 }}",
"type": "string"
},
{
"id": "83ebe9f9-ccd2-4f48-96c3-1aa4332ac6e4",
"name": "metin2",
"value": "={{ $json.paragraph2 }}",
"type": "string"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
1520,
1600
],
"id": "69baa4d6-3477-4f2b-9c7a-52343e654cb4",
"name": "Edit Fields"
},
{
"parameters": {
"modelId": {
"__rl": true,
"value": "gpt-4o",
"mode": "list",
"cachedResultName": "GPT-4O"
},
"messages": {
"values": [
{
"content": "={{ $('Sistem Promptlar\u0131').item.json['Youtube Title Yaz\u0131c\u0131 Sistem Promptu'] }}\n\n{{ $('Konu\u015fma Metni Yaz\u0131c\u0131').item.json.message.content }}",
"role": "system"
}
]
},
"options": {}
},
"type": "@n8n/n8n-nodes-langchain.openAi",
"typeVersion": 1.8,
"position": [
3860,
1760
],
"id": "5631fd74-810e-443b-88dd-3b2246074a70",
"name": "Youtube Title Yaz\u0131c\u0131",
"credentials": {
"openAiApi": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"url": "={{ $json['blog url'] }}/feeds/posts/default??alt=rss&max-results={{ $json['Tek seferde ka\u00e7 yaz\u0131 \u00e7eksin?'] }}",
"options": {}
},
"type": "n8n-nodes-base.rssFeedRead",
"typeVersion": 1.1,
"position": [
800,
780
],
"id": "72c32486-8a6f-4b52-9f3a-b97782b6bcb1",
"name": "RSS Reader"
},
{
"parameters": {
"assignments": {
"assignments": [
{
"id": "54afb1ea-bacd-4741-a5d2-d0b8cbc8879d",
"name": "blog url",
"value": "https://bloghocam.blogspot.com/",
"type": "string"
},
{
"id": "7dba08ea-ae8f-4df1-9586-3ecd5e3e779d",
"name": "Tek seferde ka\u00e7 yaz\u0131 \u00e7eksin?",
"value": 100,
"type": "number"
}
]
},
"options": {}
},
"type": "n8n-nodes-base.set",
"typeVersion": 3.4,
"position": [
460,
780
],
"id": "c1f792bd-cfef-4b08-9eba-62c8a27d1bdd",
"name": "de\u011fi\u015fkenler"
},
{
"parameters": {
"operation": "removeItemsSeenInPreviousExecutions",
"dedupeValue": "link",
"options": {}
},
"type": "n8n-nodes-base.removeDuplicates",
"typeVersion": 2,
"position": [
1160,
780
],
"id": "de59dd6c-1f79-4940-846e-337214233bc6",
"name": "Remove Duplicates"
},
{
"parameters": {
"url": "={{ $json.video_url }}",
"options": {
"response": {
"response": {
"responseFormat": "file"
}
}
}
},
"type": "n8n-nodes-base.httpRequest",
"typeVersion": 4.2,
"position": [
3020,
1340
],
"id": "e2c703af-a23d-48d0-b75b-19b5cb52dc15",
"name": "Videoyu indir"
},
{
"parameters": {
"name": "={{ $('Google Sheets4').item.json['Ba\u015fl\u0131k'] }}",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"folderId": {
"__rl": true,
"mode": "list",
"value": "root",
"cachedResultName": "/ (Root folder)"
},
"options": {}
},
"type": "n8n-nodes-base.googleDrive",
"typeVersion": 3,
"position": [
3340,
1220
],
"id": "f9134226-8b6e-4f0c-b62b-2817484a3697",
"name": "Drive'a y\u00fckle",
"credentials": {
"googleDriveOAuth2Api": {
"name": "<your credential>"
}
}
},
{
"parameters": {
"content": "## \u00dcretilen videoyu otomatik instagramda payla\u015fmak i\u00e7in a\u015fa\u011f\u0131daki mod\u00fcl\u00fc \"Post a\u00e7\u0131klama yaz\u0131c\u0131\" ya ba\u011flay\u0131n.",
"height": 300,
"width": 820
},
"type": "n8n-nodes-base.stickyNote",
"position": [
4060,
720
],
"typeVersion": 1,
"id": "647aea55-02d9-4f74-a9ff-2a83a059994a",
"name": "Sticky Note"
},
{
"parameters": {
"content": "# Haz\u0131rl\u0131k\n\nSekt\u00f6r\u00fcn\u00fcze uygun ke\u015ffetti\u011finiz blog sitesi blogger tabanl\u0131ysa bu otomasyon ile d\u00fczenli yaz\u0131 \u00e7ekip i\u00e7erik \u00fcretebilirsiniz.\n\n\"de\u011fi\u015fkenler\" mod\u00fcl\u00fcne blog sitesinin url'sini ekleyip, tek seferde ka\u00e7 yaz\u0131 \u00e7ekece\u011finizi belirtin. (max 500, varsay\u0131lan 25)\n\nBirden fazla blog u takip etmek i\u00e7in \"de\u011fi\u015fkenler\" mod\u00fcl\u00fc ve sonraki mod\u00fclleri grup halinde kopyalay\u0131p \"Schedule Trigger\" a ba\u011flay\u0131n. Sonra onun blog url'sini g\u00fcncelleyin.",
"height": 220,
"width": 1480
},
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
500
],
"typeVersion": 1,
"id": "61e13aae-632f-4496-9980-dc6d15106c3e",
"name": "Sticky Note1"
},
{
"parameters": {
"content": "# \u00a0Sistem Promptlar\u0131 Mod\u00fcl\u00fc\n\n\n\n### Metin yaz\u0131c\u0131 sistem promptu: Blog yaz\u0131s\u0131n\u0131 referans alarak video metninizi yazacak chatgpt 4o i\u00e7in sistem promptu.\n\n### Post a\u00e7\u0131klama yaz\u0131c\u0131 sistem promptu: Sosyal medyada yapaca\u011f\u0131n\u0131z payla\u015f\u0131m\u0131n a\u00e7\u0131klamas\u0131n\u0131 \u00fcretecek chatgpt 4o i\u00e7in sistem promptu.\n\n### Youtube Title Yaz\u0131c\u0131 Sistem Promptu: Youtube shorts payla\u015f\u0131m\u0131n\u0131n Ba\u015fl\u0131k k\u0131sm\u0131n\u0131 \u00fcretecek chatgpt 4o i\u00e7in sistem promptu. \n\n### Avatar prompt \u00fcretici sistem promptu: Videoda konu\u015fmay\u0131 yapan avatar\u0131 \u00fcretecek g\u00f6rsel modeli i\u00e7in prompt \u00fcreten chatgpt 4o i\u00e7in sistem promptu.",
"height": 500,
"width": 860,
"color": 5
},
"type": "n8n-nodes-base.stickyNote",
"position": [
-380,
1860
],
"typeVersion": 1,
"id": "868cd5cd-d6fe-415a-9237-d9d63401754b",
"name": "Sticky Note5"
},
{
"parameters": {
"content": "# keys\n\n**fal_key:** fal.ai api anahtar\u0131n\u0131z\u0131 giriniz.\n\n**Instagram hesap kodu:** Meta business manager i\u015fletme ayarlar\u0131 > instagram hesaplar\u0131 b\u00f6l\u00fcm\u00fcnde instagram hesab\u0131n\u0131z\u0131 se\u00e7iniz. Kod k\u0131sm\u0131ndaki kodu kopyalay\u0131p yap\u0131\u015ft\u0131r\u0131n\u0131z. (instagram payla\u015f\u0131m\u0131n\u0131 kullanmayacaksan\u0131z bo\u015f b\u0131rakabilirsiniz)",
"height": 220,
"width": 480,
"color": 5
},
"type": "n8n-nodes-base.stickyNote",
"position": [
-380,
2400
],
"typeVersion": 1,
"id": "e1ce3ac7-fed7-469f-ab72-7e0d3b096cd2",
"name": "Sticky Note6"
},
{
"parameters": {
"content": "# Drive'a Y\u00fckle\n\nDrive'da dosyalar\u0131 y\u00fcklemek i\u00e7in \u00f6zel bir klas\u00f6r se\u00e7mek isterseniz mod\u00fcl i\u00e7erisinde se\u00e7ebilirsiniz.\n\nReferans ald\u0131\u011f\u0131n\u0131z blog yaz\u0131s\u0131n\u0131n ba\u015fl\u0131\u011f\u0131 dosya ismi olarak kaydedilecektir.",
"height": 220,
"width": 520,
"color": 5
},
"type": "n8n-nodes-base.stickyNote",
"position": [
3000,
920
],
"typeVersion": 1,
"id": "67043f95-147f-4b87-991a-c20dc6c23efd",
"name": "Sticky Note8"
},
{
"parameters": {
"content": "## Instagram payla\u015f\u0131m\u0131 i\u00e7in jeton\n\nMeta Jetonu almak i\u00e7in [Bu](https://www.youtube.com/watch?v=n0KDfcvZzOk) videoyu inceleyebilirsiniz.**",
"height": 120,
"width": 500
},
"type": "n8n-nodes-base.stickyNote",
"position": [
4060,
560
],
"typeVersion": 1,
"id": "2324aa85-dacd-4885-9147-fbb235115236",
"name": "Sticky Note10"
},
{
"parameters": {
"rule": {
"interval": [
{
"field": "weeks",
"triggerAtHour": 17
},
{
"field": "weeks",
"triggerAtDay": [
3
],
"triggerAtHour": 17
},
{
"field": "weeks",
"triggerAtDay": [
5
],
"triggerAtHour": 17
}
]
}
},
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
-320,
1600
],
"id": "a7d76583-8923-4c5a-9597-03cc0eb27f76",
"name": "Schedule Trigger1"
},
{
"parameters": {
"content": "## Zamanlay\u0131c\u0131lar\n\nYukardaki zamanlay\u0131c\u0131n\u0131n g\u00fcnde 2 defa \u00e7al\u0131\u015fmas\u0131 \u00f6nerilir. Ayn\u0131 yaz\u0131lar tekrardan kaydedilmez.\n\nA\u015fa\u011f\u0131daki zamanlay\u0131c\u0131y\u0131 ise payla\u015f\u0131m s\u0131kl\u0131\u011f\u0131n\u0131za g\u00f6re d\u00fczenleyebilirsiniz.",
"height": 240,
"width": 620,
"color": 2
},
"type": "n8n-nodes-base.stickyNote",
"position": [
-500,
1100
],
"typeVersion": 1,
"id": "423d01e6-f335-41ef-971d-cd36fcf225fd",
"name": "Sticky Note2"
}
],
"connections": {
"Schedule Trigger": {
"main": [
[
{
"node": "de\u011fi\u015fkenler",
"type": "main",
"index": 0
}
]
]
},
"Google Sheets4": {
"main": [
[
{
"node": "Konu\u015fma Metni Yaz\u0131c\u0131",
"type": "main",
"index": 0
}
]
]
},
"Code": {
"main": [
[
{
"node": "Edit Fields",
"type": "main",
"index": 0
}
]
]
},
"keys": {
"main": [
[
{
"node": "Google Sheets4",
"type": "main",
"index": 0
}
]
]
},
"Video \u00dcretim \u0130ste\u011fi": {
"main": [
[
{
"node": "Durum Kontrol",
"type": "main",
"index": 0
}
]
]
},
"Durum Kontrol": {
"main": [
[
{
"node": "If1",
"type": "main",
"index": 0
}
]
]
},
"Wait": {
"main": [
[
{
"node": "Durum Kontrol",
"type": "main",
"index": 0
}
]
]
},
"If1": {
"main": [
[
{
"node": "Videoyu Al",
"type": "main",
"index": 0
}
],
[
{
"node": "Wait",
"type": "main",
"index": 0
}
]
]
},
"Post Konteyner Olu\u015ftur": {
"main": [
[
{
"node": "Wait2",
"type": "main",
"index": 0
}
]
]
},
"Wait2": {
"main": [
[
{
"node": "Postu Payla\u015f",
"type": "main",
"index": 0
}
]
]
},
"Konu\u015fma Metni Yaz\u0131c\u0131": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
}
]
]
},
"Videoyu Al": {
"main": [
[
{
"node": "Post a\u00e7\u0131klama yaz\u0131c\u0131",
"type": "main",
"index": 0
},
{
"node": "Videoyu indir",
"type": "main",
"index": 0
}
]
]
},
"Sistem Promptlar\u0131": {
"main": [
[
{
"node": "keys",
"type": "main",
"index": 0
}
]
]
},
"Post a\u00e7\u0131klama yaz\u0131c\u0131": {
"main": [
[
{
"node": "Youtube Title Yaz\u0131c\u0131",
"type": "main",
"index": 0
}
]
]
},
"Youtube videosunu haz\u0131rla": {
"main": [
[
{
"node": "YouTube",
"type": "main",
"index": 0
}
]
]
},
"Postu Payla\u015f": {
"main": [
[]
]
},
"YouTube": {
"main": [
[
{
"node": "Google Sheets5",
"type": "main",
"index": 0
}
]
]
},
"Edit Fields": {
"main": [
[
{
"node": "Video \u00dcretim \u0130ste\u011fi",
"type": "main",
"index": 0
}
]
]
},
"Youtube Title Yaz\u0131c\u0131": {
"main": [
[
{
"node": "Youtube videosunu haz\u0131rla",
"type": "main",
"index": 0
}
]
]
},
"RSS Reader": {
"main": [
[
{
"node": "Remove Duplicates",
"type": "main",
"index": 0
}
]
]
},
"de\u011fi\u015fkenler": {
"main": [
[
{
"node": "RSS Reader",
"type": "main",
"index": 0
}
]
]
},
"Remove Duplicates": {
"main": [
[
{
"node": "Google Sheets",
"type": "main",
"index": 0
}
]
]
},
"Videoyu indir": {
"main": [
[
{
"node": "Drive'a y\u00fckle",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger1": {
"main": [
[
{
"node": "Sistem Promptlar\u0131",
"type": "main",
"index": 0
}
]
]
}
},
"active": false,
"settings": {
"executionOrder": "v1"
},
"versionId": "3cf80451-0ae0-45a2-a79b-2234e16b5f3e",
"meta": {
"templateCredsSetupCompleted": true
},
"id": "6O2UAu8F0QxX8fDc",
"tags": []
}
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.
facebookGraphApigoogleDriveOAuth2ApigoogleSheetsOAuth2ApiopenAiApiyouTubeOAuth2Api
Pro
For the full experience including quality scoring and batch install features for each workflow upgrade to Pro
About this workflow
Blogdan UGC (blogger). Uses googleSheets, httpRequest, facebookGraphApi, openAi. Scheduled trigger; 34 nodes.
Source: https://github.com/salihoglueyup/AxiarIntelligence/blob/c67e1f0a43a1b27fda421a5393f6cf5d6a06c814/axiarautomation/n8n-free-templates-main/blog_ugc_blogger.json — 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.
A production-ready n8n workflow that generates AI avatar videos from images and text using VEED Fabric 1.0, with flexible multi-platform publishing capabilities. Process any number of videos: Sequenti
Google Sheets, HTTP Request, OpenAI +6
This workflow demonstrates how to combine trend harvesting, channel intelligence, and AI scoring to select the best daily content ideas for short-form videos (YouTube Shorts / TikTok).
YouTube, OpenRouter Chat, RSS Feed Read +4
This workflow contains community nodes that are only compatible with the self-hosted version of n8n.
HTTP Request, Google Sheets, RSS Feed Read +3
Multi Platform Content Generator from YouTube using AI & RSS. Uses httpRequest, googleSheets, rssFeedRead, lmChatOpenRouter. Scheduled trigger; 37 nodes.
HTTP Request, Google Sheets, RSS Feed Read +3
Multi Platform Content Generator from YouTube using AI & RSS. Uses httpRequest, googleSheets, rssFeedRead, lmChatOpenRouter. Scheduled trigger; 37 nodes.
HTTP Request, Google Sheets, RSS Feed Read +3