Automatización de encuestas CSAT con Freshdesk y almacenamiento de respuestas en Google Sheets
Avanzado
Este es unSupportflujo de automatización del dominio deautomatización que contiene 21 nodos.Utiliza principalmente nodos como If, Set, Markdown, EmailSend, Freshdesk. Automatización de encuestas de CSAT con Freshdesk y almacenamiento de respuestas en Google Sheets
Requisitos previos
- •Credenciales de API de Google Sheets
Nodos utilizados (21)
Categoría
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
{
"nodes": [
{
"id": "7e821a77-1db8-4d91-8500-7785b195151b",
"name": "Al hacer clic en 'Probar flujo de trabajo'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
-260
],
"parameters": {},
"typeVersion": 1
},
{
"id": "999e52f3-c10d-450a-ab13-f0d01318f1b4",
"name": "Si el ticket está resuelto",
"type": "n8n-nodes-base.if",
"position": [
880,
-360
],
"parameters": {
"options": {},
"conditions": {
"options": {
"version": 2,
"leftValue": "",
"caseSensitive": true,
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "e70ba235-bc7d-400f-a0e1-8e0baa815918",
"operator": {
"type": "number",
"operation": "notEquals"
},
"leftValue": "={{ $('get tickets').item.json.status }}",
"rightValue": "={{ $('get existing tickets').item.json.status }}"
},
{
"id": "82e34950-8e33-4f13-b562-c73b79c584fa",
"operator": {
"type": "number",
"operation": "equals"
},
"leftValue": "={{ $('get tickets').item.json.status }}",
"rightValue": 4
}
]
},
"looseTypeValidation": true
},
"typeVersion": 2.2
},
{
"id": "fbe9f747-e591-491e-b47d-4a1875daa898",
"name": "Enviar correo electrónico",
"type": "n8n-nodes-base.emailSend",
"position": [
1980,
-360
],
"webhookId": "28ebac0e-0387-4f8a-a574-a867e51de272",
"parameters": {
"html": "={{ $json.data }}",
"options": {
"appendAttribution": false
},
"subject": "={{ $json.subject }}",
"toEmail": "={{ $('get client').first().json.email }}",
"fromEmail": "thomas@pollup.net"
},
"credentials": {
"smtp": {
"id": "yrsGGdbYvSB8u7sx",
"name": "SMTP account"
}
},
"typeVersion": 2.1
},
{
"id": "fdc22898-b6ad-4489-8562-fe29e68a0832",
"name": "Obtener cliente",
"type": "n8n-nodes-base.freshdesk",
"position": [
1320,
-360
],
"parameters": {
"resource": "contact",
"contactId": "={{ $('get tickets').item.json.requester_id }}",
"operation": "get"
},
"credentials": {
"freshdeskApi": {
"id": "op9AMlUqPbk3ZD8n",
"name": "Freshdesk account"
}
},
"typeVersion": 1
},
{
"id": "e9001b35-1d1f-4d23-bd84-92a471a043e5",
"name": "Obtener tickets",
"type": "n8n-nodes-base.freshdesk",
"position": [
660,
-360
],
"parameters": {
"options": {},
"operation": "getAll"
},
"credentials": {
"freshdeskApi": {
"id": "op9AMlUqPbk3ZD8n",
"name": "Freshdesk account"
}
},
"typeVersion": 1
},
{
"id": "053a1afe-5f25-418e-936a-7770d9bb487e",
"name": "Actualizar estado",
"type": "n8n-nodes-base.googleSheets",
"position": [
1100,
-360
],
"parameters": {
"columns": {
"value": {
"status": "={{ $('get tickets').item.json.status }}",
"row_number": "={{ $('get existing tickets').item.json.row_number }}"
},
"schema": [
{
"id": "cc_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "cc_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "fwd_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "fwd_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "reply_cc_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "reply_cc_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ticket_cc_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "ticket_cc_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "ticket_bcc_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "ticket_bcc_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "fr_escalated",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "fr_escalated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "spam",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "spam",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email_config_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email_config_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "group_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "group_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "priority",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "priority",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "requester_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "requester_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "responder_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "responder_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "source",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "source",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "company_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "company_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "status",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "status",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "subject",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "subject",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "association_type",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "association_type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "support_email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "support_email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "to_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "to_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "product_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "product_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "id",
"defaultMatch": true,
"canBeUsedToMatch": true
},
{
"id": "type",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "type",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "due_by",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "due_by",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "fr_due_by",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "fr_due_by",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "is_escalated",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "is_escalated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "custom_fields",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "custom_fields",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "created_at",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "created_at",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "updated_at",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "updated_at",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "associated_tickets_count",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "associated_tickets_count",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "tags",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "tags",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "structured_description",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "structured_description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "sentiment_score",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "sentiment_score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "initial_sentiment_score",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "initial_sentiment_score",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "nr_due_by",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "nr_due_by",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "nr_escalated",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "nr_escalated",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "active",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "active",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "address",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "address",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "description",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "description",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "email",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "email",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "job_title",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "job_title",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "language",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "language",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "mobile",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "mobile",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "phone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "phone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "time_zone",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "time_zone",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "twitter_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "twitter_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "other_emails",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "other_emails",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "facebook_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "facebook_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "csat_rating",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "csat_rating",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "preferred_source",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "preferred_source",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "view_all_tickets",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "view_all_tickets",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "other_companies",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "other_companies",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "unique_external_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "unique_external_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "avatar",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "avatar",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "first_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "first_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "last_name",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "last_name",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "visitor_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "visitor_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "org_contact_id",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "org_contact_id",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "other_phone_numbers",
"type": "string",
"display": true,
"removed": true,
"required": false,
"displayName": "other_phone_numbers",
"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": "appendOrUpdate",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8/edit?usp=drivesdk",
"cachedResultName": "Freshdesk Tickets"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "2f192048-9b73-4687-a357-e84d1818209e",
"name": "Activador programado",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
-460
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "b6690a95-d6b9-4283-a709-ad1a6b8502fe",
"name": "Configurar sus datos",
"type": "n8n-nodes-base.set",
"position": [
220,
-360
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "d372b3e3-31bf-45f7-a407-b59916c38bee",
"name": "your name",
"type": "string",
"value": "Thomas Vié"
},
{
"id": "96626d9c-77f1-44e1-aa6f-f2df9f5680ac",
"name": "Your email",
"type": "string",
"value": "thomas@pollup.net"
},
{
"id": "48de3b9d-e582-4d31-9e24-9600c64ef20b",
"name": "your company name",
"type": "string",
"value": "Pollup Data services"
},
{
"id": "c83824e8-498d-4957-a7a9-12c939d7f989",
"name": "your position",
"type": "string",
"value": "C.T.O."
},
{
"id": "09065360-22c6-4c92-be2a-c6129b4dd3a0",
"name": "survey link",
"type": "string",
"value": "https://n8n.pollup.net/form/a05aa4bc-20a7-488d-8249-4d79a94c3a69"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "013c1ba5-d3ff-4304-88c5-ec824686a372",
"name": "Nota adhesiva",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-540
],
"parameters": {
"color": 4,
"height": 340,
"content": "## Set your data here\n- Put as Survey link the Production URL of the \"Survey\" Node and set the workflow to \"Active\""
},
"typeVersion": 1
},
{
"id": "cfcc442f-e885-43dc-ae0e-0bf27443c6ac",
"name": "Encuesta",
"type": "n8n-nodes-base.formTrigger",
"position": [
0,
0
],
"webhookId": "a05aa4bc-20a7-488d-8249-4d79a94c3a69",
"parameters": {
"options": {},
"formTitle": "Quick Feedback",
"formFields": {
"values": [
{
"fieldType": "dropdown",
"fieldLabel": "On a scale of 1-5, how satisfied are you with the support you received?",
"fieldOptions": {
"values": [
{
"option": "1"
},
{
"option": "2"
},
{
"option": "3"
},
{
"option": "4"
},
{
"option": "5"
}
]
},
"requiredField": true
},
{
"fieldType": "textarea",
"fieldLabel": "Could you share what went wrong so we can improve?",
"requiredField": true
}
]
},
"formDescription": "Help Us Improve!"
},
"typeVersion": 2.2
},
{
"id": "cc3f18ff-6967-42f4-aa2a-23ec503a9b43",
"name": "Obtener tickets existentes",
"type": "n8n-nodes-base.googleSheets",
"position": [
440,
-360
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1G8ULQOK9WWsalHUs2RMTozLfQcYfFm4BLPnBSfVKYa8/edit?usp=drivesdk",
"cachedResultName": "Freshdesk Tickets"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "a6590283-4b5c-44d7-9384-40708e38a8e4",
"name": "Nota adhesiva1",
"type": "n8n-nodes-base.stickyNote",
"position": [
400,
-540
],
"parameters": {
"color": 4,
"width": 180,
"height": 340,
"content": "## Save tickets\n- Create an empty google sheet and put it here"
},
"typeVersion": 1
},
{
"id": "878ba0f7-cad0-443a-884e-8ff1259fa02f",
"name": "Nota adhesiva2",
"type": "n8n-nodes-base.stickyNote",
"position": [
600,
-540
],
"parameters": {
"color": 4,
"width": 200,
"height": 340,
"content": "## Get tickets\n- Connect here to Freshdesk with your credentials"
},
"typeVersion": 1
},
{
"id": "c114af56-5686-40fa-b63d-158d14f87131",
"name": "Crear el texto del correo",
"type": "n8n-nodes-base.set",
"position": [
1540,
-360
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "63d258ad-77b4-4aab-9380-3a66152ac133",
"name": "subject",
"type": "string",
"value": "=Quick Feedback? Help Us Improve"
},
{
"id": "54baa177-0163-47d1-937a-b58547cc4767",
"name": "body",
"type": "string",
"value": "=Hi,\n\nWe recently closed the ticket \"{{ $('get tickets').item.json.subject }}\". How satisfied were you with your recent support experience? Could you answer a [very fast survey]({{ $('Set your data').item.json['survey link'] }})?\n\nThank you for your time — we value your voice.\n\nBest regards,\n\n{{ $('Set your data').item.json['your name'] }}\n{{ $('Set your data').item.json['your position'] }}\n{{ $('Set your data').item.json['your company name'] }}"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "c5c217d5-7d2e-4c27-828f-a758a35c0f9c",
"name": "Convertir el texto del correo a HTML",
"type": "n8n-nodes-base.markdown",
"position": [
1760,
-360
],
"parameters": {
"mode": "markdownToHtml",
"options": {},
"markdown": "={{ $json.body }}"
},
"typeVersion": 1
},
{
"id": "64bebbc9-a8a3-459f-8938-d9b17b1c64a2",
"name": "Nota adhesiva3",
"type": "n8n-nodes-base.stickyNote",
"position": [
1920,
-540
],
"parameters": {
"color": 6,
"width": 200,
"height": 340,
"content": "## Email send settings\n- Here you can change this node for a gmail node for eaxmple. "
},
"typeVersion": 1
},
{
"id": "1372a887-042f-401c-bc39-38bccdb943e8",
"name": "Nota adhesiva4",
"type": "n8n-nodes-base.stickyNote",
"position": [
1260,
-540
],
"parameters": {
"color": 4,
"width": 200,
"height": 340,
"content": "## Get Client\n- Connect here to Freshdesk with your credentials"
},
"typeVersion": 1
},
{
"id": "07287a6a-16e8-40da-a45e-bdc0e01f14d5",
"name": "Guardar encuesta en hoja google",
"type": "n8n-nodes-base.googleSheets",
"position": [
200,
0
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "On a scale of 1-5, how satisfied are you with the support you received?",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "On a scale of 1-5, how satisfied are you with the support you received?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Could you share what went wrong so we can improve?",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Could you share what went wrong so we can improve?",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "submittedAt",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "submittedAt",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "formMode",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "formMode",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1owSLNTGyoDUw0IB6RFqRYyF_P-KFPiIvS8MM-RrDPjI/edit#gid=0",
"cachedResultName": "Sheet1"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1owSLNTGyoDUw0IB6RFqRYyF_P-KFPiIvS8MM-RrDPjI",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1owSLNTGyoDUw0IB6RFqRYyF_P-KFPiIvS8MM-RrDPjI/edit?usp=drivesdk",
"cachedResultName": "Feedback freshdesk"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "gdLmm513ROUyH6oU",
"name": "Google Sheets account"
}
},
"typeVersion": 4.5
},
{
"id": "78fa9cde-7135-4dd2-8d74-9b6c826fbd6b",
"name": "Nota adhesiva5",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-100
],
"parameters": {
"color": 4,
"width": 220,
"height": 340,
"content": "## Save survey\n- Create an empty google sheet and put it here"
},
"typeVersion": 1
},
{
"id": "001ff1c0-515c-410f-a460-c52867af8cb9",
"name": "Nota adhesiva7",
"type": "n8n-nodes-base.stickyNote",
"position": [
-80,
-780
],
"parameters": {
"width": 880,
"height": 220,
"content": "## Contact me\n- If you need any modification to this workflow\n- if you need some help with this workflow\n- Or if you need any workflow in n8n, Make, or Langchain / Langgraph\n\nWrite to me: [thomas@pollup.net](mailto:thomas@pollup.net)\n\n**Take a look at my others workflows [here](https://n8n.io/creators/zeerobug/)**\n\n"
},
"typeVersion": 1
},
{
"id": "e5420f8a-b734-4d7c-af02-204c3d263457",
"name": "Nota adhesiva6",
"type": "n8n-nodes-base.stickyNote",
"position": [
-100,
-100
],
"parameters": {
"color": 6,
"width": 220,
"height": 340,
"content": "## Modify Survey\n- Set all the survey's question you need here"
},
"typeVersion": 1
}
],
"connections": {
"cfcc442f-e885-43dc-ae0e-0bf27443c6ac": {
"main": [
[
{
"node": "07287a6a-16e8-40da-a45e-bdc0e01f14d5",
"type": "main",
"index": 0
}
]
]
},
"fdc22898-b6ad-4489-8562-fe29e68a0832": {
"main": [
[
{
"node": "c114af56-5686-40fa-b63d-158d14f87131",
"type": "main",
"index": 0
}
]
]
},
"e9001b35-1d1f-4d23-bd84-92a471a043e5": {
"main": [
[
{
"node": "999e52f3-c10d-450a-ab13-f0d01318f1b4",
"type": "main",
"index": 0
}
]
]
},
"b6690a95-d6b9-4283-a709-ad1a6b8502fe": {
"main": [
[
{
"node": "cc3f18ff-6967-42f4-aa2a-23ec503a9b43",
"type": "main",
"index": 0
}
]
]
},
"053a1afe-5f25-418e-936a-7770d9bb487e": {
"main": [
[
{
"node": "fdc22898-b6ad-4489-8562-fe29e68a0832",
"type": "main",
"index": 0
}
]
]
},
"2f192048-9b73-4687-a357-e84d1818209e": {
"main": [
[
{
"node": "b6690a95-d6b9-4283-a709-ad1a6b8502fe",
"type": "main",
"index": 0
}
]
]
},
"999e52f3-c10d-450a-ab13-f0d01318f1b4": {
"main": [
[
{
"node": "053a1afe-5f25-418e-936a-7770d9bb487e",
"type": "main",
"index": 0
}
]
]
},
"cc3f18ff-6967-42f4-aa2a-23ec503a9b43": {
"main": [
[
{
"node": "e9001b35-1d1f-4d23-bd84-92a471a043e5",
"type": "main",
"index": 0
}
]
]
},
"c114af56-5686-40fa-b63d-158d14f87131": {
"main": [
[
{
"node": "c5c217d5-7d2e-4c27-828f-a758a35c0f9c",
"type": "main",
"index": 0
}
]
]
},
"c5c217d5-7d2e-4c27-828f-a758a35c0f9c": {
"main": [
[
{
"node": "fbe9f747-e591-491e-b47d-4a1875daa898",
"type": "main",
"index": 0
}
]
]
},
"7e821a77-1db8-4d91-8500-7785b195151b": {
"main": [
[
{
"node": "b6690a95-d6b9-4283-a709-ad1a6b8502fe",
"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 - Soporte
¿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.
Flujos de trabajo relacionados recomendados
Automatización del proceso de incorporación multifase usando Google Sheets, Forms y notificaciones de Gmail
Automatización del proceso de incorporación de múltiples pasos con Google Sheets, Forms y notificaciones por Gmail
If
Set
Code
+
If
Set
Code
31 NodosPollupAI
Recursos Humanos
Tablero de Noco con priorización basada en IA
Asignar solicitudes con IA y enviar recordatorios basados en el estado del tablero de NocoDB
If
Set
Slack
+
If
Set
Slack
27 NodosŁukasz
Soporte
Envío automático de solicitudes de contacto y mensajes de rompimiento de hielo en LinkedIn usando Unipile y Google Sheets
Envío automático de solicitudes de conexión de LinkedIn y mensajes de rompimiento de hielo con Unipile y Google Sheets
If
Set
Code
+
If
Set
Code
44 NodosPollupAI
Otros
Automatización de solicitudes y mensajes de rompimiento de hielo en LinkedIn usando Browserflow y Google Sheets
Automatización de solicitudes y mensajes de rompimiento de hielo de LinkedIn con Browserflow y Google Sheets
If
Set
Sort
+
If
Set
Sort
44 NodosPollupAI
Ventas
Cargador de CSV a HubSpot (mapeo de campos dinámico e integración con Google Sheets)
Subidor de CSV a HubSpot con mapeo de campos dinámico e integración con Google Sheets
If
Set
Code
+
If
Set
Code
36 NodosPollupAI
Inteligencia Artificial
Desarrollo de leads y flujos de correo electrónico
Usar Google Maps, SendGrid e IA para automatizar el desarrollo de leads B2B y el marketing por correo electrónico
If
Set
Code
+
If
Set
Code
141 NodosEzema Kingsley Chibuzo
Generación de leads
Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos21
Categoría1
Tipos de nodos10
Descripción de la dificultad
Autor
PollupAI
@zeerobugWe create bespoke AI solutions, automations and agents that help your business as it scales.
Enlaces externos
Ver en n8n.io →
Compartir este flujo de trabajo