Obtenir les insights publicitaires de Meta et les sauvegarder dans Google Sheets

Avancé

Ceci est unMarketingworkflow d'automatisation du domainecontenant 20 nœuds.Utilise principalement des nœuds comme Filter, SplitOut, GoogleSheets, ManualTrigger, ScheduleTrigger. Obtenir des informations sur les publicités Meta et les sauvegarder dans Google Sheets

Prérequis
  • Informations d'identification Google Sheets API
  • Informations d'identification Facebook Graph API

Catégorie

Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "nodes": [
    {
      "id": "82313e22-7fea-4d64-95d6-577d1ac46775",
      "name": "colonne de données uniquement",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        1320,
        240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "4ad67c87-ff93-460c-b2b4-5053f1393ed9",
      "name": "diviser les 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": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        140,
        -80
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "43f806e2-92d5-4a02-8491-2ddeca3601c7",
      "name": "Note adhésive 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1260,
        520
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "b6e86b79-ddde-4095-a602-08f5ceadcfa8",
      "name": "Note adhésive 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2600,
        -140
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "55a38170-38ef-4c03-9284-d31c2d057e70",
      "name": "Ad insights from any date period",
      "type": "n8n-nodes-base.facebookGraphApi",
      "position": [
        1080,
        560
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "28e25544-838f-43a8-9fb9-8d9c7ba57bf1",
      "name": "Note adhésive 3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1080,
        0
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "88fdc9b5-c918-4756-9d66-f4694b87cffd",
      "name": "Ad insights from yesterday",
      "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": "Note adhésive 4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2600,
        660
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "45ad5870-8381-46e3-a713-2ae31313c597",
      "name": "Note adhésive 5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3140,
        480
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "6d8ad63c-a53e-4831-9ab4-dda7aaa71d5b",
      "name": "Ajouter des métriques générales",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1600,
        20
      ],
      "parameters": {},
      "typeVersion": 4.4
    },
    {
      "id": "3b530b1d-11d8-43b3-a60c-92bfb0a77297",
      "name": "Note adhésive 6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1600,
        -240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "d22e5ce5-533d-4745-959c-38df65b17148",
      "name": "Ajouter des actions non monétaires",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2920,
        240
      ],
      "parameters": {},
      "typeVersion": 4.4
    },
    {
      "id": "c7c25228-7a03-4ec8-b827-7a64da151be8",
      "name": "Ajouter des actions monétaires",
      "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
          }
        ]
      ]
    }
  }
}
Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Avancé - Marketing

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.

Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds20
Catégorie1
Types de nœuds7
Description de la difficulté

Adapté aux utilisateurs avancés, avec des workflows complexes contenant 16+ nœuds

Auteur
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.

Liens externes
Voir sur n8n.io

Partager ce workflow

Catégories

Catégories: 34