Automatización de Generación y Aprobación de Publicaciones en LinkedIn

• •Cuenta de Google y credenciales de API de Gmail
• •Credenciales de API de LinkedIn
• •Pueden requerirse credenciales de autenticación para la API de destino
• •Credenciales de API de Google Sheets
• •Clave de API de OpenAI

{
  "id": "w9YVsuUtlNgXOEAQ",
  "meta": {
    "instanceId": "58a9e858b82757a75629d435ec0da2448ad5d9e906a9ce3b7dcbb64c90fda9fe",
    "templateCredsSetupCompleted": true
  },
  "name": "LinkedIn Post Generation & Approval Automation",
  "tags": [
    {
      "id": "3bzbXbpZW83y48aK",
      "name": "content-approval",
      "createdAt": "2025-05-13T18:45:19.225Z",
      "updatedAt": "2025-05-13T18:45:19.225Z"
    },
    {
      "id": "9SfWdyKRFVbPxrNL",
      "name": "post-generator",
      "createdAt": "2025-05-13T18:45:09.255Z",
      "updatedAt": "2025-05-13T18:45:09.255Z"
    },
    {
      "id": "VWnkUEKQKJB2WmbL",
      "name": "linkedin",
      "createdAt": "2025-05-13T18:45:04.175Z",
      "updatedAt": "2025-05-13T18:45:04.175Z"
    }
  ],
  "nodes": [
    {
      "id": "d0f86395-aeec-4284-a2d5-26db2dfebd53",
      "name": "Obtener Imagen",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1592,
        2120
      ],
      "parameters": {
        "url": "={{ $('Get Data from Sheets').item.json.Image }}",
        "options": {}
      },
      "typeVersion": 4.2,
      "alwaysOutputData": true
    },
    {
      "id": "b8ca88a6-aaf1-4191-8b75-9a63b746af77",
      "name": "Activador Programado",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -260,
        2595
      ],
      "parameters": {
        "rule": {
          "interval": [
            {}
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "8e4e294f-56d4-4317-aea8-ea258527f55a",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        268,
        2815
      ],
      "parameters": {
        "model": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini"
        },
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "7OVQwPA6RZRwFmwI",
          "name": "OpenAI Account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "d262684e-7671-4602-ba77-4270441a69fb",
      "name": "Obtener Datos de Hojas",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -40,
        2595
      ],
      "parameters": {
        "options": {
          "returnFirstMatch": true
        },
        "filtersUI": {
          "values": [
            {
              "lookupValue": "Pending",
              "lookupColumn": "Status"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAdLU9-l0ATGDa5_xwTwFO-rPhvZurM2BOSKjH2P-W8/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1EAdLU9-l0ATGDa5_xwTwFO-rPhvZurM2BOSKjH2P-W8",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAdLU9-l0ATGDa5_xwTwFO-rPhvZurM2BOSKjH2P-W8/edit?usp=drivesdk",
          "cachedResultName": "LinkedIn Post Automation"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Gs7mfT220sbLQ7PS",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "93d3e57f-a22d-4c04-9ccc-7ee655bedbdb",
      "name": "Generar Contenido de Publicación",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        180,
        2595
      ],
      "parameters": {
        "text": "=# LinkedIn Post Generation\n\n## Post Description:\n{{ $json[\"Post Description\"] }}\n\n## Instructions:\n{{ $json[\"Instructions\"] }}\n\n---\n\n**Task:**\nUsing the information above, generate the content for a LinkedIn post:\n- Use the Description and Instructions to create a new post.\n- Ensure your output is positive, professional, clear, and follows all provided instructions and feedback.\n- Do not include any explanations, just the final post content only, ready to publish on LinkedIn.\n- Limit to 1300 characters.\n- If the user demands to keep the same post as the Post Descrioption (in the instructions), then keep the same post content as provided in the Post Description, and output it.",
        "messages": {
          "messageValues": [
            {
              "message": "=You are an expert social media and LinkedIn content writer.\n\nYou will be provided with:\n- A brief post description\n- Specific instructions from the user\n\nPlease follow these steps:\n\n1. Initial Creation:\nIf you are given a post description and instructions, write a polished, professionally worded LinkedIn post suitable for sharing. Strictly follow the instructions and ensure the message is engaging and succinct.\nIf instructed, add a call to action or particular phrase (for example, \"Connect with me\" at the bottom).\n\n2. Formatting:\nKeep the tone positive, inclusive, and professional.\nAdd relevant hashtags in small case.\nLimit the content to within 1300 characters.\nPlace the call to action or special instruction at the end if requested.\nOutput ONLY the final LinkedIn post content. Do NOT include any explanations, markdown, headings, or commentary—just the post text, ready to copy and share on LinkedIn."
            }
          ]
        },
        "promptType": "define"
      },
      "typeVersion": 1.6
    },
    {
      "id": "6ea121f4-661c-4dd4-a0bc-7edb8a0b884a",
      "name": "Formateo de Datos 1",
      "type": "n8n-nodes-base.set",
      "position": [
        556,
        2595
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "bded6f56-99e2-4f1a-be41-27a8dd417844",
              "name": "Post Content",
              "type": "string",
              "value": "={{ $json.text }}"
            },
            {
              "id": "c222c42e-b639-4a74-a1b0-7a3e6e141d55",
              "name": "Post Description",
              "type": "string",
              "value": "={{ $('Get Data from Sheets').item.json['Post Description'] }}"
            },
            {
              "id": "14775ff7-e005-4a86-9623-c322365f7d3a",
              "name": "Instructions",
              "type": "string",
              "value": "={{ $('Get Data from Sheets').item.json.Instructions }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "a00ec081-07c0-4f8a-9139-6606a65236ff",
      "name": "Enviar Confirmación de Contenido",
      "type": "n8n-nodes-base.gmail",
      "position": [
        776,
        2495
      ],
      "webhookId": "29614d41-05c1-44af-93a6-4831a27f9331",
      "parameters": {
        "sendTo": "shindearyan179@gmail.com",
        "message": "=Generated Post:\n{{ $json['Post Content'] }}\n\n----------\n\nPost Description:\n{{ $json['Post Description'] }}\n\n----------\n\nInstructions:\n{{ $json.Instructions }}",
        "options": {},
        "subject": "Approval for LinkedIn Post",
        "operation": "sendAndWait",
        "formFields": {
          "values": [
            {
              "fieldType": "dropdown",
              "fieldLabel": "Confirm  Content?",
              "fieldOptions": {
                "values": [
                  {
                    "option": "Yes"
                  },
                  {
                    "option": "No"
                  },
                  {
                    "option": "Cancel"
                  }
                ]
              },
              "requiredField": true
            },
            {
              "fieldType": "textarea",
              "fieldLabel": "Any Changes?"
            }
          ]
        },
        "responseType": "customForm"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "n47Kn2N5BwXYv6eA",
          "name": "Gmail account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "5a1e8061-ef79-4974-888d-8670e60a1b0c",
      "name": "Lógica de Confirmación de Contenido",
      "type": "n8n-nodes-base.switch",
      "position": [
        996,
        2495
      ],
      "parameters": {
        "rules": {
          "values": [
            {
              "outputKey": "Yes",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "99ec185e-80ac-451d-bb69-662f84a7cf52",
                    "operator": {
                      "type": "string",
                      "operation": "equals"
                    },
                    "leftValue": "={{ $json.data['Confirm  Content?'] }}",
                    "rightValue": "Yes"
                  }
                ]
              },
              "renameOutput": true
            },
            {
              "outputKey": "No",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "77031007-a912-4b9b-9cca-846c57ffaec8",
                    "operator": {
                      "name": "filter.operator.equals",
                      "type": "string",
                      "operation": "equals"
                    },
                    "leftValue": "={{ $json.data['Confirm  Content?'] }}",
                    "rightValue": "No"
                  }
                ]
              },
              "renameOutput": true
            },
            {
              "outputKey": "Cancel",
              "conditions": {
                "options": {
                  "version": 2,
                  "leftValue": "",
                  "caseSensitive": true,
                  "typeValidation": "strict"
                },
                "combinator": "and",
                "conditions": [
                  {
                    "id": "e94de530-6451-48aa-892c-924a9c41cfb0",
                    "operator": {
                      "name": "filter.operator.equals",
                      "type": "string",
                      "operation": "equals"
                    },
                    "leftValue": "={{ $json.data['Confirm  Content?'] }}",
                    "rightValue": "Cancel"
                  }
                ]
              },
              "renameOutput": true
            }
          ]
        },
        "options": {}
      },
      "typeVersion": 3.2
    },
    {
      "id": "c139fda0-4be1-4ad7-bb28-802b7150365d",
      "name": "Regenerar Contenido de Publicación",
      "type": "@n8n/n8n-nodes-langchain.chainLlm",
      "position": [
        1216,
        2670
      ],
      "parameters": {
        "text": "=Apply the modification requests on the following LinkedIn post. Besides applying the reqested modifications, return the same linkedin post.\n\nLinkedIn post:\n```\n{{ $('Data Formatting 1').item.json['Post Content'] }}\n```\n\nChange requests:\n{{ $('Send Content Confirmation').item.json.data['Any Changes?'] }}\n\n**Task:**\nUsing the information above, update the LinkedIn post content:\n- Do not include any explanations, just the final post content only (with all the change requests included in the post), ready to publish on LinkedIn.\n- Limit to 1300 characters.\n- If the user demands to keep the same post as the Post Description (in the instructions), then keep the same post content as provided in the Post Description, and output it.",
        "promptType": "define"
      },
      "typeVersion": 1.6
    },
    {
      "id": "b8587578-03a6-4975-8907-667628dc958a",
      "name": "Si se Proporciona Imagen",
      "type": "n8n-nodes-base.if",
      "position": [
        1294,
        2220
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "version": 2,
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "9a78220d-35f5-48b6-9ce3-faecaac24b74",
              "operator": {
                "type": "string",
                "operation": "notEmpty",
                "singleValue": true
              },
              "leftValue": "={{ $('Get Data from Sheets').item.json.Image }}",
              "rightValue": ""
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "30bf76c8-8420-4d77-bc2b-8a1c27fbf36a",
      "name": "Publicar con Imagen",
      "type": "n8n-nodes-base.linkedIn",
      "position": [
        1812,
        2120
      ],
      "parameters": {
        "text": "={{ $('Data Formatting 1').item.json['Post Content'] }}",
        "person": "pM247vR8Se",
        "additionalFields": {},
        "shareMediaCategory": "IMAGE"
      },
      "credentials": {
        "linkedInOAuth2Api": {
          "id": "Fg8i5E17dzZcPtMH",
          "name": "LinkedIn account 2"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "62bf9597-3e38-45ec-853c-aa2d77c40bc2",
      "name": "Publicar sin Imagen",
      "type": "n8n-nodes-base.linkedIn",
      "position": [
        1812,
        2320
      ],
      "parameters": {
        "text": "={{ $('Data Formatting 1').item.json['Post Content'] }}",
        "person": "pM247vR8Se",
        "additionalFields": {}
      },
      "credentials": {
        "linkedInOAuth2Api": {
          "id": "Fg8i5E17dzZcPtMH",
          "name": "LinkedIn account 2"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "0ddd307d-5e54-42cf-b65a-25f111fb4bea",
      "name": "Actualizar Hoja Google",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2032,
        2320
      ],
      "parameters": {
        "columns": {
          "value": {
            "Output": "={{ $json.urn }}",
            "Status": "=Completed",
            "Post Link": "={{ $json.urn }}",
            "row_number": "={{ $('Get Data from Sheets').item.json.row_number }}"
          },
          "schema": [
            {
              "id": "Post Description",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Post Description",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Instructions",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Instructions",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Image",
              "type": "string",
              "display": true,
              "removed": true,
              "required": false,
              "displayName": "Image",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Status",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Status",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Output",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Output",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Post Link",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Post Link",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "row_number",
              "type": "string",
              "display": true,
              "removed": false,
              "readOnly": true,
              "required": false,
              "displayName": "row_number",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "row_number"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "gid=0",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAdLU9-l0ATGDa5_xwTwFO-rPhvZurM2BOSKjH2P-W8/edit#gid=0",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1EAdLU9-l0ATGDa5_xwTwFO-rPhvZurM2BOSKjH2P-W8",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1EAdLU9-l0ATGDa5_xwTwFO-rPhvZurM2BOSKjH2P-W8/edit?usp=drivesdk",
          "cachedResultName": "LinkedIn Post Automation"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "Gs7mfT220sbLQ7PS",
          "name": "Google Sheets account"
        }
      },
      "typeVersion": 4.5
    },
    {
      "id": "c4a55beb-8459-4faa-b072-51c500562ae3",
      "name": "Nota Adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -780,
        2480
      ],
      "parameters": {
        "width": 420,
        "height": 380,
        "content": "## 1. Schedule & Sheet Data Retrieval\n\nThis workflow starts automatically on a defined schedule (e.g., daily or hourly).\n\nIt retrieves the next Google Sheet row marked as ‘Pending’.\n\nThe sheet should include columns like:\n1. Post Description\n2. Instructions\n3. Image\n4. Status\n5. row_number (required for updates)\n\nEnsure your Google Sheets credentials are correctly configured."
      },
      "typeVersion": 1
    },
    {
      "id": "09dade5b-e26a-4b97-9b8a-a5c807cff937",
      "name": "Nota Adhesiva1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -220,
        3040
      ],
      "parameters": {
        "width": 420,
        "height": 240,
        "content": "## 2. AI-Powered Post Generation & Formatting\n\nUses OpenAI GPT to generate a LinkedIn post based on the sheet’s Post Description and Instructions.\n\nYou can modify the prompt if needed.\nThe generated post is then formatted along with relevant data for easy reference and consistency."
      },
      "typeVersion": 1
    },
    {
      "id": "f373dfd9-f971-4925-8e74-15201c8a47c4",
      "name": "Nota Adhesiva2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        440,
        3040
      ],
      "parameters": {
        "width": 440,
        "height": 240,
        "content": "## 3. Gmail Approval Workflow\n\nSends the formatted post to an approver via Gmail.\n\nThe approver can respond with:\n✅ Yes – Approve\n✏️ No – Request changes\n❌ Cancel – Abort the post\n\nSet Gmail credentials and recipient email in the node."
      },
      "typeVersion": 1
    },
    {
      "id": "66d51a35-262e-469b-bcd8-aca3cf60452c",
      "name": "Nota Adhesiva3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1120,
        3040
      ],
      "parameters": {
        "width": 440,
        "height": 240,
        "content": "## 4. Approval Handling & Regeneration\n\nHandles all approval responses:\n- If Yes, proceed to post.\n- If No, regenerate content based on the feedback and resend.\n- If Cancel, update the Google Sheet as Cancelled.\n\nThis ensures a complete review cycle before posting."
      },
      "typeVersion": 1
    },
    {
      "id": "ad4023af-0e8b-4ec1-be1d-9313ec4f5ca7",
      "name": "Nota Adhesiva4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1800,
        3040
      ],
      "parameters": {
        "width": 460,
        "height": 320,
        "content": "## 5. Image Check, Posting & Sheet Update\n\nChecks if an image URL is provided.\n- If present: Downloads the image and posts with it.\n- If not: Posts content without an image.\n\nAfter posting, it updates the Google Sheet with:\n- Status = Completed or Cancelled\n- LinkedIn post link/output\n\nUses row_number for precise sheet updates."
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "65685909-274a-4d41-8f8a-fbba9442597b",
  "connections": {
    "d0f86395-aeec-4284-a2d5-26db2dfebd53": {
      "main": [
        [
          {
            "node": "30bf76c8-8420-4d77-bc2b-8a1c27fbf36a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "30bf76c8-8420-4d77-bc2b-8a1c27fbf36a": {
      "main": [
        [
          {
            "node": "0ddd307d-5e54-42cf-b65a-25f111fb4bea",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b8ca88a6-aaf1-4191-8b75-9a63b746af77": {
      "main": [
        [
          {
            "node": "d262684e-7671-4602-ba77-4270441a69fb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "6ea121f4-661c-4dd4-a0bc-7edb8a0b884a": {
      "main": [
        [
          {
            "node": "a00ec081-07c0-4f8a-9139-6606a65236ff",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b8587578-03a6-4975-8907-667628dc958a": {
      "main": [
        [
          {
            "node": "d0f86395-aeec-4284-a2d5-26db2dfebd53",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "62bf9597-3e38-45ec-853c-aa2d77c40bc2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "8e4e294f-56d4-4317-aea8-ea258527f55a": {
      "ai_languageModel": [
        [
          {
            "node": "93d3e57f-a22d-4c04-9ccc-7ee655bedbdb",
            "type": "ai_languageModel",
            "index": 0
          },
          {
            "node": "c139fda0-4be1-4ad7-bb28-802b7150365d",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "62bf9597-3e38-45ec-853c-aa2d77c40bc2": {
      "main": [
        [
          {
            "node": "0ddd307d-5e54-42cf-b65a-25f111fb4bea",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d262684e-7671-4602-ba77-4270441a69fb": {
      "main": [
        [
          {
            "node": "93d3e57f-a22d-4c04-9ccc-7ee655bedbdb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "93d3e57f-a22d-4c04-9ccc-7ee655bedbdb": {
      "main": [
        [
          {
            "node": "6ea121f4-661c-4dd4-a0bc-7edb8a0b884a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c139fda0-4be1-4ad7-bb28-802b7150365d": {
      "main": [
        [
          {
            "node": "6ea121f4-661c-4dd4-a0bc-7edb8a0b884a",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "a00ec081-07c0-4f8a-9139-6606a65236ff": {
      "main": [
        [
          {
            "node": "5a1e8061-ef79-4974-888d-8670e60a1b0c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5a1e8061-ef79-4974-888d-8670e60a1b0c": {
      "main": [
        [
          {
            "node": "b8587578-03a6-4975-8907-667628dc958a",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "c139fda0-4be1-4ad7-bb28-802b7150365d",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "0ddd307d-5e54-42cf-b65a-25f111fb4bea",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}