{"id":"mNbQmMNEvpiZqASG","meta":{"instanceId":"workflow-705b95c3","versionId":"1.0.0","createdAt":"2025-09-29T07:07:44.557501","updatedAt":"2025-09-29T07:07:44.557515","owner":"n8n-user","license":"MIT","category":"automation","status":"active","priority":"high","environment":"production"},"name":"Format US Phone Number","nodes":[{"id":"bf150da4-5e01-4571-a606-10a0fb25004b","name":"When Executed by Another Workflow","type":"n8n-nodes-base.executeWorkflowTrigger","position":[0,275],"parameters":{"workflowInputs":{"values":[{"name":"Phone Number","type":"any"}]}},"typeVersion":1.1,"notes":"This executeWorkflowTrigger node performs automated tasks as part of the workflow."},{"id":"7c560ecf-c827-413f-a115-7b6bc8f21a41","name":"Check if first digit is valid country code","type":"n8n-nodes-base.if","position":[660,275],"parameters":{"options":{},"conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"4d5c838e-9b08-4466-b00d-c695fd76d66d","operator":{"type":"number","operation":"equals"},"leftValue":"={{ $json['Phone Number'].toString().slice(0,1).toNumber() }}","rightValue":1}]}},"typeVersion":2.2,"notes":"This if node performs automated tasks as part of the workflow."},{"id":"783d8fd0-2a38-41fc-87c9-b0aec9933070","name":"Add valid country code","type":"n8n-nodes-base.set","position":[880,475],"parameters":{"options":{},"assignments":{"assignments":[{"id":"e47a1812-f69c-4182-bed5-cf037071cd9b","name":"Phone Number","type":"number","value":"=1{{ $json['Phone Number'] }}"}]}},"typeVersion":3.4,"notes":"This set node performs automated tasks as part of the workflow."},{"id":"a93923f3-5d8d-4617-a63d-50b66b3b1128","name":"Strip phone number formatting","type":"n8n-nodes-base.set","position":[220,275],"parameters":{"options":{},"assignments":{"assignments":[{"id":"91d348df-6937-4118-8f7b-c9d386eb5c21","name":"Phone Number","type":"number","value":"={{ $json['Phone Number'].match(/[0-9]+/gmi).join('') }}"}]}},"typeVersion":3.4,"notes":"This set node performs automated tasks as part of the workflow."},{"id":"58d6d280-ec86-4b69-a89c-e43571ce1035","name":"Check number of digits in phone number","type":"n8n-nodes-base.switch","position":[440,254],"parameters":{"rules":{"values":[{"outputKey":"YOUR_CREDENTIAL_HERE","conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"66c9d1e7-dc56-4ce8-b7e4-64274feb8750","operator":{"type":"number","operation":"gte"},"leftValue":"={{ $json['Phone Number'].toString().length }}","rightValue":11}]},"renameOutput":true},{"outputKey":"YOUR_CREDENTIAL_HERE","conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"2b9be422-2c4d-402a-b598-e8ab55aa5196","operator":{"type":"number","operation":"equals"},"leftValue":"={{ $json['Phone Number'].toString().length }}","rightValue":10}]},"renameOutput":true},{"outputKey":"YOUR_CREDENTIAL_HERE","conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"a442130a-f2f8-4399-8edb-180d3607ec9b","operator":{"type":"number","operation":"lt"},"leftValue":"={{ $json['Phone Number'].toString().length }}","rightValue":10}]},"renameOutput":true},{"outputKey":"YOUR_CREDENTIAL_HERE","conditions":{"options":{"version":2,"leftValue":"","caseSensitive":true,"typeValidation":"strict"},"combinator":"and","conditions":[{"id":"efba5af9-dfe4-47f0-8e82-253accd4f238","operator":{"type":"number","operation":"notExists","singleValue":true},"leftValue":"={{ $json['Phone Number'] }}","rightValue":""}]},"renameOutput":true}]},"options":{}},"typeVersion":3.2,"notes":"This switch node performs automated tasks as part of the workflow."},{"id":"1f6a4aa7-0595-4db3-a9c3-dc7a72656597","name":"Format phone numbers","type":"n8n-nodes-base.set","position":[1100,325],"parameters":{"options":{},"assignments":{"assignments":[{"id":"402c8481-3dee-4b90-8a08-7e611156d012","name":"Phone Number (Input)","type":"string","value":"={{ $('When Executed by Another Workflow').item.json['Phone Number'] }}"},{"id":"9bc193b1-664f-40c0-8545-6792b5599777","name":"Phone Number","type":"number","value":"={{ $json['Phone Number'].toString().slice(0,11).toNumber() }}"},{"id":"a4944be5-bfd5-4804-aeb5-d84c59145485","name":"=Phone Number (E-164)","type":"string","value":"={{ $json['Phone Number'] ? '+' + $json['Phone Number'] : '' }}"},{"id":"3a8d506c-45ba-4843-b186-78bf877b7903","name":"Phone Number (National)","type":"string","value":"={{ $json['Phone Number'] ? '(' + $json['Phone Number'].toString().slice(1,4) + ') ' + $json['Phone Number'].toString().slice(4,7) + '-' + $json['Phone Number'].toString().slice(7,11) : '' }}"},{"id":"14daf876-5f94-44d7-915b-bc4a8d6afbc4","name":"Phone Number (Full National)","type":"string","value":"={{ $json['Phone Number'] ? '1 (' + $json['Phone Number'].toString().slice(1,4) + ') ' + $json['Phone Number'].toString().slice(4,7) + '-' + $json['Phone Number'].toString().slice(7,11) : '' }}"},{"id":"3270cc41-bfd7-4c5d-a05e-4af8da028bd5","name":"Phone Number (International)","type":"string","value":"={{ $json['Phone Number'] ? '00-1-' + $json['Phone Number'].toString().slice(1,4) + '-' + $json['Phone Number'].toString().slice(4,7) + '-' + $json['Phone Number'].toString().slice(7,11) : '' }}"},{"id":"a6bd3652-071f-41b6-b523-bca427ef54f5","name":"Extension","type":"number","value":"={{ $json['Phone Number'].toString().slice(11).toNumber() }}"},{"id":"7b808bfb-0d69-410c-b8f4-cbf2cafcf7e8","name":"Extension (String)","type":"string","value":"={{ $json['Phone Number'].toString().slice(11).toNumber() > 0 ? $json['Phone Number'].toString().slice(11).toNumber() : '' }}"}]}},"typeVersion":3.4,"notes":"This set node performs automated tasks as part of the workflow."},{"id":"7bc3c1a0-2056-48a0-b826-21a8c1bff31b","name":"Clear invalid number","type":"n8n-nodes-base.set","position":[880,125],"parameters":{"options":{},"assignments":{"assignments":[{"id":"c8d90980-61c9-49c5-8769-32c445790328","name":"Phone Number","type":"string","value":""}]},"includeOtherFields":true},"typeVersion":3.4,"notes":"This set node performs automated tasks as part of the workflow."},{"id":"error-e3f09ca8","name":"Error Handler","type":"n8n-nodes-base.stopAndError","typeVersion":1,"position":[1000,400],"parameters":{"message":"Workflow execution error","options":{}}}],"active":false,"settings":{"executionOrder":"v1","saveManualExecutions":true,"callerPolicy":"workflowsFromSameOwner","errorWorkflow":null,"timezone":"UTC","executionTimeout":3600,"maxExecutions":1000,"retryOnFail":true,"retryCount":3,"retryDelay":1000},"versionId":"1b7626d5-b32b-41bd-989a-a79616769278","connections":{},"description":"Automated workflow: Format US Phone Number. This workflow processes data and performs automated tasks.","notes":"Excellent quality workflow: Format US Phone Number. This workflow has been optimized for production use with comprehensive error handling, security, and documentation."}