Obtener tokens de acceso de Facebook de larga duración con hojas de cálculo

Name: Obtener tokens de acceso de Facebook de larga duración con hojas de cálculo
Rating: 4.5 (10 reviews)
Author: Đỗ Thành Nguyên

Intermedio

Este es unSocial Mediaflujo de automatización del dominio deautomatización que contiene 11 nodos.Utiliza principalmente nodos como Set, SplitOut, DataTable, HttpRequest, ScheduleTrigger. Automatización de la renovación de tokens de páginas de Facebook mediante el almacenamiento en hojas de cálculo

Requisitos previos

•Pueden requerirse credenciales de autenticación para la API de destino

Nodos utilizados (11)

Categoría

Redes sociales

Vista previa del flujo de trabajo

Visualización de las conexiones entre nodos, con soporte para zoom y panorámica

Establecer parámetro

Dividir

Editar campos

Actualizar/Insertar fila(s)

Activador programado

Obtener token de usuario de larga duración facebook

Obtener lista de páginas facebook

Obtener token de página de larga duración facebook

React Flow

Exportar flujo de trabajo

Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo

{
  "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": "Establecer parámetro",
      "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": "Dividir",
      "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": "Editar campos",
      "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": "Actualizar/Insertar fila(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": "Activador programado",
      "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": "Nota adhesiva",
      "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": "Nota adhesiva1",
      "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": "Nota adhesiva2",
      "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": "Obtener token de usuario de larga duración facebook",
      "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": "Obtener lista de páginas facebook",
      "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": "Obtener token de página de larga duración facebook",
      "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
          }
        ]
      ]
    }
  }
}

Preguntas frecuentes

¿Cómo usar este flujo de trabajo?

Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.

¿En qué escenarios es adecuado este flujo de trabajo?

Intermedio - Redes sociales

¿Es de pago?

Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.