Instagramビジュアル分析:Apifyスクレイピング、OpenAI GPT-5、Googleスプレッドシート統合

中級

これはMarket Research, Multimodal AI分野の自動化ワークフローで、13個のノードを含みます。主にFilter, SplitOut, HttpRequest, GoogleSheets, ManualTriggerなどのノードを使用。 Apifyによるスクレイピング、OpenAI GPT-5による分析、Googleスプレッドシートでのインスタグラムビジュアル分析

前提条件
  • ターゲットAPIの認証情報が必要な場合あり
  • Google Sheets API認証情報
  • OpenAI API Key
ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
  "meta": {
    "instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "5432b2ed-adde-4021-b6b3-e75e43bd102c",
      "name": "ワークフロー実行時",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1152,
        3984
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "5c21dec6-09d2-427e-89bc-2a1b809a0d40",
      "name": "詳細情報をクロール",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -400,
        3952
      ],
      "parameters": {
        "url": "=https://api.apify.com/v2/acts/apify~instagram-profile-scraper/run-sync-get-dataset-items\n",
        "method": "POST",
        "options": {},
        "jsonBody": "={\n    \"usernames\": [\n        \"{{ $json.User }}\"\n    ]\n}",
        "sendBody": true,
        "specifyBody": "json",
        "authentication": "genericCredentialType",
        "genericAuthType": "httpQueryAuth"
      },
      "credentials": {
        "httpQueryAuth": {
          "id": "wR5zdRq0CfAhl2yx",
          "name": "Query Auth account"
        }
      },
      "executeOnce": true,
      "typeVersion": 4.2
    },
    {
      "id": "5dd0aa9e-2197-46e4-adcc-c4fed6e0b002",
      "name": "Googleシートを取得",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -928,
        3984
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1dgkznTbUYCi6bzX_K2qRQT0WvmgTtPISWP9iyiLouyA/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1dgkznTbUYCi6bzX_K2qRQT0WvmgTtPISWP9iyiLouyA",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1dgkznTbUYCi6bzX_K2qRQT0WvmgTtPISWP9iyiLouyA/edit?usp=drivesdk",
          "cachedResultName": "Instagram Analysis"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "HlBW2puZbuCCq8jJ",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "f316f5b7-e4be-42fd-8eb4-730cd2a8759c",
      "name": "フィルター",
      "type": "n8n-nodes-base.filter",
      "position": [
        -672,
        3616
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "33016bc5-0c17-48c0-b77a-67c9b74584ac",
              "operator": {
                "type": "number",
                "operation": "equals"
              },
              "leftValue": "={{ $json.row_number }}",
              "rightValue": 2
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "37cf43bb-4e6b-462f-a34f-e0b4651e033d",
      "name": "AIエージェント",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        352,
        3568
      ],
      "parameters": {
        "text": "=image: data",
        "options": {
          "systemMessage": "to go the url provided. analyze what is in the image. output the analyis and the image",
          "passthroughBinaryImages": true
        },
        "promptType": "define"
      },
      "executeOnce": true,
      "typeVersion": 2.2
    },
    {
      "id": "a690587f-4d14-4087-b255-67a152cc75fa",
      "name": "OpenAIチャットモデル",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        192,
        4064
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-5",
          "cachedResultName": "gpt-5"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "4l6TDfLZVFS24g3X",
          "name": "OpenAi account 4"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "ac29d89e-49f2-4bbf-ba23-5fd00aa689d6",
      "name": "分割",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -176,
        3552
      ],
      "parameters": {
        "options": {},
        "fieldToSplitOut": "latestPosts"
      },
      "typeVersion": 1
    },
    {
      "id": "0ad175a5-c1c8-498e-b6b0-1c36aabacb8d",
      "name": "HTTPリクエスト",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        16,
        3568
      ],
      "parameters": {
        "url": "={{ $json.displayUrl }}",
        "options": {}
      },
      "executeOnce": true,
      "typeVersion": 4.2
    },
    {
      "id": "c5f57bab-6350-4bf0-8524-75cbbca86321",
      "name": "付箋53",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1248,
        3312
      ],
      "parameters": {
        "color": 7,
        "width": 2144,
        "height": 1056,
        "content": "### Scrape Instagram images with Apify and analyze them using OpenAI in n8n for fast visual insights (Google Sheets + HTTP + OpenAI)\n\nPull recent Instagram post media for any username, fetch the image binaries, and run automated **visual analysis** with OpenAI — all orchestrated in n8n. Use a Google Sheet to supply target usernames and store results anywhere you like.\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "38a41e2a-85bd-4e73-9513-1cc6b3277735",
      "name": "付箋1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1696,
        3312
      ],
      "parameters": {
        "width": 400,
        "height": 1056,
        "content": "\n\n## ⚙️ Setup (minimal credentials)\n### 1) Connect Google Sheets (OAuth2)\n1. In **n8n → Credentials → New → Google Sheets (OAuth2)**  \n2. Sign in with your Google account and grant access  \n3. In the **Get Google Sheet** node, select your **Spreadsheet** and **Worksheet** with a `user` column (the example uses the “Multi Scraper” sheet)\n\n### 2) Connect Apify (HTTP Query Auth)\n1. Get your **Apify API token** (Apify Console → *Integrations/API*)  \n2. In **n8n → Credentials → New → HTTP Query Auth**, add a query param `token=<YOUR_APIFY_TOKEN>`  \n3. In the **Scrape Details** node, pick that credential. The URL is set to  \n   `https://api.apify.com/v2/acts/apify~instagram-profile-scraper/run-sync-get-dataset-items`  \n   The body passes `usernames: [\"{{$json.user}}\"]` from the Google Sheet row.\n\n### 3) Connect OpenAI (API Key)\n1. In **n8n → Credentials → New → OpenAI API**  \n2. Paste your **OpenAI API key**  \n3. In **OpenAI Chat Model**, select your credential and a **vision-capable** chat model (e.g., `gpt-4o-mini`, `gpt-4o`, or your configured vision model)\n\n> That’s it. No other services required.\n\n-\n\n## 📬 Contact  \nNeed help customizing this (e.g., filtering by campaign, sending reports by email, or formatting your PDF)?  \n\n- 📧 **rbreen@ynteractive.com**  \n- 🔗 **[Robert Breen](https://www.linkedin.com/in/robert-breen-29429625/)**  \n- 🌐 **[ynteractive.com](https://ynteractive.com)**\n"
      },
      "typeVersion": 1
    },
    {
      "id": "e8a37bc8-a2db-4eea-ae7f-3b13b647f6e5",
      "name": "付箋61",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -992,
        3664
      ],
      "parameters": {
        "color": 3,
        "width": 224,
        "height": 496,
        "content": "### 1) Connect Google Sheets (OAuth2)\n1. In **n8n → Credentials → New → Google Sheets (OAuth2)**  \n2. Sign in with your Google account and grant access  \n3. In the **Get Google Sheet** node, select your **Spreadsheet** and **Worksheet** with a `user` column (the example uses the “Multi Scraper” sheet)\n"
      },
      "typeVersion": 1
    },
    {
      "id": "b24c1d5f-9070-4578-bd70-6c4711545818",
      "name": "付箋63",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -464,
        3504
      ],
      "parameters": {
        "color": 3,
        "width": 224,
        "height": 640,
        "content": "### 2) Connect Apify (HTTP Query Auth)\n1. Get your **Apify API token** (Apify Console → *Integrations/API*)  \n2. In **n8n → Credentials → New → HTTP Query Auth**, add a query param `token=<YOUR_APIFY_TOKEN>`  \n3. In the **Scrape Details** node, pick that credential. The URL is set to  \n   `https://api.apify.com/v2/acts/apify~instagram-profile-scraper/run-sync-get-dataset-items`  \n   The body passes `usernames: [\"{{$json.user}}\"]` from the Google Sheet row.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "23416d72-b9e9-4ab1-8b57-8a8a1f0cfcfe",
      "name": "付箋64",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        112,
        3776
      ],
      "parameters": {
        "color": 3,
        "width": 224,
        "height": 400,
        "content": "### 3) Connect OpenAI (API Key)\n1. In **n8n → Credentials → New → OpenAI API**  \n2. Paste your **OpenAI API key**  \n3. In **OpenAI Chat Model**, select your credential and a **vision-capable** chat model (e.g., `gpt-4o-mini`, `gpt-4o`, or your configured vision model)\n"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "f316f5b7-e4be-42fd-8eb4-730cd2a8759c": {
      "main": [
        [
          {
            "node": "5c21dec6-09d2-427e-89bc-2a1b809a0d40",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ac29d89e-49f2-4bbf-ba23-5fd00aa689d6": {
      "main": [
        [
          {
            "node": "0ad175a5-c1c8-498e-b6b0-1c36aabacb8d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0ad175a5-c1c8-498e-b6b0-1c36aabacb8d": {
      "main": [
        [
          {
            "node": "37cf43bb-4e6b-462f-a34f-e0b4651e033d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5c21dec6-09d2-427e-89bc-2a1b809a0d40": {
      "main": [
        [
          {
            "node": "ac29d89e-49f2-4bbf-ba23-5fd00aa689d6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5dd0aa9e-2197-46e4-adcc-c4fed6e0b002": {
      "main": [
        [
          {
            "node": "f316f5b7-e4be-42fd-8eb4-730cd2a8759c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a690587f-4d14-4087-b255-67a152cc75fa": {
      "ai_languageModel": [
        [
          {
            "node": "37cf43bb-4e6b-462f-a34f-e0b4651e033d",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "5432b2ed-adde-4021-b6b3-e75e43bd102c": {
      "main": [
        [
          {
            "node": "5dd0aa9e-2197-46e4-adcc-c4fed6e0b002",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
よくある質問

このワークフローの使い方は?

上記のJSON設定コードをコピーし、n8nインスタンスで新しいワークフローを作成して「JSONからインポート」を選択、設定を貼り付けて認証情報を必要に応じて変更してください。

このワークフローはどんな場面に適していますか?

中級 - 市場調査, マルチモーダルAI

有料ですか?

このワークフローは完全無料です。ただし、ワークフローで使用するサードパーティサービス(OpenAI APIなど)は別途料金が発生する場合があります。

関連ワークフロー

AI生成LinkedIn投稿(人間による承認付き)
GPT-4、GoToHuman、Blotatoを使用したAI生成LinkedIn投稿(人間による承認付き)
Code
Merge
Filter
+
Code
Merge
Filter
19 ノードRobert Breen
ソーシャルメディア
Apify + GPT-4o-mini を使ってタグ分析から Instagram キャプションを生成
Apify + GPT-4o-mini を使ってタグ分析から Instagram キャプションを生成
Set
Code
Merge
+
Set
Code
Merge
17 ノードRobert Breen
コンテンツ作成
Google Sheets、SerpAPI、Apify、GPT-4o を使ってローカル企業の連絡先を抽出
Google Sheets、SerpAPI、Apify、GPT-4oを使ってローカルの企業連絡先を取得する
Code
Filter
Summarize
+
Code
Filter
Summarize
18 ノードRobert Breen
リード獲得
ブログコンテンツの多言語自動翻訳
GPT-4oとMarkdownを使用してブログ記事を自動で複数の言語に翻訳
Set
Merge
Split Out
+
Set
Merge
Split Out
12 ノードRobert Breen
コンテンツ作成
リアルタイムSEOキーワードリサーチツール
DataForSEOとGoogleスプレッドシートを使ってリアルタイムSEOキーワード調査を自動化
Set
Filter
Split Out
+
Set
Filter
Split Out
37 ノードAgent Circle
市場調査
Indeedの求人情報スクレイピングとGPT-4o-miniを使った自動職業紹介状ジェネレーター
Indeed 求人クリーニングと GPT-4o-mini を用いた自動求職者レターゲンエイター
Set
Http Request
Manual Trigger
+
Set
Http Request
Manual Trigger
10 ノードRobert Breen
マルチモーダルAI
ワークフロー情報
難易度
中級
ノード数13
カテゴリー2
ノードタイプ8
難易度説明

経験者向け、6-15ノードの中程度の複雑さのワークフロー

作成者
Robert Breen

Robert Breen

@rbreen

Professional services consultant with over 10 years of experience solving complex business problems across industries. I specialize in n8n and process automation—designing custom workflows that integrate tools like Google Calendar, Airtable, GPT, and internal systems. Whether you need to automate scheduling, sync data, or streamline operations, I build solutions that save time and drive results.

外部リンク
n8n.ioで表示

このワークフローを共有

カテゴリー

カテゴリー: 34