Meta広告のインサイトを取得してGoogleスプレッドシートに保存

上級

これはMarketing分野の自動化ワークフローで、20個のノードを含みます。主にFilter, SplitOut, GoogleSheets, ManualTrigger, ScheduleTriggerなどのノードを使用。 Meta の広告インサイトを取得して Google スプシッドシートに保存

前提条件
  • Google Sheets API認証情報
  • Facebook Graph API認証情報

カテゴリー

ワークフロープレビュー
ノード接続関係を可視化、ズームとパンをサポート
ワークフローをエクスポート
以下のJSON設定をn8nにインポートして、このワークフローを使用できます
{
  "nodes": [
    {
      "id": "82313e22-7fea-4d64-95d6-577d1ac46775",
      "name": "data column only",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1320,
        240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "4ad67c87-ff93-460c-b2b4-5053f1393ed9",
      "name": "split actions",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1860,
        240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "79c0f6f5-6f44-4b1c-b8aa-ab4a5e963baf",
      "name": "When clicking ‘Test workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        860,
        240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "23bedaf7-e02f-4947-9446-addf864302fd",
      "name": "Everyday at 3am",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        860,
        60
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "b221a2b7-ac20-4c0d-a655-27849fa2649a",
      "name": "付箋",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        140,
        -80
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "43f806e2-92d5-4a02-8491-2ddeca3601c7",
      "name": "付箋1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1260,
        520
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b6e86b79-ddde-4095-a602-08f5ceadcfa8",
      "name": "付箋2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2600,
        -140
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "55a38170-38ef-4c03-9284-d31c2d057e70",
      "name": "任意の期間の広告インサイト",
      "type": "n8n-nodes-base.facebookGraphApi",
      "position": [
        1080,
        560
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "28e25544-838f-43a8-9fb9-8d9c7ba57bf1",
      "name": "付箋3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1080,
        0
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "88fdc9b5-c918-4756-9d66-f4694b87cffd",
      "name": "前日の広告インサイト",
      "type": "n8n-nodes-base.facebookGraphApi",
      "position": [
        1080,
        240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "3287f957-9464-4cbc-93b9-5b6f07655b9c",
      "name": "split action values",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        2100,
        500
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "422671e1-e054-45ed-b5f6-246085320f6c",
      "name": "filter by action type",
      "type": "n8n-nodes-base.filter",
      "position": [
        2600,
        240
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "18202591-8208-4f4d-b861-640c4ccb1d8f",
      "name": "Only monetary actions",
      "type": "n8n-nodes-base.filter",
      "position": [
        2340,
        500
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "ac91d6d2-6d61-4687-8a8a-551cadc36516",
      "name": "filter by monetary action type",
      "type": "n8n-nodes-base.filter",
      "position": [
        2600,
        500
      ],
      "parameters": {},
      "typeVersion": 2.2
    },
    {
      "id": "54b9a7bd-0642-4c0f-9159-09ebf1baa8ce",
      "name": "付箋4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2600,
        660
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "45ad5870-8381-46e3-a713-2ae31313c597",
      "name": "付箋5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3140,
        480
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6d8ad63c-a53e-4831-9ab4-dda7aaa71d5b",
      "name": "一般指標を追加",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1600,
        20
      ],
      "parameters": {},
      "typeVersion": 4.4
    },
    {
      "id": "3b530b1d-11d8-43b3-a60c-92bfb0a77297",
      "name": "付箋6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1600,
        -240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d22e5ce5-533d-4745-959c-38df65b17148",
      "name": "非金銭的アクションを追加",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2920,
        240
      ],
      "parameters": {},
      "typeVersion": 4.4
    },
    {
      "id": "c7c25228-7a03-4ec8-b827-7a64da151be8",
      "name": "金銭的アクションを追加",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2920,
        500
      ],
      "parameters": {},
      "typeVersion": 4.4
    }
  ],
  "pinData": {},
  "connections": {
    "4ad67c87-ff93-460c-b2b4-5053f1393ed9": {
      "main": [
        [
          {
            "node": "3287f957-9464-4cbc-93b9-5b6f07655b9c",
            "type": "main",
            "index": 0
          },
          {
            "node": "422671e1-e054-45ed-b5f6-246085320f6c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "23bedaf7-e02f-4947-9446-addf864302fd": {
      "main": [
        [
          {
            "node": "88fdc9b5-c918-4756-9d66-f4694b87cffd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "82313e22-7fea-4d64-95d6-577d1ac46775": {
      "main": [
        [
          {
            "node": "4ad67c87-ff93-460c-b2b4-5053f1393ed9",
            "type": "main",
            "index": 0
          },
          {
            "node": "6d8ad63c-a53e-4831-9ab4-dda7aaa71d5b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3287f957-9464-4cbc-93b9-5b6f07655b9c": {
      "main": [
        [
          {
            "node": "18202591-8208-4f4d-b861-640c4ccb1d8f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "18202591-8208-4f4d-b861-640c4ccb1d8f": {
      "main": [
        [
          {
            "node": "ac91d6d2-6d61-4687-8a8a-551cadc36516",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "422671e1-e054-45ed-b5f6-246085320f6c": {
      "main": [
        [
          {
            "node": "d22e5ce5-533d-4745-959c-38df65b17148",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d22e5ce5-533d-4745-959c-38df65b17148": {
      "main": [
        []
      ]
    },
    "88fdc9b5-c918-4756-9d66-f4694b87cffd": {
      "main": [
        [
          {
            "node": "82313e22-7fea-4d64-95d6-577d1ac46775",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ac91d6d2-6d61-4687-8a8a-551cadc36516": {
      "main": [
        [
          {
            "node": "c7c25228-7a03-4ec8-b827-7a64da151be8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "79c0f6f5-6f44-4b1c-b8aa-ab4a5e963baf": {
      "main": [
        [
          {
            "node": "88fdc9b5-c918-4756-9d66-f4694b87cffd",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
よくある質問

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

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

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

上級 - マーケティング

有料ですか?

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

ワークフロー情報
難易度
上級
ノード数20
カテゴリー1
ノードタイプ7
難易度説明

上級者向け、16ノード以上の複雑なワークフロー

作成者
Solomon

Solomon

@solomon

Freelance consultant from Brazil, specializing in automations and data analysis. I work with select clients, addressing their toughest projects. For business inquiries, email me at automations.solomon@gmail.com or message me on Telegram for a faster response.

外部リンク
n8n.ioで表示

このワークフローを共有

カテゴリー

カテゴリー: 34