Obtention de jetons d'accès Facebook à long terme à l'aide de feuilles de calcul

Name: Obtention de jetons d'accès Facebook à long terme à l'aide de feuilles de calcul
Rating: 4.5 (10 reviews)
Author: Đỗ Thành Nguyên

Intermédiaire

Ceci est unSocial Mediaworkflow d'automatisation du domainecontenant 11 nœuds.Utilise principalement des nœuds comme Set, SplitOut, DataTable, HttpRequest, ScheduleTrigger. Automatisation du renouvellement des jetons de page Facebook via le stockage dans une feuille de calcul

Prérequis

•Peut nécessiter les informations d'identification d'authentification de l'API cible

Nœuds utilisés (11)

Catégorie

Réseaux sociaux

Aperçu du workflow

Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement

Définir le paramètre

Diviser

Modifier les champs

Upsert ligne(s)

Déclencheur planifié

Obtenir un jeton utilisateur facebook de longue durée

Obtenir la liste facebook des pages

Obtenir un jeton de page facebook de longue durée

React Flow

Exporter le workflow

Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow

{
  "id": "enqUom6Fs1WaDOCW",
  "meta": {
    "instanceId": "b5825084f383ba38862ba0b5b7e95c5107a40c4ed7afc78372d74501163a8e33",
    "templateId": "2535"
  },
  "name": "Get long facebook access token with data tables",
  "tags": [],
  "nodes": [
    {
      "id": "11a68266-f7ec-4c56-9327-c4fd0e4478f6",
      "name": "Définir le paramètre",
      "type": "n8n-nodes-base.set",
      "position": [
        720,
        240
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "b1f6b8a1-dc25-4b1e-9aa3-0c0e452ae2de",
              "name": " client_id",
              "type": "string",
              "value": "<client_id>"
            },
            {
              "id": "9a63879a-c359-49ad-9fec-19c9e4c78dd6",
              "name": " client_secret",
              "type": "string",
              "value": "<client_secret>"
            },
            {
              "id": "6971a841-ed5e-4d96-bdab-1eaec2d51ccc",
              "name": "user_access_token",
              "type": "string",
              "value": "<user_access_token>"
            },
            {
              "id": "c75d5e50-62ea-4ee0-bfaa-5f79cf4d147e",
              "name": "app_scoped_user_id",
              "type": "string",
              "value": "<app_scoped_user_id>"
            },
            {
              "id": "75516211-496a-46bf-82ad-2352f7080512",
              "name": "long_user_access_token",
              "type": "string",
              "value": "={{ $json.body.access_token }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "c844cc76-6a73-4e4c-b5af-dd3b0c391a66",
      "name": "Diviser",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        352,
        880
      ],
      "parameters": {
        "include": "allOtherFields",
        "options": {
          "includeBinary": false
        },
        "fieldToSplitOut": "body.data"
      },
      "typeVersion": 1
    },
    {
      "id": "5bbff2d4-0b0e-4194-97f7-c1a4c09c7c77",
      "name": "Modifier les champs",
      "type": "n8n-nodes-base.set",
      "position": [
        544,
        880
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "fead0c79-b7a9-4da8-adc8-c68ea86041af",
              "name": "access_token",
              "type": "string",
              "value": "={{ $json['body.data'].access_token }}"
            },
            {
              "id": "98467cc1-4960-4291-a685-b7dd04f24211",
              "name": "name",
              "type": "string",
              "value": "={{ $json['body.data'].name }}"
            },
            {
              "id": "6b7b8c21-ef78-40ba-86df-0a7f46057bca",
              "name": "id",
              "type": "string",
              "value": "={{ $json['body.data'].id }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "fa84d8ed-511e-42b7-a954-a35bb5b70dd8",
      "name": "Upsert ligne(s)",
      "type": "n8n-nodes-base.dataTable",
      "position": [
        736,
        880
      ],
      "parameters": {
        "columns": {
          "value": {
            "token": "={{ $json.access_token }}",
            "id_page": "={{ $json.id }}",
            "name_page": "={{ $json.name }}"
          },
          "schema": [
            {
              "id": "name_page",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "name_page",
              "defaultMatch": false
            },
            {
              "id": "id_page",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "id_page",
              "defaultMatch": false
            },
            {
              "id": "token",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": false,
              "required": false,
              "displayName": "token",
              "defaultMatch": false
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "filters": {
          "conditions": [
            {
              "keyName": "id_page",
              "keyValue": "={{ $json.id }}"
            }
          ]
        },
        "matchType": "allConditions",
        "operation": "upsert",
        "dataTableId": {
          "__rl": true,
          "mode": "list",
          "value": "tmKVoWFoXqgiVHtI",
          "cachedResultUrl": "/projects/ZsXeoU4uGUhTbvTf/datatables/tmKVoWFoXqgiVHtI",
          "cachedResultName": "n8n"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "76b1d58f-41d6-4088-99e1-da2a3663116e",
      "name": "Déclencheur planifié",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        272,
        240
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "months",
              "monthsInterval": 2
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "831a32d7-ea1a-4d5b-bd2e-e9e715e6d7a1",
      "name": "Note adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        176
      ],
      "parameters": {
        "color": 6,
        "width": 1072,
        "height": 288,
        "content": "## Step 1\n**Get  client_id,  client_secret** [here](https://developers.facebook.com/apps)\n\n**Get  user_access_token** [here](https://developers.facebook.com/tools/explorer/)\n\n**Get  app_scoped_user_idn** [here](https://developers.facebook.com/tools/debug/accesstoken/)"
      },
      "typeVersion": 1
    },
    {
      "id": "cfbc57a3-bfb2-4237-b7b0-88d339362931",
      "name": "Note adhésive 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        512
      ],
      "parameters": {
        "color": 3,
        "width": 1072,
        "height": 288,
        "content": "## Step 2 \n**Get long lived facebook page token**"
      },
      "typeVersion": 1
    },
    {
      "id": "dddf5f0d-2cab-4b75-8cc4-ecbcd5e3cbcc",
      "name": "Note adhésive 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -160,
        848
      ],
      "parameters": {
        "width": 1072,
        "height": 288,
        "content": "## Step 3 \n**Now the Facebook Page token has \n\nbeen renewed and will be stored in \n\nthe data tables. This information \n\nwill also be updated whenever you \n\nrun this workflow.**"
      },
      "typeVersion": 1
    },
    {
      "id": "9f3d0b85-8c02-4d78-9da8-f9ce98b189b2",
      "name": "Obtenir un jeton utilisateur facebook de longue durée",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        304,
        560
      ],
      "parameters": {
        "url": "https://graph.facebook.com/v23.0/oauth/access_token",
        "options": {
          "response": {
            "response": {
              "fullResponse": true
            }
          }
        },
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "grant_type",
              "value": "fb_exchange_token"
            },
            {
              "name": "client_id",
              "value": "={{ $json[' client_id'] }}"
            },
            {
              "name": "client_secret",
              "value": "={{ $json[' client_secret'] }}"
            },
            {
              "name": "fb_exchange_token",
              "value": "={{ $json.user_access_token }}"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "84e16f5c-6be3-4639-9d34-18cc057725e6",
      "name": "Obtenir la liste facebook des pages",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        512,
        560
      ],
      "parameters": {
        "url": "https://graph.facebook.com/v23.0/me/accounts",
        "options": {
          "response": {
            "response": {
              "fullResponse": true
            }
          }
        },
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": "access_token",
              "value": "={{ $json.body.access_token }}"
            }
          ]
        }
      },
      "typeVersion": 4.2
    },
    {
      "id": "4e898760-43cd-4d4f-a76c-555175fb2a27",
      "name": "Obtenir un jeton de page facebook de longue durée",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        720,
        560
      ],
      "parameters": {
        "url": "=https://graph.facebook.com/v23.0/{{ $('Set Parameter').item.json.app_scoped_user_id }}/accounts",
        "method": "=GET",
        "options": {
          "response": {
            "response": {
              "fullResponse": true
            }
          }
        },
        "sendQuery": true,
        "queryParameters": {
          "parameters": [
            {
              "name": " access_token",
              "value": "={{ $('Get long lived facebook user token').item.json.body.access_token }}"
            }
          ]
        }
      },
      "typeVersion": 4.2
    }
  ],
  "active": true,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "a43aee60-5261-4af8-bdde-cf2c27b2cbc8",
  "connections": {
    "c844cc76-6a73-4e4c-b5af-dd3b0c391a66": {
      "main": [
        [
          {
            "node": "5bbff2d4-0b0e-4194-97f7-c1a4c09c7c77",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5bbff2d4-0b0e-4194-97f7-c1a4c09c7c77": {
      "main": [
        [
          {
            "node": "fa84d8ed-511e-42b7-a954-a35bb5b70dd8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "11a68266-f7ec-4c56-9327-c4fd0e4478f6": {
      "main": [
        [
          {
            "node": "9f3d0b85-8c02-4d78-9da8-f9ce98b189b2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "76b1d58f-41d6-4088-99e1-da2a3663116e": {
      "main": [
        [
          {
            "node": "11a68266-f7ec-4c56-9327-c4fd0e4478f6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "84e16f5c-6be3-4639-9d34-18cc057725e6": {
      "main": [
        [
          {
            "node": "4e898760-43cd-4d4f-a76c-555175fb2a27",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4e898760-43cd-4d4f-a76c-555175fb2a27": {
      "main": [
        [
          {
            "node": "c844cc76-6a73-4e4c-b5af-dd3b0c391a66",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9f3d0b85-8c02-4d78-9da8-f9ce98b189b2": {
      "main": [
        [
          {
            "node": "84e16f5c-6be3-4639-9d34-18cc057725e6",
            "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é ?

Intermédiaire - Réseaux sociaux

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.