GoogleスプレッドシートからFacebook広告を自動作成

Name: GoogleスプレッドシートからFacebook広告を自動作成
Rating: 4.5 (10 reviews)
Author: Artur

中級

これはMarketing分野の自動化ワークフローで、8個のノードを含みます。主にSet, HttpRequest, GoogleSheets, FacebookGraphApi, GoogleSheetsTriggerなどのノードを使用。 GoogleスプレッドシートからFacebook広告の自動作成

前提条件

•ターゲットAPIの認証情報が必要な場合あり
•Google Sheets API認証情報
•Facebook Graph API認証情報

使用ノード (8)

カテゴリー

マーケティング

ワークフロープレビュー

ノード接続関係を可視化、ズームとパンをサポート

画像を取得

広告画像をアップロード

Facebook Ad Creative

広告を作成

Google Sheets Trigger

広告セットを作成

Google Sheetsを更新

変数を指定

React Flow

ワークフローをエクスポート

以下のJSON設定をn8nにインポートして、このワークフローを使用できます

{
  "meta": {
    "instanceId": "2718e70d3927cc6f222cd0fca1f41929053688eb8b4504451ee7746fdfef7be1"
  },
  "nodes": [
    {
      "id": "d82a3afd-4d22-4886-b175-d2f78ec54f94",
      "name": "画像を取得",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        480,
        20
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "9aaf29e7-17f9-453f-88fb-cd9f90611706",
      "name": "広告画像をアップロード",
      "type": "n8n-nodes-base.facebookGraphApi",
      "position": [
        700,
        20
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d1539410-3b66-4790-a20d-ec48276bc61d",
      "name": "Facebook Ad Creative",
      "type": "n8n-nodes-base.facebookGraphApi",
      "position": [
        920,
        20
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "0481e563-bffb-4c97-addc-74ff3620270f",
      "name": "広告を作成",
      "type": "n8n-nodes-base.facebookGraphApi",
      "position": [
        1140,
        20
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "762da443-fcc0-4dc7-b024-b90b9ec563ba",
      "name": "Google Sheets Trigger",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -180,
        20
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "42c1cf13-b87d-4700-bee6-655fcc7afe8c",
      "name": "広告セットを作成",
      "type": "n8n-nodes-base.facebookGraphApi",
      "position": [
        260,
        20
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "7f42f413-b004-4ee3-9f1e-8bcb943e8088",
      "name": "Google Sheetsを更新",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1360,
        20
      ],
      "parameters": {},
      "typeVersion": 4.5
    },
    {
      "id": "1bbafbf9-5848-4009-b6b5-49e1ea6a2471",
      "name": "変数を指定",
      "type": "n8n-nodes-base.set",
      "position": [
        40,
        20
      ],
      "parameters": {},
      "typeVersion": 3.4
    }
  ],
  "pinData": {
    "Google Sheets Trigger": [
      {
        "Hooks": "\"Ever wish you could sprinkle a little magic into their day, even with your busy schedule?\"",
        "ad id": "120219801541720760",
        "Render URL": "https://templated-assets.s3.amazonaws.com/render/d8785acf-a6f4-4f25-bb17-46abe7376cd4.jpg",
        "generate ad": "generated"
      }
    ]
  },
  "connections": {
    "d82a3afd-4d22-4886-b175-d2f78ec54f94": {
      "main": [
        [
          {
            "node": "9aaf29e7-17f9-453f-88fb-cd9f90611706",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0481e563-bffb-4c97-addc-74ff3620270f": {
      "main": [
        [
          {
            "node": "7f42f413-b004-4ee3-9f1e-8bcb943e8088",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9aaf29e7-17f9-453f-88fb-cd9f90611706": {
      "main": [
        [
          {
            "node": "d1539410-3b66-4790-a20d-ec48276bc61d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "42c1cf13-b87d-4700-bee6-655fcc7afe8c": {
      "main": [
        [
          {
            "node": "d82a3afd-4d22-4886-b175-d2f78ec54f94",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1bbafbf9-5848-4009-b6b5-49e1ea6a2471": {
      "main": [
        [
          {
            "node": "42c1cf13-b87d-4700-bee6-655fcc7afe8c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d1539410-3b66-4790-a20d-ec48276bc61d": {
      "main": [
        [
          {
            "node": "0481e563-bffb-4c97-addc-74ff3620270f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "762da443-fcc0-4dc7-b024-b90b9ec563ba": {
      "main": [
        [
          {
            "node": "1bbafbf9-5848-4009-b6b5-49e1ea6a2471",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

よくある質問