Automatisation des enquêtes CSAT avec Freshdesk et stockage des réponses dans Google Sheets
Avancé
Ceci est unSupportworkflow d'automatisation du domainecontenant 21 nœuds.Utilise principalement des nœuds comme If, Set, Markdown, EmailSend, Freshdesk. Automatisation des enquêtes CSAT avec Freshdesk et stockage des réponses dans Google Sheets
Prérequis
- •Informations d'identification Google Sheets API
Nœuds utilisés (21)
Catégorie
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
"nodes": [
{
"id": "7e821a77-1db8-4d91-8500-7785b195151b",
"name": "Lors du clic sur 'Tester le workflow'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
-260
],
"parameters": {},
"typeVersion": 1
},
{
"id": "999e52f3-c10d-450a-ab13-f0d01318f1b4",
"name": "Si le ticket est résolu",
"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": "Envoyer un e-mail",
"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": "obtenir le client",
"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": "obtenir les 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": "Mettre à jour le statut",
"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": "Déclencheur programmé",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
-460
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "b6690a95-d6b9-4283-a709-ad1a6b8502fe",
"name": "Définir vos données",
"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": "Note autocollante",
"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": "Enquête",
"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": "obtenir les tickets existants",
"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": "Note autocollante1",
"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": "Note autocollante2",
"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": "Créer le texte de l'e-mail",
"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 le texte de l'e-mail en 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": "Note autocollante3",
"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": "Note autocollante4",
"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": "Enregistrer l'enquête dans la feuille 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": "Note autocollante5",
"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": "Note autocollante7",
"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": "Note autocollante6",
"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
}
]
]
}
}
}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é ?
Avancé - Support
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.
Workflows recommandés
Automatisation du processus d'intégration en plusieurs étapes avec Google Sheets, Forms et notifications Gmail
Utiliser Google Sheets, Forms et les notifications Gmail pour automatiser un processus d'intégration multi-étapes
If
Set
Code
+
If
Set
Code
31 NœudsPollupAI
Ressources Humaines
Tableaux Noco avec priorisation par IA
Utiliser l'IA pour assigner des requêtes et envoyer des rappels en fonction de l'état du tableau de bord NocoDB
If
Set
Slack
+
If
Set
Slack
27 NœudsŁukasz
Support
Automatisation de l'envoi de demandes de contact LinkedIn et de messages d'ouverture avec Unipile et Google Sheets
Utiliser Unipile et Google Sheets pour envoyer automatiquement des demandes de contact LinkedIn et des messages d'ouverture
If
Set
Code
+
If
Set
Code
44 NœudsPollupAI
Autres
Automatisation des demandes LinkedIn et des messages d'ouverture avec Browserflow et Google Sheets
Utiliser Browserflow et Google Sheets pour automatiser les demandes LinkedIn et les messages d'ouverture
If
Set
Sort
+
If
Set
Sort
44 NœudsPollupAI
Ventes
Téléverseur CSV vers HubSpot (cartographie dynamique de champs et intégration Google Sheets)
Chargeur de fichiers CSV vers HubSpot avec mappage de champs dynamique et intégration Google Sheets
If
Set
Code
+
If
Set
Code
36 NœudsPollupAI
Intelligence Artificielle
Prospection et workflow d'e-mails
Utiliser Google Maps, SendGrid et l'IA pour automatiser le développement de prospects B2B et le marketing par e-mail
If
Set
Code
+
If
Set
Code
141 NœudsEzema Kingsley Chibuzo
Génération de leads
Informations sur le workflow
Niveau de difficulté
Avancé
Nombre de nœuds21
Catégorie1
Types de nœuds10
Description de la difficulté
Auteur
PollupAI
@zeerobugWe create bespoke AI solutions, automations and agents that help your business as it scales.
Liens externes
Voir sur n8n.io →
Partager ce workflow