← All Productivity Workflows
BillionVerifyFreshdesk
Automate CSAT surveys with Freshdesk & store responses in Google Sheets
Pull contacts, verify each address with BillionVerify, and continue to Freshdesk — only deliverable addresses get through.
Why verify before the send
Sending to invalid, risky, catch-all, or disposable addresses spikes your bounce rate and erodes sender reputation. A verification gate before the Freshdesk step removes that risk automatically — only deliverable addresses continue, the rest are flagged.
The workflow
BillionVerify — verification sits right before the send.
Node by node
- 1When clicking ‘Test workflow’Trigger· n8n
Starts the workflow — on a schedule, a webhook, or manually while you test.
- 2Schedule TriggerTrigger· n8n
Starts the workflow — on a schedule, a webhook, or manually while you test.
- 3SurveyTrigger· n8n
Starts the workflow — on a schedule, a webhook, or manually while you test.
- 4Set your dataSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 5Save survey to google sheetSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 6get existing ticketsSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 7get ticketsSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 8If ticket resolvedLogic· n8n
Branches on the verification result: only deliverable addresses continue to the send; the rest are skipped and flagged.
- 9Updates statusSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 10get clientSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 11Create the email textSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 12Convert the email text to HTMLSource· n8n
Provides or transforms the contact data flowing through the workflow.
- 13Verify Email (BillionVerify)Verify· billionverify
The BillionVerify node verifies the address — status (valid / invalid / risky / catch-all / role / disposable), is_deliverable, and a confidence score — before anything is sent.
- 14IF deliverableLogic· n8n
Branches on the verification result: only deliverable addresses continue to the send; the rest are skipped and flagged.
- 15Send EmailSend· n8n
Sends only to verified, deliverable addresses. Swap in your own provider node if you send elsewhere.
Workflow JSON
Copy or download this workflow, then import it in n8n (Workflows → Import from File / Paste). Install the BillionVerify community node first, then add your API key credential.
verify-emails-in-freshdesk.json
{
"name": "Automate CSAT surveys with Freshdesk & store responses in Google Sheets + BillionVerify",
"nodes": [
{
"id": "7e821a77-1db8-4d91-8500-7785b195151b",
"name": "When clicking ‘Test workflow’",
"type": "n8n-nodes-base.manualTrigger",
"position": [
0,
-260
],
"parameters": {},
"typeVersion": 1
},
{
"id": "999e52f3-c10d-450a-ab13-f0d01318f1b4",
"name": "If ticket resolved",
"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": "Send Email",
"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": "user@example.com"
},
"credentials": {
"smtp": {
"id": "credential-id",
"name": "smtp Credential"
}
},
"typeVersion": 2.1
},
{
"id": "fdc22898-b6ad-4489-8562-fe29e68a0832",
"name": "get client",
"type": "n8n-nodes-base.freshdesk",
"position": [
1320,
-360
],
"parameters": {
"resource": "contact",
"contactId": "={{ $('get tickets').item.json.requester_id }}",
"operation": "get"
},
"credentials": {
"freshdeskApi": {
"id": "credential-id",
"name": "freshdeskApi Credential"
}
},
"typeVersion": 1
},
{
"id": "e9001b35-1d1f-4d23-bd84-92a471a043e5",
"name": "get tickets",
"type": "n8n-nodes-base.freshdesk",
"position": [
660,
-360
],
"parameters": {
"options": {},
"operation": "getAll"
},
"credentials": {
"freshdeskApi": {
"id": "credential-id",
"name": "freshdeskApi Credential"
}
},
"typeVersion": 1
},
{
"id": "053a1afe-5f25-418e-936a-7770d9bb487e",
"name": "Updates status",
"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": "credential-id",
"name": "googleSheetsOAuth2Api Credential"
}
},
"typeVersion": 4.5
},
{
"id": "2f192048-9b73-4687-a357-e84d1818209e",
"name": "Schedule Trigger",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
0,
-460
],
"parameters": {
"rule": {
"interval": [
{
"field": "hours"
}
]
}
},
"typeVersion": 1.2
},
{
"id": "b6690a95-d6b9-4283-a709-ad1a6b8502fe",
"name": "Set your data",
"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": "user@example.com"
},
{
"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": "Sticky Note",
"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": "Survey",
"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": "get existing tickets",
"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": "credential-id",
"name": "googleSheetsOAuth2Api Credential"
}
},
"typeVersion": 4.5,
"alwaysOutputData": true
},
{
"id": "a6590283-4b5c-44d7-9384-40708e38a8e4",
"name": "Sticky Note1",
"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": "Sticky Note2",
"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": "Create the email text",
"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": "Convert the email text to 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": "Sticky Note3",
"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": "Sticky Note4",
"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": "Save survey to google sheet",
"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": "credential-id",
"name": "googleSheetsOAuth2Api Credential"
}
},
"typeVersion": 4.5
},
{
"id": "78fa9cde-7135-4dd2-8d74-9b6c826fbd6b",
"name": "Sticky Note5",
"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": "Sticky Note7",
"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": "Sticky Note6",
"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
},
{
"parameters": {
"operation": "verify",
"email": "={{ $('get client').first().json.email }}",
"additionalOptions": {}
},
"type": "n8n-nodes-billionverify.billionVerify",
"typeVersion": 1,
"position": [
1620,
-360
],
"name": "Verify Email (BillionVerify)",
"credentials": {
"billionVerifyApi": {
"id": "",
"name": "BillionVerify account"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "loose"
},
"combinator": "and",
"conditions": [
{
"id": "is-deliverable",
"leftValue": "={{ $json.is_deliverable }}",
"rightValue": "",
"operator": {
"type": "boolean",
"operation": "true",
"singleValue": true
}
}
]
}
},
"type": "n8n-nodes-base.if",
"typeVersion": 2,
"position": [
1800,
-360
],
"name": "IF deliverable"
}
],
"connections": {
"Survey": {
"main": [
[
{
"node": "Save survey to google sheet",
"type": "main",
"index": 0
}
]
]
},
"get client": {
"main": [
[
{
"node": "Create the email text",
"type": "main",
"index": 0
}
]
]
},
"get tickets": {
"main": [
[
{
"node": "If ticket resolved",
"type": "main",
"index": 0
}
]
]
},
"Set your data": {
"main": [
[
{
"node": "get existing tickets",
"type": "main",
"index": 0
}
]
]
},
"Updates status": {
"main": [
[
{
"node": "get client",
"type": "main",
"index": 0
}
]
]
},
"Schedule Trigger": {
"main": [
[
{
"node": "Set your data",
"type": "main",
"index": 0
}
]
]
},
"If ticket resolved": {
"main": [
[
{
"node": "Updates status",
"type": "main",
"index": 0
}
]
]
},
"get existing tickets": {
"main": [
[
{
"node": "get tickets",
"type": "main",
"index": 0
}
]
]
},
"Create the email text": {
"main": [
[
{
"node": "Convert the email text to HTML",
"type": "main",
"index": 0
}
]
]
},
"Convert the email text to HTML": {
"main": [
[
{
"node": "Verify Email (BillionVerify)",
"type": "main",
"index": 0
}
]
]
},
"When clicking ‘Test workflow’": {
"main": [
[
{
"node": "Set your data",
"type": "main",
"index": 0
}
]
]
},
"Verify Email (BillionVerify)": {
"main": [
[
{
"node": "IF deliverable",
"type": "main",
"index": 0
}
]
]
},
"IF deliverable": {
"main": [
[
{
"node": "Send Email",
"type": "main",
"index": 0
}
],
[]
]
}
},
"settings": {}
}When to use this
- Cleaning a list before a Freshdesk send or sync.
- Protecting Freshdesk deliverability and sender reputation.
- Keeping bounce rates low so your sending is never throttled.
FAQ
Why verify before sending in Freshdesk?
Verifying first keeps your bounce rate low, which protects your sender reputation and your results.
How do I import this workflow?
Download the JSON, then in n8n go to Workflows → Import from File (or paste it). Install the BillionVerify community node and add your API key credential.
What happens to risky or catch-all addresses?
They are routed to the false branch and excluded from the send. You decide whether to retry, review, or drop them.
Add verification to your workflow
Create a free account, grab your API key, and stop bounces before they happen.
Get started free