CallForge - 02 - Preparar llamadas de Gong para resumen de IA usando Sheets y Notion

Avanzado

Este es unSales, Product, AIflujo de automatización del dominio deautomatización que contiene 26 nodos.Utiliza principalmente nodos como Set, Gong, Merge, Notion, SplitOut, combinando tecnología de inteligencia artificial para lograr automatización inteligente. CallForge - 02 - Preparación de llamadas de Gong para resumen de IA con Sheets y Notion

Requisitos previos
  • Clave de API de Notion
  • Credenciales de API de Google Sheets
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
  "meta": {
    "instanceId": "cb484ba7b742928a2048bf8829668bed5b5ad9787579adea888f05980292a4a7",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "25fb4302-853a-421d-8e4f-4a18d723c4a0",
      "name": "Al hacer clic en 'Test workflow'",
      "type": "n8n-nodes-base.manualTrigger",
      "disabled": true,
      "position": [
        -860,
        380
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "acb8e29a-75b8-4ccb-aca8-20d5a7053334",
      "name": "Gong",
      "type": "n8n-nodes-base.gong",
      "disabled": true,
      "position": [
        -440,
        120
      ],
      "parameters": {
        "filters": {
          "toDateTime": "={{ $now.toISO() }}",
          "fromDateTime": "={{ $now.minus({ days: 2 }).toISO() }}"
        },
        "options": {},
        "returnAll": true,
        "requestOptions": {}
      },
      "credentials": {
        "gongApi": {
          "id": "EchfvOC4rjw8MUkr",
          "name": "Liam Gong Cred"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "930a7fc9-64a1-4966-be0d-c58132b735e5",
      "name": "Nota adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -700,
        -60
      ],
      "parameters": {
        "color": 7,
        "width": 1080,
        "height": 920,
        "content": "## Get Gong Calls and Supporting Data\nBesides the phone calls, integration and competitor data is extracted to supplement the AI prompt with accurate data to compare against mispronunciations. "
      },
      "typeVersion": 1
    },
    {
      "id": "f21ae8cc-eed1-4d31-8b1f-cc731e3dc642",
      "name": "Nota adhesiva1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        400,
        -60
      ],
      "parameters": {
        "color": 7,
        "width": 880,
        "height": 920,
        "content": "## Remove Duplicates from Queue\nChecks notion for already processed calls and removes them from the processing queue ensuring data is not duplicated. "
      },
      "typeVersion": 1
    },
    {
      "id": "d796312a-2a7f-429f-8550-d4af6d81a26d",
      "name": "Transcript Processor",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        2200,
        640
      ],
      "parameters": {
        "options": {},
        "workflowId": {
          "__rl": true,
          "mode": "list",
          "value": "7BAQDjnHQVYO1SWG",
          "cachedResultName": "Transcript Processor Demo"
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "b381f944-d865-450e-a24d-31d394a01b36",
      "name": "Nota adhesiva2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1820,
        420
      ],
      "parameters": {
        "color": 7,
        "width": 700,
        "height": 440,
        "content": "## Generate Clean Transcript \nAllows for reduced prompting in the OpenAI node. "
      },
      "typeVersion": 1
    },
    {
      "id": "7a87e6a0-0009-4776-bf2e-bea68702c808",
      "name": "Nota adhesiva3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1820,
        -40
      ],
      "parameters": {
        "color": 7,
        "width": 700,
        "height": 440,
        "content": "## Pass Call Transcripts to Call Processor\nThe OpenAI node handles this process and outputs in structured JSON."
      },
      "typeVersion": 1
    },
    {
      "id": "4c3b5280-c5e1-49d1-9651-e3fdd45978f7",
      "name": "Nota adhesiva4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1300,
        -60
      ],
      "parameters": {
        "color": 7,
        "width": 500,
        "height": 920,
        "content": "## Loop through all calls to get enrichment\nAllows for easier processing due to complexity "
      },
      "typeVersion": 1
    },
    {
      "id": "ce942178-c93e-490a-9b4e-0798f8c5c742",
      "name": "Nota adhesiva5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1080,
        -340
      ],
      "parameters": {
        "color": 5,
        "width": 360,
        "height": 1200,
        "content": "![Callforge](https://uploads.n8n.io/templates/callforgeshadow.png)\n## CallForge - The AI Gong Sales Call Processor\nCallForge allows you to extract important information for different departments from your Sales Gong Calls. \n\n### Call PreProcessor\nThis workflow preps the calls to pass into the call processor. It also pulls data from the product in order to enrich the AI Prompt to catch typos in the Gong call transcript. It then cleans up the transcript into a single string and then sends it to the call processor."
      },
      "typeVersion": 1
    },
    {
      "id": "41f3d049-e25b-453a-bf98-501af7f177d0",
      "name": "Disparador de ejecución de flujo",
      "type": "n8n-nodes-base.executeWorkflowTrigger",
      "position": [
        -860,
        580
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "02265963-ab06-4bf5-8b0b-5299cd3330c9",
      "name": "Call Aggregator",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        -100,
        120
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData",
        "destinationFieldName": "calls"
      },
      "typeVersion": 1
    },
    {
      "id": "044e1b65-059c-4084-b85a-e10e6149be34",
      "name": "Integration Aggregator",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        -240,
        380
      ],
      "parameters": {
        "options": {},
        "fieldsToAggregate": {
          "fieldToAggregate": [
            {
              "fieldToAggregate": "Google Sheets"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "31df099f-45ec-4dff-b968-a90e7eaa67b5",
      "name": "Get Integrations",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -460,
        380
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 1859794756,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DKrLntdoNScMey5Bb4ggSpS8NFHlYN3kuTJQbrbJU7I/edit#gid=1859794756",
          "cachedResultName": "Sheet1"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1DKrLntdoNScMey5Bb4ggSpS8NFHlYN3kuTJQbrbJU7I",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1DKrLntdoNScMey5Bb4ggSpS8NFHlYN3kuTJQbrbJU7I/edit?usp=drivesdk",
          "cachedResultName": "Most Popular Node Combos"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "4ZBfVX71VUd6pRy3",
          "name": "Google Sheets Angel Access"
        }
      },
      "executeOnce": true,
      "typeVersion": 4.5
    },
    {
      "id": "42a8299e-d2e4-48a9-bba9-1c5e419d8c0c",
      "name": "Comma Separate Integrations",
      "type": "n8n-nodes-base.set",
      "position": [
        -20,
        380
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "39dfde65-e5e0-46d8-8596-af7ea31fcd3b",
              "name": "integrations",
              "type": "string",
              "value": "={{ $json[\"Google Sheets\"].join() }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "4226f79a-8b28-46d7-8b3b-972ef41d9535",
      "name": "Comma separate competitors",
      "type": "n8n-nodes-base.set",
      "position": [
        -20,
        580
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "c419af9b-f161-4aac-863f-3a450aaf759f",
              "name": "competitors",
              "type": "string",
              "value": "={{ $jmespath($json.properties['Competitor vs.'].select.options, '[].name').join() }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "cce3fab9-63fb-49de-8e3f-4fb7956d0b80",
      "name": "Get list of Competitors",
      "type": "n8n-nodes-base.notion",
      "position": [
        -460,
        580
      ],
      "parameters": {
        "simple": false,
        "resource": "database",
        "databaseId": {
          "__rl": true,
          "mode": "list",
          "value": "2cb8596f-2029-4d15-bf56-7001652f6fcf",
          "cachedResultUrl": "https://www.notion.so/2cb8596f20294d15bf567001652f6fcf",
          "cachedResultName": "n8n vs."
        }
      },
      "credentials": {
        "notionApi": {
          "id": "80",
          "name": "Notion david-internal"
        }
      },
      "retryOnFail": true,
      "typeVersion": 2.2,
      "waitBetweenTries": 3000
    },
    {
      "id": "05e82483-ed91-4733-a8a7-621d8cf6f3f1",
      "name": "Fusionar 3 objects into one",
      "type": "n8n-nodes-base.merge",
      "position": [
        260,
        380
      ],
      "parameters": {
        "numberInputs": 3
      },
      "typeVersion": 3
    },
    {
      "id": "f01f839a-b0b5-4368-8cd3-3466f3cd44a4",
      "name": "Agregar Call Data",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        560,
        240
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData",
        "destinationFieldName": "calldata"
      },
      "typeVersion": 1
    },
    {
      "id": "c89b9deb-7f52-4d0d-8cdf-ce1b2a1771d2",
      "name": "Split Out Call Data and Competitors",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        760,
        240
      ],
      "parameters": {
        "include": "selectedOtherFields",
        "options": {},
        "fieldToSplitOut": "calldata[0].calls",
        "fieldsToInclude": "calldata[1].integrations, , calldata[2].competitors"
      },
      "typeVersion": 1
    },
    {
      "id": "c5c90fd2-03f4-425c-9a49-b26887705c6c",
      "name": "Reduce down to 1 object",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        480,
        580
      ],
      "parameters": {
        "options": {},
        "aggregate": "aggregateAllItemData"
      },
      "typeVersion": 1
    },
    {
      "id": "3835aeb8-589c-49b5-995a-2bf0bc0698a8",
      "name": "Get Previous Phone Calls",
      "type": "n8n-nodes-base.notion",
      "position": [
        700,
        580
      ],
      "parameters": {
        "options": {},
        "resource": "databasePage",
        "operation": "getAll",
        "returnAll": true,
        "databaseId": {
          "__rl": true,
          "mode": "list",
          "value": "1a85b6e0-c94f-81a3-aa21-e3ccf8296d72",
          "cachedResultUrl": "https://www.notion.so/1a85b6e0c94f81a3aa21e3ccf8296d72",
          "cachedResultName": "Sales Call Summaries Demo"
        }
      },
      "credentials": {
        "notionApi": {
          "id": "2B3YIiD4FMsF9Rjn",
          "name": "Angelbot Notion"
        }
      },
      "retryOnFail": true,
      "typeVersion": 2.2,
      "waitBetweenTries": 3000
    },
    {
      "id": "9b7d60bd-d08a-4529-aefb-c89f277fcd8f",
      "name": "Isolate Only Call IDs",
      "type": "n8n-nodes-base.set",
      "position": [
        900,
        580
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "328e6ac8-88f3-4c2f-b8e8-d4a0756efd24",
              "name": "Call ID",
              "type": "string",
              "value": "={{ $json.property_gong_call_id ? $json.property_gong_call_id : \"none\" }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "3eb7613c-2eaa-430a-9f67-5fc486b84ff0",
      "name": "Only Process New Calls",
      "type": "n8n-nodes-base.compareDatasets",
      "position": [
        1120,
        420
      ],
      "parameters": {
        "options": {},
        "resolve": "preferInput1",
        "mergeByFields": {
          "values": [
            {
              "field1": "['calldata[0].calls'].id",
              "field2": "Call ID"
            }
          ]
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "5e69b2a1-eb6a-4bb4-a126-0605f60ff95b",
      "name": "Loop Over Calls",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1500,
        400
      ],
      "parameters": {
        "options": {}
      },
      "typeVersion": 3
    },
    {
      "id": "6b170ccb-d492-4e7e-9aeb-13c769d36040",
      "name": "Process All Call Transcripts",
      "type": "n8n-nodes-base.executeWorkflow",
      "position": [
        2200,
        140
      ],
      "parameters": {
        "options": {},
        "workflowId": {
          "__rl": true,
          "mode": "list",
          "value": "cg4Eo7yZlhWkqHCB",
          "cachedResultName": "Call Processor Demo"
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "3107c6d8-0c8c-4dad-bcbc-c897b0be45b9",
      "name": "Receive all Transcripts",
      "type": "n8n-nodes-base.noOp",
      "position": [
        1920,
        140
      ],
      "parameters": {},
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "acb8e29a-75b8-4ccb-aca8-20d5a7053334": {
      "main": [
        [
          {
            "node": "02265963-ab06-4bf5-8b0b-5299cd3330c9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "02265963-ab06-4bf5-8b0b-5299cd3330c9": {
      "main": [
        [
          {
            "node": "Merge 3 objects into one",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5e69b2a1-eb6a-4bb4-a126-0605f60ff95b": {
      "main": [
        [
          {
            "node": "3107c6d8-0c8c-4dad-bcbc-c897b0be45b9",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "d796312a-2a7f-429f-8550-d4af6d81a26d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "31df099f-45ec-4dff-b968-a90e7eaa67b5": {
      "main": [
        [
          {
            "node": "044e1b65-059c-4084-b85a-e10e6149be34",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Aggregate Call Data": {
      "main": [
        [
          {
            "node": "c89b9deb-7f52-4d0d-8cdf-ce1b2a1771d2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d796312a-2a7f-429f-8550-d4af6d81a26d": {
      "main": [
        [
          {
            "node": "5e69b2a1-eb6a-4bb4-a126-0605f60ff95b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9b7d60bd-d08a-4529-aefb-c89f277fcd8f": {
      "main": [
        [
          {
            "node": "3eb7613c-2eaa-430a-9f67-5fc486b84ff0",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "044e1b65-059c-4084-b85a-e10e6149be34": {
      "main": [
        [
          {
            "node": "42a8299e-d2e4-48a9-bba9-1c5e419d8c0c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3eb7613c-2eaa-430a-9f67-5fc486b84ff0": {
      "main": [
        [
          {
            "node": "5e69b2a1-eb6a-4bb4-a126-0605f60ff95b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "cce3fab9-63fb-49de-8e3f-4fb7956d0b80": {
      "main": [
        [
          {
            "node": "4226f79a-8b28-46d7-8b3b-972ef41d9535",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3107c6d8-0c8c-4dad-bcbc-c897b0be45b9": {
      "main": [
        [
          {
            "node": "6b170ccb-d492-4e7e-9aeb-13c769d36040",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c5c90fd2-03f4-425c-9a49-b26887705c6c": {
      "main": [
        [
          {
            "node": "3835aeb8-589c-49b5-995a-2bf0bc0698a8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Execute Workflow Trigger": {
      "main": [
        [
          {
            "node": "acb8e29a-75b8-4ccb-aca8-20d5a7053334",
            "type": "main",
            "index": 0
          },
          {
            "node": "cce3fab9-63fb-49de-8e3f-4fb7956d0b80",
            "type": "main",
            "index": 0
          },
          {
            "node": "31df099f-45ec-4dff-b968-a90e7eaa67b5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3835aeb8-589c-49b5-995a-2bf0bc0698a8": {
      "main": [
        [
          {
            "node": "9b7d60bd-d08a-4529-aefb-c89f277fcd8f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge 3 objects into one": {
      "main": [
        [
          {
            "node": "Aggregate Call Data",
            "type": "main",
            "index": 0
          },
          {
            "node": "c5c90fd2-03f4-425c-9a49-b26887705c6c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "4226f79a-8b28-46d7-8b3b-972ef41d9535": {
      "main": [
        [
          {
            "node": "Merge 3 objects into one",
            "type": "main",
            "index": 2
          }
        ]
      ]
    },
    "42a8299e-d2e4-48a9-bba9-1c5e419d8c0c": {
      "main": [
        [
          {
            "node": "Merge 3 objects into one",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "25fb4302-853a-421d-8e4f-4a18d723c4a0": {
      "main": [
        [
          {
            "node": "acb8e29a-75b8-4ccb-aca8-20d5a7053334",
            "type": "main",
            "index": 0
          },
          {
            "node": "31df099f-45ec-4dff-b968-a90e7eaa67b5",
            "type": "main",
            "index": 0
          },
          {
            "node": "cce3fab9-63fb-49de-8e3f-4fb7956d0b80",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c89b9deb-7f52-4d0d-8cdf-ce1b2a1771d2": {
      "main": [
        [
          {
            "node": "3eb7613c-2eaa-430a-9f67-5fc486b84ff0",
            "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?

Avanzado - Ventas, Producto, Inteligencia Artificial

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

Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos26
Categoría3
Tipos de nodos14
Descripción de la dificultad

Adecuado para usuarios avanzados, flujos de trabajo complejos con 16+ nodos

Autor
Angel Menendez

Angel Menendez

@djangelic

Angel Menendez is a Staff Developer Advocate at n8n.io, specializing in low-code tools for cybersecurity workflows. From Puerto Rico, Angel's tech journey began by helping his father translate technical books. He later started a web development business and transitioned from a career as a flight attendant to cybersecurity engineering. His workflows have saved companies significant time. Outside work, Angel enjoys time with his two sons, riding electric bikes, reading, and exploring new places.

Enlaces externos
Ver en n8n.io

Compartir este flujo de trabajo

Categorías

Categorías: 34