Claude AI、DALL-E 画像、Google Sheets で LinkedIn 投稿を自動化して承認
上級
これはAI, Marketing分野の自動化ワークフローで、28個のノードを含みます。主にSet, Code, Wait, Limit, Twitterなどのノードを使用、AI技術を活用したスマート自動化を実現。 Claude AI、DALL-E 画像、Google Sheets で LinkedIn 投稿を自動承認
前提条件
- •Twitter API認証情報
- •LinkedIn API認証情報
- •Google Drive API認証情報
- •ターゲットAPIの認証情報が必要な場合あり
- •Google Sheets API認証情報
- •Facebook Graph API認証情報
- •Anthropic API Key
使用ノード (28)
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
"meta": {
"instanceId": "4e229722e6c43a4914d2d66178b48335adf795d73afbee5b0ea0c52938ef4d8e"
},
"nodes": [
{
"id": "2d694354-6ab0-42fd-abbf-d3085813fd49",
"name": "アイデア生成",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1100,
200
],
"parameters": {
"text": "=Generate materials for my next LinkedIn post.\n\nHere are the ideas that we've already used: {{ $json.mergedText }}.\n\nCome up with a new, super valuable and concrete post, and prepare all the needed materials for it:\n- idea\n- title\n- text\n- image description\n\nUse the least used bucket of content (out of my 4 buckets).\n\nBegin:",
"options": {
"systemMessage": "=ROLE: You're an expert in viral LinkedIn posts content creation with 10 years of experience. You've created viral posts that have gotten 10 billion views in total.\n\nOBJECTIVE: Your goal is to write a 1) name, 2) idea, 3) title, 4) text, and 5) image description for my next LinkedIn Post. They should be super valuable to my audience.\n\nSCENARIO: I run a LinkedIn blog about marketing and sales. My audience is marketers, salespeople, founders, B2B business owners, B2C business owners, brands. My goal is to help them build better brands with valuable, and practical content. \nI have 4 main buckets of content on my page:\n1) timeless principles. ideas for this videos are taken from timeless books: Influnece and Pre-Suasion by Robert Cialdini, $100M Leads and $100M Offers by Alex Hormozi, Ogilvy on Advertising.\n2) case studies. for instance a case study breaking down on of the famous ads from the latest SuperBowl.\n3) growth hacks. latest trends on how to grow with a proof. for instance an SEO tactic that became known in the last year.\n4) contraversial ads. breakdowns of interesting and famous contraversial ads.\nEvery video that I post is focused solely on one of the content buckets. That makes my content more diverse and covering more cool topics.\n\nEXPECTATION: Write me 1) name (short name for the post, less than 50 characters), 2) idea (detailed description in 3 sentences max), 3) title (the first sentence of the post, less than 80 characters, it should be ultra hooking), 4) full text of the post, 5) image description (the image is the first thing people will look at, so make it ultra hooking; write the image description to be super clear and ultra simple, so the AI image generator will precisely know that to generate; the image should be minimalistic) for a 200-300 words LinkedIn post from one of the content buckets described above.\nMake sure to have great: hook, retention, and reward at the end.\nThe post should clearly lead to a marketing/sales insight.\nYour output should be in the JSON format.\nIdea should always start with a category: Timeless principle, Case study, Growth hack, Contraversial ad.\nExample output:\n{\"name\": \"The Power of Social Proof\",\n\"idea\": \"Timeless principle: Social proof is a psychological phenomenon that influences decision-making by showing how others' actions affect our own choices. It works universally across physical spaces and digital platforms. Marketers who strategically implement social proof elements can significantly increase conversion rates and customer trust.\",\n\"title\": \"Why we can't resist looking up when others do (and what it means for sales)\",\n\"text\": \"Why we can't resist looking up when others do (and what it means for sales)\\n\\nA psychology experiment once placed actors on a street corner to stare upward at nothing.\\n\\nWithin minutes, dozens of passersby stopped to look up too.\\n\\nThis is social proof in action—our natural tendency to follow others when uncertain.\\n\\nIn marketing, this same principle powers your conversion rates.\\n\\nNotice how differently you perceive:\\n\\n• A product with 5,000+ five-star reviews\\n• A service used by \\\"67% of Fortune 500 companies\\\"\\n• A landing page showing \\\"10,000+ satisfied customers\\\"\\n\\nCompared to identical offerings without these trust signals.\\n\\nBut here's what many marketers miss: social proof must feel authentic to work.\\n\\nGeneric testimonials or inflated numbers create skepticism, not confidence.\\n\\nThe most effective social proof strategies I've implemented for clients:\\n\\n1. Specificity: \\\"503 marketing agencies use our platform daily\\\" beats \\\"Hundreds of satisfied customers\\\"\\n\\n2. Relevance: Highlight testimonials from users who match your prospect's profile\\n\\n3. Recency: Fresh testimonials outperform older ones by 35% in our tests\\n\\n4. Visibility: Place social proof elements near decision points (like \\\"Buy Now\\\" buttons)\\n\\nImplement these four tactics, and you'll see the same psychological force that makes us look up at the sky work to increase your conversion rates.\\n\\nWhat's your most effective social proof strategy? Share below.\",\n\"image\": \"Simple black background with grainy texture. Six basic stick figure silhouettes in white - five figures on the left all looking up, one figure on the right just starting to look up. Bold text in Inter Bold font at the center reads \\\"FOLLOW THE CROWD\\\" with \\\"FOLLOW\\\" in white and \\\"CROWD\\\" in light green (#cff150). No other elements or details. Clean, minimal design with plenty of empty space.\"}\nNOTES:\n- THE BACKGROUND OF THE IMAGE SHOULD ALWAYS BE BLACK AND DARK GRAINY FILM\nTo accomplish your task you can use the web search."
},
"promptType": "define",
"hasOutputParser": true
},
"retryOnFail": true,
"typeVersion": 1.7
},
{
"id": "991032b8-6839-4c5a-9df9-6e8e7a924c9e",
"name": "付箋7",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
100
],
"parameters": {
"color": 6,
"width": 980,
"height": 480,
"content": "# Generate a New Post Idea and All Materials"
},
"typeVersion": 1
},
{
"id": "40294f91-5002-44a2-91e7-5bee74c30698",
"name": "付箋8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1480,
100
],
"parameters": {
"color": 6,
"width": 1140,
"height": 480,
"content": "# Generate an Image and Save"
},
"typeVersion": 1
},
{
"id": "b3e2d972-f763-4fa5-88eb-bbb1afa7fc2d",
"name": "構造化出力パーサー",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1300,
400
],
"parameters": {
"jsonSchemaExample": "{\n\t\"name\": \"name\",\n \"idea\": \"idea\",\n \"title\": \"title\",\n \"text\": \"text\",\n \"image\": \"image\"\n}"
},
"typeVersion": 1.2
},
{
"id": "77a4755a-0d64-4bce-b8a1-90b649d21039",
"name": "Anthropicチャットモデル",
"type": "@n8n/n8n-nodes-langchain.lmChatAnthropic",
"position": [
960,
400
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "claude-3-7-sonnet-20250219",
"cachedResultName": "Claude 3.7 Sonnet"
},
"options": {}
},
"typeVersion": 1.3
},
{
"id": "431ac158-ed33-4fdc-ae28-9a8fe1829f7e",
"name": "Perplexityリサーチ",
"type": "@n8n/n8n-nodes-langchain.toolWorkflow",
"position": [
1120,
400
],
"parameters": {
"name": "web_search",
"workflowId": {
"__rl": true,
"mode": "list",
"value": "eALld0YaOZuUCU5q",
"cachedResultName": "Perplexity Research"
},
"description": "Call this tool to make a web search query using Perplexity AI. It will automatically look at multiple relevant websites and combine all the valuable information in one clean response.",
"workflowInputs": {
"value": {},
"schema": [
{
"id": "query",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "query",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"query"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
}
},
"typeVersion": 2.1
},
{
"id": "9098aa0e-e707-4825-a848-50f8a3ad767d",
"name": "ファイルに変換",
"type": "n8n-nodes-base.convertToFile",
"position": [
1960,
280
],
"parameters": {
"options": {},
"operation": "toBinary",
"sourceProperty": "data[0].b64_json"
},
"typeVersion": 1.1
},
{
"id": "e7782adf-936a-47a5-8174-469e9d439b76",
"name": "スケジュール",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
560,
200
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 5
}
]
}
},
"typeVersion": 1.2
},
{
"id": "67704ef3-a0b3-4401-88aa-edc9b332c5fb",
"name": "アイデアを結合",
"type": "n8n-nodes-base.code",
"position": [
920,
200
],
"parameters": {
"jsCode": "// Get all incoming items\nconst items = $input.all();\n\n// Extract the text field from each item\nconst texts = items.map(item => item.json.idea);\n\n// Concatenate them (adjust the separator as needed)\nconst concatenated = texts.join(\", \");\n\n// Return a single item with the concatenated text\nreturn [{ json: { mergedText: concatenated } }];"
},
"typeVersion": 2
},
{
"id": "766ba040-6217-460e-a285-7dd3fe612654",
"name": "一つを選択",
"type": "n8n-nodes-base.limit",
"position": [
920,
700
],
"parameters": {},
"typeVersion": 1
},
{
"id": "ab433d53-9946-4778-bb59-bf636388da03",
"name": "付箋1",
"type": "n8n-nodes-base.stickyNote",
"position": [
480,
600
],
"parameters": {
"color": 4,
"width": 1340,
"height": 300,
"content": "# Auto Posting"
},
"typeVersion": 1
},
{
"id": "35b01ea3-8a91-4bdb-8b0b-e1e99f3c0482",
"name": "X",
"type": "n8n-nodes-base.twitter",
"disabled": true,
"position": [
1140,
980
],
"parameters": {
"additionalFields": {}
},
"typeVersion": 2
},
{
"id": "25628428-075e-449c-8585-fc33d9185522",
"name": "Instagram API用データ準備",
"type": "n8n-nodes-base.set",
"disabled": true,
"position": [
1400,
980
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "8a4260ba-3bde-4444-8f42-8a8abd51ff0c",
"name": "ImageURL",
"type": "string",
"value": "={{ $json.output }}"
},
{
"id": "1953ae03-6a86-4847-8686-5a928637be1d",
"name": "Caption",
"type": "string",
"value": "={{ $('3c. Generate Post Caption (Gemini)').item.json.output.Caption }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "61af7e71-5470-44a1-a157-2c15311b9dff",
"name": "Instagramメディアコンテナ作成",
"type": "n8n-nodes-base.facebookGraphApi",
"disabled": true,
"position": [
1580,
980
],
"parameters": {
"edge": "media",
"node": "17841473009917118",
"options": {
"queryParameters": {
"parameter": [
{
"name": "caption",
"value": "={{ $json.Caption }}"
},
{
"name": "image_url",
"value": "={{ $json.ImageURL }}"
}
]
}
},
"graphApiVersion": "v22.0",
"httpRequestMethod": "POST"
},
"typeVersion": 1
},
{
"id": "177e67d6-2783-4691-a90f-4b6fb398ab5e",
"name": "コンテナ処理待機",
"type": "n8n-nodes-base.wait",
"disabled": true,
"position": [
1780,
980
],
"webhookId": "1b14c8bf-151a-4054-8215-093dd5b6cbcc",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "8ef68b10-af6c-4f05-91ae-43586098b051",
"name": "Instagramへの投稿公開",
"type": "n8n-nodes-base.facebookGraphApi",
"disabled": true,
"position": [
1980,
980
],
"parameters": {
"edge": "media_publish",
"node": "17841473009917118",
"options": {
"queryParameters": {
"parameter": [
{
"name": "creation_id",
"value": "={{ $json.id }}"
}
]
}
},
"graphApiVersion": "v22.0",
"httpRequestMethod": "POST"
},
"typeVersion": 1
},
{
"id": "9702cd17-9bd3-429e-842e-56089b50d50b",
"name": "付箋",
"type": "n8n-nodes-base.stickyNote",
"position": [
1080,
920
],
"parameters": {
"width": 1120,
"height": 260,
"content": "## Twitter & Instagram"
},
"typeVersion": 1
},
{
"id": "8633b8e7-0119-4b60-a42e-362e26134772",
"name": "付箋6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-260,
100
],
"parameters": {
"width": 720,
"height": 1800,
"content": "# 🛠️ Setup Guide \n**Author:** [Usman Liaqat](https://www.linkedin.com/in/usmanliaqat404)\n\nThis guide will walk you through the 7 steps to fully configure your automation workflow using Google Sheets, Google Drive, Anthropic, OpenAI, Perplexity AI and LinkedIn.\n\n---\n\n## ✅ Step 1: Set Up Google Sheets Credential\n1. In the n8n Google Sheets node create a new credential using your Google account\n\n---\n\n## ✅ Step 2: Set Up Google Drive Credential\n1. Go to the [Google Cloud Console](https://console.cloud.google.com) and create or select a project\n2. Enable the Google Drive API under APIs & Services > Library\n3. Still in APIs & Services, select Credentials from the left menu\n4. Click + CREATE CREDENTIALS > OAuth client ID\n5. For Application type, choose Web application\n6. Under Authorized redirect URIs, paste the OAuth Redirect URL: https://oauth.n8n.cloud/oauth2/callback\n7. Click Create, then copy the Client ID and Client Secret shown in the modal\n8. In the n8n Google Drive node click Create Credential\n9. Paste in the Client ID and Client Secret from Google Cloud\n10. Click Sign in with Google, complete the OAuth consent flow, then Save your credential\n\n---\n\n## ✅ Step 3: Set Up Anthropic Credential\n1. Navigate to the [Anthropic Console](https://console.anthropic.com/) and sign in or sign up\n2. Generate an API key\n3. In the n8n \"Anthropic Chat Model\" node click Create Credential, past the API key and save\n\n---\n\n## ✅ Step 4: Configure OpenAI via HTTP Request Node\n1. Visit the [OpenAI API Keys](https://platform.openai.com/account/api-keys) page and create a new secret key\n2. In the n8n OpenAI Image node in the Authentication select Generic Credential Type\n3. In Generic Auth Type select Header Auth\n4. Create a new Header Auth, Name = Authorization, Value = Bearer YOUR_TOKEN\n\n---\n\n## ✅ Step 5: Configure Perplexity AI via HTTP Request Node\n1. Go to the [Perplexity API Portal](https://www.perplexity.ai/account/api/keys) and click Create Key\n2. Copy the generated API key\n3. Inside n8n, in the sub-workflow, open the Perplexity Research node\n4. In the Authentication select Generic Credential Type\n5. In Generic Auth Type select Header Auth\n6. Create a new Header Auth, Name = Authorization, Value = Bearer YOUR_TOKEN\n\n---\n\n## ✅ Step 6: Set Up LinkedIn Credential\n1. In the n8n LinkedIn node create a new credential using your LinkedIn account\n\n---\n\n## ✅ Step 7: Customize The System For Your Use Case\n1. In the Idea Generator node adjust the prompts to reflect your content style and your topics\n2. Create a folder in your Google Drive where you will store all the images\n3. Put in that folder the image with the style of your brand, that you want to replicate every time\n4. Paste the shared link to this image in the \"Image Style\" node\n5. In the OpenAI Image node adjust the prompt to reflect your image style\n6. Copy my [Google Sheet](https://docs.google.com/spreadsheets/d/1-F3ZioIs3oWOKMyDPMuquaH-qiuaZs6qdZXP-yNeRbs/edit?usp=sharing)\n7. Select your Google Sheet in the Google Sheets nodes\n8. Activate the system, now every day a new post will be created inside the Google Sheet, and once you've reviewed it (might edit it as well), set the status to \"ready\" and it will be posted; the posting mechanism is set to work every day, one post at a time\n\n---\n\nNow you're ready to run your workflow. Happy automating!\n"
},
"typeVersion": 1
},
{
"id": "e853ea9d-5b19-4b7b-8dc4-110bcc481471",
"name": "OpenAI画像",
"type": "n8n-nodes-base.httpRequest",
"position": [
1760,
280
],
"parameters": {
"url": "https://api.openai.com/v1/images/edits",
"method": "POST",
"options": {},
"sendBody": true,
"contentType": "multipart-form-data",
"authentication": "genericCredentialType",
"bodyParameters": {
"parameters": [
{
"name": "model",
"value": "gpt-image-1"
},
{
"name": "image",
"parameterType": "formBinaryData",
"inputDataFieldName": "data"
},
{
"name": "prompt",
"value": "=You're a professional graphic designer.\n\nMake a new image in the style very very similar to the reference.\n\nCopy the style, spacing, minimalistic structure, especially copy the FONTS, and everything else.\n\nUse black and dark grainy film (mainly for the background), white and salad green (#cff150).\n\nMake the image super aestetic and minimalistic.\n\nMake it vertical 3x4.\n\nIt will be an image for a LinkedIn post.\n\nHere is the description of the new image:\n{{ $('Idea Generator').item.json.output.image }}"
}
]
},
"genericAuthType": "httpHeaderAuth"
},
"typeVersion": 4.2
},
{
"id": "2642278d-235c-46f0-994e-aa1ebec5ae64",
"name": "画像スタイル",
"type": "n8n-nodes-base.googleDrive",
"position": [
1540,
280
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "url",
"value": "=https://drive.google.com/file/d/1wm4anhC6ygXl4ZJAjJryWfEXTG-VeH8s/view?usp=sharing"
},
"options": {},
"operation": "download"
},
"typeVersion": 3
},
{
"id": "31218124-74e6-4117-bd76-125545aaf969",
"name": "過去のアイデア取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
740,
200
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-F3ZioIs3oWOKMyDPMuquaH-qiuaZs6qdZXP-yNeRbs/edit#gid=0",
"cachedResultName": "Posts"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1-F3ZioIs3oWOKMyDPMuquaH-qiuaZs6qdZXP-yNeRbs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-F3ZioIs3oWOKMyDPMuquaH-qiuaZs6qdZXP-yNeRbs/edit?usp=drivesdk",
"cachedResultName": "AI Posts Content Machine"
}
},
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "b4776d32-d742-42d8-8454-048ccadc8ecd",
"name": "画像保存",
"type": "n8n-nodes-base.googleDrive",
"position": [
2180,
280
],
"parameters": {
"name": "={{ $('Idea Generator').item.json.output.name }}",
"driveId": {
"__rl": true,
"mode": "list",
"value": "My Drive"
},
"options": {},
"folderId": {
"__rl": true,
"mode": "list",
"value": "1PZW0Hef8yKwKtBZuRxZAMkakzdyyP0iZ",
"cachedResultUrl": "https://drive.google.com/drive/folders/1PZW0Hef8yKwKtBZuRxZAMkakzdyyP0iZ",
"cachedResultName": "AI Posts Content Machine"
}
},
"typeVersion": 3
},
{
"id": "c6a71846-4538-4204-9ddc-f5c0fb18ac1a",
"name": "投稿保存",
"type": "n8n-nodes-base.googleSheets",
"position": [
2380,
280
],
"parameters": {
"columns": {
"value": {
"idea": "={{ $('Idea Generator').item.json.output.idea }}",
"name": "={{ $('Idea Generator').item.json.output.name }}",
"text": "={{ $('Idea Generator').item.json.output.text }}",
"image": "={{ $json.webViewLink.replace(/usp=[^&]+/, 'usp=sharing') }}",
"status": "review"
},
"schema": [
{
"id": "name",
"type": "string",
"display": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "idea",
"type": "string",
"display": true,
"required": false,
"displayName": "idea",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "text",
"type": "string",
"display": true,
"required": false,
"displayName": "text",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "image",
"type": "string",
"display": true,
"required": false,
"displayName": "image",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"required": false,
"displayName": "status",
"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-F3ZioIs3oWOKMyDPMuquaH-qiuaZs6qdZXP-yNeRbs/edit#gid=0",
"cachedResultName": "Posts"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1-F3ZioIs3oWOKMyDPMuquaH-qiuaZs6qdZXP-yNeRbs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-F3ZioIs3oWOKMyDPMuquaH-qiuaZs6qdZXP-yNeRbs/edit?usp=drivesdk",
"cachedResultName": "AI Posts Content Machine"
}
},
"typeVersion": 4.5
},
{
"id": "7b8e2c00-2c14-4bb7-acee-0181990e9434",
"name": "スケジュール2",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
560,
700
],
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 16
}
]
}
},
"typeVersion": 1.2
},
{
"id": "66c0ae82-6ba3-4fa0-8033-3726796cdc0a",
"name": "準備済み投稿取得",
"type": "n8n-nodes-base.googleSheets",
"position": [
740,
700
],
"parameters": {
"options": {},
"filtersUI": {
"values": [
{
"lookupValue": "ready",
"lookupColumn": "status"
}
]
},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-F3ZioIs3oWOKMyDPMuquaH-qiuaZs6qdZXP-yNeRbs/edit#gid=0",
"cachedResultName": "Posts"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1-F3ZioIs3oWOKMyDPMuquaH-qiuaZs6qdZXP-yNeRbs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-F3ZioIs3oWOKMyDPMuquaH-qiuaZs6qdZXP-yNeRbs/edit?usp=drivesdk",
"cachedResultName": "AI Posts Content Machine"
}
},
"typeVersion": 4.5
},
{
"id": "7ee9c81f-00ca-4f89-95bb-61d224b06a2e",
"name": "画像ダウンロード",
"type": "n8n-nodes-base.googleDrive",
"position": [
1120,
700
],
"parameters": {
"fileId": {
"__rl": true,
"mode": "url",
"value": "={{ $json.image }}"
},
"options": {},
"operation": "download"
},
"typeVersion": 3
},
{
"id": "94fbbd95-fe52-4eda-ac78-2201ff72fe50",
"name": "投稿公開",
"type": "n8n-nodes-base.linkedIn",
"position": [
1320,
700
],
"parameters": {
"text": "={{ $json.text }}",
"person": "-NknGiXASA",
"additionalFields": {},
"shareMediaCategory": "IMAGE"
},
"typeVersion": 1
},
{
"id": "0893a7f2-490b-49f1-96cb-56090cb59c10",
"name": "ステータス更新",
"type": "n8n-nodes-base.googleSheets",
"position": [
1520,
700
],
"parameters": {
"columns": {
"value": {
"name": "={{ $('Pick One').item.json.name }}",
"status": "posted"
},
"schema": [
{
"id": "name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "idea",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "idea",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "text",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "text",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "image",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "image",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"required": false,
"displayName": "status",
"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": [
"name"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "update",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-F3ZioIs3oWOKMyDPMuquaH-qiuaZs6qdZXP-yNeRbs/edit#gid=0",
"cachedResultName": "Posts"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1-F3ZioIs3oWOKMyDPMuquaH-qiuaZs6qdZXP-yNeRbs",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1-F3ZioIs3oWOKMyDPMuquaH-qiuaZs6qdZXP-yNeRbs/edit?usp=drivesdk",
"cachedResultName": "AI Posts Content Machine"
}
},
"typeVersion": 4.5
}
],
"pinData": {},
"connections": {
"766ba040-6217-460e-a285-7dd3fe612654": {
"main": [
[
{
"node": "7ee9c81f-00ca-4f89-95bb-61d224b06a2e",
"type": "main",
"index": 0
}
]
]
},
"e7782adf-936a-47a5-8174-469e9d439b76": {
"main": [
[
{
"node": "31218124-74e6-4117-bd76-125545aaf969",
"type": "main",
"index": 0
}
]
]
},
"67704ef3-a0b3-4401-88aa-edc9b332c5fb": {
"main": [
[
{
"node": "2d694354-6ab0-42fd-abbf-d3085813fd49",
"type": "main",
"index": 0
}
]
]
},
"b4776d32-d742-42d8-8454-048ccadc8ecd": {
"main": [
[
{
"node": "c6a71846-4538-4204-9ddc-f5c0fb18ac1a",
"type": "main",
"index": 0
}
]
]
},
"7b8e2c00-2c14-4bb7-acee-0181990e9434": {
"main": [
[
{
"node": "66c0ae82-6ba3-4fa0-8033-3726796cdc0a",
"type": "main",
"index": 0
}
]
]
},
"2642278d-235c-46f0-994e-aa1ebec5ae64": {
"main": [
[
{
"node": "e853ea9d-5b19-4b7b-8dc4-110bcc481471",
"type": "main",
"index": 0
}
]
]
},
"e853ea9d-5b19-4b7b-8dc4-110bcc481471": {
"main": [
[
{
"node": "9098aa0e-e707-4825-a848-50f8a3ad767d",
"type": "main",
"index": 0
}
]
]
},
"94fbbd95-fe52-4eda-ac78-2201ff72fe50": {
"main": [
[
{
"node": "0893a7f2-490b-49f1-96cb-56090cb59c10",
"type": "main",
"index": 0
}
]
]
},
"7ee9c81f-00ca-4f89-95bb-61d224b06a2e": {
"main": [
[
{
"node": "94fbbd95-fe52-4eda-ac78-2201ff72fe50",
"type": "main",
"index": 0
}
]
]
},
"31218124-74e6-4117-bd76-125545aaf969": {
"main": [
[
{
"node": "67704ef3-a0b3-4401-88aa-edc9b332c5fb",
"type": "main",
"index": 0
}
]
]
},
"2d694354-6ab0-42fd-abbf-d3085813fd49": {
"main": [
[
{
"node": "2642278d-235c-46f0-994e-aa1ebec5ae64",
"type": "main",
"index": 0
}
]
]
},
"9098aa0e-e707-4825-a848-50f8a3ad767d": {
"main": [
[
{
"node": "b4776d32-d742-42d8-8454-048ccadc8ecd",
"type": "main",
"index": 0
}
]
]
},
"66c0ae82-6ba3-4fa0-8033-3726796cdc0a": {
"main": [
[
{
"node": "766ba040-6217-460e-a285-7dd3fe612654",
"type": "main",
"index": 0
}
]
]
},
"431ac158-ed33-4fdc-ae28-9a8fe1829f7e": {
"ai_tool": [
[
{
"node": "2d694354-6ab0-42fd-abbf-d3085813fd49",
"type": "ai_tool",
"index": 0
}
]
]
},
"77a4755a-0d64-4bce-b8a1-90b649d21039": {
"ai_languageModel": [
[
{
"node": "2d694354-6ab0-42fd-abbf-d3085813fd49",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"b3e2d972-f763-4fa5-88eb-bbb1afa7fc2d": {
"ai_outputParser": [
[
{
"node": "2d694354-6ab0-42fd-abbf-d3085813fd49",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"177e67d6-2783-4691-a90f-4b6fb398ab5e": {
"main": [
[
{
"node": "8ef68b10-af6c-4f05-91ae-43586098b051",
"type": "main",
"index": 0
}
]
]
},
"25628428-075e-449c-8585-fc33d9185522": {
"main": [
[
{
"node": "61af7e71-5470-44a1-a157-2c15311b9dff",
"type": "main",
"index": 0
}
]
]
},
"61af7e71-5470-44a1-a157-2c15311b9dff": {
"main": [
[
{
"node": "177e67d6-2783-4691-a90f-4b6fb398ab5e",
"type": "main",
"index": 0
}
]
]
}
}
}よくある質問
このワークフローの使い方は?
上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。
このワークフローはどんな場面に適していますか?
上級 - 人工知能, マーケティング
有料ですか?
このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス(OpenAI APIなど)は別途料金が発生する場合があります。
関連ワークフロー
ブログ投稿自動化とSNSプロモーションエージェント
GPT-4、Perplexity、WordPressを使用したSEOブログ作成の自動化+ソーシャルメディア
Set
Code
Gmail
+
Set
Code
Gmail
79 ノードLukaszB
デザイン
AI、ElevenLabs、マルチプラットフォーム公開を使ってPOVビデオの作成と承認
AI、ElevenLabs、そしてマルチプラットフォーム公開を使ったPOVビデオの作成と承認(TikTok/IG/YT)
If
Set
Code
+
If
Set
Code
60 ノードImmanuel
デザイン
n8nノードの探索(可視化リファレンスライブラリ内)
n8nノードを可視化リファレンスライブラリで探索
If
Ftp
Set
+
If
Ftp
Set
113 ノードI versus AI
その他
AI、ElevenLabs、PIAPI Shotstack / Creatomate を使用して動画を作成し、YouTube に投稿
AI、ElevenLabs、PIAPI Shotstack/Creatomate を使用して動画を生成し、YouTube に投稿
If
Set
Code
+
If
Set
Code
79 ノードImmanuel
人工知能
[テンプレート] AIペットショップ v8
AIペットショップアシスタント - GPT-4o、Googleカレンダー、WhatsApp/Instagram/Facebookを統合
If
N8n
Set
+
If
N8n
Set
244 ノードAmanda Benks
営業
ペットショップ 4
ペットショップ予約AIエージェント
If
Set
Code
+
If
Set
Code
187 ノードBruno Dias
人工知能